Financial Trading Warehouse

A hard Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

hard

Seniority

L6

Problem

We're building the data warehouse for a trading platform. We handle stocks, ETFs, and crypto with fractional share support. Trades settle in multiple currencies, and the SEC requires point-in-time snapshots for audits. Design the dimensional model.

Summary

Every trade, every tick, every fraction of a share. The regulators want receipts.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.