PREVIEW / etf_30min / 2025-10-09
file: by_date/etf_30min/2025/2025-10-09.parquet size: 1.0 MB rows: 44,549
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-10-09 04:00:00 | SPY | ETF | 673.12 | 673.28 | 672.86 | 673.02 | 7276.0 |
| 2025-10-09 04:30:00 | SPY | ETF | 672.96 | 672.96 | 672.59 | 672.7 | 14201.0 |
| 2025-10-09 05:00:00 | SPY | ETF | 672.74 | 673.11 | 672.61 | 673.09 | 4176.0 |
| 2025-10-09 05:30:00 | SPY | ETF | 673.08 | 673.34 | 673.05 | 673.1 | 3438.0 |
| 2025-10-09 06:00:00 | SPY | ETF | 673.09 | 673.23 | 672.94 | 673.01 | 2700.0 |
| 2025-10-09 06:30:00 | SPY | ETF | 672.83 | 673.12 | 672.73 | 673.11 | 9066.0 |
| 2025-10-09 07:00:00 | SPY | ETF | 673.01 | 673.5 | 673.0 | 673.49 | 67228.0 |
| 2025-10-09 07:30:00 | SPY | ETF | 673.45 | 673.58 | 673.04 | 673.08 | 12077.0 |
| 2025-10-09 08:00:00 | SPY | ETF | 673.0197 | 673.68 | 672.7 | 673.32 | 80333.0 |
| 2025-10-09 08:30:00 | SPY | ETF | 673.32 | 673.49 | 672.95 | 673.4694 | 34450.0 |
| 2025-10-09 09:00:00 | SPY | ETF | 673.47 | 673.58 | 673.15 | 673.53 | 112272.0 |
| 2025-10-09 09:30:00 | SPY | ETF | 673.52 | 673.94 | 671.57 | 671.915 | 7255141.0 |
| 2025-10-09 10:00:00 | SPY | ETF | 671.91 | 672.24 | 671.12 | 671.225 | 4200586.0 |
| 2025-10-09 10:30:00 | SPY | ETF | 671.23 | 671.53 | 669.97 | 671.355 | 5058597.0 |
| 2025-10-09 11:00:00 | SPY | ETF | 671.35 | 671.851 | 670.67 | 670.75 | 2660855.0 |
| 2025-10-09 11:30:00 | SPY | ETF | 670.75 | 671.51 | 669.99 | 671.308 | 3022233.0 |
| 2025-10-09 12:00:00 | SPY | ETF | 671.31 | 671.58 | 670.54 | 670.965 | 1710097.0 |
| 2025-10-09 12:30:00 | SPY | ETF | 670.97 | 671.125 | 669.65 | 669.8 | 2157514.0 |
| 2025-10-09 13:00:00 | SPY | ETF | 669.8 | 670.38 | 669.34 | 669.4688 | 3282091.0 |
| 2025-10-09 13:30:00 | SPY | ETF | 669.46 | 670.38 | 669.21 | 670.19 | 2355805.0 |
| 2025-10-09 14:00:00 | SPY | ETF | 670.185 | 670.33 | 669.33 | 669.82 | 1996936.0 |
| 2025-10-09 14:30:00 | SPY | ETF | 669.81 | 670.08 | 669.5185 | 669.9 | 1686232.0 |
| 2025-10-09 15:00:00 | SPY | ETF | 669.92 | 670.67 | 669.825 | 670.51 | 2989296.0 |
| 2025-10-09 15:30:00 | SPY | ETF | 670.51 | 671.26 | 670.44 | 671.17 | 8157234.0 |
| 2025-10-09 16:00:00 | SPY | ETF | 671.18 | 671.31 | 670.7 | 670.77 | 2552889.0 |
| 2025-10-09 16:30:00 | SPY | ETF | 670.79 | 671.02 | 670.63 | 671.02 | 106815.0 |
| 2025-10-09 17:00:00 | SPY | ETF | 671.02 | 671.0597 | 670.94 | 671.0 | 7147.0 |
| 2025-10-09 17:30:00 | SPY | ETF | 671.01 | 671.2 | 670.9558 | 671.11 | 31819.0 |
| 2025-10-09 18:00:00 | SPY | ETF | 671.05 | 671.67 | 671.05 | 671.2199 | 71708.0 |
| 2025-10-09 18:30:00 | SPY | ETF | 671.23 | 671.68 | 671.23 | 671.59 | 29873.0 |
| 2025-10-09 19:00:00 | SPY | ETF | 671.59 | 671.69 | 671.45 | 671.65 | 16194.0 |
| 2025-10-09 19:30:00 | SPY | ETF | 671.59 | 671.96 | 671.52 | 671.96 | 13419.0 |
| 2025-10-09 04:00:00 | QQQ | ETF | 611.74 | 611.83 | 611.08 | 611.43 | 46959.0 |
| 2025-10-09 04:30:00 | QQQ | ETF | 611.46 | 611.46 | 610.66 | 610.78 | 62097.0 |
| 2025-10-09 05:00:00 | QQQ | ETF | 610.85 | 611.41 | 610.69 | 611.31 | 31493.0 |
| 2025-10-09 05:30:00 | QQQ | ETF | 611.31 | 611.71 | 611.29 | 611.29 | 30964.0 |
| 2025-10-09 06:00:00 | QQQ | ETF | 611.29 | 611.58 | 611.0 | 611.0 | 20094.0 |
| 2025-10-09 06:30:00 | QQQ | ETF | 610.98 | 611.31 | 610.89 | 611.25 | 22778.0 |
| 2025-10-09 07:00:00 | QQQ | ETF | 611.24 | 611.69 | 611.22 | 611.669 | 32528.0 |
| 2025-10-09 07:30:00 | QQQ | ETF | 611.67 | 611.79 | 611.11 | 611.12 | 33735.0 |
| 2025-10-09 08:00:00 | QQQ | ETF | 611.3 | 612.36 | 610.7 | 611.4225 | 123458.0 |
| 2025-10-09 08:30:00 | QQQ | ETF | 611.43 | 611.62 | 611.21 | 611.6 | 71605.0 |
| 2025-10-09 09:00:00 | QQQ | ETF | 611.61 | 611.66 | 611.16 | 611.54 | 159943.0 |
| 2025-10-09 09:30:00 | QQQ | ETF | 611.48 | 611.61 | 609.68 | 610.29 | 4446590.0 |
| 2025-10-09 10:00:00 | QQQ | ETF | 610.3 | 610.53 | 609.48 | 609.64 | 2626899.0 |
| 2025-10-09 10:30:00 | QQQ | ETF | 609.66 | 609.84 | 608.23 | 609.63 | 2851127.0 |
| 2025-10-09 11:00:00 | QQQ | ETF | 609.64 | 610.18 | 608.95 | 609.06 | 1708981.0 |
| 2025-10-09 11:30:00 | QQQ | ETF | 609.05 | 610.19 | 608.34 | 609.92 | 2070273.0 |
| 2025-10-09 12:00:00 | QQQ | ETF | 609.93 | 610.19 | 609.24 | 609.71 | 1299507.0 |
| 2025-10-09 12:30:00 | QQQ | ETF | 609.73 | 609.88 | 608.32 | 608.5 | 1894298.0 |
> showing 50 of 44,549 rows — these rows as CSV