PREVIEW / etf_30min / 2026-08-06
file: by_date/etf_30min/2026/2026-08-06.parquet size: 1.0 MB rows: 46,165
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-06 04:00:00 | SPY | ETF | 770.9 | 771.5 | 770.05 | 771.0 | 36480.0 |
| 2026-08-06 04:30:00 | SPY | ETF | 771.06 | 771.55 | 771.0 | 771.39 | 12623.0 |
| 2026-08-06 05:00:00 | SPY | ETF | 771.42 | 771.42 | 770.62 | 770.97 | 9217.0 |
| 2026-08-06 05:30:00 | SPY | ETF | 770.99 | 771.705 | 770.9 | 771.685 | 8361.0 |
| 2026-08-06 06:00:00 | SPY | ETF | 771.65 | 771.67 | 771.215 | 771.56 | 5640.0 |
| 2026-08-06 06:30:00 | SPY | ETF | 771.45 | 771.46 | 770.89 | 771.16 | 9157.0 |
| 2026-08-06 07:00:00 | SPY | ETF | 771.189 | 771.77 | 770.04 | 771.19 | 58375.0 |
| 2026-08-06 07:30:00 | SPY | ETF | 771.3 | 771.55 | 770.44 | 770.91 | 76891.0 |
| 2026-08-06 08:00:00 | SPY | ETF | 770.9 | 771.0 | 770.22 | 770.69 | 84954.0 |
| 2026-08-06 08:30:00 | SPY | ETF | 770.7 | 771.13 | 770.31 | 770.39 | 118868.0 |
| 2026-08-06 09:00:00 | SPY | ETF | 770.43 | 770.5 | 769.8 | 770.17 | 186431.0 |
| 2026-08-06 09:30:00 | SPY | ETF | 770.21 | 771.525 | 769.0576 | 770.92 | 2811859.0 |
| 2026-08-06 10:00:00 | SPY | ETF | 770.95 | 771.82 | 770.07 | 770.45 | 1450207.0 |
| 2026-08-06 10:30:00 | SPY | ETF | 770.45 | 771.06 | 769.53 | 770.985 | 1885999.0 |
| 2026-08-06 11:00:00 | SPY | ETF | 771.0 | 771.21 | 768.62 | 769.24 | 1590117.0 |
| 2026-08-06 11:30:00 | SPY | ETF | 769.24 | 769.78 | 767.95 | 768.125 | 2059547.0 |
| 2026-08-06 12:00:00 | SPY | ETF | 768.16 | 768.54 | 767.46 | 768.26 | 1834033.0 |
| 2026-08-06 12:30:00 | SPY | ETF | 768.27 | 769.04 | 767.9081 | 768.96 | 1194870.0 |
| 2026-08-06 13:00:00 | SPY | ETF | 768.99 | 769.18 | 767.81 | 767.83 | 1281602.0 |
| 2026-08-06 13:30:00 | SPY | ETF | 767.83 | 768.64 | 767.72 | 768.6303 | 1205005.0 |
| 2026-08-06 14:00:00 | SPY | ETF | 768.65 | 769.73 | 768.45 | 769.43 | 1918403.0 |
| 2026-08-06 14:30:00 | SPY | ETF | 769.43 | 769.47 | 768.515 | 768.96 | 1321649.0 |
| 2026-08-06 15:00:00 | SPY | ETF | 768.97 | 769.79 | 768.57 | 768.66 | 1842993.0 |
| 2026-08-06 15:30:00 | SPY | ETF | 768.655 | 769.0 | 767.7 | 768.53 | 5088093.0 |
| 2026-08-06 16:00:00 | SPY | ETF | 768.52 | 769.13 | 767.91 | 768.01 | 1842008.0 |
| 2026-08-06 16:30:00 | SPY | ETF | 768.03 | 768.25 | 767.85 | 768.21 | 131689.0 |
| 2026-08-06 17:00:00 | SPY | ETF | 768.2 | 768.36 | 768.1 | 768.3 | 27443.0 |
| 2026-08-06 17:30:00 | SPY | ETF | 768.15 | 768.35 | 767.8 | 768.34 | 20537.0 |
| 2026-08-06 18:00:00 | SPY | ETF | 768.39 | 769.05 | 768.0 | 768.6798 | 36822.0 |
| 2026-08-06 18:30:00 | SPY | ETF | 768.6 | 768.84 | 768.38 | 768.8271 | 8481.0 |
| 2026-08-06 19:00:00 | SPY | ETF | 768.77 | 768.9938 | 768.64 | 768.83 | 9129.0 |
| 2026-08-06 19:30:00 | SPY | ETF | 768.8046 | 769.09 | 768.77 | 768.9861 | 14041.0 |
| 2026-08-06 04:00:00 | QQQ | ETF | 716.63 | 717.14 | 713.46 | 714.93 | 154983.0 |
| 2026-08-06 04:30:00 | QQQ | ETF | 715.01 | 715.52 | 714.54 | 715.23 | 49575.0 |
| 2026-08-06 05:00:00 | QQQ | ETF | 715.21 | 715.21 | 713.39 | 714.32 | 46948.0 |
| 2026-08-06 05:30:00 | QQQ | ETF | 714.35 | 715.49 | 714.2 | 715.35 | 22645.0 |
| 2026-08-06 06:00:00 | QQQ | ETF | 715.35 | 715.59 | 714.81 | 715.33 | 25294.0 |
| 2026-08-06 06:30:00 | QQQ | ETF | 715.249 | 715.249 | 714.01 | 714.32 | 44635.0 |
| 2026-08-06 07:00:00 | QQQ | ETF | 714.41 | 714.46 | 711.49 | 714.07 | 290360.0 |
| 2026-08-06 07:30:00 | QQQ | ETF | 714.04 | 715.12 | 713.3 | 714.0088 | 152965.0 |
| 2026-08-06 08:00:00 | QQQ | ETF | 713.9 | 716.763 | 712.09 | 713.0 | 203582.0 |
| 2026-08-06 08:30:00 | QQQ | ETF | 713.0 | 713.84 | 712.13 | 712.39 | 168571.0 |
| 2026-08-06 09:00:00 | QQQ | ETF | 712.3 | 712.47 | 710.62 | 710.76 | 313719.0 |
| 2026-08-06 09:30:00 | QQQ | ETF | 710.76 | 716.03 | 708.5 | 715.48 | 4150276.0 |
| 2026-08-06 10:00:00 | QQQ | ETF | 715.5 | 718.86 | 714.52 | 716.84 | 3106504.0 |
| 2026-08-06 10:30:00 | QQQ | ETF | 716.95 | 718.625 | 715.61 | 718.592 | 1885184.0 |
| 2026-08-06 11:00:00 | QQQ | ETF | 718.6 | 719.32 | 716.37 | 717.42 | 1688708.0 |
| 2026-08-06 11:30:00 | QQQ | ETF | 717.48 | 717.86 | 714.965 | 715.17 | 1510155.0 |
| 2026-08-06 12:00:00 | QQQ | ETF | 715.17 | 715.81 | 713.53 | 714.1 | 1558685.0 |
| 2026-08-06 12:30:00 | QQQ | ETF | 714.11 | 716.16 | 713.86 | 716.1499 | 1132571.0 |
> showing 50 of 46,165 rows — these rows as CSV