PREVIEW / etf_30min / 2026-01-29
file: by_date/etf_30min/2026/2026-01-29.parquet size: 1.1 MB rows: 48,949
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-29 04:00:00 | SPY | ETF | 697.0 | 697.75 | 697.0 | 697.35 | 30251.0 |
| 2026-01-29 04:30:00 | SPY | ETF | 697.47 | 697.7 | 696.74 | 696.79 | 51939.0 |
| 2026-01-29 05:00:00 | SPY | ETF | 696.75 | 697.16 | 696.63 | 697.08 | 10735.0 |
| 2026-01-29 05:30:00 | SPY | ETF | 696.99 | 697.1 | 696.19 | 696.27 | 22664.0 |
| 2026-01-29 06:00:00 | SPY | ETF | 696.27 | 696.76 | 695.95 | 696.66 | 13956.0 |
| 2026-01-29 06:30:00 | SPY | ETF | 696.62 | 697.05 | 696.52 | 696.71 | 21817.0 |
| 2026-01-29 07:00:00 | SPY | ETF | 696.74 | 697.2 | 696.7 | 697.13 | 157382.0 |
| 2026-01-29 07:30:00 | SPY | ETF | 697.06 | 697.1 | 696.2 | 696.74 | 51761.0 |
| 2026-01-29 08:00:00 | SPY | ETF | 696.75 | 697.76 | 695.9012 | 696.82 | 236961.0 |
| 2026-01-29 08:30:00 | SPY | ETF | 696.9 | 697.49 | 696.61 | 697.2 | 180738.0 |
| 2026-01-29 09:00:00 | SPY | ETF | 697.21 | 697.21 | 696.1526 | 696.39 | 291563.0 |
| 2026-01-29 09:30:00 | SPY | ETF | 696.35 | 697.06 | 691.47 | 691.56 | 10613514.0 |
| 2026-01-29 10:00:00 | SPY | ETF | 691.57 | 691.64 | 688.86 | 688.97 | 9114580.0 |
| 2026-01-29 10:30:00 | SPY | ETF | 688.97 | 689.31 | 685.1935 | 686.05 | 9497810.0 |
| 2026-01-29 11:00:00 | SPY | ETF | 686.07 | 688.655 | 684.83 | 687.91 | 8056957.0 |
| 2026-01-29 11:30:00 | SPY | ETF | 687.91 | 689.04 | 687.82 | 688.705 | 4443745.0 |
| 2026-01-29 12:00:00 | SPY | ETF | 688.71 | 691.36 | 688.64 | 691.0301 | 4306394.0 |
| 2026-01-29 12:30:00 | SPY | ETF | 691.02 | 691.675 | 688.71 | 688.89 | 4311234.0 |
| 2026-01-29 13:00:00 | SPY | ETF | 688.89 | 691.15 | 688.71 | 690.97 | 3635162.0 |
| 2026-01-29 13:30:00 | SPY | ETF | 690.98 | 691.81 | 690.19 | 690.59 | 3342947.0 |
| 2026-01-29 14:00:00 | SPY | ETF | 690.59 | 692.21 | 690.225 | 692.07 | 4088127.0 |
| 2026-01-29 14:30:00 | SPY | ETF | 692.07 | 692.225 | 691.08 | 691.13 | 3565873.0 |
| 2026-01-29 15:00:00 | SPY | ETF | 691.13 | 692.05 | 691.045 | 691.57 | 3557804.0 |
| 2026-01-29 15:30:00 | SPY | ETF | 691.58 | 694.79 | 691.39 | 693.97 | 12619719.0 |
| 2026-01-29 16:00:00 | SPY | ETF | 693.97 | 694.5825 | 693.47 | 693.75 | 2990892.0 |
| 2026-01-29 16:30:00 | SPY | ETF | 693.96 | 695.2 | 693.68 | 693.92 | 515967.0 |
| 2026-01-29 17:00:00 | SPY | ETF | 693.92 | 694.5 | 693.92 | 694.07 | 75876.0 |
| 2026-01-29 17:30:00 | SPY | ETF | 694.01 | 694.5 | 693.92 | 694.11 | 44298.0 |
| 2026-01-29 18:00:00 | SPY | ETF | 694.14 | 694.23 | 691.61 | 693.01 | 125407.0 |
| 2026-01-29 18:30:00 | SPY | ETF | 693.19 | 694.39 | 693.19 | 693.68 | 36278.0 |
| 2026-01-29 19:00:00 | SPY | ETF | 693.7094 | 693.9 | 692.44 | 692.77 | 30092.0 |
| 2026-01-29 19:30:00 | SPY | ETF | 692.81 | 693.95 | 692.42 | 692.6923 | 27472.0 |
| 2026-01-29 04:00:00 | QQQ | ETF | 635.44 | 636.02 | 635.39 | 635.5 | 53577.0 |
| 2026-01-29 04:30:00 | QQQ | ETF | 635.61 | 635.83 | 634.52 | 634.55 | 45002.0 |
| 2026-01-29 05:00:00 | QQQ | ETF | 634.51 | 635.14 | 634.21 | 634.95 | 32772.0 |
| 2026-01-29 05:30:00 | QQQ | ETF | 634.97 | 634.97 | 633.98 | 634.07 | 25431.0 |
| 2026-01-29 06:00:00 | QQQ | ETF | 634.06 | 634.39 | 633.7 | 634.1 | 72986.0 |
| 2026-01-29 06:30:00 | QQQ | ETF | 634.12 | 634.44 | 633.8 | 634.23 | 38869.0 |
| 2026-01-29 07:00:00 | QQQ | ETF | 634.31 | 634.78 | 634.05 | 634.29 | 82260.0 |
| 2026-01-29 07:30:00 | QQQ | ETF | 634.26 | 634.32 | 633.28 | 633.76 | 108698.0 |
| 2026-01-29 08:00:00 | QQQ | ETF | 634.48 | 636.1 | 632.746 | 633.71 | 277726.0 |
| 2026-01-29 08:30:00 | QQQ | ETF | 633.68 | 634.38 | 633.34 | 634.15 | 155810.0 |
| 2026-01-29 09:00:00 | QQQ | ETF | 634.14 | 634.2 | 632.67 | 632.67 | 318682.0 |
| 2026-01-29 09:30:00 | QQQ | ETF | 632.67 | 633.67 | 626.06 | 626.19 | 8995201.0 |
| 2026-01-29 10:00:00 | QQQ | ETF | 626.2 | 626.28 | 622.7 | 623.12 | 7348066.0 |
| 2026-01-29 10:30:00 | QQQ | ETF | 623.09 | 623.52 | 618.27 | 619.26 | 6690361.0 |
| 2026-01-29 11:00:00 | QQQ | ETF | 619.28 | 622.59 | 618.34 | 621.89 | 6205609.0 |
| 2026-01-29 11:30:00 | QQQ | ETF | 621.88 | 623.22 | 621.47 | 622.53 | 4227736.0 |
| 2026-01-29 12:00:00 | QQQ | ETF | 622.5 | 625.93 | 622.47 | 625.62 | 3598221.0 |
| 2026-01-29 12:30:00 | QQQ | ETF | 625.6 | 626.57 | 623.46 | 623.72 | 3354455.0 |
> showing 50 of 48,949 rows — these rows as CSV