PREVIEW / etf_30min / 2026-01-22
file: by_date/etf_30min/2026/2026-01-22.parquet size: 1.1 MB rows: 47,832
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-22 04:00:00 | SPY | ETF | 688.0 | 689.85 | 688.0 | 689.4 | 87935.0 |
| 2026-01-22 04:30:00 | SPY | ETF | 689.4 | 689.86 | 689.35 | 689.57 | 21742.0 |
| 2026-01-22 05:00:00 | SPY | ETF | 689.57 | 689.63 | 688.9 | 689.28 | 40108.0 |
| 2026-01-22 05:30:00 | SPY | ETF | 689.31 | 689.5 | 689.24 | 689.42 | 13853.0 |
| 2026-01-22 06:00:00 | SPY | ETF | 689.38 | 689.73 | 688.74 | 689.16 | 54375.0 |
| 2026-01-22 06:30:00 | SPY | ETF | 689.13 | 689.56 | 688.66 | 688.78 | 58876.0 |
| 2026-01-22 07:00:00 | SPY | ETF | 688.75 | 689.01 | 688.45 | 688.87 | 234437.0 |
| 2026-01-22 07:30:00 | SPY | ETF | 688.83 | 689.09 | 688.59 | 688.99 | 54377.0 |
| 2026-01-22 08:00:00 | SPY | ETF | 688.75 | 689.849 | 685.44 | 689.28 | 239628.0 |
| 2026-01-22 08:30:00 | SPY | ETF | 689.24 | 690.06 | 688.9 | 690.01 | 278074.0 |
| 2026-01-22 09:00:00 | SPY | ETF | 690.0 | 690.07 | 689.5 | 689.89 | 280547.0 |
| 2026-01-22 09:30:00 | SPY | ETF | 689.85 | 690.67 | 687.38 | 687.89 | 11414860.0 |
| 2026-01-22 10:00:00 | SPY | ETF | 687.89 | 688.61 | 686.92 | 688.44 | 5883477.0 |
| 2026-01-22 10:30:00 | SPY | ETF | 688.46 | 689.49 | 688.05 | 688.63 | 3562877.0 |
| 2026-01-22 11:00:00 | SPY | ETF | 688.62 | 690.0469 | 688.58 | 689.8 | 3046292.0 |
| 2026-01-22 11:30:00 | SPY | ETF | 689.8 | 690.5 | 689.62 | 689.715 | 2178219.0 |
| 2026-01-22 12:00:00 | SPY | ETF | 689.71 | 690.558 | 689.405 | 690.23 | 2713887.0 |
| 2026-01-22 12:30:00 | SPY | ETF | 690.24 | 691.08 | 690.24 | 690.955 | 2232742.0 |
| 2026-01-22 13:00:00 | SPY | ETF | 690.95 | 691.125 | 690.27 | 690.45 | 2346663.0 |
| 2026-01-22 13:30:00 | SPY | ETF | 690.44 | 690.84 | 689.83 | 690.025 | 1918934.0 |
| 2026-01-22 14:00:00 | SPY | ETF | 690.01 | 690.96 | 689.97 | 690.66 | 2869015.0 |
| 2026-01-22 14:30:00 | SPY | ETF | 690.66 | 690.735 | 688.74 | 688.77 | 4420271.0 |
| 2026-01-22 15:00:00 | SPY | ETF | 688.76 | 689.51 | 688.13 | 688.16 | 4540364.0 |
| 2026-01-22 15:30:00 | SPY | ETF | 688.16 | 689.045 | 687.595 | 688.93 | 8904527.0 |
| 2026-01-22 16:00:00 | SPY | ETF | 688.93 | 689.17 | 688.51 | 688.99 | 4184103.0 |
| 2026-01-22 16:30:00 | SPY | ETF | 689.01 | 689.04 | 687.911 | 688.3997 | 212425.0 |
| 2026-01-22 17:00:00 | SPY | ETF | 688.3111 | 688.6 | 688.18 | 688.39 | 94047.0 |
| 2026-01-22 17:30:00 | SPY | ETF | 688.41 | 688.44 | 688.18 | 688.36 | 22874.0 |
| 2026-01-22 18:00:00 | SPY | ETF | 688.23 | 688.66 | 687.7502 | 688.52 | 57199.0 |
| 2026-01-22 18:30:00 | SPY | ETF | 688.52 | 688.76 | 688.22 | 688.43 | 14561.0 |
| 2026-01-22 19:00:00 | SPY | ETF | 688.42 | 688.96 | 688.15 | 688.8 | 9152.0 |
| 2026-01-22 19:30:00 | SPY | ETF | 688.82 | 689.329 | 688.8 | 689.329 | 23666.0 |
| 2026-01-22 04:00:00 | QQQ | ETF | 619.65 | 622.06 | 619.65 | 621.53 | 122530.0 |
| 2026-01-22 04:30:00 | QQQ | ETF | 621.52 | 621.96 | 621.46 | 621.64 | 44206.0 |
| 2026-01-22 05:00:00 | QQQ | ETF | 621.73 | 621.77 | 620.98 | 621.37 | 88531.0 |
| 2026-01-22 05:30:00 | QQQ | ETF | 621.39 | 621.55 | 621.3 | 621.49 | 39428.0 |
| 2026-01-22 06:00:00 | QQQ | ETF | 621.43 | 622.04 | 620.9 | 621.24 | 124227.0 |
| 2026-01-22 06:30:00 | QQQ | ETF | 621.22 | 621.73 | 620.99 | 621.04 | 78000.0 |
| 2026-01-22 07:00:00 | QQQ | ETF | 621.05 | 621.43 | 620.71 | 621.33 | 105449.0 |
| 2026-01-22 07:30:00 | QQQ | ETF | 621.29 | 621.55 | 620.99 | 621.45 | 63272.0 |
| 2026-01-22 08:00:00 | QQQ | ETF | 621.03 | 622.02 | 616.58 | 621.73 | 406701.0 |
| 2026-01-22 08:30:00 | QQQ | ETF | 621.71 | 622.6169 | 621.15 | 622.54 | 382162.0 |
| 2026-01-22 09:00:00 | QQQ | ETF | 622.5329 | 622.6 | 621.79 | 622.4 | 421279.0 |
| 2026-01-22 09:30:00 | QQQ | ETF | 622.36 | 622.46 | 618.15 | 618.81 | 7123898.0 |
| 2026-01-22 10:00:00 | QQQ | ETF | 618.82 | 619.53 | 617.78 | 619.1 | 3563168.0 |
| 2026-01-22 10:30:00 | QQQ | ETF | 619.13 | 620.71 | 618.63 | 619.44 | 2742655.0 |
| 2026-01-22 11:00:00 | QQQ | ETF | 619.43 | 621.3299 | 619.38 | 621.05 | 2329347.0 |
| 2026-01-22 11:30:00 | QQQ | ETF | 621.01 | 621.67 | 620.73 | 620.9201 | 1561850.0 |
| 2026-01-22 12:00:00 | QQQ | ETF | 620.92 | 621.54 | 620.55 | 621.18 | 1462367.0 |
| 2026-01-22 12:30:00 | QQQ | ETF | 621.2 | 622.2 | 621.2 | 621.97 | 1388448.0 |
> showing 50 of 47,832 rows — these rows as CSV