What considerations would you take into account when designing a data warehouse for Binance?
For this hands-on exercise, use the provided Binance-style dimension and fact tables to produce a warehouse-ready asset summary for a UTC reporting period. Include active assets with no qualifying trades.
symbol, quote_asset, total_quote_volume, completed_trade_count, unique_buyers, unique_sellers, and average_execution_price.2025-01-01 inclusive through 2025-01-04 exclusive.symbol ascending, then asset_id ascending.| Column | Type | Description |
|---|---|---|
| asset_idPK | INT | Surrogate identifier for the asset dimension |
| symbol | VARCHAR(20) | Asset trading symbol |
| quote_asset | VARCHAR(20) | Quote currency used for reporting volume |
| is_active | BOOLEAN | Whether the asset is currently active |
| Column | Type | Description |
|---|---|---|
| trade_idPK | BIGINT | Unique spot trade identifier |
| asset_id | INT | Referenced asset dimension key |
| buyer_id | BIGINT | Buyer account identifier |
| seller_id | BIGINT | Seller account identifier |
| quote_volume | NUMERIC(24,8) | Trade value in the quote asset |
| execution_price | NUMERIC(24,8) | Executed price in quote currency |
| executed_at | TIMESTAMP | UTC trade execution timestamp |
| status | VARCHAR(20) | Trade lifecycle status |
| trade_type | VARCHAR(20) | Trade market type |