PREVIEW / etf_30min / 2026-08-21
file: by_date/etf_30min/2026/2026-08-21.parquet size: 1.1 MB rows: 46,986
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-08-21 04:00:00 | SPY | ETF | 764.69 | 766.6 | 762.91 | 764.82 | 57616.0 |
| 2026-08-21 04:30:00 | SPY | ETF | 764.86 | 765.31 | 764.81 | 765.22 | 19072.0 |
| 2026-08-21 05:00:00 | SPY | ETF | 765.22 | 765.25 | 764.68 | 765.03 | 8752.0 |
| 2026-08-21 05:30:00 | SPY | ETF | 764.9 | 765.28 | 764.87 | 765.26 | 10896.0 |
| 2026-08-21 06:00:00 | SPY | ETF | 765.25 | 765.63 | 765.0 | 765.295 | 17439.0 |
| 2026-08-21 06:30:00 | SPY | ETF | 765.32 | 765.375 | 765.11 | 765.202 | 7921.0 |
| 2026-08-21 07:00:00 | SPY | ETF | 765.24 | 766.23 | 764.91 | 766.061 | 116106.0 |
| 2026-08-21 07:30:00 | SPY | ETF | 766.08 | 766.34 | 765.77 | 765.93 | 184115.0 |
| 2026-08-21 08:00:00 | SPY | ETF | 765.96 | 766.46 | 765.75 | 766.46 | 118829.0 |
| 2026-08-21 08:30:00 | SPY | ETF | 766.49 | 766.85 | 766.22 | 766.45 | 131430.0 |
| 2026-08-21 09:00:00 | SPY | ETF | 766.47 | 766.61 | 764.95 | 766.02 | 275883.0 |
| 2026-08-21 09:30:00 | SPY | ETF | 766.04 | 766.15 | 764.17 | 764.5124 | 3583646.0 |
| 2026-08-21 10:00:00 | SPY | ETF | 764.53 | 765.53 | 764.45 | 764.65 | 1804948.0 |
| 2026-08-21 10:30:00 | SPY | ETF | 764.65 | 765.835 | 764.215 | 765.8151 | 1391833.0 |
| 2026-08-21 11:00:00 | SPY | ETF | 765.81 | 766.41 | 765.455 | 765.955 | 1913902.0 |
| 2026-08-21 11:30:00 | SPY | ETF | 765.96 | 767.85 | 765.82 | 767.2 | 1671176.0 |
| 2026-08-21 12:00:00 | SPY | ETF | 767.2 | 767.3299 | 765.87 | 766.515 | 1671004.0 |
| 2026-08-21 12:30:00 | SPY | ETF | 766.51 | 766.57 | 765.81 | 766.39 | 1117308.0 |
| 2026-08-21 13:00:00 | SPY | ETF | 766.39 | 766.53 | 765.705 | 765.8 | 1053242.0 |
| 2026-08-21 13:30:00 | SPY | ETF | 765.82 | 765.9 | 765.43 | 765.43 | 820131.0 |
| 2026-08-21 14:00:00 | SPY | ETF | 765.44 | 765.735 | 765.26 | 765.285 | 931614.0 |
| 2026-08-21 14:30:00 | SPY | ETF | 765.27 | 766.23 | 765.06 | 766.1975 | 1237412.0 |
| 2026-08-21 15:00:00 | SPY | ETF | 766.2 | 766.365 | 765.85 | 766.05 | 1557887.0 |
| 2026-08-21 15:30:00 | SPY | ETF | 766.05 | 766.8 | 765.34 | 765.69 | 4885583.0 |
| 2026-08-21 16:00:00 | SPY | ETF | 765.65 | 765.72 | 765.24 | 765.26 | 2451243.0 |
| 2026-08-21 16:30:00 | SPY | ETF | 765.24 | 765.5 | 765.2 | 765.267 | 70005.0 |
| 2026-08-21 17:00:00 | SPY | ETF | 765.23 | 765.76 | 765.23 | 765.75 | 217273.0 |
| 2026-08-21 17:30:00 | SPY | ETF | 765.65 | 766.5 | 765.65 | 766.3034 | 92758.0 |
| 2026-08-21 18:00:00 | SPY | ETF | 766.33 | 767.2241 | 766.33 | 767.1 | 74147.0 |
| 2026-08-21 18:30:00 | SPY | ETF | 767.1 | 767.405 | 766.8905 | 767.29 | 71616.0 |
| 2026-08-21 19:00:00 | SPY | ETF | 767.13 | 767.14 | 766.71 | 766.79 | 16523.0 |
| 2026-08-21 19:30:00 | SPY | ETF | 766.79 | 767.0 | 766.73 | 767.0 | 14755.0 |
| 2026-08-21 04:00:00 | QQQ | ETF | 714.24 | 715.0 | 711.68 | 714.01 | 158112.0 |
| 2026-08-21 04:30:00 | QQQ | ETF | 714.01 | 715.13 | 713.98 | 714.9 | 40420.0 |
| 2026-08-21 05:00:00 | QQQ | ETF | 714.77 | 714.78 | 713.86 | 714.49 | 17558.0 |
| 2026-08-21 05:30:00 | QQQ | ETF | 714.5 | 715.77 | 714.39 | 715.61 | 38060.0 |
| 2026-08-21 06:00:00 | QQQ | ETF | 715.58 | 716.29 | 715.28 | 715.65 | 45684.0 |
| 2026-08-21 06:30:00 | QQQ | ETF | 715.74 | 715.77 | 715.29 | 715.49 | 31781.0 |
| 2026-08-21 07:00:00 | QQQ | ETF | 715.43 | 716.5 | 714.7921 | 716.37 | 179500.0 |
| 2026-08-21 07:30:00 | QQQ | ETF | 716.37 | 716.83 | 715.88 | 715.98 | 216319.0 |
| 2026-08-21 08:00:00 | QQQ | ETF | 715.94 | 716.3 | 710.397 | 716.3 | 77049.0 |
| 2026-08-21 08:30:00 | QQQ | ETF | 716.45 | 716.81 | 716.02 | 716.17 | 144033.0 |
| 2026-08-21 09:00:00 | QQQ | ETF | 716.18 | 716.2677 | 713.93 | 715.36 | 394119.0 |
| 2026-08-21 09:30:00 | QQQ | ETF | 715.22 | 715.4 | 710.1 | 711.27 | 3339067.0 |
| 2026-08-21 10:00:00 | QQQ | ETF | 711.2195 | 711.97 | 709.2 | 710.59 | 2287698.0 |
| 2026-08-21 10:30:00 | QQQ | ETF | 710.6 | 711.91 | 710.1635 | 711.9 | 1407829.0 |
| 2026-08-21 11:00:00 | QQQ | ETF | 711.9 | 712.85 | 711.78 | 712.75 | 1603396.0 |
| 2026-08-21 11:30:00 | QQQ | ETF | 712.78 | 715.6738 | 712.68 | 714.6 | 2387469.0 |
| 2026-08-21 12:00:00 | QQQ | ETF | 714.6 | 714.83 | 713.26 | 713.77 | 988048.0 |
| 2026-08-21 12:30:00 | QQQ | ETF | 713.7795 | 714.11 | 713.05 | 713.83 | 557935.0 |
> showing 50 of 46,986 rows — these rows as CSV