PREVIEW / etf_30min / 2026-01-06
file: by_date/etf_30min/2026/2026-01-06.parquet size: 1.1 MB rows: 47,683
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-06 04:00:00 | SPY | ETF | 686.95 | 687.37 | 686.9 | 687.0 | 22333.0 |
| 2026-01-06 04:30:00 | SPY | ETF | 687.01 | 687.69 | 686.88 | 687.25 | 17390.0 |
| 2026-01-06 05:00:00 | SPY | ETF | 687.27 | 687.43 | 687.13 | 687.22 | 8622.0 |
| 2026-01-06 05:30:00 | SPY | ETF | 687.29 | 687.47 | 687.27 | 687.35 | 8098.0 |
| 2026-01-06 06:00:00 | SPY | ETF | 687.35 | 687.55 | 687.33 | 687.42 | 4492.0 |
| 2026-01-06 06:30:00 | SPY | ETF | 687.38 | 687.5 | 687.19 | 687.35 | 14778.0 |
| 2026-01-06 07:00:00 | SPY | ETF | 687.29 | 687.69 | 687.22 | 687.67 | 31756.0 |
| 2026-01-06 07:30:00 | SPY | ETF | 687.68 | 688.19 | 687.55 | 688.06 | 26900.0 |
| 2026-01-06 08:00:00 | SPY | ETF | 687.07 | 689.07 | 686.44 | 687.7324 | 147834.0 |
| 2026-01-06 08:30:00 | SPY | ETF | 687.74 | 687.97 | 687.18 | 687.71 | 88654.0 |
| 2026-01-06 09:00:00 | SPY | ETF | 687.64 | 687.9296 | 687.28 | 687.9 | 265339.0 |
| 2026-01-06 09:30:00 | SPY | ETF | 687.93 | 690.16 | 687.78 | 690.075 | 7795284.0 |
| 2026-01-06 10:00:00 | SPY | ETF | 690.075 | 690.86 | 689.99 | 690.6599 | 5692226.0 |
| 2026-01-06 10:30:00 | SPY | ETF | 690.65 | 690.65 | 688.695 | 689.105 | 5936476.0 |
| 2026-01-06 11:00:00 | SPY | ETF | 689.1 | 689.5 | 688.3 | 689.045 | 4028707.0 |
| 2026-01-06 11:30:00 | SPY | ETF | 689.05 | 689.526 | 688.62 | 689.43 | 3314295.0 |
| 2026-01-06 12:00:00 | SPY | ETF | 689.43 | 690.62 | 689.155 | 690.39 | 2813300.0 |
| 2026-01-06 12:30:00 | SPY | ETF | 690.39 | 691.1 | 690.37 | 690.945 | 3063866.0 |
| 2026-01-06 13:00:00 | SPY | ETF | 690.95 | 691.2 | 690.55 | 690.8702 | 2307105.0 |
| 2026-01-06 13:30:00 | SPY | ETF | 690.88 | 691.725 | 690.65 | 691.72 | 2675923.0 |
| 2026-01-06 14:00:00 | SPY | ETF | 691.72 | 692.16 | 691.67 | 691.94 | 2862308.0 |
| 2026-01-06 14:30:00 | SPY | ETF | 691.948 | 692.165 | 691.82 | 691.875 | 2636752.0 |
| 2026-01-06 15:00:00 | SPY | ETF | 691.875 | 692.24 | 691.825 | 691.96 | 3108865.0 |
| 2026-01-06 15:30:00 | SPY | ETF | 691.96 | 692.315 | 691.8 | 691.8 | 8996081.0 |
| 2026-01-06 16:00:00 | SPY | ETF | 691.81 | 692.06 | 691.78 | 691.89 | 2432274.0 |
| 2026-01-06 16:30:00 | SPY | ETF | 691.91 | 692.13 | 691.8 | 692.05 | 190634.0 |
| 2026-01-06 17:00:00 | SPY | ETF | 692.059 | 692.1 | 687.86 | 691.94 | 129199.0 |
| 2026-01-06 17:30:00 | SPY | ETF | 691.94 | 692.0599 | 691.94 | 692.0019 | 35267.0 |
| 2026-01-06 18:00:00 | SPY | ETF | 692.08 | 692.29 | 691.9 | 692.0 | 60032.0 |
| 2026-01-06 18:30:00 | SPY | ETF | 691.963 | 692.0498 | 691.84 | 691.84 | 26475.0 |
| 2026-01-06 19:00:00 | SPY | ETF | 691.84 | 692.1902 | 691.82 | 692.11 | 38555.0 |
| 2026-01-06 19:30:00 | SPY | ETF | 692.1 | 692.2212 | 691.93 | 692.0996 | 24559.0 |
| 2026-01-06 04:00:00 | QQQ | ETF | 617.7 | 618.04 | 617.38 | 617.67 | 43920.0 |
| 2026-01-06 04:30:00 | QQQ | ETF | 617.63 | 618.54 | 617.54 | 618.06 | 56304.0 |
| 2026-01-06 05:00:00 | QQQ | ETF | 618.08 | 618.15 | 617.72 | 617.9 | 22084.0 |
| 2026-01-06 05:30:00 | QQQ | ETF | 617.89 | 618.3 | 617.86 | 618.2 | 15572.0 |
| 2026-01-06 06:00:00 | QQQ | ETF | 618.23 | 618.47 | 618.15 | 618.19 | 24954.0 |
| 2026-01-06 06:30:00 | QQQ | ETF | 618.23 | 618.6 | 618.16 | 618.31 | 17725.0 |
| 2026-01-06 07:00:00 | QQQ | ETF | 618.31 | 618.76 | 618.19 | 618.73 | 21620.0 |
| 2026-01-06 07:30:00 | QQQ | ETF | 618.8 | 619.53 | 618.69 | 619.35 | 70929.0 |
| 2026-01-06 08:00:00 | QQQ | ETF | 618.1932 | 620.1 | 616.69 | 618.95 | 229533.0 |
| 2026-01-06 08:30:00 | QQQ | ETF | 618.98 | 619.27 | 618.18 | 618.85 | 142684.0 |
| 2026-01-06 09:00:00 | QQQ | ETF | 618.79 | 619.24 | 618.22 | 619.2 | 159241.0 |
| 2026-01-06 09:30:00 | QQQ | ETF | 619.23 | 622.19 | 618.54 | 621.9844 | 6057073.0 |
| 2026-01-06 10:00:00 | QQQ | ETF | 621.96 | 622.59 | 621.35 | 622.43 | 3299767.0 |
| 2026-01-06 10:30:00 | QQQ | ETF | 622.42 | 622.45 | 620.1 | 620.43 | 3446992.0 |
| 2026-01-06 11:00:00 | QQQ | ETF | 620.43 | 620.96 | 619.29 | 620.2 | 2833790.0 |
| 2026-01-06 11:30:00 | QQQ | ETF | 620.2 | 620.78 | 619.76 | 620.66 | 2023040.0 |
| 2026-01-06 12:00:00 | QQQ | ETF | 620.65 | 621.8 | 620.1499 | 621.5825 | 1779864.0 |
| 2026-01-06 12:30:00 | QQQ | ETF | 621.59 | 622.785 | 621.57 | 622.16 | 1893475.0 |
> showing 50 of 47,683 rows — these rows as CSV