PREVIEW / etf_30min / 2026-09-01
file: by_date/etf_30min/2026/2026-09-01.parquet size: 1.1 MB rows: 48,046
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-09-01 04:00:00 | SPY | ETF | 766.4 | 767.84 | 763.79 | 763.8 | 73054.0 |
| 2026-09-01 04:30:00 | SPY | ETF | 763.8 | 764.15 | 763.19 | 763.2 | 24018.0 |
| 2026-09-01 05:00:00 | SPY | ETF | 763.21 | 763.23 | 762.205 | 762.37 | 59849.0 |
| 2026-09-01 05:30:00 | SPY | ETF | 762.48 | 762.9 | 762.32 | 762.69 | 16669.0 |
| 2026-09-01 06:00:00 | SPY | ETF | 762.76 | 764.0 | 762.5 | 763.34 | 25124.0 |
| 2026-09-01 06:30:00 | SPY | ETF | 763.38 | 763.7 | 762.78 | 762.97 | 65680.0 |
| 2026-09-01 07:00:00 | SPY | ETF | 762.96 | 763.13 | 762.59 | 763.02 | 211762.0 |
| 2026-09-01 07:30:00 | SPY | ETF | 762.99 | 763.61 | 762.4 | 762.5377 | 68974.0 |
| 2026-09-01 08:00:00 | SPY | ETF | 762.5177 | 762.79 | 762.15 | 762.6 | 205476.0 |
| 2026-09-01 08:30:00 | SPY | ETF | 762.5 | 762.5 | 761.81 | 762.05 | 241912.0 |
| 2026-09-01 09:00:00 | SPY | ETF | 762.03 | 762.2 | 761.41 | 762.04 | 194102.0 |
| 2026-09-01 09:30:00 | SPY | ETF | 762.03 | 762.48 | 761.17 | 762.015 | 3153155.0 |
| 2026-09-01 10:00:00 | SPY | ETF | 762.02 | 764.0 | 761.74 | 763.7694 | 1968036.0 |
| 2026-09-01 10:30:00 | SPY | ETF | 763.76 | 764.55 | 763.3501 | 763.54 | 1972423.0 |
| 2026-09-01 11:00:00 | SPY | ETF | 763.56 | 763.66 | 762.67 | 763.59 | 1422964.0 |
| 2026-09-01 11:30:00 | SPY | ETF | 763.59 | 764.67 | 763.44 | 764.29 | 1435428.0 |
| 2026-09-01 12:00:00 | SPY | ETF | 764.29 | 764.34 | 762.29 | 762.5399 | 1820860.0 |
| 2026-09-01 12:30:00 | SPY | ETF | 762.54 | 762.63 | 761.58 | 762.26 | 1485532.0 |
| 2026-09-01 13:00:00 | SPY | ETF | 762.26 | 762.29 | 760.73 | 761.68 | 1560865.0 |
| 2026-09-01 13:30:00 | SPY | ETF | 761.68 | 762.23 | 761.46 | 761.82 | 1201576.0 |
| 2026-09-01 14:00:00 | SPY | ETF | 761.81 | 762.04 | 761.07 | 761.21 | 1420506.0 |
| 2026-09-01 14:30:00 | SPY | ETF | 761.2199 | 761.245 | 759.48 | 760.7295 | 2142157.0 |
| 2026-09-01 15:00:00 | SPY | ETF | 760.72 | 761.61 | 760.62 | 761.36 | 2020351.0 |
| 2026-09-01 15:30:00 | SPY | ETF | 761.3999 | 761.76 | 760.58 | 761.66 | 5455932.0 |
| 2026-09-01 16:00:00 | SPY | ETF | 761.64 | 762.16 | 761.35 | 761.95 | 2611419.0 |
| 2026-09-01 16:30:00 | SPY | ETF | 761.95 | 762.17 | 761.79 | 761.9 | 174418.0 |
| 2026-09-01 17:00:00 | SPY | ETF | 761.97 | 762.15 | 761.78 | 761.78 | 45678.0 |
| 2026-09-01 17:30:00 | SPY | ETF | 761.79 | 761.94 | 761.75 | 761.78 | 22460.0 |
| 2026-09-01 18:00:00 | SPY | ETF | 761.77 | 762.07 | 761.45 | 761.53 | 48775.0 |
| 2026-09-01 18:30:00 | SPY | ETF | 761.59 | 761.93 | 761.55 | 761.8 | 9895.0 |
| 2026-09-01 19:00:00 | SPY | ETF | 761.77 | 761.88 | 761.67 | 761.8 | 28544.0 |
| 2026-09-01 19:30:00 | SPY | ETF | 761.85 | 761.99 | 761.78 | 761.93 | 22614.0 |
| 2026-09-01 04:00:00 | QQQ | ETF | 715.68 | 718.38 | 711.42 | 711.44 | 221376.0 |
| 2026-09-01 04:30:00 | QQQ | ETF | 711.5 | 712.15 | 710.3 | 710.3607 | 149409.0 |
| 2026-09-01 05:00:00 | QQQ | ETF | 710.43 | 710.5 | 709.19 | 709.4 | 134770.0 |
| 2026-09-01 05:30:00 | QQQ | ETF | 709.4499 | 710.16 | 709.12 | 709.85 | 57233.0 |
| 2026-09-01 06:00:00 | QQQ | ETF | 709.75 | 710.62 | 709.53 | 710.3456 | 55082.0 |
| 2026-09-01 06:30:00 | QQQ | ETF | 710.4292 | 710.87 | 709.46 | 709.84 | 119054.0 |
| 2026-09-01 07:00:00 | QQQ | ETF | 709.75 | 709.9 | 709.0 | 709.71 | 83831.0 |
| 2026-09-01 07:30:00 | QQQ | ETF | 709.72 | 710.39 | 708.72 | 708.84 | 159579.0 |
| 2026-09-01 08:00:00 | QQQ | ETF | 708.81 | 708.94 | 707.99 | 708.7348 | 179761.0 |
| 2026-09-01 08:30:00 | QQQ | ETF | 708.7 | 717.297 | 707.65 | 707.65 | 169661.0 |
| 2026-09-01 09:00:00 | QQQ | ETF | 707.65 | 707.65 | 706.7 | 707.3 | 300285.0 |
| 2026-09-01 09:30:00 | QQQ | ETF | 707.37 | 708.45 | 705.62 | 707.225 | 3880458.0 |
| 2026-09-01 10:00:00 | QQQ | ETF | 707.27 | 708.97 | 706.7714 | 708.61 | 1749882.0 |
| 2026-09-01 10:30:00 | QQQ | ETF | 708.6 | 711.1 | 708.57 | 710.18 | 1575958.0 |
| 2026-09-01 11:00:00 | QQQ | ETF | 710.18 | 710.48 | 708.9997 | 710.24 | 1149909.0 |
| 2026-09-01 11:30:00 | QQQ | ETF | 710.25 | 712.3 | 710.06 | 711.81 | 1229014.0 |
| 2026-09-01 12:00:00 | QQQ | ETF | 711.85 | 711.89 | 708.61 | 708.99 | 1768361.0 |
| 2026-09-01 12:30:00 | QQQ | ETF | 708.97 | 709.44 | 707.87 | 709.3 | 1535493.0 |
> showing 50 of 48,046 rows — these rows as CSV