PREVIEW / etf_30min / 2026-05-01
file: by_date/etf_30min/2026/2026-05-01.parquet size: 1.0 MB rows: 45,478
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-01 04:00:00 | SPY | ETF | 720.36 | 720.92 | 719.75 | 720.06 | 38111.0 |
| 2026-05-01 04:30:00 | SPY | ETF | 720.0 | 720.0 | 719.61 | 719.88 | 5401.0 |
| 2026-05-01 05:00:00 | SPY | ETF | 719.79 | 720.1 | 719.55 | 720.03 | 6674.0 |
| 2026-05-01 05:30:00 | SPY | ETF | 719.92 | 720.24 | 719.92 | 720.16 | 5796.0 |
| 2026-05-01 06:00:00 | SPY | ETF | 720.2 | 720.29 | 720.01 | 720.14 | 4613.0 |
| 2026-05-01 06:30:00 | SPY | ETF | 720.16 | 720.26 | 719.72 | 720.22 | 5610.0 |
| 2026-05-01 07:00:00 | SPY | ETF | 720.24 | 720.3026 | 719.7503 | 720.19 | 30705.0 |
| 2026-05-01 07:30:00 | SPY | ETF | 720.11 | 720.49 | 719.97 | 720.4403 | 44431.0 |
| 2026-05-01 08:00:00 | SPY | ETF | 720.55 | 721.99 | 720.26 | 721.48 | 217920.0 |
| 2026-05-01 08:30:00 | SPY | ETF | 721.4 | 721.41 | 720.6 | 720.7 | 178830.0 |
| 2026-05-01 09:00:00 | SPY | ETF | 720.65 | 721.37 | 720.61 | 721.25 | 160148.0 |
| 2026-05-01 09:30:00 | SPY | ETF | 721.25 | 724.24 | 720.74 | 724.175 | 4777838.0 |
| 2026-05-01 10:00:00 | SPY | ETF | 724.19 | 724.87 | 723.77 | 724.2588 | 2576807.0 |
| 2026-05-01 10:30:00 | SPY | ETF | 724.27 | 724.27 | 722.3 | 722.72 | 2749044.0 |
| 2026-05-01 11:00:00 | SPY | ETF | 722.73 | 723.38 | 722.04 | 723.29 | 1502525.0 |
| 2026-05-01 11:30:00 | SPY | ETF | 723.295 | 724.38 | 722.71 | 723.385 | 2285964.0 |
| 2026-05-01 12:00:00 | SPY | ETF | 723.36 | 723.61 | 721.87 | 722.14 | 2423963.0 |
| 2026-05-01 12:30:00 | SPY | ETF | 722.1201 | 722.36 | 721.49 | 721.89 | 1595555.0 |
| 2026-05-01 13:00:00 | SPY | ETF | 721.89 | 722.98 | 721.86 | 722.98 | 1392896.0 |
| 2026-05-01 13:30:00 | SPY | ETF | 722.96 | 723.22 | 722.62 | 722.8 | 1320098.0 |
| 2026-05-01 14:00:00 | SPY | ETF | 722.79 | 722.92 | 721.5 | 722.18 | 1439294.0 |
| 2026-05-01 14:30:00 | SPY | ETF | 722.14 | 722.2 | 720.78 | 721.17 | 1841005.0 |
| 2026-05-01 15:00:00 | SPY | ETF | 721.17 | 722.59 | 721.09 | 722.42 | 1983849.0 |
| 2026-05-01 15:30:00 | SPY | ETF | 722.43 | 722.5 | 720.47 | 720.67 | 4508739.0 |
| 2026-05-01 16:00:00 | SPY | ETF | 720.655 | 720.75 | 719.69 | 719.86 | 1860140.0 |
| 2026-05-01 16:30:00 | SPY | ETF | 719.85 | 719.89 | 718.97 | 719.74 | 360343.0 |
| 2026-05-01 17:00:00 | SPY | ETF | 719.73 | 720.07 | 719.73 | 720.07 | 57010.0 |
| 2026-05-01 17:30:00 | SPY | ETF | 720.0684 | 720.24 | 720.0 | 720.23 | 31277.0 |
| 2026-05-01 18:00:00 | SPY | ETF | 720.24 | 720.65 | 720.06 | 720.12 | 206574.0 |
| 2026-05-01 18:30:00 | SPY | ETF | 720.23 | 720.24 | 719.99 | 720.19 | 10244.0 |
| 2026-05-01 19:00:00 | SPY | ETF | 720.1805 | 720.21 | 720.05 | 720.05 | 4215.0 |
| 2026-05-01 19:30:00 | SPY | ETF | 720.14 | 720.16 | 719.99 | 720.0 | 17208.0 |
| 2026-05-01 04:00:00 | QQQ | ETF | 668.35 | 669.35 | 667.75 | 668.06 | 93931.0 |
| 2026-05-01 04:30:00 | QQQ | ETF | 667.9 | 667.9 | 667.3 | 667.54 | 32919.0 |
| 2026-05-01 05:00:00 | QQQ | ETF | 667.5245 | 667.65 | 667.08 | 667.48 | 26376.0 |
| 2026-05-01 05:30:00 | QQQ | ETF | 667.38 | 667.76 | 667.35 | 667.69 | 11053.0 |
| 2026-05-01 06:00:00 | QQQ | ETF | 667.7 | 667.93 | 667.3841 | 667.57 | 39271.0 |
| 2026-05-01 06:30:00 | QQQ | ETF | 667.58 | 667.67 | 666.62 | 667.67 | 52609.0 |
| 2026-05-01 07:00:00 | QQQ | ETF | 667.6899 | 667.76 | 666.99 | 667.17 | 44039.0 |
| 2026-05-01 07:30:00 | QQQ | ETF | 667.1 | 667.5 | 666.92 | 667.5 | 64608.0 |
| 2026-05-01 08:00:00 | QQQ | ETF | 667.51 | 669.0 | 667.1 | 668.74 | 207880.0 |
| 2026-05-01 08:30:00 | QQQ | ETF | 668.69 | 668.69 | 667.58 | 667.77 | 135999.0 |
| 2026-05-01 09:00:00 | QQQ | ETF | 667.79 | 669.23 | 667.79 | 669.11 | 211312.0 |
| 2026-05-01 09:30:00 | QQQ | ETF | 669.14 | 674.96 | 668.8 | 674.96 | 5027798.0 |
| 2026-05-01 10:00:00 | QQQ | ETF | 674.98 | 675.76 | 674.47 | 674.87 | 3280549.0 |
| 2026-05-01 10:30:00 | QQQ | ETF | 674.9 | 674.9 | 672.01 | 673.53 | 2947693.0 |
| 2026-05-01 11:00:00 | QQQ | ETF | 673.57 | 674.86 | 672.47 | 674.69 | 1847790.0 |
| 2026-05-01 11:30:00 | QQQ | ETF | 674.71 | 675.97 | 674.1 | 675.36 | 2392688.0 |
| 2026-05-01 12:00:00 | QQQ | ETF | 675.35 | 675.61 | 673.63 | 674.0 | 1771019.0 |
| 2026-05-01 12:30:00 | QQQ | ETF | 673.98 | 674.535 | 673.33 | 673.935 | 1157017.0 |
> showing 50 of 45,478 rows — these rows as CSV