Query readiness:
Pre-aggregate
calculations
Pause
Pre-aggregation turns 9 quotes into 4 summary rows; queries read only 2 for AAPL.
Raw quotes
Ordered by sym
sym
day
AAPL
D1
AAPL
D2
AAPL
D1
MSFT
D1
MSFT
D1
MSFT
D1
NVDA
D2
NVDA
D2
NVDA
D2
Scanned 3 rows · Skipped 6
Grouped by day · Computed counts
Pre-aggregated by sym, day
Ordered by sym
sym
day
COUNT(*)
AAPL
D1
2
AAPL
D2
1
MSFT
D1
3
NVDA
D2
3
Scanned 2 rows · Skipped 2
Read precomputed counts