PREVIEW / etf_30min / 2025-09-10
file: by_date/etf_30min/2025/2025-09-10.parquet size: 1.0 MB rows: 42,928
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 |
|---|---|---|---|---|---|---|---|
| 2025-09-10 04:00:00 | SPY | ETF | 652.12 | 652.44 | 651.67 | 652.02 | 18443.0 |
| 2025-09-10 04:30:00 | SPY | ETF | 651.75 | 651.75 | 651.45 | 651.63 | 11018.0 |
| 2025-09-10 05:00:00 | SPY | ETF | 651.73 | 651.73 | 651.34 | 651.5 | 6008.0 |
| 2025-09-10 05:30:00 | SPY | ETF | 651.42 | 651.92 | 651.42 | 651.9 | 6350.0 |
| 2025-09-10 06:00:00 | SPY | ETF | 651.89 | 652.13 | 651.83 | 652.1 | 9389.0 |
| 2025-09-10 06:30:00 | SPY | ETF | 652.05 | 652.28 | 652.04 | 652.25 | 14538.0 |
| 2025-09-10 07:00:00 | SPY | ETF | 652.28 | 652.65 | 652.27 | 652.4 | 53120.0 |
| 2025-09-10 07:30:00 | SPY | ETF | 652.46 | 652.84 | 652.39 | 652.621 | 74458.0 |
| 2025-09-10 08:00:00 | SPY | ETF | 652.28 | 652.98 | 651.48 | 652.47 | 113712.0 |
| 2025-09-10 08:30:00 | SPY | ETF | 652.42 | 654.8 | 652.32 | 653.81 | 760095.0 |
| 2025-09-10 09:00:00 | SPY | ETF | 653.76 | 654.2 | 653.42 | 653.66 | 277150.0 |
| 2025-09-10 09:30:00 | SPY | ETF | 653.63 | 653.885 | 652.68 | 653.5971 | 7874467.0 |
| 2025-09-10 10:00:00 | SPY | ETF | 653.59 | 654.55 | 653.48 | 653.94 | 4632188.0 |
| 2025-09-10 10:30:00 | SPY | ETF | 653.91 | 654.03 | 653.305 | 653.42 | 3572103.0 |
| 2025-09-10 11:00:00 | SPY | ETF | 653.42 | 653.615 | 652.46 | 652.82 | 4137313.0 |
| 2025-09-10 11:30:00 | SPY | ETF | 652.83 | 653.63 | 652.3401 | 653.305 | 2615683.0 |
| 2025-09-10 12:00:00 | SPY | ETF | 653.31 | 653.41 | 652.62 | 652.635 | 1704104.0 |
| 2025-09-10 12:30:00 | SPY | ETF | 652.64 | 653.03 | 652.16 | 652.94 | 1745460.0 |
| 2025-09-10 13:00:00 | SPY | ETF | 652.94 | 653.46 | 652.11 | 652.29 | 2092426.0 |
| 2025-09-10 13:30:00 | SPY | ETF | 652.29 | 652.72 | 651.94 | 652.345 | 2137079.0 |
| 2025-09-10 14:00:00 | SPY | ETF | 652.34 | 652.41 | 651.4 | 651.69 | 2871176.0 |
| 2025-09-10 14:30:00 | SPY | ETF | 651.69 | 652.13 | 651.39 | 651.995 | 3087619.0 |
| 2025-09-10 15:00:00 | SPY | ETF | 651.995 | 652.1399 | 650.63 | 650.84 | 4249001.0 |
| 2025-09-10 15:30:00 | SPY | ETF | 650.86 | 652.7 | 650.69 | 652.225 | 8602975.0 |
| 2025-09-10 16:00:00 | SPY | ETF | 652.22 | 652.44 | 651.96 | 652.19 | 2022348.0 |
| 2025-09-10 16:30:00 | SPY | ETF | 652.15 | 652.26 | 652.0 | 652.04 | 112834.0 |
| 2025-09-10 17:00:00 | SPY | ETF | 652.05 | 652.07 | 651.9 | 651.91 | 121221.0 |
| 2025-09-10 17:30:00 | SPY | ETF | 651.97 | 651.9995 | 651.91 | 651.97 | 8592.0 |
| 2025-09-10 18:00:00 | SPY | ETF | 651.99 | 652.41 | 651.96 | 652.21 | 31489.0 |
| 2025-09-10 18:30:00 | SPY | ETF | 652.3001 | 653.03 | 652.251 | 652.77 | 36978.0 |
| 2025-09-10 19:00:00 | SPY | ETF | 652.75 | 653.05 | 652.27 | 652.86 | 141708.0 |
| 2025-09-10 19:30:00 | SPY | ETF | 652.88 | 652.9 | 652.7 | 652.88 | 21005.0 |
| 2025-09-10 20:00:00 | SPY | ETF | 652.88 | 652.88 | 652.88 | 652.88 | 200.0 |
| 2025-09-10 04:00:00 | QQQ | ETF | 582.25 | 582.28 | 581.6 | 581.63 | 24613.0 |
| 2025-09-10 04:30:00 | QQQ | ETF | 581.6 | 581.6 | 581.07 | 581.2 | 32137.0 |
| 2025-09-10 05:00:00 | QQQ | ETF | 581.34 | 581.35 | 580.93 | 581.16 | 39900.0 |
| 2025-09-10 05:30:00 | QQQ | ETF | 581.05 | 581.53 | 581.0 | 581.51 | 15244.0 |
| 2025-09-10 06:00:00 | QQQ | ETF | 581.41 | 581.8 | 581.41 | 581.74 | 18757.0 |
| 2025-09-10 06:30:00 | QQQ | ETF | 581.86 | 581.95 | 581.72 | 581.89 | 43014.0 |
| 2025-09-10 07:00:00 | QQQ | ETF | 581.93 | 582.16 | 581.866 | 582.01 | 48473.0 |
| 2025-09-10 07:30:00 | QQQ | ETF | 582.01 | 582.7 | 582.0 | 582.5 | 50113.0 |
| 2025-09-10 08:00:00 | QQQ | ETF | 581.97 | 582.86 | 581.03 | 582.36 | 192538.0 |
| 2025-09-10 08:30:00 | QQQ | ETF | 582.0 | 584.77 | 581.86 | 583.88 | 627198.0 |
| 2025-09-10 09:00:00 | QQQ | ETF | 583.87 | 584.1 | 583.25 | 583.78 | 141231.0 |
| 2025-09-10 09:30:00 | QQQ | ETF | 583.74 | 583.77 | 581.33 | 582.035 | 6977312.0 |
| 2025-09-10 10:00:00 | QQQ | ETF | 582.03 | 583.355 | 581.9 | 582.85 | 3559687.0 |
| 2025-09-10 10:30:00 | QQQ | ETF | 582.84 | 583.45 | 582.69 | 582.91 | 2546245.0 |
| 2025-09-10 11:00:00 | QQQ | ETF | 582.92 | 583.195 | 581.8499 | 582.33 | 2851854.0 |
| 2025-09-10 11:30:00 | QQQ | ETF | 582.35 | 582.9699 | 581.85 | 582.5 | 2023443.0 |
| 2025-09-10 12:00:00 | QQQ | ETF | 582.5 | 582.51 | 581.42 | 581.72 | 1594221.0 |
> showing 50 of 42,928 rows — these rows as CSV