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

DIY Steps:

1. Create two new materialized views

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;