PREVIEW / etf_30min / 2025-09-30
file: by_date/etf_30min/2025/2025-09-30.parquet size: 1.0 MB rows: 44,098
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-30 04:00:00 | SPY | ETF | 662.08 | 662.6 | 662.0 | 662.54 | 13737.0 |
| 2025-09-30 04:30:00 | SPY | ETF | 662.29 | 662.8 | 662.29 | 662.65 | 6099.0 |
| 2025-09-30 05:00:00 | SPY | ETF | 662.64 | 662.64 | 662.35 | 662.57 | 2815.0 |
| 2025-09-30 05:30:00 | SPY | ETF | 662.63 | 662.82 | 662.35 | 662.39 | 4600.0 |
| 2025-09-30 06:00:00 | SPY | ETF | 662.46 | 662.69 | 661.93 | 662.18 | 57754.0 |
| 2025-09-30 06:30:00 | SPY | ETF | 662.2 | 662.66 | 661.94 | 662.63 | 15041.0 |
| 2025-09-30 07:00:00 | SPY | ETF | 662.59 | 662.72 | 662.22 | 662.5 | 25260.0 |
| 2025-09-30 07:30:00 | SPY | ETF | 662.5 | 662.71 | 662.18 | 662.4 | 33782.0 |
| 2025-09-30 08:00:00 | SPY | ETF | 662.43 | 663.69 | 661.9 | 662.68 | 63980.0 |
| 2025-09-30 08:30:00 | SPY | ETF | 662.7 | 663.27 | 662.62 | 663.06 | 154545.0 |
| 2025-09-30 09:00:00 | SPY | ETF | 663.061 | 663.07 | 662.6 | 662.9 | 97141.0 |
| 2025-09-30 09:30:00 | SPY | ETF | 662.92 | 663.28 | 661.9693 | 663.08 | 5485179.0 |
| 2025-09-30 10:00:00 | SPY | ETF | 663.05 | 663.5512 | 662.235 | 662.8571 | 3869243.0 |
| 2025-09-30 10:30:00 | SPY | ETF | 662.85 | 663.38 | 661.691 | 663.22 | 3537281.0 |
| 2025-09-30 11:00:00 | SPY | ETF | 663.22 | 663.63 | 661.61 | 662.225 | 2833261.0 |
| 2025-09-30 11:30:00 | SPY | ETF | 662.23 | 663.16 | 661.89 | 663.0 | 2564984.0 |
| 2025-09-30 12:00:00 | SPY | ETF | 662.99 | 664.0526 | 662.59 | 663.405 | 2046468.0 |
| 2025-09-30 12:30:00 | SPY | ETF | 663.41 | 663.665 | 662.615 | 662.819 | 1578841.0 |
| 2025-09-30 13:00:00 | SPY | ETF | 662.81 | 662.91 | 661.78 | 662.13 | 2451675.0 |
| 2025-09-30 13:30:00 | SPY | ETF | 662.12 | 663.085 | 661.812 | 662.53 | 2352884.0 |
| 2025-09-30 14:00:00 | SPY | ETF | 662.51 | 664.03 | 662.425 | 663.88 | 3664867.0 |
| 2025-09-30 14:30:00 | SPY | ETF | 663.87 | 664.63 | 663.6 | 664.422 | 2671296.0 |
| 2025-09-30 15:00:00 | SPY | ETF | 664.42 | 665.51 | 664.36 | 665.37 | 4466808.0 |
| 2025-09-30 15:30:00 | SPY | ETF | 665.38 | 666.65 | 664.85 | 666.11 | 16296533.0 |
| 2025-09-30 16:00:00 | SPY | ETF | 666.09 | 666.23 | 664.5 | 664.91 | 5552656.0 |
| 2025-09-30 16:30:00 | SPY | ETF | 664.92 | 664.97 | 664.56 | 664.79 | 182113.0 |
| 2025-09-30 17:00:00 | SPY | ETF | 664.9 | 664.94 | 664.75 | 664.93 | 23603.0 |
| 2025-09-30 17:30:00 | SPY | ETF | 664.88 | 664.95 | 664.68 | 664.88 | 50645.0 |
| 2025-09-30 18:00:00 | SPY | ETF | 664.87 | 665.4799 | 664.86 | 665.46 | 128225.0 |
| 2025-09-30 18:30:00 | SPY | ETF | 665.5 | 665.55 | 664.5 | 664.6904 | 63175.0 |
| 2025-09-30 19:00:00 | SPY | ETF | 664.75 | 664.97 | 664.38 | 664.741 | 10717.0 |
| 2025-09-30 19:30:00 | SPY | ETF | 664.89 | 664.9 | 664.65 | 664.68 | 38419.0 |
| 2025-09-30 04:00:00 | QQQ | ETF | 597.71 | 598.19 | 597.1 | 597.68 | 33309.0 |
| 2025-09-30 04:30:00 | QQQ | ETF | 597.69 | 598.24 | 597.64 | 597.95 | 22002.0 |
| 2025-09-30 05:00:00 | QQQ | ETF | 597.96 | 598.08 | 597.65 | 598.08 | 40042.0 |
| 2025-09-30 05:30:00 | QQQ | ETF | 598.09 | 598.43 | 597.66 | 597.86 | 29841.0 |
| 2025-09-30 06:00:00 | QQQ | ETF | 597.82 | 598.22 | 597.48 | 597.71 | 23253.0 |
| 2025-09-30 06:30:00 | QQQ | ETF | 597.69 | 598.26 | 597.31 | 598.12 | 49365.0 |
| 2025-09-30 07:00:00 | QQQ | ETF | 598.1 | 598.37 | 597.88 | 598.07 | 41887.0 |
| 2025-09-30 07:30:00 | QQQ | ETF | 598.06 | 598.27 | 597.7 | 598.08 | 18296.0 |
| 2025-09-30 08:00:00 | QQQ | ETF | 598.06 | 599.179 | 597.0 | 598.31 | 99099.0 |
| 2025-09-30 08:30:00 | QQQ | ETF | 598.31 | 599.01 | 598.25 | 598.75 | 128667.0 |
| 2025-09-30 09:00:00 | QQQ | ETF | 598.78 | 598.78 | 598.25 | 598.46 | 135767.0 |
| 2025-09-30 09:30:00 | QQQ | ETF | 598.45 | 598.67 | 596.1 | 597.63 | 4175220.0 |
| 2025-09-30 10:00:00 | QQQ | ETF | 597.72 | 598.24 | 596.66 | 597.53 | 2684026.0 |
| 2025-09-30 10:30:00 | QQQ | ETF | 597.52 | 599.21 | 596.8 | 598.94 | 2380478.0 |
| 2025-09-30 11:00:00 | QQQ | ETF | 598.94 | 599.41 | 596.85 | 597.43 | 2350712.0 |
| 2025-09-30 11:30:00 | QQQ | ETF | 597.44 | 598.42 | 597.03 | 598.2 | 2182705.0 |
| 2025-09-30 12:00:00 | QQQ | ETF | 598.18 | 598.97 | 597.5 | 598.18 | 1488178.0 |
| 2025-09-30 12:30:00 | QQQ | ETF | 598.19 | 598.49 | 597.22 | 597.54 | 1069359.0 |
> showing 50 of 44,098 rows — these rows as CSV