PREVIEW / etf_30min / 2026-08-27
file: by_date/etf_30min/2026/2026-08-27.parquet size: 1.1 MB rows: 46,392
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-08-27 04:00:00 | SPY | ETF | 769.47 | 770.27 | 767.6 | 770.27 | 80125.0 |
| 2026-08-27 04:30:00 | SPY | ETF | 770.25 | 770.25 | 769.57 | 769.79 | 14732.0 |
| 2026-08-27 05:00:00 | SPY | ETF | 769.6 | 769.65 | 768.76 | 769.29 | 64377.0 |
| 2026-08-27 05:30:00 | SPY | ETF | 769.42 | 769.68 | 769.42 | 769.46 | 7060.0 |
| 2026-08-27 06:00:00 | SPY | ETF | 769.17 | 769.23 | 768.8 | 768.82 | 17206.0 |
| 2026-08-27 06:30:00 | SPY | ETF | 768.84 | 769.3 | 768.69 | 769.205 | 17297.0 |
| 2026-08-27 07:00:00 | SPY | ETF | 769.27 | 769.8 | 769.03 | 769.089 | 139470.0 |
| 2026-08-27 07:30:00 | SPY | ETF | 769.06 | 769.32 | 768.375 | 769.0869 | 106869.0 |
| 2026-08-27 08:00:00 | SPY | ETF | 769.06 | 769.46 | 768.9 | 769.1092 | 195106.0 |
| 2026-08-27 08:30:00 | SPY | ETF | 769.12 | 769.12 | 767.96 | 768.02 | 70818.0 |
| 2026-08-27 09:00:00 | SPY | ETF | 767.97 | 768.55 | 767.91 | 768.55 | 182351.0 |
| 2026-08-27 09:30:00 | SPY | ETF | 768.49 | 769.69 | 767.16 | 768.4056 | 4296865.0 |
| 2026-08-27 10:00:00 | SPY | ETF | 768.4 | 769.88 | 768.05 | 769.675 | 1873695.0 |
| 2026-08-27 10:30:00 | SPY | ETF | 769.6999 | 770.44 | 769.06 | 770.395 | 1231928.0 |
| 2026-08-27 11:00:00 | SPY | ETF | 770.41 | 771.1 | 770.2281 | 770.315 | 1323376.0 |
| 2026-08-27 11:30:00 | SPY | ETF | 770.31 | 770.88 | 769.39 | 770.64 | 1559392.0 |
| 2026-08-27 12:00:00 | SPY | ETF | 770.64 | 770.97 | 770.34 | 770.91 | 884952.0 |
| 2026-08-27 12:30:00 | SPY | ETF | 770.91 | 772.03 | 770.82 | 771.99 | 1140120.0 |
| 2026-08-27 13:00:00 | SPY | ETF | 772.02 | 772.355 | 771.6 | 771.75 | 997401.0 |
| 2026-08-27 13:30:00 | SPY | ETF | 771.75 | 772.06 | 771.1 | 771.225 | 1183008.0 |
| 2026-08-27 14:00:00 | SPY | ETF | 771.225 | 771.39 | 769.26 | 769.46 | 1552487.0 |
| 2026-08-27 14:30:00 | SPY | ETF | 769.47 | 770.12 | 769.16 | 769.65 | 1284651.0 |
| 2026-08-27 15:00:00 | SPY | ETF | 769.65 | 770.28 | 769.52 | 769.94 | 1817659.0 |
| 2026-08-27 15:30:00 | SPY | ETF | 769.945 | 771.36 | 769.87 | 771.07 | 4228712.0 |
| 2026-08-27 16:00:00 | SPY | ETF | 771.05 | 771.2 | 770.0 | 770.16 | 2087428.0 |
| 2026-08-27 16:30:00 | SPY | ETF | 770.23 | 771.1 | 770.0 | 770.15 | 334737.0 |
| 2026-08-27 17:00:00 | SPY | ETF | 770.29 | 770.45 | 770.0 | 770.36 | 29463.0 |
| 2026-08-27 17:30:00 | SPY | ETF | 770.4 | 770.43 | 770.2886 | 770.3 | 10773.0 |
| 2026-08-27 18:00:00 | SPY | ETF | 770.29 | 770.34 | 769.65 | 770.24 | 30550.0 |
| 2026-08-27 18:30:00 | SPY | ETF | 770.27 | 770.29 | 770.1 | 770.18 | 2620.0 |
| 2026-08-27 19:00:00 | SPY | ETF | 770.19 | 770.19 | 769.65 | 769.85 | 19020.0 |
| 2026-08-27 19:30:00 | SPY | ETF | 769.88 | 769.9 | 769.6202 | 769.8 | 23372.0 |
| 2026-08-27 04:00:00 | QQQ | ETF | 717.35 | 720.15 | 714.0 | 720.135 | 358272.0 |
| 2026-08-27 04:30:00 | QQQ | ETF | 720.1 | 720.18 | 719.01 | 719.36 | 58517.0 |
| 2026-08-27 05:00:00 | QQQ | ETF | 719.33 | 719.5 | 717.95 | 718.66 | 62063.0 |
| 2026-08-27 05:30:00 | QQQ | ETF | 718.7 | 719.5 | 718.69 | 718.775 | 29873.0 |
| 2026-08-27 06:00:00 | QQQ | ETF | 718.76 | 718.865 | 718.21 | 718.27 | 37682.0 |
| 2026-08-27 06:30:00 | QQQ | ETF | 718.25 | 718.8 | 718.0 | 718.67 | 55874.0 |
| 2026-08-27 07:00:00 | QQQ | ETF | 718.71 | 719.45 | 718.0826 | 718.1393 | 85633.0 |
| 2026-08-27 07:30:00 | QQQ | ETF | 718.06 | 718.42 | 716.75 | 717.69 | 136922.0 |
| 2026-08-27 08:00:00 | QQQ | ETF | 717.74 | 718.48 | 717.6 | 718.194 | 116805.0 |
| 2026-08-27 08:30:00 | QQQ | ETF | 718.25 | 718.25 | 716.735 | 716.84 | 109249.0 |
| 2026-08-27 09:00:00 | QQQ | ETF | 716.85 | 718.0 | 716.78 | 716.94 | 244445.0 |
| 2026-08-27 09:30:00 | QQQ | ETF | 716.94 | 718.83 | 714.525 | 715.93 | 4008819.0 |
| 2026-08-27 10:00:00 | QQQ | ETF | 715.96 | 719.29 | 715.84 | 718.935 | 1769002.0 |
| 2026-08-27 10:30:00 | QQQ | ETF | 718.9 | 718.99 | 717.14 | 718.8 | 1400659.0 |
| 2026-08-27 11:00:00 | QQQ | ETF | 718.81 | 719.59 | 718.145 | 718.28 | 1102626.0 |
| 2026-08-27 11:30:00 | QQQ | ETF | 718.25 | 719.0 | 716.67 | 718.69 | 1426302.0 |
| 2026-08-27 12:00:00 | QQQ | ETF | 718.695 | 719.32 | 718.08 | 718.89 | 801810.0 |
| 2026-08-27 12:30:00 | QQQ | ETF | 718.8863 | 720.18 | 718.79 | 720.03 | 990006.0 |
> showing 50 of 46,392 rows — these rows as CSV