PREVIEW / etf_30min / 2026-06-26
file: by_date/etf_30min/2026/2026-06-26.parquet size: 1.0 MB rows: 45,507
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-26 04:00:00 | SPY | ETF | 732.62 | 732.62 | 727.44 | 731.59 | 252300.0 |
| 2026-06-26 04:30:00 | SPY | ETF | 731.47 | 731.52 | 729.16 | 729.71 | 35108.0 |
| 2026-06-26 05:00:00 | SPY | ETF | 729.43 | 729.8 | 728.8 | 729.25 | 85922.0 |
| 2026-06-26 05:30:00 | SPY | ETF | 729.09 | 730.38 | 728.9 | 729.4 | 64058.0 |
| 2026-06-26 06:00:00 | SPY | ETF | 729.12 | 729.695 | 728.48 | 729.35 | 55150.0 |
| 2026-06-26 06:30:00 | SPY | ETF | 729.57 | 729.65 | 729.15 | 729.41 | 23456.0 |
| 2026-06-26 07:00:00 | SPY | ETF | 729.47 | 730.25 | 729.17 | 729.38 | 117640.0 |
| 2026-06-26 07:30:00 | SPY | ETF | 729.4 | 729.9 | 728.63 | 729.35 | 85998.0 |
| 2026-06-26 08:00:00 | SPY | ETF | 729.34 | 731.18 | 727.75 | 730.38 | 230308.0 |
| 2026-06-26 08:30:00 | SPY | ETF | 730.42 | 730.57 | 728.92 | 729.27 | 161840.0 |
| 2026-06-26 09:00:00 | SPY | ETF | 729.3 | 729.31 | 727.4 | 728.92 | 532806.0 |
| 2026-06-26 09:30:00 | SPY | ETF | 728.95 | 731.31 | 726.86 | 730.895 | 8828734.0 |
| 2026-06-26 10:00:00 | SPY | ETF | 730.87 | 734.2425 | 730.63 | 733.49 | 6257768.0 |
| 2026-06-26 10:30:00 | SPY | ETF | 733.49 | 733.92 | 731.6005 | 732.45 | 4090838.0 |
| 2026-06-26 11:00:00 | SPY | ETF | 732.46 | 734.67 | 731.62 | 734.67 | 3845736.0 |
| 2026-06-26 11:30:00 | SPY | ETF | 734.67 | 736.53 | 734.18 | 735.4 | 5127988.0 |
| 2026-06-26 12:00:00 | SPY | ETF | 735.4 | 735.52 | 732.74 | 733.42 | 3471776.0 |
| 2026-06-26 12:30:00 | SPY | ETF | 733.4 | 734.9 | 733.4 | 734.47 | 2798328.0 |
| 2026-06-26 13:00:00 | SPY | ETF | 734.48 | 735.86 | 733.79 | 734.72 | 2998552.0 |
| 2026-06-26 13:30:00 | SPY | ETF | 734.72 | 735.39 | 733.47 | 733.66 | 2447318.0 |
| 2026-06-26 14:00:00 | SPY | ETF | 733.69 | 734.59 | 732.74 | 732.83 | 3648686.0 |
| 2026-06-26 14:30:00 | SPY | ETF | 732.83 | 733.67 | 731.28 | 731.62 | 6664650.0 |
| 2026-06-26 15:00:00 | SPY | ETF | 731.63 | 732.99 | 731.33 | 732.19 | 6264114.0 |
| 2026-06-26 15:30:00 | SPY | ETF | 732.2 | 733.86 | 716.58 | 729.09 | 19984532.0 |
| 2026-06-26 16:00:00 | SPY | ETF | 729.21 | 732.9088 | 728.23 | 732.45 | 13470834.0 |
| 2026-06-26 16:30:00 | SPY | ETF | 732.49 | 732.52 | 730.46 | 730.57 | 1380450.0 |
| 2026-06-26 17:00:00 | SPY | ETF | 730.66 | 732.55 | 730.15 | 730.6 | 1987140.0 |
| 2026-06-26 17:30:00 | SPY | ETF | 730.55 | 731.5 | 730.54 | 731.33 | 376400.0 |
| 2026-06-26 18:00:00 | SPY | ETF | 731.44 | 731.76 | 731.11 | 731.48 | 119148.0 |
| 2026-06-26 18:30:00 | SPY | ETF | 731.35 | 731.65 | 731.05 | 731.33 | 45740.0 |
| 2026-06-26 19:00:00 | SPY | ETF | 731.3294 | 731.35 | 731.01 | 731.038 | 23604.0 |
| 2026-06-26 19:30:00 | SPY | ETF | 731.15 | 731.4 | 730.98 | 731.2006 | 44716.0 |
| 2026-06-26 04:00:00 | QQQ | ETF | 711.07 | 711.9 | 704.55 | 710.53 | 574562.0 |
| 2026-06-26 04:30:00 | QQQ | ETF | 710.33 | 710.49 | 707.2 | 707.99 | 110744.0 |
| 2026-06-26 05:00:00 | QQQ | ETF | 707.66 | 708.28 | 706.76 | 707.57 | 185452.0 |
| 2026-06-26 05:30:00 | QQQ | ETF | 707.24 | 709.07 | 706.98 | 707.48 | 129952.0 |
| 2026-06-26 06:00:00 | QQQ | ETF | 707.26 | 707.89 | 706.08 | 707.4 | 160800.0 |
| 2026-06-26 06:30:00 | QQQ | ETF | 707.3 | 707.72 | 706.66 | 707.07 | 120358.0 |
| 2026-06-26 07:00:00 | QQQ | ETF | 707.17 | 708.71 | 706.99 | 707.46 | 219998.0 |
| 2026-06-26 07:30:00 | QQQ | ETF | 707.49 | 708.08 | 705.86 | 706.8901 | 245792.0 |
| 2026-06-26 08:00:00 | QQQ | ETF | 706.66 | 715.843 | 706.59 | 707.93 | 266084.0 |
| 2026-06-26 08:30:00 | QQQ | ETF | 707.89 | 708.42 | 705.68 | 706.0205 | 424116.0 |
| 2026-06-26 09:00:00 | QQQ | ETF | 706.12 | 707.22 | 703.6 | 707.22 | 927390.0 |
| 2026-06-26 09:30:00 | QQQ | ETF | 707.13 | 709.65 | 702.81 | 709.12 | 8895128.0 |
| 2026-06-26 10:00:00 | QQQ | ETF | 709.14 | 714.33 | 708.62 | 712.66 | 6808392.0 |
| 2026-06-26 10:30:00 | QQQ | ETF | 712.69 | 713.26 | 709.37 | 710.51 | 4313970.0 |
| 2026-06-26 11:00:00 | QQQ | ETF | 710.56 | 712.57 | 708.22 | 712.521 | 3020516.0 |
| 2026-06-26 11:30:00 | QQQ | ETF | 712.5201 | 715.555 | 711.11 | 713.21 | 4391230.0 |
| 2026-06-26 12:00:00 | QQQ | ETF | 713.25 | 713.36 | 710.27 | 711.85 | 2381958.0 |
| 2026-06-26 12:30:00 | QQQ | ETF | 711.9 | 713.84 | 711.82 | 713.045 | 2000316.0 |
> showing 50 of 45,507 rows — these rows as CSV