PREVIEW / etf_30min / 2026-08-05
file: by_date/etf_30min/2026/2026-08-05.parquet size: 1.1 MB rows: 47,832
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-05 04:00:00 | SPY | ETF | 773.73 | 774.82 | 773.1 | 773.34 | 83887.0 |
| 2026-08-05 04:30:00 | SPY | ETF | 773.4 | 773.4 | 772.97 | 773.3 | 18398.0 |
| 2026-08-05 05:00:00 | SPY | ETF | 773.3247 | 773.7 | 773.17 | 773.7 | 12830.0 |
| 2026-08-05 05:30:00 | SPY | ETF | 773.77 | 774.06 | 773.6 | 773.77 | 27663.0 |
| 2026-08-05 06:00:00 | SPY | ETF | 773.72 | 774.18 | 773.66 | 774.15 | 14372.0 |
| 2026-08-05 06:30:00 | SPY | ETF | 774.17 | 774.66 | 774.05 | 774.57 | 64108.0 |
| 2026-08-05 07:00:00 | SPY | ETF | 774.59 | 774.8 | 774.3 | 774.3 | 132308.0 |
| 2026-08-05 07:30:00 | SPY | ETF | 774.3 | 775.0 | 774.0 | 774.6704 | 112536.0 |
| 2026-08-05 08:00:00 | SPY | ETF | 774.68 | 775.42 | 774.61 | 775.19 | 110723.0 |
| 2026-08-05 08:30:00 | SPY | ETF | 775.2613 | 775.2613 | 774.46 | 774.81 | 110450.0 |
| 2026-08-05 09:00:00 | SPY | ETF | 774.86 | 775.84 | 774.86 | 775.84 | 214267.0 |
| 2026-08-05 09:30:00 | SPY | ETF | 775.84 | 776.85 | 774.39 | 776.7036 | 4359415.0 |
| 2026-08-05 10:00:00 | SPY | ETF | 776.67 | 776.7 | 774.75 | 774.7809 | 2324395.0 |
| 2026-08-05 10:30:00 | SPY | ETF | 774.78 | 775.0201 | 772.54 | 773.47 | 3036703.0 |
| 2026-08-05 11:00:00 | SPY | ETF | 773.46 | 773.95 | 771.0 | 771.71 | 2576846.0 |
| 2026-08-05 11:30:00 | SPY | ETF | 771.7 | 772.52 | 770.33 | 770.645 | 1940826.0 |
| 2026-08-05 12:00:00 | SPY | ETF | 770.63 | 772.12 | 769.91 | 772.1 | 2876632.0 |
| 2026-08-05 12:30:00 | SPY | ETF | 772.09 | 772.22 | 771.2 | 771.8525 | 1674976.0 |
| 2026-08-05 13:00:00 | SPY | ETF | 771.89 | 772.16 | 771.01 | 771.34 | 1289512.0 |
| 2026-08-05 13:30:00 | SPY | ETF | 771.33 | 772.01 | 771.07 | 771.555 | 953593.0 |
| 2026-08-05 14:00:00 | SPY | ETF | 771.56 | 772.25 | 771.54 | 771.94 | 1663659.0 |
| 2026-08-05 14:30:00 | SPY | ETF | 771.93 | 771.96 | 771.2 | 771.391 | 1700936.0 |
| 2026-08-05 15:00:00 | SPY | ETF | 771.4 | 771.989 | 771.24 | 771.8 | 1845015.0 |
| 2026-08-05 15:30:00 | SPY | ETF | 771.78 | 771.89 | 769.51 | 769.76 | 4521890.0 |
| 2026-08-05 16:00:00 | SPY | ETF | 769.75 | 770.97 | 769.61 | 770.62 | 3161205.0 |
| 2026-08-05 16:30:00 | SPY | ETF | 770.63 | 771.09 | 770.63 | 770.83 | 166654.0 |
| 2026-08-05 17:00:00 | SPY | ETF | 770.76 | 771.0 | 770.41 | 770.6623 | 104951.0 |
| 2026-08-05 17:30:00 | SPY | ETF | 770.66 | 770.66 | 770.35 | 770.5 | 28536.0 |
| 2026-08-05 18:00:00 | SPY | ETF | 770.61 | 771.6399 | 770.59 | 771.5938 | 44267.0 |
| 2026-08-05 18:30:00 | SPY | ETF | 771.6295 | 771.97 | 771.35 | 771.35 | 15044.0 |
| 2026-08-05 19:00:00 | SPY | ETF | 771.33 | 771.71 | 771.3029 | 771.48 | 6250.0 |
| 2026-08-05 19:30:00 | SPY | ETF | 771.46 | 771.52 | 771.0 | 771.12 | 11386.0 |
| 2026-08-05 04:00:00 | QQQ | ETF | 723.84 | 726.55 | 722.46 | 722.8003 | 199623.0 |
| 2026-08-05 04:30:00 | QQQ | ETF | 722.85 | 722.995 | 721.92 | 722.81 | 81950.0 |
| 2026-08-05 05:00:00 | QQQ | ETF | 722.9 | 723.47 | 722.3 | 723.35 | 50375.0 |
| 2026-08-05 05:30:00 | QQQ | ETF | 723.39 | 724.1 | 723.29 | 723.33 | 32712.0 |
| 2026-08-05 06:00:00 | QQQ | ETF | 723.52 | 723.62 | 722.79 | 723.32 | 27031.0 |
| 2026-08-05 06:30:00 | QQQ | ETF | 723.35 | 723.69 | 722.82 | 723.54 | 32587.0 |
| 2026-08-05 07:00:00 | QQQ | ETF | 723.53 | 724.9 | 723.51 | 724.55 | 166460.0 |
| 2026-08-05 07:30:00 | QQQ | ETF | 724.36 | 725.4 | 724.11 | 724.87 | 120709.0 |
| 2026-08-05 08:00:00 | QQQ | ETF | 724.7986 | 725.29 | 724.18 | 725.21 | 103022.0 |
| 2026-08-05 08:30:00 | QQQ | ETF | 725.21 | 725.54 | 724.22 | 724.78 | 115305.0 |
| 2026-08-05 09:00:00 | QQQ | ETF | 724.7993 | 726.2 | 724.34 | 726.2 | 238635.0 |
| 2026-08-05 09:30:00 | QQQ | ETF | 726.23 | 728.54 | 724.63 | 727.99 | 3952635.0 |
| 2026-08-05 10:00:00 | QQQ | ETF | 727.9 | 727.93 | 724.4 | 724.72 | 2454708.0 |
| 2026-08-05 10:30:00 | QQQ | ETF | 724.67 | 724.8 | 721.6 | 723.04 | 2813059.0 |
| 2026-08-05 11:00:00 | QQQ | ETF | 723.07 | 724.115 | 721.01 | 722.085 | 2072567.0 |
| 2026-08-05 11:30:00 | QQQ | ETF | 722.08 | 723.33 | 719.77 | 720.37 | 1398223.0 |
| 2026-08-05 12:00:00 | QQQ | ETF | 720.38 | 722.71 | 719.48 | 722.665 | 1950175.0 |
| 2026-08-05 12:30:00 | QQQ | ETF | 722.655 | 722.88 | 721.17 | 722.14 | 907147.0 |
> showing 50 of 47,832 rows — these rows as CSV