PREVIEW / etf_30min / 2026-01-07
file: by_date/etf_30min/2026/2026-01-07.parquet size: 1.1 MB rows: 46,775
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-07 04:00:00 | SPY | ETF | 690.77 | 691.45 | 690.0 | 691.12 | 23491.0 |
| 2026-01-07 04:30:00 | SPY | ETF | 691.15 | 691.29 | 690.99 | 691.18 | 4855.0 |
| 2026-01-07 05:00:00 | SPY | ETF | 691.18 | 691.44 | 690.91 | 690.91 | 9723.0 |
| 2026-01-07 05:30:00 | SPY | ETF | 690.92 | 691.14 | 690.85 | 691.14 | 11871.0 |
| 2026-01-07 06:00:00 | SPY | ETF | 691.09 | 691.33 | 691.04 | 691.18 | 14819.0 |
| 2026-01-07 06:30:00 | SPY | ETF | 691.15 | 691.54 | 691.15 | 691.53 | 13167.0 |
| 2026-01-07 07:00:00 | SPY | ETF | 691.52 | 691.76 | 691.51 | 691.69 | 174587.0 |
| 2026-01-07 07:30:00 | SPY | ETF | 691.6 | 691.8 | 691.29 | 691.661 | 78152.0 |
| 2026-01-07 08:00:00 | SPY | ETF | 691.63 | 691.95 | 690.87 | 691.95 | 193722.0 |
| 2026-01-07 08:30:00 | SPY | ETF | 691.95 | 692.29 | 691.84 | 692.22 | 194066.0 |
| 2026-01-07 09:00:00 | SPY | ETF | 692.23 | 692.25 | 691.8 | 692.21 | 94585.0 |
| 2026-01-07 09:30:00 | SPY | ETF | 692.2 | 693.09 | 691.71 | 692.5666 | 6038125.0 |
| 2026-01-07 10:00:00 | SPY | ETF | 692.6 | 692.77 | 691.1 | 691.672 | 5660996.0 |
| 2026-01-07 10:30:00 | SPY | ETF | 691.67 | 692.6 | 690.96 | 692.505 | 5407022.0 |
| 2026-01-07 11:00:00 | SPY | ETF | 692.51 | 692.825 | 691.92 | 692.25 | 2809298.0 |
| 2026-01-07 11:30:00 | SPY | ETF | 692.25 | 693.56 | 692.1682 | 693.505 | 3336773.0 |
| 2026-01-07 12:00:00 | SPY | ETF | 693.52 | 693.96 | 693.47 | 693.6596 | 2611215.0 |
| 2026-01-07 12:30:00 | SPY | ETF | 693.66 | 693.79 | 692.78 | 692.99 | 3421183.0 |
| 2026-01-07 13:00:00 | SPY | ETF | 692.99 | 693.01 | 692.04 | 692.13 | 3347606.0 |
| 2026-01-07 13:30:00 | SPY | ETF | 692.13 | 693.145 | 692.13 | 692.825 | 3380483.0 |
| 2026-01-07 14:00:00 | SPY | ETF | 692.83 | 692.89 | 691.45 | 691.68 | 4256301.0 |
| 2026-01-07 14:30:00 | SPY | ETF | 691.68 | 692.16 | 691.58 | 691.74 | 2804855.0 |
| 2026-01-07 15:00:00 | SPY | ETF | 691.75 | 691.815 | 690.1175 | 690.36 | 5573502.0 |
| 2026-01-07 15:30:00 | SPY | ETF | 690.36 | 690.37 | 689.32 | 689.59 | 11507247.0 |
| 2026-01-07 16:00:00 | SPY | ETF | 689.585 | 689.61 | 689.14 | 689.47 | 2198801.0 |
| 2026-01-07 16:30:00 | SPY | ETF | 689.45 | 690.03 | 689.39 | 690.0 | 141551.0 |
| 2026-01-07 17:00:00 | SPY | ETF | 690.01 | 692.17 | 689.97 | 690.03 | 43225.0 |
| 2026-01-07 17:30:00 | SPY | ETF | 690.02 | 690.2 | 689.82 | 689.95 | 19313.0 |
| 2026-01-07 18:00:00 | SPY | ETF | 689.97 | 690.23 | 689.78 | 689.81 | 46738.0 |
| 2026-01-07 18:30:00 | SPY | ETF | 689.85 | 689.97 | 689.7 | 689.75 | 14036.0 |
| 2026-01-07 19:00:00 | SPY | ETF | 689.77 | 689.8795 | 689.58 | 689.62 | 14528.0 |
| 2026-01-07 19:30:00 | SPY | ETF | 689.71 | 690.15 | 689.6604 | 690.11 | 10011.0 |
| 2026-01-07 04:00:00 | QQQ | ETF | 622.85 | 622.85 | 621.47 | 621.9 | 91453.0 |
| 2026-01-07 04:30:00 | QQQ | ETF | 621.94 | 622.19 | 621.83 | 622.1 | 35220.0 |
| 2026-01-07 05:00:00 | QQQ | ETF | 622.08 | 622.3 | 621.66 | 621.67 | 27053.0 |
| 2026-01-07 05:30:00 | QQQ | ETF | 621.67 | 621.81 | 621.5 | 621.76 | 31264.0 |
| 2026-01-07 06:00:00 | QQQ | ETF | 621.74 | 622.01 | 621.6 | 621.81 | 24434.0 |
| 2026-01-07 06:30:00 | QQQ | ETF | 621.83 | 622.47 | 621.8 | 622.47 | 27080.0 |
| 2026-01-07 07:00:00 | QQQ | ETF | 622.48 | 622.82 | 622.34 | 622.65 | 72397.0 |
| 2026-01-07 07:30:00 | QQQ | ETF | 622.65 | 622.71 | 622.17 | 622.45 | 64955.0 |
| 2026-01-07 08:00:00 | QQQ | ETF | 622.43 | 623.2 | 621.5 | 622.66 | 218524.0 |
| 2026-01-07 08:30:00 | QQQ | ETF | 622.67 | 623.1 | 622.46 | 622.99 | 211761.0 |
| 2026-01-07 09:00:00 | QQQ | ETF | 623.01 | 623.04 | 622.35 | 623.04 | 194221.0 |
| 2026-01-07 09:30:00 | QQQ | ETF | 623.04 | 625.15 | 622.56 | 624.6 | 5425035.0 |
| 2026-01-07 10:00:00 | QQQ | ETF | 624.63 | 625.061 | 623.53 | 624.83 | 2983011.0 |
| 2026-01-07 10:30:00 | QQQ | ETF | 624.83 | 625.91 | 623.52 | 625.78 | 3387435.0 |
| 2026-01-07 11:00:00 | QQQ | ETF | 625.79 | 626.31 | 625.1441 | 625.54 | 1981081.0 |
| 2026-01-07 11:30:00 | QQQ | ETF | 625.5399 | 627.34 | 625.41 | 627.31 | 2664617.0 |
| 2026-01-07 12:00:00 | QQQ | ETF | 627.31 | 627.8 | 627.185 | 627.655 | 1763279.0 |
| 2026-01-07 12:30:00 | QQQ | ETF | 627.66 | 627.94 | 627.11 | 627.33 | 1842745.0 |
> showing 50 of 46,775 rows — these rows as CSV