PREVIEW / etf_30min / 2026-01-12
file: by_date/etf_30min/2026/2026-01-12.parquet size: 1.1 MB rows: 48,099
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-12 04:00:00 | SPY | ETF | 689.02 | 689.53 | 688.97 | 689.09 | 66794.0 |
| 2026-01-12 04:30:00 | SPY | ETF | 689.06 | 689.63 | 688.88 | 689.54 | 23502.0 |
| 2026-01-12 05:00:00 | SPY | ETF | 689.57 | 689.63 | 689.31 | 689.59 | 34609.0 |
| 2026-01-12 05:30:00 | SPY | ETF | 689.57 | 689.81 | 689.45 | 689.6 | 18628.0 |
| 2026-01-12 06:00:00 | SPY | ETF | 689.56 | 690.2 | 689.5 | 689.95 | 36642.0 |
| 2026-01-12 06:30:00 | SPY | ETF | 689.88 | 690.01 | 689.74 | 689.8 | 39889.0 |
| 2026-01-12 07:00:00 | SPY | ETF | 689.83 | 690.52 | 689.77 | 690.39 | 170815.0 |
| 2026-01-12 07:30:00 | SPY | ETF | 690.34 | 690.78 | 690.16 | 690.6 | 156484.0 |
| 2026-01-12 08:00:00 | SPY | ETF | 689.12 | 690.751 | 688.79 | 690.63 | 266986.0 |
| 2026-01-12 08:30:00 | SPY | ETF | 690.65 | 690.72 | 690.27 | 690.46 | 186549.0 |
| 2026-01-12 09:00:00 | SPY | ETF | 690.43 | 690.71 | 690.2 | 690.71 | 180957.0 |
| 2026-01-12 09:30:00 | SPY | ETF | 690.68 | 693.9 | 690.63 | 693.63 | 9209258.0 |
| 2026-01-12 10:00:00 | SPY | ETF | 693.64 | 693.81 | 693.0 | 693.57 | 5138553.0 |
| 2026-01-12 10:30:00 | SPY | ETF | 693.565 | 694.06 | 692.96 | 693.91 | 3919413.0 |
| 2026-01-12 11:00:00 | SPY | ETF | 693.915 | 694.68 | 693.66 | 694.23 | 3900141.0 |
| 2026-01-12 11:30:00 | SPY | ETF | 694.24 | 694.86 | 694.07 | 694.56 | 2619547.0 |
| 2026-01-12 12:00:00 | SPY | ETF | 694.56 | 694.8399 | 694.25 | 694.535 | 2404202.0 |
| 2026-01-12 12:30:00 | SPY | ETF | 694.53 | 694.76 | 694.1 | 694.6601 | 1893233.0 |
| 2026-01-12 13:00:00 | SPY | ETF | 694.67 | 695.2 | 694.585 | 695.125 | 2356886.0 |
| 2026-01-12 13:30:00 | SPY | ETF | 695.125 | 695.39 | 694.93 | 695.215 | 2181923.0 |
| 2026-01-12 14:00:00 | SPY | ETF | 695.21 | 695.46 | 694.945 | 695.32 | 2467551.0 |
| 2026-01-12 14:30:00 | SPY | ETF | 695.32 | 696.03 | 695.295 | 695.945 | 2988020.0 |
| 2026-01-12 15:00:00 | SPY | ETF | 695.945 | 696.09 | 695.18 | 695.32 | 3510178.0 |
| 2026-01-12 15:30:00 | SPY | ETF | 695.32 | 695.74 | 695.14 | 695.16 | 7207972.0 |
| 2026-01-12 16:00:00 | SPY | ETF | 695.155 | 695.45 | 695.0 | 695.35 | 1590686.0 |
| 2026-01-12 16:30:00 | SPY | ETF | 695.38 | 695.39 | 694.58 | 694.72 | 428938.0 |
| 2026-01-12 17:00:00 | SPY | ETF | 694.7301 | 695.06 | 694.73 | 695.06 | 133746.0 |
| 2026-01-12 17:30:00 | SPY | ETF | 695.07 | 695.19 | 695.0 | 695.09 | 85407.0 |
| 2026-01-12 18:00:00 | SPY | ETF | 695.09 | 695.09 | 694.36 | 694.63 | 139378.0 |
| 2026-01-12 18:30:00 | SPY | ETF | 694.66 | 694.76 | 694.21 | 694.24 | 20587.0 |
| 2026-01-12 19:00:00 | SPY | ETF | 694.21 | 694.33 | 694.02 | 694.0799 | 30344.0 |
| 2026-01-12 19:30:00 | SPY | ETF | 694.0785 | 694.1566 | 693.86 | 693.87 | 40745.0 |
| 2026-01-12 04:00:00 | QQQ | ETF | 620.26 | 621.15 | 620.25 | 620.65 | 83937.0 |
| 2026-01-12 04:30:00 | QQQ | ETF | 620.61 | 621.3 | 620.32 | 621.16 | 57752.0 |
| 2026-01-12 05:00:00 | QQQ | ETF | 621.15 | 621.3 | 620.88 | 621.26 | 55923.0 |
| 2026-01-12 05:30:00 | QQQ | ETF | 621.35 | 621.68 | 621.19 | 621.36 | 37056.0 |
| 2026-01-12 06:00:00 | QQQ | ETF | 621.34 | 621.96 | 621.32 | 621.62 | 59434.0 |
| 2026-01-12 06:30:00 | QQQ | ETF | 621.61 | 621.7 | 621.41 | 621.55 | 26696.0 |
| 2026-01-12 07:00:00 | QQQ | ETF | 621.6 | 622.17 | 621.48 | 621.88 | 112429.0 |
| 2026-01-12 07:30:00 | QQQ | ETF | 621.93 | 622.64 | 621.9 | 622.47 | 109069.0 |
| 2026-01-12 08:00:00 | QQQ | ETF | 621.64 | 622.69 | 619.6 | 622.49 | 460314.0 |
| 2026-01-12 08:30:00 | QQQ | ETF | 622.5 | 622.63 | 622.09 | 622.24 | 165311.0 |
| 2026-01-12 09:00:00 | QQQ | ETF | 622.21 | 622.5 | 621.67 | 622.31 | 360662.0 |
| 2026-01-12 09:30:00 | QQQ | ETF | 622.3 | 626.54 | 622.26 | 625.97 | 6472288.0 |
| 2026-01-12 10:00:00 | QQQ | ETF | 625.99 | 626.76 | 625.18 | 626.48 | 3818602.0 |
| 2026-01-12 10:30:00 | QQQ | ETF | 626.47 | 626.51 | 625.09 | 626.325 | 2681942.0 |
| 2026-01-12 11:00:00 | QQQ | ETF | 626.32 | 627.39 | 625.99 | 626.93 | 2099627.0 |
| 2026-01-12 11:30:00 | QQQ | ETF | 626.935 | 627.61 | 626.48 | 627.4 | 1392258.0 |
| 2026-01-12 12:00:00 | QQQ | ETF | 627.4 | 627.71 | 627.13 | 627.44 | 1177190.0 |
| 2026-01-12 12:30:00 | QQQ | ETF | 627.43 | 627.68 | 626.87 | 627.585 | 1046918.0 |
> showing 50 of 48,099 rows — these rows as CSV