PREVIEW / etf_30min / 2025-09-11
file: by_date/etf_30min/2025/2025-09-11.parquet size: 1.0 MB rows: 42,300
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-11 04:00:00 | SPY | ETF | 653.22 | 653.46 | 653.2 | 653.23 | 8429.0 |
| 2025-09-11 04:30:00 | SPY | ETF | 653.22 | 653.24 | 653.1 | 653.17 | 2138.0 |
| 2025-09-11 05:00:00 | SPY | ETF | 653.21 | 653.28 | 653.21 | 653.28 | 2630.0 |
| 2025-09-11 05:30:00 | SPY | ETF | 653.28 | 653.28 | 653.07 | 653.21 | 3810.0 |
| 2025-09-11 06:00:00 | SPY | ETF | 653.22 | 653.63 | 653.22 | 653.55 | 14052.0 |
| 2025-09-11 06:30:00 | SPY | ETF | 653.61 | 653.71 | 653.53 | 653.65 | 3040.0 |
| 2025-09-11 07:00:00 | SPY | ETF | 653.68 | 653.74 | 653.6 | 653.64 | 11445.0 |
| 2025-09-11 07:30:00 | SPY | ETF | 653.63 | 653.9 | 653.63 | 653.72 | 34456.0 |
| 2025-09-11 08:00:00 | SPY | ETF | 653.67 | 654.09 | 652.43 | 653.84 | 216194.0 |
| 2025-09-11 08:30:00 | SPY | ETF | 653.73 | 654.58 | 652.0 | 654.21 | 735675.0 |
| 2025-09-11 09:00:00 | SPY | ETF | 654.19 | 654.25 | 653.64 | 654.15 | 163092.0 |
| 2025-09-11 09:30:00 | SPY | ETF | 654.18 | 655.63 | 653.59 | 655.57 | 7127229.0 |
| 2025-09-11 10:00:00 | SPY | ETF | 655.57 | 656.25 | 655.38 | 655.96 | 4072980.0 |
| 2025-09-11 10:30:00 | SPY | ETF | 655.955 | 657.0 | 655.855 | 656.65 | 3879243.0 |
| 2025-09-11 11:00:00 | SPY | ETF | 656.65 | 657.59 | 656.54 | 657.42 | 3119458.0 |
| 2025-09-11 11:30:00 | SPY | ETF | 657.42 | 657.8 | 656.64 | 657.21 | 2702829.0 |
| 2025-09-11 12:00:00 | SPY | ETF | 657.21 | 657.72 | 657.11 | 657.35 | 2063487.0 |
| 2025-09-11 12:30:00 | SPY | ETF | 657.36 | 657.5358 | 656.855 | 657.16 | 1550601.0 |
| 2025-09-11 13:00:00 | SPY | ETF | 657.15 | 657.555 | 656.88 | 657.12 | 1800088.0 |
| 2025-09-11 13:30:00 | SPY | ETF | 657.115 | 657.57 | 657.01 | 657.55 | 1622246.0 |
| 2025-09-11 14:00:00 | SPY | ETF | 657.555 | 657.66 | 657.17 | 657.33 | 2837336.0 |
| 2025-09-11 14:30:00 | SPY | ETF | 657.33 | 657.735 | 657.16 | 657.535 | 2179092.0 |
| 2025-09-11 15:00:00 | SPY | ETF | 657.53 | 657.83 | 657.4 | 657.76 | 3016830.0 |
| 2025-09-11 15:30:00 | SPY | ETF | 657.75 | 658.33 | 657.465 | 657.61 | 9514242.0 |
| 2025-09-11 16:00:00 | SPY | ETF | 657.6 | 657.79 | 657.42 | 657.58 | 2311051.0 |
| 2025-09-11 16:30:00 | SPY | ETF | 657.57 | 657.65 | 657.49 | 657.55 | 103146.0 |
| 2025-09-11 17:00:00 | SPY | ETF | 657.55 | 657.62 | 657.47 | 657.57 | 19077.0 |
| 2025-09-11 17:30:00 | SPY | ETF | 657.63 | 657.95 | 657.6 | 657.94 | 46972.0 |
| 2025-09-11 18:00:00 | SPY | ETF | 657.88 | 657.9394 | 657.41 | 657.61 | 65245.0 |
| 2025-09-11 18:30:00 | SPY | ETF | 657.58 | 657.59 | 657.4 | 657.58 | 15675.0 |
| 2025-09-11 19:00:00 | SPY | ETF | 657.53 | 657.8 | 657.42 | 657.68 | 4770.0 |
| 2025-09-11 19:30:00 | SPY | ETF | 657.7 | 657.78 | 657.63 | 657.67 | 17666.0 |
| 2025-09-11 04:00:00 | QQQ | ETF | 581.62 | 582.37 | 581.62 | 581.99 | 15255.0 |
| 2025-09-11 04:30:00 | QQQ | ETF | 581.97 | 582.02 | 581.81 | 581.98 | 11849.0 |
| 2025-09-11 05:00:00 | QQQ | ETF | 581.96 | 582.12 | 581.9 | 582.03 | 16532.0 |
| 2025-09-11 05:30:00 | QQQ | ETF | 581.99 | 582.0 | 581.6 | 581.89 | 13921.0 |
| 2025-09-11 06:00:00 | QQQ | ETF | 581.9 | 582.34 | 581.88 | 582.31 | 14144.0 |
| 2025-09-11 06:30:00 | QQQ | ETF | 582.31 | 582.57 | 582.24 | 582.53 | 12505.0 |
| 2025-09-11 07:00:00 | QQQ | ETF | 582.46 | 582.57 | 582.33 | 582.39 | 27421.0 |
| 2025-09-11 07:30:00 | QQQ | ETF | 582.39 | 582.7 | 582.34 | 582.5 | 37281.0 |
| 2025-09-11 08:00:00 | QQQ | ETF | 582.51 | 582.73 | 580.77 | 582.49 | 154389.0 |
| 2025-09-11 08:30:00 | QQQ | ETF | 582.08 | 583.17 | 580.01 | 582.82 | 605997.0 |
| 2025-09-11 09:00:00 | QQQ | ETF | 582.8 | 583.26 | 582.35 | 583.21 | 157862.0 |
| 2025-09-11 09:30:00 | QQQ | ETF | 583.24 | 583.73 | 581.62 | 583.28 | 5786988.0 |
| 2025-09-11 10:00:00 | QQQ | ETF | 583.26 | 583.85 | 582.5 | 582.95 | 3400070.0 |
| 2025-09-11 10:30:00 | QQQ | ETF | 582.94 | 584.24 | 582.86 | 583.8607 | 2985355.0 |
| 2025-09-11 11:00:00 | QQQ | ETF | 583.86 | 584.88 | 583.79 | 584.68 | 2406121.0 |
| 2025-09-11 11:30:00 | QQQ | ETF | 584.68 | 584.88 | 583.87 | 584.37 | 1778568.0 |
| 2025-09-11 12:00:00 | QQQ | ETF | 584.37 | 584.83 | 584.3 | 584.36 | 1399412.0 |
| 2025-09-11 12:30:00 | QQQ | ETF | 584.39 | 584.57 | 583.67 | 584.0 | 1376399.0 |
> showing 50 of 42,300 rows — these rows as CSV