AWS Industry Quest: Financial Services - Ingesting Exchange Data in Near Real Time Study Note

CREATE MATERIALIZED VIEW query_5 AS select ticker, round(sum(price),2) as total_negotiated from stock_lake.stock_data where status = 'complete' and order_type = 'buy' group by ticker; CREATE MATERIALIZED VIEW query_6 AS select investor_id, round(sum(price),2) as total_negotiated from stock_lake.stock_data where status = 'complete' and order_type = 'buy' group by investor_id;