PREVIEW / etf_30min / 2026-01-15
file: by_date/etf_30min/2026/2026-01-15.parquet size: 1.1 MB rows: 47,195
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2026-01-15 04:00:00 | SPY | ETF | 691.1 | 692.66 | 690.65 | 692.58 | 30080.0 |
| 2026-01-15 04:30:00 | SPY | ETF | 692.62 | 693.02 | 692.51 | 692.55 | 18975.0 |
| 2026-01-15 05:00:00 | SPY | ETF | 692.64 | 692.83 | 692.46 | 692.59 | 27936.0 |
| 2026-01-15 05:30:00 | SPY | ETF | 692.58 | 692.9 | 692.56 | 692.75 | 39661.0 |
| 2026-01-15 06:00:00 | SPY | ETF | 692.73 | 693.13 | 692.72 | 692.87 | 122204.0 |
| 2026-01-15 06:30:00 | SPY | ETF | 692.92 | 693.2 | 692.5 | 692.9 | 170384.0 |
| 2026-01-15 07:00:00 | SPY | ETF | 692.9 | 693.0 | 692.55 | 692.74 | 121569.0 |
| 2026-01-15 07:30:00 | SPY | ETF | 692.77 | 693.3 | 692.52 | 693.0 | 164325.0 |
| 2026-01-15 08:00:00 | SPY | ETF | 692.99 | 693.47 | 689.5 | 693.27 | 222181.0 |
| 2026-01-15 08:30:00 | SPY | ETF | 693.34 | 694.0 | 693.0 | 693.51 | 441331.0 |
| 2026-01-15 09:00:00 | SPY | ETF | 693.55 | 694.8 | 693.43 | 694.62 | 330050.0 |
| 2026-01-15 09:30:00 | SPY | ETF | 694.57 | 694.69 | 693.18 | 693.61 | 8518950.0 |
| 2026-01-15 10:00:00 | SPY | ETF | 693.61 | 694.72 | 693.27 | 693.94 | 4909144.0 |
| 2026-01-15 10:30:00 | SPY | ETF | 693.94 | 694.9 | 692.99 | 694.45 | 6520284.0 |
| 2026-01-15 11:00:00 | SPY | ETF | 694.45 | 695.16 | 694.34 | 694.815 | 3691722.0 |
| 2026-01-15 11:30:00 | SPY | ETF | 694.81 | 695.345 | 694.48 | 695.03 | 2574198.0 |
| 2026-01-15 12:00:00 | SPY | ETF | 695.0399 | 695.45 | 694.39 | 694.45 | 2600080.0 |
| 2026-01-15 12:30:00 | SPY | ETF | 694.45 | 695.0199 | 693.905 | 693.98 | 2769556.0 |
| 2026-01-15 13:00:00 | SPY | ETF | 693.98 | 694.905 | 693.88 | 694.885 | 2611465.0 |
| 2026-01-15 13:30:00 | SPY | ETF | 694.88 | 695.25 | 694.615 | 694.7158 | 1992222.0 |
| 2026-01-15 14:00:00 | SPY | ETF | 694.71 | 694.71 | 693.52 | 693.61 | 3205305.0 |
| 2026-01-15 14:30:00 | SPY | ETF | 693.61 | 693.7376 | 692.58 | 692.78 | 4869884.0 |
| 2026-01-15 15:00:00 | SPY | ETF | 692.77 | 693.03 | 691.2907 | 691.83 | 6197795.0 |
| 2026-01-15 15:30:00 | SPY | ETF | 691.835 | 692.25 | 691.25 | 692.18 | 9679925.0 |
| 2026-01-15 16:00:00 | SPY | ETF | 692.19 | 692.33 | 691.86 | 691.91 | 3403641.0 |
| 2026-01-15 16:30:00 | SPY | ETF | 691.93 | 692.24 | 691.85 | 692.1 | 300977.0 |
| 2026-01-15 17:00:00 | SPY | ETF | 692.1 | 692.38 | 692.05 | 692.38 | 32872.0 |
| 2026-01-15 17:30:00 | SPY | ETF | 692.38 | 692.45 | 692.23 | 692.3766 | 42132.0 |
| 2026-01-15 18:00:00 | SPY | ETF | 692.24 | 692.63 | 692.01 | 692.59 | 167521.0 |
| 2026-01-15 18:30:00 | SPY | ETF | 692.65 | 692.8 | 692.36 | 692.7 | 18787.0 |
| 2026-01-15 19:00:00 | SPY | ETF | 692.65 | 692.84 | 692.5 | 692.75 | 21927.0 |
| 2026-01-15 19:30:00 | SPY | ETF | 692.81 | 692.98 | 692.75 | 692.9387 | 10683.0 |
| 2026-01-15 04:00:00 | QQQ | ETF | 622.14 | 623.86 | 622.04 | 623.76 | 154313.0 |
| 2026-01-15 04:30:00 | QQQ | ETF | 623.77 | 624.47 | 623.77 | 623.95 | 77120.0 |
| 2026-01-15 05:00:00 | QQQ | ETF | 623.95 | 624.37 | 623.64 | 623.95 | 82933.0 |
| 2026-01-15 05:30:00 | QQQ | ETF | 624.02 | 624.31 | 623.9 | 624.11 | 62407.0 |
| 2026-01-15 06:00:00 | QQQ | ETF | 624.16 | 624.86 | 624.14 | 624.5 | 168228.0 |
| 2026-01-15 06:30:00 | QQQ | ETF | 624.5 | 625.08 | 624.45 | 624.7 | 166371.0 |
| 2026-01-15 07:00:00 | QQQ | ETF | 624.7 | 624.73 | 624.05 | 624.4 | 209848.0 |
| 2026-01-15 07:30:00 | QQQ | ETF | 624.41 | 625.0 | 623.91 | 624.88 | 131756.0 |
| 2026-01-15 08:00:00 | QQQ | ETF | 623.1 | 625.35 | 618.4 | 625.29 | 450484.0 |
| 2026-01-15 08:30:00 | QQQ | ETF | 625.32 | 626.42 | 624.9409 | 625.8802 | 776710.0 |
| 2026-01-15 09:00:00 | QQQ | ETF | 625.88 | 627.25 | 625.83 | 626.62 | 559978.0 |
| 2026-01-15 09:30:00 | QQQ | ETF | 626.61 | 627.27 | 624.66 | 625.16 | 7722676.0 |
| 2026-01-15 10:00:00 | QQQ | ETF | 625.155 | 626.4 | 624.61 | 625.14 | 3319190.0 |
| 2026-01-15 10:30:00 | QQQ | ETF | 625.15 | 630.0 | 623.76 | 625.7 | 4384019.0 |
| 2026-01-15 11:00:00 | QQQ | ETF | 625.69 | 626.77 | 625.55 | 626.17 | 2281972.0 |
| 2026-01-15 11:30:00 | QQQ | ETF | 626.14 | 626.98 | 625.61 | 626.64 | 1676555.0 |
| 2026-01-15 12:00:00 | QQQ | ETF | 626.64 | 626.96 | 625.51 | 625.6 | 1634755.0 |
| 2026-01-15 12:30:00 | QQQ | ETF | 625.6032 | 625.94 | 624.86 | 624.96 | 1747677.0 |
> showing 50 of 47,195 rows — these rows as CSV