PREVIEW / etf_30min / 2026-07-15
file: by_date/etf_30min/2026/2026-07-15.parquet size: 1.0 MB rows: 46,179
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-07-15 04:00:00 | SPY | ETF | 753.5 | 754.33 | 752.45 | 753.11 | 45954.0 |
| 2026-07-15 04:30:00 | SPY | ETF | 753.17 | 753.73 | 753.08 | 753.71 | 10967.0 |
| 2026-07-15 05:00:00 | SPY | ETF | 753.81 | 754.08 | 753.72 | 753.86 | 7600.0 |
| 2026-07-15 05:30:00 | SPY | ETF | 753.83 | 754.02 | 753.41 | 753.49 | 8817.0 |
| 2026-07-15 06:00:00 | SPY | ETF | 753.48 | 753.66 | 752.69 | 752.83 | 17790.0 |
| 2026-07-15 06:30:00 | SPY | ETF | 752.84 | 753.23 | 752.84 | 753.18 | 15707.0 |
| 2026-07-15 07:00:00 | SPY | ETF | 753.16 | 753.359 | 752.9738 | 753.06 | 31922.0 |
| 2026-07-15 07:30:00 | SPY | ETF | 753.06 | 753.31 | 752.81 | 753.12 | 37797.0 |
| 2026-07-15 08:00:00 | SPY | ETF | 753.05 | 753.2 | 752.3 | 752.62 | 58620.0 |
| 2026-07-15 08:30:00 | SPY | ETF | 752.45 | 754.42 | 752.2 | 754.1195 | 309900.0 |
| 2026-07-15 09:00:00 | SPY | ETF | 754.12 | 754.5 | 753.61 | 754.29 | 167643.0 |
| 2026-07-15 09:30:00 | SPY | ETF | 754.24 | 755.58 | 753.18 | 754.45 | 3540641.0 |
| 2026-07-15 10:00:00 | SPY | ETF | 754.52 | 755.56 | 753.35 | 754.62 | 2982228.0 |
| 2026-07-15 10:30:00 | SPY | ETF | 754.64 | 754.87 | 752.741 | 753.4607 | 2166548.0 |
| 2026-07-15 11:00:00 | SPY | ETF | 753.48 | 754.16 | 752.2 | 753.605 | 1663522.0 |
| 2026-07-15 11:30:00 | SPY | ETF | 753.6 | 753.84 | 752.28 | 752.6695 | 1337453.0 |
| 2026-07-15 12:00:00 | SPY | ETF | 752.64 | 752.828 | 750.44 | 750.83 | 2037575.0 |
| 2026-07-15 12:30:00 | SPY | ETF | 750.81 | 752.32 | 750.2 | 751.67 | 2114758.0 |
| 2026-07-15 13:00:00 | SPY | ETF | 751.68 | 752.85 | 751.58 | 752.81 | 1325361.0 |
| 2026-07-15 13:30:00 | SPY | ETF | 752.81 | 754.55 | 752.81 | 754.1901 | 1897868.0 |
| 2026-07-15 14:00:00 | SPY | ETF | 754.2 | 754.84 | 754.14 | 754.635 | 1959606.0 |
| 2026-07-15 14:30:00 | SPY | ETF | 754.635 | 754.92 | 753.1 | 753.19 | 1768754.0 |
| 2026-07-15 15:00:00 | SPY | ETF | 753.19 | 753.93 | 753.05 | 753.63 | 1856903.0 |
| 2026-07-15 15:30:00 | SPY | ETF | 753.63 | 754.8 | 753.09 | 754.74 | 5980943.0 |
| 2026-07-15 16:00:00 | SPY | ETF | 754.74 | 754.95 | 753.85 | 754.7 | 3871947.0 |
| 2026-07-15 16:30:00 | SPY | ETF | 754.68 | 754.8 | 754.49 | 754.54 | 40408.0 |
| 2026-07-15 17:00:00 | SPY | ETF | 754.64 | 754.93 | 754.47 | 754.51 | 43842.0 |
| 2026-07-15 17:30:00 | SPY | ETF | 754.62 | 754.77 | 754.51 | 754.65 | 6310.0 |
| 2026-07-15 18:00:00 | SPY | ETF | 754.65 | 755.19 | 754.5 | 754.67 | 32049.0 |
| 2026-07-15 18:30:00 | SPY | ETF | 754.74 | 754.89 | 754.45 | 754.85 | 15657.0 |
| 2026-07-15 19:00:00 | SPY | ETF | 754.82 | 755.03 | 754.75 | 755.03 | 8303.0 |
| 2026-07-15 19:30:00 | SPY | ETF | 755.0185 | 755.19 | 754.61 | 754.68 | 16041.0 |
| 2026-07-15 04:00:00 | QQQ | ETF | 724.12 | 726.27 | 721.8 | 722.74 | 161620.0 |
| 2026-07-15 04:30:00 | QQQ | ETF | 722.8509 | 723.4936 | 722.51 | 723.3 | 28715.0 |
| 2026-07-15 05:00:00 | QQQ | ETF | 723.3393 | 723.98 | 723.3393 | 723.68 | 20935.0 |
| 2026-07-15 05:30:00 | QQQ | ETF | 723.73 | 723.8207 | 722.84 | 723.06 | 28817.0 |
| 2026-07-15 06:00:00 | QQQ | ETF | 723.0464 | 723.57 | 722.25 | 722.46 | 48184.0 |
| 2026-07-15 06:30:00 | QQQ | ETF | 722.41 | 723.28 | 722.26 | 723.15 | 27250.0 |
| 2026-07-15 07:00:00 | QQQ | ETF | 723.07 | 723.74 | 722.89 | 722.9892 | 53322.0 |
| 2026-07-15 07:30:00 | QQQ | ETF | 722.95 | 723.489 | 722.65 | 722.74 | 47871.0 |
| 2026-07-15 08:00:00 | QQQ | ETF | 722.7 | 722.91 | 721.45 | 721.92 | 96165.0 |
| 2026-07-15 08:30:00 | QQQ | ETF | 721.92 | 724.73 | 721.83 | 724.37 | 219327.0 |
| 2026-07-15 09:00:00 | QQQ | ETF | 724.38 | 724.81 | 723.39 | 723.99 | 161833.0 |
| 2026-07-15 09:30:00 | QQQ | ETF | 723.85 | 724.36 | 718.93 | 720.66 | 2873990.0 |
| 2026-07-15 10:00:00 | QQQ | ETF | 720.69 | 722.29 | 716.206 | 718.215 | 2363743.0 |
| 2026-07-15 10:30:00 | QQQ | ETF | 718.25 | 718.53 | 713.72 | 715.96 | 2304927.0 |
| 2026-07-15 11:00:00 | QQQ | ETF | 716.0 | 716.6999 | 713.58 | 716.21 | 1533164.0 |
| 2026-07-15 11:30:00 | QQQ | ETF | 716.17 | 716.55 | 714.26 | 714.74 | 1084825.0 |
| 2026-07-15 12:00:00 | QQQ | ETF | 714.71 | 715.14 | 711.07 | 711.845 | 2439020.0 |
| 2026-07-15 12:30:00 | QQQ | ETF | 711.82 | 713.66 | 710.23 | 713.02 | 1904882.0 |
> showing 50 of 46,179 rows — these rows as CSV