PREVIEW / etf_30min / 2026-06-24
file: by_date/etf_30min/2026/2026-06-24.parquet size: 1.0 MB rows: 46,241
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-06-24 04:00:00 | SPY | ETF | 735.94 | 736.27 | 734.0 | 735.16 | 57130.0 |
| 2026-06-24 04:30:00 | SPY | ETF | 735.33 | 735.74 | 734.98 | 735.2 | 6533.0 |
| 2026-06-24 05:00:00 | SPY | ETF | 735.3418 | 735.65 | 734.8 | 735.06 | 8254.0 |
| 2026-06-24 05:30:00 | SPY | ETF | 735.13 | 735.34 | 734.44 | 735.15 | 8493.0 |
| 2026-06-24 06:00:00 | SPY | ETF | 734.8 | 735.45 | 734.77 | 735.38 | 9828.0 |
| 2026-06-24 06:30:00 | SPY | ETF | 735.44 | 736.25 | 735.21 | 735.3 | 55562.0 |
| 2026-06-24 07:00:00 | SPY | ETF | 735.325 | 736.0 | 734.82 | 735.22 | 63675.0 |
| 2026-06-24 07:30:00 | SPY | ETF | 735.35 | 737.0 | 735.34 | 736.6 | 143675.0 |
| 2026-06-24 08:00:00 | SPY | ETF | 736.8 | 737.12 | 736.12 | 736.93 | 87601.0 |
| 2026-06-24 08:30:00 | SPY | ETF | 736.88 | 737.1 | 735.25 | 735.53 | 116267.0 |
| 2026-06-24 09:00:00 | SPY | ETF | 735.56 | 735.97 | 734.39 | 735.21 | 274888.0 |
| 2026-06-24 09:30:00 | SPY | ETF | 735.14 | 737.7 | 734.3 | 735.935 | 5581620.0 |
| 2026-06-24 10:00:00 | SPY | ETF | 735.94 | 736.975 | 734.11 | 736.49 | 1955718.0 |
| 2026-06-24 10:30:00 | SPY | ETF | 736.46 | 739.71 | 736.16 | 739.66 | 2059209.0 |
| 2026-06-24 11:00:00 | SPY | ETF | 739.68 | 739.945 | 737.97 | 739.64 | 2090364.0 |
| 2026-06-24 11:30:00 | SPY | ETF | 739.63 | 739.93 | 737.83 | 738.34 | 1586039.0 |
| 2026-06-24 12:00:00 | SPY | ETF | 738.34 | 738.87 | 737.81 | 738.08 | 788313.0 |
| 2026-06-24 12:30:00 | SPY | ETF | 738.09 | 738.1 | 735.39 | 735.69 | 1775355.0 |
| 2026-06-24 13:00:00 | SPY | ETF | 735.7 | 736.46 | 732.06 | 732.16 | 2298979.0 |
| 2026-06-24 13:30:00 | SPY | ETF | 732.16 | 733.15 | 731.28 | 731.87 | 2119745.0 |
| 2026-06-24 14:00:00 | SPY | ETF | 731.86 | 734.66 | 731.77 | 734.34 | 2200816.0 |
| 2026-06-24 14:30:00 | SPY | ETF | 734.352 | 734.57 | 731.23 | 731.93 | 2588760.0 |
| 2026-06-24 15:00:00 | SPY | ETF | 731.93 | 732.94 | 730.84 | 731.98 | 3297621.0 |
| 2026-06-24 15:30:00 | SPY | ETF | 731.97 | 733.35 | 730.93 | 733.12 | 7377643.0 |
| 2026-06-24 16:00:00 | SPY | ETF | 733.04 | 737.57 | 732.45 | 737.28 | 4273631.0 |
| 2026-06-24 16:30:00 | SPY | ETF | 737.24 | 738.35 | 737.0 | 737.85 | 659213.0 |
| 2026-06-24 17:00:00 | SPY | ETF | 737.86 | 738.01 | 737.05 | 737.89 | 111432.0 |
| 2026-06-24 17:30:00 | SPY | ETF | 737.9 | 738.0 | 737.1 | 737.89 | 29760.0 |
| 2026-06-24 18:00:00 | SPY | ETF | 738.0 | 738.73 | 737.02 | 737.02 | 81699.0 |
| 2026-06-24 18:30:00 | SPY | ETF | 737.04 | 737.32 | 736.7 | 736.7 | 190711.0 |
| 2026-06-24 19:00:00 | SPY | ETF | 736.7 | 737.03 | 736.45 | 736.88 | 235644.0 |
| 2026-06-24 19:30:00 | SPY | ETF | 736.92 | 737.74 | 736.92 | 737.2 | 55901.0 |
| 2026-06-24 04:00:00 | QQQ | ETF | 716.79 | 719.43 | 714.01 | 718.48 | 198481.0 |
| 2026-06-24 04:30:00 | QQQ | ETF | 718.48 | 719.1 | 717.63 | 717.95 | 36233.0 |
| 2026-06-24 05:00:00 | QQQ | ETF | 718.19 | 718.5 | 717.41 | 717.72 | 26116.0 |
| 2026-06-24 05:30:00 | QQQ | ETF | 717.76 | 717.82 | 716.48 | 717.75 | 29106.0 |
| 2026-06-24 06:00:00 | QQQ | ETF | 717.71 | 718.08 | 717.05 | 717.85 | 16654.0 |
| 2026-06-24 06:30:00 | QQQ | ETF | 717.99 | 718.75 | 717.29 | 717.38 | 65464.0 |
| 2026-06-24 07:00:00 | QQQ | ETF | 717.39 | 718.15 | 716.0 | 716.48 | 125317.0 |
| 2026-06-24 07:30:00 | QQQ | ETF | 716.47 | 719.1 | 716.4 | 718.93 | 113616.0 |
| 2026-06-24 08:00:00 | QQQ | ETF | 718.97 | 719.28 | 718.17 | 718.73 | 89419.0 |
| 2026-06-24 08:30:00 | QQQ | ETF | 718.74 | 719.09 | 716.43 | 716.71 | 139388.0 |
| 2026-06-24 09:00:00 | QQQ | ETF | 716.71 | 717.3 | 715.01 | 715.43 | 378252.0 |
| 2026-06-24 09:30:00 | QQQ | ETF | 715.4 | 718.4999 | 711.78 | 714.75 | 4527542.0 |
| 2026-06-24 10:00:00 | QQQ | ETF | 714.78 | 715.8084 | 710.88 | 715.15 | 2605146.0 |
| 2026-06-24 10:30:00 | QQQ | ETF | 715.19 | 719.6 | 715.12 | 719.55 | 2115362.0 |
| 2026-06-24 11:00:00 | QQQ | ETF | 719.57 | 719.93 | 715.1 | 717.42 | 1797712.0 |
| 2026-06-24 11:30:00 | QQQ | ETF | 717.41 | 718.05 | 714.96 | 716.3 | 1401178.0 |
| 2026-06-24 12:00:00 | QQQ | ETF | 716.34 | 717.5 | 715.69 | 716.23 | 879803.0 |
| 2026-06-24 12:30:00 | QQQ | ETF | 716.265 | 716.29 | 712.52 | 712.78 | 1461158.0 |
> showing 50 of 46,241 rows — these rows as CSV