PREVIEW / etf_1hour / 2025-12-11
file: by_date/etf_1hour/2025/2025-12-11.parquet size: 726 KB rows: 27,887
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-11 04:00:00 | SPY | ETF | 683.3 | 684.08 | 682.41 | 683.84 | 78021.0 |
| 2025-12-11 05:00:00 | SPY | ETF | 683.97 | 684.03 | 683.45 | 683.67 | 99357.0 |
| 2025-12-11 06:00:00 | SPY | ETF | 683.67 | 684.7 | 683.5 | 684.65 | 105402.0 |
| 2025-12-11 07:00:00 | SPY | ETF | 684.56 | 686.0 | 684.54 | 685.75 | 138501.0 |
| 2025-12-11 08:00:00 | SPY | ETF | 685.72 | 685.9729 | 681.28 | 684.73 | 345781.0 |
| 2025-12-11 09:00:00 | SPY | ETF | 684.76 | 685.82 | 682.29 | 682.62 | 9929344.0 |
| 2025-12-11 10:00:00 | SPY | ETF | 682.65 | 686.7995 | 682.165 | 685.74 | 11683812.0 |
| 2025-12-11 11:00:00 | SPY | ETF | 685.74 | 686.97 | 684.4 | 685.5 | 7426639.0 |
| 2025-12-11 12:00:00 | SPY | ETF | 685.52 | 688.0351 | 685.395 | 687.29 | 7217302.0 |
| 2025-12-11 13:00:00 | SPY | ETF | 687.28 | 688.625 | 687.09 | 687.96 | 5058716.0 |
| 2025-12-11 14:00:00 | SPY | ETF | 687.97 | 689.25 | 687.85 | 688.83 | 6767559.0 |
| 2025-12-11 15:00:00 | SPY | ETF | 688.83 | 689.18 | 687.99 | 689.145 | 14154312.0 |
| 2025-12-11 16:00:00 | SPY | ETF | 689.14 | 691.24 | 688.95 | 690.87 | 4597196.0 |
| 2025-12-11 17:00:00 | SPY | ETF | 690.87 | 691.04 | 688.76 | 689.27 | 241348.0 |
| 2025-12-11 18:00:00 | SPY | ETF | 689.2 | 690.0 | 688.67 | 688.75 | 151344.0 |
| 2025-12-11 19:00:00 | SPY | ETF | 688.7294 | 689.09 | 688.2 | 688.48 | 47330.0 |
| 2025-12-11 04:00:00 | QQQ | ETF | 618.85 | 623.3 | 618.85 | 622.82 | 157685.0 |
| 2025-12-11 05:00:00 | QQQ | ETF | 623.0 | 623.19 | 622.34 | 622.73 | 63821.0 |
| 2025-12-11 06:00:00 | QQQ | ETF | 622.75 | 623.5 | 622.59 | 623.31 | 68792.0 |
| 2025-12-11 07:00:00 | QQQ | ETF | 623.34 | 625.17 | 623.23 | 625.0 | 211095.0 |
| 2025-12-11 08:00:00 | QQQ | ETF | 623.37 | 628.08 | 619.71 | 623.8 | 646386.0 |
| 2025-12-11 09:00:00 | QQQ | ETF | 623.76 | 624.7 | 617.98 | 618.29 | 8475998.0 |
| 2025-12-11 10:00:00 | QQQ | ETF | 618.31 | 623.5 | 617.72 | 621.1399 | 11690132.0 |
| 2025-12-11 11:00:00 | QQQ | ETF | 621.1344 | 622.54 | 619.31 | 620.42 | 7373540.0 |
| 2025-12-11 12:00:00 | QQQ | ETF | 620.42 | 623.945 | 620.285 | 622.65 | 5112894.0 |
| 2025-12-11 13:00:00 | QQQ | ETF | 622.63 | 624.88 | 622.39 | 623.72 | 4205944.0 |
| 2025-12-11 14:00:00 | QQQ | ETF | 623.73 | 625.78 | 623.685 | 624.98 | 3395398.0 |
| 2025-12-11 15:00:00 | QQQ | ETF | 624.98 | 625.72 | 624.26 | 625.62 | 6007757.0 |
| 2025-12-11 16:00:00 | QQQ | ETF | 625.61 | 629.14 | 625.44 | 628.52 | 1336088.0 |
| 2025-12-11 17:00:00 | QQQ | ETF | 628.61 | 628.61 | 624.0 | 624.85 | 651785.0 |
| 2025-12-11 18:00:00 | QQQ | ETF | 624.89 | 625.97 | 624.0 | 624.52 | 337719.0 |
| 2025-12-11 19:00:00 | QQQ | ETF | 624.5 | 624.87 | 623.85 | 624.02 | 82161.0 |
| 2025-12-11 04:00:00 | IWM | ETF | 253.6 | 254.94 | 253.6 | 254.85 | 29781.0 |
| 2025-12-11 05:00:00 | IWM | ETF | 254.8 | 254.84 | 254.46 | 254.52 | 14943.0 |
| 2025-12-11 06:00:00 | IWM | ETF | 254.52 | 254.75 | 254.48 | 254.68 | 19095.0 |
| 2025-12-11 07:00:00 | IWM | ETF | 254.65 | 255.51 | 254.62 | 255.23 | 118818.0 |
| 2025-12-11 08:00:00 | IWM | ETF | 255.08 | 255.4845 | 253.34 | 254.27 | 274242.0 |
| 2025-12-11 09:00:00 | IWM | ETF | 254.29 | 256.505 | 254.09 | 254.75 | 4800291.0 |
| 2025-12-11 10:00:00 | IWM | ETF | 254.75 | 256.28 | 254.34 | 256.06 | 4426372.0 |
| 2025-12-11 11:00:00 | IWM | ETF | 256.07 | 257.29 | 255.64 | 256.88 | 3842693.0 |
| 2025-12-11 12:00:00 | IWM | ETF | 256.88 | 257.665 | 256.82 | 257.415 | 2963332.0 |
| 2025-12-11 13:00:00 | IWM | ETF | 257.4 | 257.76 | 257.185 | 257.58 | 2235252.0 |
| 2025-12-11 14:00:00 | IWM | ETF | 257.58 | 258.01 | 257.43 | 257.76 | 3467123.0 |
| 2025-12-11 15:00:00 | IWM | ETF | 257.75 | 258.005 | 257.44 | 257.81 | 5656654.0 |
| 2025-12-11 16:00:00 | IWM | ETF | 257.81 | 258.26 | 257.71 | 258.19 | 940241.0 |
| 2025-12-11 17:00:00 | IWM | ETF | 258.1 | 258.4 | 257.82 | 258.1 | 31900.0 |
| 2025-12-11 18:00:00 | IWM | ETF | 258.31 | 258.39 | 257.86 | 258.01 | 18742.0 |
| 2025-12-11 19:00:00 | IWM | ETF | 257.85 | 258.42 | 257.85 | 258.1494 | 20006.0 |
| 2025-12-11 04:00:00 | DIA | ETF | 479.89 | 480.54 | 479.84 | 480.54 | 1371.0 |
| 2025-12-11 05:00:00 | DIA | ETF | 480.57 | 480.57 | 480.32 | 480.35 | 2035.0 |
> showing 50 of 27,887 rows — these rows as CSV