PREVIEW / etf_30min / 2026-05-04
file: by_date/etf_30min/2026/2026-05-04.parquet size: 1.1 MB rows: 47,436
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-04 04:00:00 | SPY | ETF | 721.8 | 722.34 | 720.34 | 721.3 | 47379.0 |
| 2026-05-04 04:30:00 | SPY | ETF | 721.4 | 721.48 | 721.12 | 721.21 | 9937.0 |
| 2026-05-04 05:00:00 | SPY | ETF | 721.14 | 721.68 | 721.14 | 721.45 | 4599.0 |
| 2026-05-04 05:30:00 | SPY | ETF | 721.53 | 721.77 | 721.41 | 721.4843 | 8351.0 |
| 2026-05-04 06:00:00 | SPY | ETF | 721.359 | 721.49 | 716.46 | 718.25 | 675047.0 |
| 2026-05-04 06:30:00 | SPY | ETF | 718.34 | 720.79 | 718.18 | 719.68 | 214858.0 |
| 2026-05-04 07:00:00 | SPY | ETF | 719.69 | 720.35 | 719.5 | 719.65 | 108587.0 |
| 2026-05-04 07:30:00 | SPY | ETF | 719.6 | 719.8 | 718.67 | 719.55 | 137219.0 |
| 2026-05-04 08:00:00 | SPY | ETF | 719.56 | 720.57 | 719.56 | 720.21 | 132174.0 |
| 2026-05-04 08:30:00 | SPY | ETF | 720.14 | 720.41 | 719.66 | 719.95 | 119028.0 |
| 2026-05-04 09:00:00 | SPY | ETF | 719.76 | 720.61 | 718.84 | 720.07 | 424364.0 |
| 2026-05-04 09:30:00 | SPY | ETF | 720.07 | 720.8 | 719.25 | 720.7602 | 3642574.0 |
| 2026-05-04 10:00:00 | SPY | ETF | 720.77 | 721.719 | 719.865 | 721.24 | 2148516.0 |
| 2026-05-04 10:30:00 | SPY | ETF | 721.22 | 722.12 | 720.7604 | 720.91 | 2196538.0 |
| 2026-05-04 11:00:00 | SPY | ETF | 720.92 | 721.56 | 717.45 | 718.44 | 5514466.0 |
| 2026-05-04 11:30:00 | SPY | ETF | 718.45 | 718.74 | 716.98 | 717.5898 | 3675423.0 |
| 2026-05-04 12:00:00 | SPY | ETF | 717.59 | 717.87 | 714.99 | 717.0 | 3880634.0 |
| 2026-05-04 12:30:00 | SPY | ETF | 716.99 | 717.67 | 716.3 | 716.55 | 1468441.0 |
| 2026-05-04 13:00:00 | SPY | ETF | 716.54 | 718.64 | 716.48 | 718.57 | 1856835.0 |
| 2026-05-04 13:30:00 | SPY | ETF | 718.56 | 718.63 | 717.6 | 718.3301 | 1324843.0 |
| 2026-05-04 14:00:00 | SPY | ETF | 718.33 | 718.995 | 717.17 | 717.76 | 1924886.0 |
| 2026-05-04 14:30:00 | SPY | ETF | 717.76 | 717.87 | 716.83 | 717.47 | 1721719.0 |
| 2026-05-04 15:00:00 | SPY | ETF | 717.48 | 718.22 | 717.13 | 717.74 | 2910903.0 |
| 2026-05-04 15:30:00 | SPY | ETF | 717.75 | 718.26 | 717.35 | 718.07 | 5798361.0 |
| 2026-05-04 16:00:00 | SPY | ETF | 718.08 | 718.08 | 717.28 | 717.85 | 2010366.0 |
| 2026-05-04 16:30:00 | SPY | ETF | 717.79 | 718.01 | 717.36 | 717.57 | 140363.0 |
| 2026-05-04 17:00:00 | SPY | ETF | 717.59 | 717.86 | 717.5729 | 717.78 | 26208.0 |
| 2026-05-04 17:30:00 | SPY | ETF | 717.71 | 717.95 | 717.63 | 717.8 | 12547.0 |
| 2026-05-04 18:00:00 | SPY | ETF | 717.96 | 718.46 | 717.96 | 718.3547 | 54111.0 |
| 2026-05-04 18:30:00 | SPY | ETF | 718.23 | 718.27 | 717.63 | 717.76 | 13308.0 |
| 2026-05-04 19:00:00 | SPY | ETF | 717.75 | 717.95 | 717.58 | 717.86 | 7544.0 |
| 2026-05-04 19:30:00 | SPY | ETF | 717.83 | 717.86 | 717.57 | 717.7622 | 24849.0 |
| 2026-05-04 04:00:00 | QQQ | ETF | 676.0 | 677.35 | 674.91 | 675.79 | 178774.0 |
| 2026-05-04 04:30:00 | QQQ | ETF | 675.89 | 676.015 | 675.55 | 675.64 | 34468.0 |
| 2026-05-04 05:00:00 | QQQ | ETF | 675.56 | 676.1 | 675.4 | 676.04 | 30425.0 |
| 2026-05-04 05:30:00 | QQQ | ETF | 676.01 | 676.35 | 675.64 | 675.64 | 66457.0 |
| 2026-05-04 06:00:00 | QQQ | ETF | 675.53 | 675.62 | 670.08 | 672.16 | 417363.0 |
| 2026-05-04 06:30:00 | QQQ | ETF | 672.19 | 674.48 | 672.0 | 673.63 | 121979.0 |
| 2026-05-04 07:00:00 | QQQ | ETF | 673.68 | 674.5 | 673.22 | 673.84 | 117648.0 |
| 2026-05-04 07:30:00 | QQQ | ETF | 673.8 | 674.12 | 672.88 | 674.06 | 101619.0 |
| 2026-05-04 08:00:00 | QQQ | ETF | 674.14 | 675.27 | 674.07 | 674.84 | 187894.0 |
| 2026-05-04 08:30:00 | QQQ | ETF | 674.794 | 675.14 | 674.15 | 674.33 | 86630.0 |
| 2026-05-04 09:00:00 | QQQ | ETF | 674.4 | 675.23 | 673.09 | 674.66 | 250476.0 |
| 2026-05-04 09:30:00 | QQQ | ETF | 674.66 | 675.67 | 673.55 | 675.61 | 2723957.0 |
| 2026-05-04 10:00:00 | QQQ | ETF | 675.6 | 676.06 | 674.45 | 675.03 | 1789549.0 |
| 2026-05-04 10:30:00 | QQQ | ETF | 675.03 | 676.73 | 674.88 | 675.3 | 2035141.0 |
| 2026-05-04 11:00:00 | QQQ | ETF | 675.33 | 676.0893 | 671.17 | 672.74 | 2735961.0 |
| 2026-05-04 11:30:00 | QQQ | ETF | 672.78 | 672.97 | 670.86 | 671.775 | 2205514.0 |
| 2026-05-04 12:00:00 | QQQ | ETF | 671.78 | 672.08 | 668.9 | 671.27 | 2584959.0 |
| 2026-05-04 12:30:00 | QQQ | ETF | 671.285 | 672.0 | 670.67 | 671.14 | 1190158.0 |
> showing 50 of 47,436 rows — these rows as CSV