PREVIEW / etf_30min / 2026-08-04
file: by_date/etf_30min/2026/2026-08-04.parquet size: 1.1 MB rows: 48,712
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-04 04:00:00 | SPY | ETF | 759.21 | 759.88 | 759.08 | 759.24 | 39910.0 |
| 2026-08-04 04:30:00 | SPY | ETF | 759.2 | 759.215 | 758.45 | 758.64 | 14040.0 |
| 2026-08-04 05:00:00 | SPY | ETF | 758.58 | 758.58 | 758.11 | 758.3 | 41352.0 |
| 2026-08-04 05:30:00 | SPY | ETF | 758.37 | 758.75 | 758.36 | 758.64 | 16824.0 |
| 2026-08-04 06:00:00 | SPY | ETF | 758.64 | 758.85 | 758.53 | 758.6 | 20643.0 |
| 2026-08-04 06:30:00 | SPY | ETF | 758.54 | 759.68 | 758.47 | 759.25 | 49714.0 |
| 2026-08-04 07:00:00 | SPY | ETF | 759.19 | 759.78 | 759.1 | 759.7077 | 31357.0 |
| 2026-08-04 07:30:00 | SPY | ETF | 759.749 | 760.64 | 759.45 | 760.29 | 264706.0 |
| 2026-08-04 08:00:00 | SPY | ETF | 760.33 | 761.0 | 760.0 | 760.33 | 132342.0 |
| 2026-08-04 08:30:00 | SPY | ETF | 760.35 | 760.46 | 760.04 | 760.05 | 55450.0 |
| 2026-08-04 09:00:00 | SPY | ETF | 760.02 | 761.56 | 759.86 | 760.59 | 300452.0 |
| 2026-08-04 09:30:00 | SPY | ETF | 760.62 | 763.48 | 760.52 | 763.39 | 4865430.0 |
| 2026-08-04 10:00:00 | SPY | ETF | 763.37 | 765.3828 | 763.09 | 764.49 | 4047404.0 |
| 2026-08-04 10:30:00 | SPY | ETF | 764.47 | 766.42 | 764.1 | 766.3 | 3190292.0 |
| 2026-08-04 11:00:00 | SPY | ETF | 766.33 | 767.87 | 766.17 | 767.35 | 3067535.0 |
| 2026-08-04 11:30:00 | SPY | ETF | 767.34 | 768.9 | 767.16 | 768.44 | 2601554.0 |
| 2026-08-04 12:00:00 | SPY | ETF | 768.445 | 769.34 | 768.14 | 769.24 | 1994351.0 |
| 2026-08-04 12:30:00 | SPY | ETF | 769.22 | 770.32 | 769.0 | 770.265 | 2587657.0 |
| 2026-08-04 13:00:00 | SPY | ETF | 770.27 | 771.605 | 770.165 | 771.28 | 2909307.0 |
| 2026-08-04 13:30:00 | SPY | ETF | 771.29 | 773.085 | 770.965 | 771.57 | 2908829.0 |
| 2026-08-04 14:00:00 | SPY | ETF | 771.57 | 772.45 | 771.08 | 772.37 | 2533521.0 |
| 2026-08-04 14:30:00 | SPY | ETF | 772.3799 | 772.4798 | 771.41 | 772.07 | 2593722.0 |
| 2026-08-04 15:00:00 | SPY | ETF | 772.085 | 773.12 | 772.05 | 772.32 | 3016859.0 |
| 2026-08-04 15:30:00 | SPY | ETF | 772.31 | 773.41 | 770.96 | 771.25 | 9110252.0 |
| 2026-08-04 16:00:00 | SPY | ETF | 771.24 | 772.96 | 771.0 | 771.53 | 3487994.0 |
| 2026-08-04 16:30:00 | SPY | ETF | 771.54 | 772.32 | 771.38 | 772.27 | 151330.0 |
| 2026-08-04 17:00:00 | SPY | ETF | 772.0779 | 772.2 | 771.93 | 772.13 | 150268.0 |
| 2026-08-04 17:30:00 | SPY | ETF | 772.13 | 772.28 | 771.99 | 772.12 | 39473.0 |
| 2026-08-04 18:00:00 | SPY | ETF | 772.14 | 772.86 | 771.92 | 772.75 | 58705.0 |
| 2026-08-04 18:30:00 | SPY | ETF | 772.78 | 773.0 | 772.51 | 772.8 | 24187.0 |
| 2026-08-04 19:00:00 | SPY | ETF | 772.84 | 773.03 | 772.6946 | 772.6946 | 13790.0 |
| 2026-08-04 19:30:00 | SPY | ETF | 772.65 | 772.8192 | 772.39 | 772.68 | 32879.0 |
| 2026-08-04 04:00:00 | QQQ | ETF | 703.78 | 705.7 | 701.81 | 705.19 | 175877.0 |
| 2026-08-04 04:30:00 | QQQ | ETF | 705.0 | 705.13 | 703.45 | 704.16 | 56492.0 |
| 2026-08-04 05:00:00 | QQQ | ETF | 704.02 | 704.13 | 702.72 | 703.57 | 50688.0 |
| 2026-08-04 05:30:00 | QQQ | ETF | 703.6 | 704.58 | 703.6 | 704.35 | 28879.0 |
| 2026-08-04 06:00:00 | QQQ | ETF | 704.21 | 705.31 | 704.21 | 704.8858 | 49577.0 |
| 2026-08-04 06:30:00 | QQQ | ETF | 704.82 | 706.01 | 704.34 | 705.28 | 102590.0 |
| 2026-08-04 07:00:00 | QQQ | ETF | 705.3 | 706.66 | 705.2812 | 706.6 | 124443.0 |
| 2026-08-04 07:30:00 | QQQ | ETF | 706.64 | 708.39 | 706.2 | 708.24 | 183813.0 |
| 2026-08-04 08:00:00 | QQQ | ETF | 708.21 | 708.22 | 699.545 | 707.92 | 200243.0 |
| 2026-08-04 08:30:00 | QQQ | ETF | 707.96 | 707.99 | 701.99 | 707.49 | 286498.0 |
| 2026-08-04 09:00:00 | QQQ | ETF | 707.49 | 709.28 | 707.16 | 708.18 | 375770.0 |
| 2026-08-04 09:30:00 | QQQ | ETF | 708.21 | 714.66 | 707.53 | 713.65 | 5203581.0 |
| 2026-08-04 10:00:00 | QQQ | ETF | 713.64 | 716.22 | 712.98 | 716.005 | 3602230.0 |
| 2026-08-04 10:30:00 | QQQ | ETF | 716.05 | 716.4 | 715.07 | 715.8008 | 2162179.0 |
| 2026-08-04 11:00:00 | QQQ | ETF | 715.85 | 718.57 | 715.74 | 717.99 | 3259841.0 |
| 2026-08-04 11:30:00 | QQQ | ETF | 717.98 | 719.4 | 717.58 | 718.8 | 2721710.0 |
| 2026-08-04 12:00:00 | QQQ | ETF | 718.785 | 719.97 | 718.56 | 719.65 | 1958343.0 |
| 2026-08-04 12:30:00 | QQQ | ETF | 719.665 | 720.6 | 719.4 | 720.57 | 2672831.0 |
> showing 50 of 48,712 rows — these rows as CSV