PREVIEW / etf_1hour / 2025-09-12
file: by_date/etf_1hour/2025/2025-09-12.parquet size: 675 KB rows: 25,782
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-12 04:00:00 | SPY | ETF | 657.17 | 657.28 | 656.29 | 656.94 | 31004.0 |
| 2025-09-12 05:00:00 | SPY | ETF | 656.88 | 657.14 | 656.85 | 657.02 | 22302.0 |
| 2025-09-12 06:00:00 | SPY | ETF | 657.01 | 657.27 | 656.95 | 657.27 | 10323.0 |
| 2025-09-12 07:00:00 | SPY | ETF | 657.2 | 657.6 | 657.0 | 657.581 | 23579.0 |
| 2025-09-12 08:00:00 | SPY | ETF | 657.54 | 657.97 | 656.4504 | 657.65 | 153388.0 |
| 2025-09-12 09:00:00 | SPY | ETF | 657.64 | 658.068 | 657.145 | 657.99 | 5884221.0 |
| 2025-09-12 10:00:00 | SPY | ETF | 658.01 | 658.48 | 657.32 | 658.3804 | 6215996.0 |
| 2025-09-12 11:00:00 | SPY | ETF | 658.38 | 658.435 | 657.21 | 657.62 | 4519709.0 |
| 2025-09-12 12:00:00 | SPY | ETF | 657.61 | 658.2 | 657.3099 | 658.07 | 3944290.0 |
| 2025-09-12 13:00:00 | SPY | ETF | 658.075 | 658.4609 | 657.795 | 658.3715 | 3800529.0 |
| 2025-09-12 14:00:00 | SPY | ETF | 658.375 | 659.11 | 658.23 | 658.81 | 6094868.0 |
| 2025-09-12 15:00:00 | SPY | ETF | 658.81 | 658.945 | 656.9 | 657.42 | 17242874.0 |
| 2025-09-12 16:00:00 | SPY | ETF | 657.4 | 657.6 | 657.18 | 657.41 | 2274643.0 |
| 2025-09-12 17:00:00 | SPY | ETF | 657.52 | 657.64 | 657.4512 | 657.46 | 64018.0 |
| 2025-09-12 18:00:00 | SPY | ETF | 657.44 | 657.45 | 657.28 | 657.28 | 40091.0 |
| 2025-09-12 19:00:00 | SPY | ETF | 657.28 | 657.35 | 657.19 | 657.25 | 43054.0 |
| 2025-09-12 04:00:00 | QQQ | ETF | 584.3 | 584.53 | 583.35 | 584.14 | 53667.0 |
| 2025-09-12 05:00:00 | QQQ | ETF | 584.13 | 584.53 | 583.98 | 584.32 | 26740.0 |
| 2025-09-12 06:00:00 | QQQ | ETF | 584.27 | 584.65 | 584.21 | 584.63 | 25895.0 |
| 2025-09-12 07:00:00 | QQQ | ETF | 584.61 | 585.21 | 584.35 | 585.16 | 44985.0 |
| 2025-09-12 08:00:00 | QQQ | ETF | 585.12 | 585.17 | 583.642 | 585.06 | 277484.0 |
| 2025-09-12 09:00:00 | QQQ | ETF | 585.05 | 585.57 | 584.1 | 585.145 | 4529052.0 |
| 2025-09-12 10:00:00 | QQQ | ETF | 585.145 | 586.83 | 584.69 | 586.6 | 5385405.0 |
| 2025-09-12 11:00:00 | QQQ | ETF | 586.6 | 586.7257 | 585.79 | 586.23 | 3801826.0 |
| 2025-09-12 12:00:00 | QQQ | ETF | 586.2201 | 586.98 | 585.77 | 586.69 | 4751128.0 |
| 2025-09-12 13:00:00 | QQQ | ETF | 586.7 | 587.11 | 586.235 | 587.01 | 3871340.0 |
| 2025-09-12 14:00:00 | QQQ | ETF | 587.02 | 587.86 | 586.75 | 587.75 | 3796472.0 |
| 2025-09-12 15:00:00 | QQQ | ETF | 587.75 | 587.83 | 586.12 | 586.66 | 7387461.0 |
| 2025-09-12 16:00:00 | QQQ | ETF | 586.66 | 586.9 | 586.38 | 586.7501 | 1493535.0 |
| 2025-09-12 17:00:00 | QQQ | ETF | 586.75 | 586.83 | 586.5 | 586.5 | 15599.0 |
| 2025-09-12 18:00:00 | QQQ | ETF | 586.7726 | 586.7793 | 586.63 | 586.69 | 19297.0 |
| 2025-09-12 19:00:00 | QQQ | ETF | 586.6996 | 586.77 | 586.55 | 586.64 | 11272.0 |
| 2025-09-12 04:00:00 | IWM | ETF | 240.04 | 240.1 | 239.53 | 239.83 | 66979.0 |
| 2025-09-12 05:00:00 | IWM | ETF | 239.82 | 239.87 | 239.62 | 239.75 | 9454.0 |
| 2025-09-12 06:00:00 | IWM | ETF | 239.79 | 240.02 | 239.75 | 239.94 | 22028.0 |
| 2025-09-12 07:00:00 | IWM | ETF | 239.96 | 240.12 | 239.78 | 239.94 | 72073.0 |
| 2025-09-12 08:00:00 | IWM | ETF | 239.96 | 240.37 | 239.63 | 240.05 | 253752.0 |
| 2025-09-12 09:00:00 | IWM | ETF | 240.06 | 240.32 | 239.36 | 239.71 | 4822610.0 |
| 2025-09-12 10:00:00 | IWM | ETF | 239.72 | 239.88 | 238.77 | 239.14 | 5311669.0 |
| 2025-09-12 11:00:00 | IWM | ETF | 239.1445 | 239.16 | 238.64 | 238.7182 | 3431414.0 |
| 2025-09-12 12:00:00 | IWM | ETF | 238.72 | 239.03 | 238.59 | 239.02 | 2519384.0 |
| 2025-09-12 13:00:00 | IWM | ETF | 239.02 | 239.22 | 238.75 | 239.085 | 2343045.0 |
| 2025-09-12 14:00:00 | IWM | ETF | 239.09 | 239.63 | 239.0537 | 239.18 | 2734966.0 |
| 2025-09-12 15:00:00 | IWM | ETF | 239.18 | 239.345 | 238.195 | 238.33 | 7564619.0 |
| 2025-09-12 16:00:00 | IWM | ETF | 238.34 | 238.56 | 238.25 | 238.42 | 2400377.0 |
| 2025-09-12 17:00:00 | IWM | ETF | 238.36 | 238.53 | 238.3 | 238.39 | 20575.0 |
| 2025-09-12 18:00:00 | IWM | ETF | 238.32 | 238.41 | 238.29 | 238.39 | 5994.0 |
| 2025-09-12 19:00:00 | IWM | ETF | 238.3 | 238.46 | 238.29 | 238.4 | 6512.0 |
| 2025-09-12 04:00:00 | DIA | ETF | 461.46 | 461.49 | 460.86 | 461.34 | 5550.0 |
| 2025-09-12 05:00:00 | DIA | ETF | 461.39 | 461.39 | 461.24 | 461.24 | 650.0 |
> showing 50 of 25,782 rows — these rows as CSV