PREVIEW / etf_1hour / 2025-09-15
file: by_date/etf_1hour/2025/2025-09-15.parquet size: 690 KB rows: 26,835
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-15 04:00:00 | SPY | ETF | 658.5 | 658.52 | 657.46 | 658.12 | 32210.0 |
| 2025-09-15 05:00:00 | SPY | ETF | 658.1 | 658.22 | 657.87 | 658.22 | 14057.0 |
| 2025-09-15 06:00:00 | SPY | ETF | 658.21 | 658.6 | 658.17 | 658.57 | 10991.0 |
| 2025-09-15 07:00:00 | SPY | ETF | 658.58 | 658.95 | 658.53 | 658.94 | 64216.0 |
| 2025-09-15 08:00:00 | SPY | ETF | 658.63 | 659.6299 | 657.8 | 659.6299 | 291150.0 |
| 2025-09-15 09:00:00 | SPY | ETF | 659.58 | 660.68 | 659.35 | 660.65 | 7130372.0 |
| 2025-09-15 10:00:00 | SPY | ETF | 660.645 | 660.995 | 659.98 | 660.95 | 7067019.0 |
| 2025-09-15 11:00:00 | SPY | ETF | 660.96 | 661.04 | 660.23 | 660.62 | 5125853.0 |
| 2025-09-15 12:00:00 | SPY | ETF | 660.61 | 660.8901 | 660.07 | 660.13 | 3943397.0 |
| 2025-09-15 13:00:00 | SPY | ETF | 660.12 | 660.66 | 659.53 | 660.6099 | 5003536.0 |
| 2025-09-15 14:00:00 | SPY | ETF | 660.6 | 660.6 | 659.34 | 660.0 | 5549650.0 |
| 2025-09-15 15:00:00 | SPY | ETF | 659.99 | 660.91 | 659.7 | 660.85 | 11203799.0 |
| 2025-09-15 16:00:00 | SPY | ETF | 660.85 | 660.91 | 660.29 | 660.32 | 3282070.0 |
| 2025-09-15 17:00:00 | SPY | ETF | 660.25 | 660.44 | 660.25 | 660.26 | 60358.0 |
| 2025-09-15 18:00:00 | SPY | ETF | 660.29 | 660.44 | 660.08 | 660.1 | 110882.0 |
| 2025-09-15 19:00:00 | SPY | ETF | 660.15 | 660.74 | 660.15 | 660.7 | 35437.0 |
| 2025-09-15 04:00:00 | QQQ | ETF | 587.6 | 587.6 | 586.0 | 586.48 | 94516.0 |
| 2025-09-15 05:00:00 | QQQ | ETF | 586.42 | 586.54 | 586.09 | 586.44 | 36235.0 |
| 2025-09-15 06:00:00 | QQQ | ETF | 586.41 | 587.31 | 586.4 | 587.17 | 46471.0 |
| 2025-09-15 07:00:00 | QQQ | ETF | 587.24 | 587.68 | 587.19 | 587.59 | 102898.0 |
| 2025-09-15 08:00:00 | QQQ | ETF | 587.34 | 588.31 | 586.18 | 588.29 | 308757.0 |
| 2025-09-15 09:00:00 | QQQ | ETF | 588.23 | 590.47 | 588.09 | 590.43 | 5344439.0 |
| 2025-09-15 10:00:00 | QQQ | ETF | 590.44 | 590.56 | 589.68 | 590.468 | 4774797.0 |
| 2025-09-15 11:00:00 | QQQ | ETF | 590.47 | 591.13 | 589.96 | 590.91 | 3696883.0 |
| 2025-09-15 12:00:00 | QQQ | ETF | 590.91 | 591.18 | 590.465 | 590.58 | 2791788.0 |
| 2025-09-15 13:00:00 | QQQ | ETF | 590.582 | 591.13 | 590.19 | 591.1 | 2963302.0 |
| 2025-09-15 14:00:00 | QQQ | ETF | 591.09 | 591.1798 | 590.09 | 590.69 | 3330572.0 |
| 2025-09-15 15:00:00 | QQQ | ETF | 590.6912 | 591.79 | 590.465 | 591.7 | 6713261.0 |
| 2025-09-15 16:00:00 | QQQ | ETF | 591.7 | 591.71 | 591.06 | 591.3 | 1733509.0 |
| 2025-09-15 17:00:00 | QQQ | ETF | 591.3058 | 591.43 | 591.2 | 591.2 | 20069.0 |
| 2025-09-15 18:00:00 | QQQ | ETF | 591.15 | 591.27 | 591.04 | 591.05 | 74632.0 |
| 2025-09-15 19:00:00 | QQQ | ETF | 591.2 | 591.579 | 591.12 | 591.55 | 27962.0 |
| 2025-09-15 04:00:00 | IWM | ETF | 238.98 | 239.34 | 238.75 | 239.19 | 29606.0 |
| 2025-09-15 05:00:00 | IWM | ETF | 239.2 | 239.3 | 239.1 | 239.22 | 12000.0 |
| 2025-09-15 06:00:00 | IWM | ETF | 239.22 | 239.23 | 239.1 | 239.14 | 14919.0 |
| 2025-09-15 07:00:00 | IWM | ETF | 239.14 | 239.19 | 238.97 | 239.18 | 23440.0 |
| 2025-09-15 08:00:00 | IWM | ETF | 239.05 | 239.5 | 238.51 | 239.38 | 185814.0 |
| 2025-09-15 09:00:00 | IWM | ETF | 239.37 | 239.8 | 238.55 | 239.77 | 3418502.0 |
| 2025-09-15 10:00:00 | IWM | ETF | 239.77 | 240.04 | 238.66 | 239.93 | 3314608.0 |
| 2025-09-15 11:00:00 | IWM | ETF | 239.93 | 239.97 | 239.125 | 239.36 | 2838536.0 |
| 2025-09-15 12:00:00 | IWM | ETF | 239.36 | 239.65 | 239.18 | 239.325 | 2019144.0 |
| 2025-09-15 13:00:00 | IWM | ETF | 239.325 | 239.88 | 238.86 | 239.625 | 2131264.0 |
| 2025-09-15 14:00:00 | IWM | ETF | 239.62 | 239.62 | 238.89 | 239.15 | 2609344.0 |
| 2025-09-15 15:00:00 | IWM | ETF | 239.18 | 239.5 | 238.95 | 239.34 | 5003643.0 |
| 2025-09-15 16:00:00 | IWM | ETF | 239.35 | 239.35 | 238.98 | 238.99 | 915529.0 |
| 2025-09-15 17:00:00 | IWM | ETF | 238.98 | 239.21 | 238.96 | 239.11 | 24989.0 |
| 2025-09-15 18:00:00 | IWM | ETF | 239.12 | 239.18 | 238.79 | 238.8 | 40033.0 |
| 2025-09-15 19:00:00 | IWM | ETF | 238.85 | 239.29 | 238.78 | 239.28 | 11910.0 |
| 2025-09-15 04:00:00 | DIA | ETF | 459.26 | 460.28 | 459.26 | 460.18 | 11706.0 |
| 2025-09-15 05:00:00 | DIA | ETF | 460.27 | 460.27 | 460.27 | 460.27 | 100.0 |
> showing 50 of 26,835 rows — these rows as CSV