PREVIEW / etf_1hour / 2025-10-27
file: by_date/etf_1hour/2025/2025-10-27.parquet size: 738 KB rows: 28,728
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-27 04:00:00 | SPY | ETF | 682.66 | 682.9 | 682.15 | 682.55 | 94738.0 |
| 2025-10-27 05:00:00 | SPY | ETF | 682.5 | 683.14 | 682.39 | 683.06 | 21367.0 |
| 2025-10-27 06:00:00 | SPY | ETF | 683.12 | 683.21 | 682.87 | 683.04 | 282877.0 |
| 2025-10-27 07:00:00 | SPY | ETF | 683.06 | 683.24 | 682.32 | 682.41 | 141191.0 |
| 2025-10-27 08:00:00 | SPY | ETF | 682.65 | 683.2201 | 682.16 | 682.71 | 290582.0 |
| 2025-10-27 09:00:00 | SPY | ETF | 682.67 | 683.23 | 682.115 | 683.08 | 5989741.0 |
| 2025-10-27 10:00:00 | SPY | ETF | 683.09 | 683.61 | 682.4 | 682.69 | 6668847.0 |
| 2025-10-27 11:00:00 | SPY | ETF | 682.69 | 683.6 | 682.55 | 683.42 | 3815396.0 |
| 2025-10-27 12:00:00 | SPY | ETF | 683.4124 | 683.88 | 683.375 | 683.74 | 3373734.0 |
| 2025-10-27 13:00:00 | SPY | ETF | 683.75 | 683.99 | 683.17 | 683.94 | 4391728.0 |
| 2025-10-27 14:00:00 | SPY | ETF | 683.93 | 684.25 | 683.76 | 684.145 | 3725737.0 |
| 2025-10-27 15:00:00 | SPY | ETF | 684.15 | 685.54 | 684.0 | 685.18 | 13019372.0 |
| 2025-10-27 16:00:00 | SPY | ETF | 685.19 | 686.02 | 685.0 | 685.74 | 3995867.0 |
| 2025-10-27 17:00:00 | SPY | ETF | 685.736 | 685.76 | 685.53 | 685.69 | 100851.0 |
| 2025-10-27 18:00:00 | SPY | ETF | 685.73 | 685.74 | 685.47 | 685.59 | 67020.0 |
| 2025-10-27 19:00:00 | SPY | ETF | 685.59 | 686.1 | 685.52 | 685.59 | 32251.0 |
| 2025-10-27 04:00:00 | QQQ | ETF | 624.0 | 624.34 | 623.07 | 624.24 | 203909.0 |
| 2025-10-27 05:00:00 | QQQ | ETF | 624.26 | 625.1 | 623.93 | 625.1 | 137723.0 |
| 2025-10-27 06:00:00 | QQQ | ETF | 625.11 | 625.41 | 624.86 | 625.08 | 119023.0 |
| 2025-10-27 07:00:00 | QQQ | ETF | 625.07 | 625.28 | 624.46 | 624.66 | 192823.0 |
| 2025-10-27 08:00:00 | QQQ | ETF | 625.04 | 625.4 | 623.06 | 624.85 | 587965.0 |
| 2025-10-27 09:00:00 | QQQ | ETF | 624.85 | 625.53 | 624.03 | 625.3 | 4848535.0 |
| 2025-10-27 10:00:00 | QQQ | ETF | 625.3 | 626.34 | 624.7 | 625.54 | 5295556.0 |
| 2025-10-27 11:00:00 | QQQ | ETF | 625.54 | 626.75 | 625.48 | 626.39 | 3945236.0 |
| 2025-10-27 12:00:00 | QQQ | ETF | 626.41 | 626.98 | 626.31 | 626.9 | 3262937.0 |
| 2025-10-27 13:00:00 | QQQ | ETF | 626.9 | 627.26 | 626.3814 | 627.205 | 3601376.0 |
| 2025-10-27 14:00:00 | QQQ | ETF | 627.2 | 627.685 | 627.035 | 627.575 | 3089077.0 |
| 2025-10-27 15:00:00 | QQQ | ETF | 627.57 | 628.55 | 627.07 | 628.08 | 9196878.0 |
| 2025-10-27 16:00:00 | QQQ | ETF | 628.08 | 629.3 | 626.21 | 629.1 | 2607031.0 |
| 2025-10-27 17:00:00 | QQQ | ETF | 629.06 | 629.13 | 628.95 | 629.07 | 70533.0 |
| 2025-10-27 18:00:00 | QQQ | ETF | 629.01 | 629.01 | 628.7008 | 628.9281 | 122802.0 |
| 2025-10-27 19:00:00 | QQQ | ETF | 628.92 | 629.39 | 628.88 | 628.94 | 101283.0 |
| 2025-10-27 04:00:00 | IWM | ETF | 251.97 | 252.35 | 250.6 | 252.19 | 57419.0 |
| 2025-10-27 05:00:00 | IWM | ETF | 252.19 | 252.29 | 251.83 | 252.17 | 40331.0 |
| 2025-10-27 06:00:00 | IWM | ETF | 252.05 | 252.55 | 251.94 | 252.36 | 65526.0 |
| 2025-10-27 07:00:00 | IWM | ETF | 252.35 | 252.36 | 251.79 | 251.79 | 70796.0 |
| 2025-10-27 08:00:00 | IWM | ETF | 252.31 | 252.55 | 251.6 | 251.89 | 153098.0 |
| 2025-10-27 09:00:00 | IWM | ETF | 251.88 | 252.21 | 250.6414 | 251.82 | 3470103.0 |
| 2025-10-27 10:00:00 | IWM | ETF | 251.82 | 251.87 | 250.1602 | 250.23 | 4100553.0 |
| 2025-10-27 11:00:00 | IWM | ETF | 250.23 | 250.8 | 249.92 | 250.215 | 3495824.0 |
| 2025-10-27 12:00:00 | IWM | ETF | 250.22 | 250.24 | 249.5 | 250.185 | 4000781.0 |
| 2025-10-27 13:00:00 | IWM | ETF | 250.185 | 250.29 | 249.53 | 250.03 | 2449010.0 |
| 2025-10-27 14:00:00 | IWM | ETF | 250.02 | 250.28 | 249.76 | 250.14 | 2027021.0 |
| 2025-10-27 15:00:00 | IWM | ETF | 250.16 | 250.53 | 250.025 | 250.31 | 5026048.0 |
| 2025-10-27 16:00:00 | IWM | ETF | 250.31 | 250.6 | 250.21 | 250.51 | 546126.0 |
| 2025-10-27 17:00:00 | IWM | ETF | 250.53 | 250.5901 | 250.43 | 250.49 | 14684.0 |
| 2025-10-27 18:00:00 | IWM | ETF | 250.46 | 250.46 | 250.13 | 250.28 | 45339.0 |
| 2025-10-27 19:00:00 | IWM | ETF | 250.2 | 250.43 | 250.13 | 250.16 | 30792.0 |
| 2025-10-27 04:00:00 | DIA | ETF | 475.21 | 475.3 | 474.8 | 474.83 | 1458.0 |
| 2025-10-27 05:00:00 | DIA | ETF | 474.81 | 474.98 | 474.6 | 474.98 | 1269.0 |
> showing 50 of 28,728 rows — these rows as CSV