PREVIEW / etf_1hour / 2025-12-24
file: by_date/etf_1hour/2025/2025-12-24.parquet size: 480 KB rows: 17,460
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-12-24 04:00:00 | SPY | ETF | 687.45 | 687.9 | 687.45 | 687.73 | 33311.0 |
| 2025-12-24 05:00:00 | SPY | ETF | 687.69 | 687.81 | 687.54 | 687.75 | 6127.0 |
| 2025-12-24 06:00:00 | SPY | ETF | 687.7 | 687.83 | 687.63 | 687.71 | 9643.0 |
| 2025-12-24 07:00:00 | SPY | ETF | 687.7 | 688.1 | 687.69 | 688.09 | 71877.0 |
| 2025-12-24 08:00:00 | SPY | ETF | 688.07 | 688.33 | 687.35 | 688.23 | 181841.0 |
| 2025-12-24 09:00:00 | SPY | ETF | 688.22 | 688.73 | 687.8 | 688.6 | 4146064.0 |
| 2025-12-24 10:00:00 | SPY | ETF | 688.59 | 689.49 | 688.51 | 689.47 | 5979969.0 |
| 2025-12-24 11:00:00 | SPY | ETF | 689.465 | 690.485 | 689.37 | 690.37 | 5953237.0 |
| 2025-12-24 12:00:00 | SPY | ETF | 690.37 | 690.83 | 690.17 | 690.28 | 10156370.0 |
| 2025-12-24 13:00:00 | SPY | ETF | 690.29 | 690.38 | 689.75 | 689.95 | 2054973.0 |
| 2025-12-24 14:00:00 | SPY | ETF | 689.9498 | 690.18 | 689.9498 | 690.01 | 114094.0 |
| 2025-12-24 15:00:00 | SPY | ETF | 690.0103 | 690.02 | 689.75 | 689.87 | 35877.0 |
| 2025-12-24 16:00:00 | SPY | ETF | 689.87 | 689.87 | 689.55 | 689.56 | 29869.0 |
| 2025-12-24 04:00:00 | QQQ | ETF | 621.91 | 622.24 | 621.72 | 622.09 | 21217.0 |
| 2025-12-24 05:00:00 | QQQ | ETF | 622.07 | 622.07 | 621.81 | 621.98 | 14264.0 |
| 2025-12-24 06:00:00 | QQQ | ETF | 621.94 | 622.12 | 621.8 | 621.9 | 20414.0 |
| 2025-12-24 07:00:00 | QQQ | ETF | 621.94 | 622.54 | 621.88 | 622.52 | 46285.0 |
| 2025-12-24 08:00:00 | QQQ | ETF | 622.5 | 622.86 | 621.59 | 622.68 | 174279.0 |
| 2025-12-24 09:00:00 | QQQ | ETF | 622.68 | 622.78 | 621.72 | 622.34 | 2989661.0 |
| 2025-12-24 10:00:00 | QQQ | ETF | 622.3232 | 623.075 | 622.19 | 622.7913 | 3284115.0 |
| 2025-12-24 11:00:00 | QQQ | ETF | 622.8 | 624.08 | 622.78 | 623.88 | 3281330.0 |
| 2025-12-24 12:00:00 | QQQ | ETF | 623.89 | 624.28 | 623.611 | 623.94 | 3641677.0 |
| 2025-12-24 13:00:00 | QQQ | ETF | 623.94 | 624.0 | 622.9188 | 623.02 | 1141187.0 |
| 2025-12-24 14:00:00 | QQQ | ETF | 623.03 | 623.25 | 623.021 | 623.1 | 15442.0 |
| 2025-12-24 15:00:00 | QQQ | ETF | 623.1 | 623.32 | 623.1 | 623.2 | 15847.0 |
| 2025-12-24 16:00:00 | QQQ | ETF | 623.2 | 623.23 | 623.02 | 623.02 | 14970.0 |
| 2025-12-24 04:00:00 | IWM | ETF | 251.83 | 251.91 | 251.69 | 251.88 | 8555.0 |
| 2025-12-24 05:00:00 | IWM | ETF | 251.87 | 252.1 | 251.84 | 252.1 | 2122.0 |
| 2025-12-24 06:00:00 | IWM | ETF | 252.03 | 252.04 | 251.88 | 251.9 | 3171.0 |
| 2025-12-24 07:00:00 | IWM | ETF | 251.89 | 252.25 | 251.89 | 252.17 | 67555.0 |
| 2025-12-24 08:00:00 | IWM | ETF | 251.89 | 252.2424 | 251.54 | 252.14 | 73769.0 |
| 2025-12-24 09:00:00 | IWM | ETF | 252.101 | 252.21 | 251.12 | 251.565 | 2151618.0 |
| 2025-12-24 10:00:00 | IWM | ETF | 251.545 | 252.47 | 251.43 | 252.4056 | 1886047.0 |
| 2025-12-24 11:00:00 | IWM | ETF | 252.4 | 252.61 | 252.095 | 252.34 | 1446622.0 |
| 2025-12-24 12:00:00 | IWM | ETF | 252.3505 | 252.86 | 252.29 | 252.69 | 2155541.0 |
| 2025-12-24 13:00:00 | IWM | ETF | 252.71 | 252.74 | 252.19 | 252.35 | 335731.0 |
| 2025-12-24 14:00:00 | IWM | ETF | 252.35 | 252.47 | 252.31 | 252.42 | 8410.0 |
| 2025-12-24 15:00:00 | IWM | ETF | 252.41 | 252.41 | 252.31 | 252.31 | 3482.0 |
| 2025-12-24 16:00:00 | IWM | ETF | 252.24 | 252.38 | 252.23 | 252.27 | 1110.0 |
| 2025-12-24 04:00:00 | DIA | ETF | 483.82 | 484.05 | 483.82 | 483.98 | 940.0 |
| 2025-12-24 05:00:00 | DIA | ETF | 483.99 | 484.03 | 483.94 | 483.99 | 585.0 |
| 2025-12-24 06:00:00 | DIA | ETF | 484.11 | 484.11 | 483.98 | 483.98 | 555.0 |
| 2025-12-24 07:00:00 | DIA | ETF | 483.95 | 484.08 | 483.94 | 484.0 | 1120.0 |
| 2025-12-24 08:00:00 | DIA | ETF | 483.9599 | 484.362 | 483.86 | 484.31 | 2056.0 |
| 2025-12-24 09:00:00 | DIA | ETF | 484.24 | 485.62 | 483.59 | 485.18 | 393206.0 |
| 2025-12-24 10:00:00 | DIA | ETF | 485.18 | 486.31 | 485.18 | 486.2499 | 335200.0 |
| 2025-12-24 11:00:00 | DIA | ETF | 486.25 | 487.07 | 486.2 | 486.97 | 245975.0 |
| 2025-12-24 12:00:00 | DIA | ETF | 486.95 | 487.57 | 486.9101 | 486.97 | 288045.0 |
| 2025-12-24 13:00:00 | DIA | ETF | 486.94 | 487.17 | 486.67 | 487.04 | 56257.0 |
| 2025-12-24 14:00:00 | DIA | ETF | 487.0 | 487.0 | 487.0 | 487.0 | 176.0 |
> showing 50 of 17,460 rows — these rows as CSV