Asset managers (big banks, insurance companies, and hedge funds) have spent hundreds of millions of dollars on systems to quickly and accurately give a SVOT in real-time. These systems are critical especially in times of market stress like the Great Financial Crisis or any unexpected market change.
Why Snowflake
SnowSight allows you to create and share dashboards for executives, portfolio managers, risk managers, and traders.
Significantly high performance and less cost of maintaining one SVOT
Near-Unlimited Compute and Concurrency enable quick data-driven decisions
What we will see
Use Data Marketplace to instantly get free stock price history from the Zepl data share
Query trade, cash, positions, and PnL (Profit and Loss) on Snowflake
Use Window Functions to automate cash, position, and PnL reporting
Prerequisites
Snowflake Account or Trial Account with accountadmin privileges.
You'll learn how to
Query free stock market history data instantly with zero learning curve and time
Run a Python faker function to create 100 synthetic traders
Size up compute to create 3 billion synthetic trades
Insert those trades ordered by trader, symbol, and date so any queries on that data are signficantly faster
Create a cluster key to future proof that trade table from any data that has been inserted without being sorted
Create a window function to calcluate real time trades, cash, and Profit and Loss (PnL)
Query 3 billion rows with only small compute and 3 second run-time
See Snowflake's 3 caches
Zero Copy Clone for DevOps and instant sandboxes
Time Travel to see and roll back up to 90 days of data
Drop and Undrop Tables
We setup
Role Based Access Control RBAC
Virtual Warehouses (compute)
Database
Objects
Run the finserv demo 10 setup script. Each script is idempotent meaning that you can rerun it without issues.