PREVIEW / etf_30min / 2026-08-07
file: by_date/etf_30min/2026/2026-08-07.parquet size: 1.0 MB rows: 46,104
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-07 04:00:00 | SPY | ETF | 768.46 | 769.93 | 767.88 | 769.65 | 39618.0 |
| 2026-08-07 04:30:00 | SPY | ETF | 769.69 | 769.94 | 769.29 | 769.82 | 148117.0 |
| 2026-08-07 05:00:00 | SPY | ETF | 769.82 | 770.16 | 769.73 | 769.98 | 12030.0 |
| 2026-08-07 05:30:00 | SPY | ETF | 769.97 | 770.08 | 769.8481 | 769.85 | 6512.0 |
| 2026-08-07 06:00:00 | SPY | ETF | 769.8443 | 769.96 | 769.68 | 769.79 | 10477.0 |
| 2026-08-07 06:30:00 | SPY | ETF | 769.9722 | 770.16 | 769.8 | 769.92 | 31289.0 |
| 2026-08-07 07:00:00 | SPY | ETF | 769.94 | 770.75 | 769.9262 | 770.65 | 33713.0 |
| 2026-08-07 07:30:00 | SPY | ETF | 770.609 | 771.0 | 770.13 | 770.16 | 70196.0 |
| 2026-08-07 08:00:00 | SPY | ETF | 770.15 | 771.15 | 768.35 | 771.01 | 101683.0 |
| 2026-08-07 08:30:00 | SPY | ETF | 770.9 | 773.11 | 770.88 | 772.67 | 618060.0 |
| 2026-08-07 09:00:00 | SPY | ETF | 772.7 | 772.78 | 770.65 | 771.02 | 316831.0 |
| 2026-08-07 09:30:00 | SPY | ETF | 771.02 | 772.37 | 770.46 | 771.0403 | 3427898.0 |
| 2026-08-07 10:00:00 | SPY | ETF | 771.07 | 773.29 | 769.61 | 773.19 | 2630008.0 |
| 2026-08-07 10:30:00 | SPY | ETF | 773.16 | 773.35 | 771.71 | 772.88 | 1813050.0 |
| 2026-08-07 11:00:00 | SPY | ETF | 772.88 | 773.89 | 772.37 | 773.65 | 1701625.0 |
| 2026-08-07 11:30:00 | SPY | ETF | 773.66 | 773.915 | 772.83 | 773.03 | 1557526.0 |
| 2026-08-07 12:00:00 | SPY | ETF | 773.04 | 773.38 | 771.334 | 771.725 | 1526834.0 |
| 2026-08-07 12:30:00 | SPY | ETF | 771.735 | 772.86 | 771.0615 | 771.965 | 1354364.0 |
| 2026-08-07 13:00:00 | SPY | ETF | 771.9601 | 772.41 | 771.74 | 772.09 | 940595.0 |
| 2026-08-07 13:30:00 | SPY | ETF | 772.11 | 772.46 | 771.73 | 772.17 | 874026.0 |
| 2026-08-07 14:00:00 | SPY | ETF | 772.165 | 772.285 | 771.45 | 771.48 | 1310030.0 |
| 2026-08-07 14:30:00 | SPY | ETF | 771.475 | 771.81 | 770.89 | 771.71 | 1165577.0 |
| 2026-08-07 15:00:00 | SPY | ETF | 771.68 | 773.45 | 771.66 | 773.075 | 2147531.0 |
| 2026-08-07 15:30:00 | SPY | ETF | 773.08 | 773.83 | 772.52 | 773.2 | 4972676.0 |
| 2026-08-07 16:00:00 | SPY | ETF | 773.16 | 773.4 | 772.55 | 772.62 | 3525763.0 |
| 2026-08-07 16:30:00 | SPY | ETF | 772.6035 | 773.12 | 772.6035 | 773.12 | 139008.0 |
| 2026-08-07 17:00:00 | SPY | ETF | 773.08 | 773.08 | 772.9502 | 773.0 | 45304.0 |
| 2026-08-07 17:30:00 | SPY | ETF | 772.99 | 773.0 | 772.92 | 772.98 | 8741.0 |
| 2026-08-07 18:00:00 | SPY | ETF | 772.95 | 773.19 | 772.93 | 773.19 | 3996.0 |
| 2026-08-07 18:30:00 | SPY | ETF | 773.15 | 773.2116 | 772.84 | 772.84 | 9179.0 |
| 2026-08-07 19:00:00 | SPY | ETF | 772.89 | 773.25 | 772.8 | 773.2099 | 6590.0 |
| 2026-08-07 19:30:00 | SPY | ETF | 773.05 | 773.4 | 773.05 | 773.375 | 7767.0 |
| 2026-08-07 04:00:00 | QQQ | ETF | 717.11 | 718.12 | 714.0 | 718.0 | 122266.0 |
| 2026-08-07 04:30:00 | QQQ | ETF | 717.98 | 718.525 | 717.68 | 718.3 | 38013.0 |
| 2026-08-07 05:00:00 | QQQ | ETF | 718.3 | 718.58 | 718.04 | 718.29 | 22618.0 |
| 2026-08-07 05:30:00 | QQQ | ETF | 718.25 | 718.5 | 717.83 | 717.8304 | 14419.0 |
| 2026-08-07 06:00:00 | QQQ | ETF | 717.92 | 718.1 | 717.23 | 717.93 | 22660.0 |
| 2026-08-07 06:30:00 | QQQ | ETF | 717.91 | 718.0 | 717.5 | 717.61 | 10070.0 |
| 2026-08-07 07:00:00 | QQQ | ETF | 717.62 | 718.9 | 717.62 | 718.8 | 59041.0 |
| 2026-08-07 07:30:00 | QQQ | ETF | 718.68 | 719.1 | 717.73 | 717.83 | 98549.0 |
| 2026-08-07 08:00:00 | QQQ | ETF | 717.72 | 719.44 | 716.21 | 719.16 | 118328.0 |
| 2026-08-07 08:30:00 | QQQ | ETF | 718.84 | 723.85 | 718.84 | 723.3 | 799445.0 |
| 2026-08-07 09:00:00 | QQQ | ETF | 723.3 | 723.43 | 719.46 | 720.19 | 459187.0 |
| 2026-08-07 09:30:00 | QQQ | ETF | 720.15 | 722.71 | 718.46 | 719.31 | 3148196.0 |
| 2026-08-07 10:00:00 | QQQ | ETF | 719.32 | 721.65 | 716.51 | 721.29 | 2962319.0 |
| 2026-08-07 10:30:00 | QQQ | ETF | 721.24 | 721.54 | 718.82 | 720.27 | 1866126.0 |
| 2026-08-07 11:00:00 | QQQ | ETF | 720.27 | 722.86 | 720.02 | 722.81 | 1953866.0 |
| 2026-08-07 11:30:00 | QQQ | ETF | 722.8 | 723.4999 | 722.04 | 722.5 | 1810346.0 |
| 2026-08-07 12:00:00 | QQQ | ETF | 722.53 | 722.91 | 719.5016 | 720.1 | 1383361.0 |
| 2026-08-07 12:30:00 | QQQ | ETF | 720.1 | 721.68 | 719.05 | 720.7 | 1341117.0 |
> showing 50 of 46,104 rows — these rows as CSV