PREVIEW / etf_30min / 2026-01-26
file: by_date/etf_30min/2026/2026-01-26.parquet size: 1.1 MB rows: 48,291
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-26 04:00:00 | SPY | ETF | 688.62 | 689.74 | 687.91 | 689.08 | 50097.0 |
| 2026-01-26 04:30:00 | SPY | ETF | 689.08 | 689.11 | 686.97 | 687.61 | 50995.0 |
| 2026-01-26 05:00:00 | SPY | ETF | 687.57 | 688.2 | 687.55 | 688.14 | 15434.0 |
| 2026-01-26 05:30:00 | SPY | ETF | 688.16 | 688.58 | 688.12 | 688.21 | 9112.0 |
| 2026-01-26 06:00:00 | SPY | ETF | 688.2 | 688.28 | 687.98 | 688.12 | 9926.0 |
| 2026-01-26 06:30:00 | SPY | ETF | 688.12 | 688.47 | 688.0 | 688.47 | 10104.0 |
| 2026-01-26 07:00:00 | SPY | ETF | 688.38 | 689.16 | 688.38 | 688.76 | 125238.0 |
| 2026-01-26 07:30:00 | SPY | ETF | 688.821 | 688.83 | 688.5 | 688.75 | 73484.0 |
| 2026-01-26 08:00:00 | SPY | ETF | 689.65 | 689.7 | 686.9989 | 689.1 | 254176.0 |
| 2026-01-26 08:30:00 | SPY | ETF | 689.14 | 689.96 | 688.5 | 689.88 | 174211.0 |
| 2026-01-26 09:00:00 | SPY | ETF | 689.88 | 690.48 | 689.82 | 690.48 | 226751.0 |
| 2026-01-26 09:30:00 | SPY | ETF | 690.47 | 692.63 | 689.92 | 692.265 | 7530412.0 |
| 2026-01-26 10:00:00 | SPY | ETF | 692.26 | 693.4 | 691.75 | 692.55 | 4338458.0 |
| 2026-01-26 10:30:00 | SPY | ETF | 692.54 | 693.3388 | 692.23 | 692.975 | 3416019.0 |
| 2026-01-26 11:00:00 | SPY | ETF | 692.98 | 693.28 | 692.23 | 693.11 | 2536419.0 |
| 2026-01-26 11:30:00 | SPY | ETF | 693.11 | 693.36 | 692.775 | 693.12 | 1961782.0 |
| 2026-01-26 12:00:00 | SPY | ETF | 693.1 | 693.7099 | 693.03 | 693.5068 | 1914583.0 |
| 2026-01-26 12:30:00 | SPY | ETF | 693.5 | 693.58 | 693.03 | 693.24 | 1828315.0 |
| 2026-01-26 13:00:00 | SPY | ETF | 693.24 | 693.87 | 692.9 | 693.79 | 1796118.0 |
| 2026-01-26 13:30:00 | SPY | ETF | 693.78 | 694.13 | 693.33 | 693.59 | 2038638.0 |
| 2026-01-26 14:00:00 | SPY | ETF | 693.58 | 693.98 | 693.46 | 693.82 | 2171582.0 |
| 2026-01-26 14:30:00 | SPY | ETF | 693.825 | 694.0 | 693.54 | 693.59 | 2455657.0 |
| 2026-01-26 15:00:00 | SPY | ETF | 693.6 | 693.75 | 693.42 | 693.57 | 2951061.0 |
| 2026-01-26 15:30:00 | SPY | ETF | 693.575 | 693.87 | 692.62 | 692.71 | 9780132.0 |
| 2026-01-26 16:00:00 | SPY | ETF | 692.71 | 692.9485 | 692.4303 | 692.9318 | 3400669.0 |
| 2026-01-26 16:30:00 | SPY | ETF | 692.85 | 692.88 | 692.32 | 692.4 | 112679.0 |
| 2026-01-26 17:00:00 | SPY | ETF | 692.56 | 692.6093 | 692.21 | 692.29 | 80765.0 |
| 2026-01-26 17:30:00 | SPY | ETF | 692.28 | 692.34 | 692.23 | 692.31 | 72406.0 |
| 2026-01-26 18:00:00 | SPY | ETF | 692.31 | 692.99 | 691.88 | 692.4506 | 136408.0 |
| 2026-01-26 18:30:00 | SPY | ETF | 692.44 | 692.75 | 692.31 | 692.73 | 10603.0 |
| 2026-01-26 19:00:00 | SPY | ETF | 692.73 | 692.9 | 692.3908 | 692.74 | 15500.0 |
| 2026-01-26 19:30:00 | SPY | ETF | 692.72 | 693.04 | 692.7 | 692.97 | 16958.0 |
| 2026-01-26 04:00:00 | QQQ | ETF | 621.67 | 622.84 | 621.67 | 621.77 | 106254.0 |
| 2026-01-26 04:30:00 | QQQ | ETF | 621.73 | 621.77 | 619.32 | 620.06 | 73770.0 |
| 2026-01-26 05:00:00 | QQQ | ETF | 620.03 | 620.93 | 619.96 | 620.87 | 41994.0 |
| 2026-01-26 05:30:00 | QQQ | ETF | 620.9 | 621.4 | 620.82 | 620.85 | 26817.0 |
| 2026-01-26 06:00:00 | QQQ | ETF | 620.89 | 621.06 | 620.62 | 620.84 | 19773.0 |
| 2026-01-26 06:30:00 | QQQ | ETF | 620.8 | 621.34 | 620.8 | 621.32 | 18504.0 |
| 2026-01-26 07:00:00 | QQQ | ETF | 621.31 | 622.32 | 621.25 | 621.8 | 38687.0 |
| 2026-01-26 07:30:00 | QQQ | ETF | 621.93 | 621.96 | 621.48 | 621.78 | 29410.0 |
| 2026-01-26 08:00:00 | QQQ | ETF | 622.59 | 622.95 | 619.4 | 621.78 | 301285.0 |
| 2026-01-26 08:30:00 | QQQ | ETF | 621.76 | 622.53 | 621.03 | 622.44 | 242472.0 |
| 2026-01-26 09:00:00 | QQQ | ETF | 622.44 | 623.18 | 622.38 | 623.18 | 194830.0 |
| 2026-01-26 09:30:00 | QQQ | ETF | 623.21 | 625.69 | 622.12 | 625.2949 | 4660693.0 |
| 2026-01-26 10:00:00 | QQQ | ETF | 625.28 | 626.456 | 624.455 | 625.48 | 2811630.0 |
| 2026-01-26 10:30:00 | QQQ | ETF | 625.48 | 626.75 | 625.2 | 626.335 | 2173000.0 |
| 2026-01-26 11:00:00 | QQQ | ETF | 626.33 | 627.0 | 625.62 | 626.9 | 2214359.0 |
| 2026-01-26 11:30:00 | QQQ | ETF | 626.92 | 627.44 | 626.49 | 626.935 | 1707293.0 |
| 2026-01-26 12:00:00 | QQQ | ETF | 626.94 | 627.61 | 626.85 | 627.09 | 1474289.0 |
| 2026-01-26 12:30:00 | QQQ | ETF | 627.09 | 627.16 | 626.36 | 626.5699 | 1201911.0 |
> showing 50 of 48,291 rows — these rows as CSV