Case Study

Database Connection Info:

DB Server: putnam.czuhwhnyaqg5.us-east-1.rds.amazonaws.com Port: 5432

Database: putnam

Username/Password: **Check with Instructor**

Database Create Scripts/Schemas

Dev Data Shared Document: https://docs.google.com/spreadsheets/d/1c14SkKRKvrckvF4fRQOlesH2zekkdu29hBt0rzZN5PM/edit?usp=sharing

CREATE TABLE IF NOT EXISTS public.test(    name character(20) COLLATE pg_catalog."default" NOT NULL,    CONSTRAINT name_pkey PRIMARY KEY (name))
================================
CREATE TABLE IF NOT EXISTS public.rfqraw(    id integer NOT NULL DEFAULT nextval('rfqraw_id_seq'::regclass),    data json,    CONSTRAINT rfqraw_pkey PRIMARY KEY (id))
================================
CREATE TABLE IF NOT EXISTS public.entities(EntityId bigint NOT NULL,   EntityName character varying(100) COLLATE pg_catalog."default",   CONSTRAINT entity_pkey PRIMARY KEY (EntityId))
================================
CREATE TABLE IF NOT EXISTS public.traders(TraderId bigint NOT NULL,   TraderName character varying(100) COLLATE pg_catalog."default",   EntityId bigint,   CONSTRAINT traders_pkey PRIMARY KEY (TraderId))
================================
CREATE TABLE IF NOT EXISTS public.securities(    isin character(12) COLLATE pg_catalog."default" NOT NULL,    name character varying(100) COLLATE pg_catalog."default",    symbol character varying(20) COLLATE pg_catalog."default",    location character varying(100) COLLATE pg_catalog."default",    maturity date,    interestrate numeric,    yieldcurve numeric,    rating character varying(5) COLLATE pg_catalog."default",    CONSTRAINT isin_pkey PRIMARY KEY (isin))
================================
CREATE TABLE IF NOT EXISTS public.tradecapture(    TraderId bigint,    EntityId bigint,    MsgType integer,    TradeReportId bigint,    PreviouslyReported character(1) COLLATE pg_catalog."default",    SecurityId character(12) COLLATE pg_catalog."default",    SecurityIdSource integer,    LastQty numeric,    LastPx numeric,    TradeDate date,    TransactionTime timestamp without time zone,    NoSides integer,    Side integer,    OrderID bigint,    Currency character(3) COLLATE pg_catalog."default")

ROI's Lambda Functions (RESTful API)

Send Sample RFQ SNS to roi-rfq-sample: https://nl5hhpina2.execute-api.us-east-1.amazonaws.com/default/roi-send-sample-message-v2
Show last 10 messages received: https://9bmhn42y3j.execute-api.us-east-1.amazonaws.com/default/roi-database-test-python39
ML Model (buy/sell/counter): https://01w9qqse1k.execute-api.us-east-1.amazonaws.com/default/roi_mlmodel_regression
AI Model (text response): https://7wsqat6pmd.execute-api.us-east-1.amazonaws.com/default/roi_aimodel

Page updated

Report abuse