PREVIEW / etf_30min / 2026-05-07
file: by_date/etf_30min/2026/2026-05-07.parquet size: 1.1 MB rows: 47,391
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-05-07 04:00:00 | SPY | ETF | 734.3 | 736.13 | 734.0 | 734.9 | 80081.0 |
| 2026-05-07 04:30:00 | SPY | ETF | 735.02 | 735.09 | 734.55 | 734.6234 | 32282.0 |
| 2026-05-07 05:00:00 | SPY | ETF | 734.57 | 735.02 | 734.33 | 734.77 | 20126.0 |
| 2026-05-07 05:30:00 | SPY | ETF | 734.7 | 735.03 | 734.32 | 734.43 | 17737.0 |
| 2026-05-07 06:00:00 | SPY | ETF | 734.5 | 734.76 | 734.08 | 734.62 | 14989.0 |
| 2026-05-07 06:30:00 | SPY | ETF | 734.56 | 734.94 | 734.42 | 734.62 | 11398.0 |
| 2026-05-07 07:00:00 | SPY | ETF | 734.68 | 735.0 | 734.46 | 734.47 | 50624.0 |
| 2026-05-07 07:30:00 | SPY | ETF | 734.47 | 734.95 | 734.4 | 734.7875 | 38743.0 |
| 2026-05-07 08:00:00 | SPY | ETF | 734.78 | 735.4 | 734.61 | 735.1 | 99864.0 |
| 2026-05-07 08:30:00 | SPY | ETF | 735.0404 | 735.4 | 734.94 | 735.25 | 85837.0 |
| 2026-05-07 09:00:00 | SPY | ETF | 735.28 | 735.33 | 734.71 | 735.08 | 160439.0 |
| 2026-05-07 09:30:00 | SPY | ETF | 735.05 | 735.13 | 733.55 | 733.94 | 3785776.0 |
| 2026-05-07 10:00:00 | SPY | ETF | 733.93 | 735.08 | 733.88 | 734.55 | 2684789.0 |
| 2026-05-07 10:30:00 | SPY | ETF | 734.63 | 736.11 | 734.45 | 736.08 | 2234565.0 |
| 2026-05-07 11:00:00 | SPY | ETF | 736.09 | 736.13 | 734.3 | 734.9088 | 2073130.0 |
| 2026-05-07 11:30:00 | SPY | ETF | 734.91 | 735.62 | 733.78 | 733.9799 | 1776747.0 |
| 2026-05-07 12:00:00 | SPY | ETF | 733.965 | 734.02 | 731.73 | 733.365 | 3144421.0 |
| 2026-05-07 12:30:00 | SPY | ETF | 733.36 | 733.82 | 731.59 | 732.04 | 1894348.0 |
| 2026-05-07 13:00:00 | SPY | ETF | 732.1 | 732.67 | 729.76 | 730.625 | 2952449.0 |
| 2026-05-07 13:30:00 | SPY | ETF | 730.63 | 731.8 | 730.15 | 731.72 | 2647720.0 |
| 2026-05-07 14:00:00 | SPY | ETF | 731.77 | 732.2 | 731.06 | 731.29 | 1960065.0 |
| 2026-05-07 14:30:00 | SPY | ETF | 731.29 | 731.94 | 729.75 | 731.14 | 2237648.0 |
| 2026-05-07 15:00:00 | SPY | ETF | 731.16 | 731.5 | 729.99 | 730.5 | 2169053.0 |
| 2026-05-07 15:30:00 | SPY | ETF | 730.5 | 731.9 | 730.4 | 731.56 | 6310422.0 |
| 2026-05-07 16:00:00 | SPY | ETF | 731.56 | 732.99 | 730.4 | 732.0104 | 2409612.0 |
| 2026-05-07 16:30:00 | SPY | ETF | 732.02 | 732.2 | 730.26 | 730.36 | 754606.0 |
| 2026-05-07 17:00:00 | SPY | ETF | 730.64 | 730.77 | 729.92 | 730.05 | 206194.0 |
| 2026-05-07 17:30:00 | SPY | ETF | 730.02 | 730.09 | 728.5 | 728.64 | 157684.0 |
| 2026-05-07 18:00:00 | SPY | ETF | 729.04 | 731.04 | 728.96 | 730.83 | 317066.0 |
| 2026-05-07 18:30:00 | SPY | ETF | 730.79 | 730.82 | 729.7 | 730.1 | 248628.0 |
| 2026-05-07 19:00:00 | SPY | ETF | 730.1 | 730.66 | 730.1 | 730.6385 | 14182.0 |
| 2026-05-07 19:30:00 | SPY | ETF | 730.62 | 731.5 | 730.51 | 731.4391 | 31825.0 |
| 2026-05-07 04:00:00 | QQQ | ETF | 696.54 | 698.11 | 695.02 | 696.43 | 177139.0 |
| 2026-05-07 04:30:00 | QQQ | ETF | 696.59 | 696.91 | 696.07 | 696.26 | 65140.0 |
| 2026-05-07 05:00:00 | QQQ | ETF | 696.11 | 696.87 | 695.68 | 696.55 | 59859.0 |
| 2026-05-07 05:30:00 | QQQ | ETF | 696.42 | 696.85 | 695.93 | 696.01 | 26454.0 |
| 2026-05-07 06:00:00 | QQQ | ETF | 696.06 | 696.16 | 695.19 | 695.89 | 71124.0 |
| 2026-05-07 06:30:00 | QQQ | ETF | 695.87 | 696.39 | 695.76 | 696.11 | 39558.0 |
| 2026-05-07 07:00:00 | QQQ | ETF | 696.04 | 696.6 | 695.6 | 695.64 | 148538.0 |
| 2026-05-07 07:30:00 | QQQ | ETF | 695.66 | 696.3 | 695.5 | 696.18 | 73611.0 |
| 2026-05-07 08:00:00 | QQQ | ETF | 696.05 | 696.45 | 695.249 | 696.34 | 89748.0 |
| 2026-05-07 08:30:00 | QQQ | ETF | 696.3 | 696.81 | 695.22 | 696.67 | 244602.0 |
| 2026-05-07 09:00:00 | QQQ | ETF | 696.65 | 696.84 | 696.04 | 696.58 | 164791.0 |
| 2026-05-07 09:30:00 | QQQ | ETF | 696.58 | 697.85 | 695.54 | 697.27 | 3662239.0 |
| 2026-05-07 10:00:00 | QQQ | ETF | 697.27 | 700.17 | 697.24 | 699.52 | 3343176.0 |
| 2026-05-07 10:30:00 | QQQ | ETF | 699.54 | 701.24 | 699.21 | 700.83 | 2046459.0 |
| 2026-05-07 11:00:00 | QQQ | ETF | 700.825 | 700.865 | 698.35 | 699.08 | 1741960.0 |
| 2026-05-07 11:30:00 | QQQ | ETF | 699.1 | 700.1 | 697.11 | 697.365 | 1582910.0 |
| 2026-05-07 12:00:00 | QQQ | ETF | 697.36 | 697.45 | 693.79 | 696.315 | 3059461.0 |
| 2026-05-07 12:30:00 | QQQ | ETF | 696.305 | 697.16 | 694.36 | 695.2101 | 1849108.0 |
> showing 50 of 47,391 rows — these rows as CSV