PREVIEW / etf_30min / 2026-01-28
file: by_date/etf_30min/2026/2026-01-28.parquet size: 1.1 MB rows: 48,865
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-28 04:00:00 | SPY | ETF | 697.5 | 697.88 | 697.42 | 697.59 | 57267.0 |
| 2026-01-28 04:30:00 | SPY | ETF | 697.55 | 698.04 | 697.45 | 697.95 | 25311.0 |
| 2026-01-28 05:00:00 | SPY | ETF | 697.85 | 698.05 | 697.7 | 697.86 | 7487.0 |
| 2026-01-28 05:30:00 | SPY | ETF | 697.93 | 698.35 | 697.91 | 698.26 | 8562.0 |
| 2026-01-28 06:00:00 | SPY | ETF | 698.23 | 698.25 | 697.65 | 698.09 | 28211.0 |
| 2026-01-28 06:30:00 | SPY | ETF | 698.13 | 698.24 | 697.93 | 698.0 | 90021.0 |
| 2026-01-28 07:00:00 | SPY | ETF | 698.04 | 698.08 | 697.0 | 697.31 | 115942.0 |
| 2026-01-28 07:30:00 | SPY | ETF | 697.34 | 697.64 | 697.07 | 697.07 | 78627.0 |
| 2026-01-28 08:00:00 | SPY | ETF | 697.07 | 698.96 | 696.6605 | 696.85 | 186355.0 |
| 2026-01-28 08:30:00 | SPY | ETF | 696.84 | 697.0584 | 696.56 | 697.02 | 116202.0 |
| 2026-01-28 09:00:00 | SPY | ETF | 696.97 | 697.11 | 696.61 | 697.06 | 279292.0 |
| 2026-01-28 09:30:00 | SPY | ETF | 697.06 | 697.84 | 696.9 | 697.12 | 7095218.0 |
| 2026-01-28 10:00:00 | SPY | ETF | 697.11 | 697.32 | 696.03 | 696.5139 | 4256879.0 |
| 2026-01-28 10:30:00 | SPY | ETF | 696.52 | 696.79 | 695.54 | 695.555 | 2821390.0 |
| 2026-01-28 11:00:00 | SPY | ETF | 695.56 | 696.33 | 695.45 | 696.1242 | 2387743.0 |
| 2026-01-28 11:30:00 | SPY | ETF | 696.12 | 696.12 | 694.495 | 694.7218 | 3080338.0 |
| 2026-01-28 12:00:00 | SPY | ETF | 694.72 | 695.68 | 694.68 | 694.855 | 2348067.0 |
| 2026-01-28 12:30:00 | SPY | ETF | 694.835 | 695.435 | 694.52 | 694.85 | 1956547.0 |
| 2026-01-28 13:00:00 | SPY | ETF | 694.84 | 695.43 | 694.56 | 695.15 | 1453320.0 |
| 2026-01-28 13:30:00 | SPY | ETF | 695.16 | 695.31 | 694.765 | 695.11 | 1487771.0 |
| 2026-01-28 14:00:00 | SPY | ETF | 695.09 | 695.6499 | 694.046 | 694.18 | 3170244.0 |
| 2026-01-28 14:30:00 | SPY | ETF | 694.18 | 696.07 | 693.94 | 694.91 | 5597924.0 |
| 2026-01-28 15:00:00 | SPY | ETF | 694.91 | 696.285 | 694.78 | 695.45 | 3161590.0 |
| 2026-01-28 15:30:00 | SPY | ETF | 695.44 | 696.135 | 694.75 | 695.42 | 8065252.0 |
| 2026-01-28 16:00:00 | SPY | ETF | 695.43 | 696.9499 | 692.49 | 696.88 | 2732896.0 |
| 2026-01-28 16:30:00 | SPY | ETF | 696.88 | 697.05 | 696.1872 | 696.42 | 429937.0 |
| 2026-01-28 17:00:00 | SPY | ETF | 696.41 | 696.87 | 696.32 | 696.8 | 129668.0 |
| 2026-01-28 17:30:00 | SPY | ETF | 696.79 | 696.87 | 696.19 | 696.6858 | 69175.0 |
| 2026-01-28 18:00:00 | SPY | ETF | 696.75 | 696.9 | 694.51 | 695.18 | 146564.0 |
| 2026-01-28 18:30:00 | SPY | ETF | 695.27 | 695.5 | 694.22 | 694.39 | 74780.0 |
| 2026-01-28 19:00:00 | SPY | ETF | 694.3994 | 694.6899 | 693.31 | 694.61 | 136000.0 |
| 2026-01-28 19:30:00 | SPY | ETF | 694.52 | 694.66 | 693.94 | 694.6302 | 56471.0 |
| 2026-01-28 04:00:00 | QQQ | ETF | 636.13 | 636.36 | 635.43 | 635.71 | 53841.0 |
| 2026-01-28 04:30:00 | QQQ | ETF | 635.71 | 636.38 | 635.5 | 636.27 | 39130.0 |
| 2026-01-28 05:00:00 | QQQ | ETF | 636.24 | 636.54 | 636.01 | 636.49 | 32871.0 |
| 2026-01-28 05:30:00 | QQQ | ETF | 636.51 | 637.13 | 636.48 | 637.11 | 44528.0 |
| 2026-01-28 06:00:00 | QQQ | ETF | 637.08 | 637.08 | 636.35 | 636.85 | 48933.0 |
| 2026-01-28 06:30:00 | QQQ | ETF | 636.9 | 637.29 | 636.79 | 637.07 | 50888.0 |
| 2026-01-28 07:00:00 | QQQ | ETF | 637.08 | 637.11 | 635.82 | 636.12 | 112296.0 |
| 2026-01-28 07:30:00 | QQQ | ETF | 636.21 | 636.64 | 635.95 | 636.18 | 55649.0 |
| 2026-01-28 08:00:00 | QQQ | ETF | 636.99 | 637.61 | 630.657 | 636.09 | 279477.0 |
| 2026-01-28 08:30:00 | QQQ | ETF | 636.07 | 636.26 | 635.52 | 635.99 | 271873.0 |
| 2026-01-28 09:00:00 | QQQ | ETF | 635.95 | 636.1 | 635.03 | 635.46 | 350493.0 |
| 2026-01-28 09:30:00 | QQQ | ETF | 635.46 | 636.6 | 634.52 | 635.46 | 6427935.0 |
| 2026-01-28 10:00:00 | QQQ | ETF | 635.45 | 635.75 | 634.36 | 634.69 | 3797698.0 |
| 2026-01-28 10:30:00 | QQQ | ETF | 634.68 | 635.06 | 633.23 | 633.3 | 2929291.0 |
| 2026-01-28 11:00:00 | QQQ | ETF | 633.29 | 634.18 | 632.985 | 633.79 | 1977323.0 |
| 2026-01-28 11:30:00 | QQQ | ETF | 633.7868 | 633.7868 | 631.81 | 632.1901 | 2203194.0 |
| 2026-01-28 12:00:00 | QQQ | ETF | 632.19 | 633.33 | 632.12 | 632.43 | 1785843.0 |
| 2026-01-28 12:30:00 | QQQ | ETF | 632.44 | 633.35 | 632.04 | 632.78 | 1660106.0 |
> showing 50 of 48,865 rows — these rows as CSV