Query readiness: Store data by column
Pause
To count AAPL quotes per day, the query needs only
sym
and
day
.
Columnar storage
sym
day
time
bid
ask
bid size
ask size
AAPL
D1
09:30:01
100.00
100.02
200
300
MSFT
D1
09:30:02
200.00
200.03
100
200
NVDA
D2
09:30:01
50.00
50.01
400
300
AAPL
D2
09:30:02
101.00
101.02
300
200
MSFT
D1
09:30:04
200.02
200.04
300
200
NVDA
D2
09:30:03
50.01
50.02
200
400
AAPL
D1
09:30:03
100.01
100.03
200
100
MSFT
D1
09:30:06
200.01
200.03
200
100
NVDA
D2
09:30:05
50.02
50.03
300
200
Scanned 2 columns · Skipped 5
Grouped by day · Computed counts