PREVIEW / etf_1hour / 2025-12-02
file: by_date/etf_1hour/2025/2025-12-02.parquet size: 717 KB rows: 27,478
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-02 04:00:00 | SPY | ETF | 680.47 | 681.2 | 680.45 | 680.93 | 44503.0 |
| 2025-12-02 05:00:00 | SPY | ETF | 681.04 | 682.1 | 680.88 | 682.0 | 34435.0 |
| 2025-12-02 06:00:00 | SPY | ETF | 681.96 | 682.4 | 681.81 | 681.81 | 32788.0 |
| 2025-12-02 07:00:00 | SPY | ETF | 681.83 | 682.09 | 681.25 | 682.07 | 113046.0 |
| 2025-12-02 08:00:00 | SPY | ETF | 679.7 | 682.36 | 678.83 | 682.35 | 267620.0 |
| 2025-12-02 09:00:00 | SPY | ETF | 682.31 | 682.96 | 681.49 | 682.33 | 5096325.0 |
| 2025-12-02 10:00:00 | SPY | ETF | 682.33 | 683.68 | 680.85 | 683.51 | 8153991.0 |
| 2025-12-02 11:00:00 | SPY | ETF | 683.51 | 683.82 | 679.3275 | 680.56 | 8648654.0 |
| 2025-12-02 12:00:00 | SPY | ETF | 680.58 | 682.84 | 680.13 | 680.14 | 4762616.0 |
| 2025-12-02 13:00:00 | SPY | ETF | 680.13 | 681.6 | 679.93 | 681.11 | 3755493.0 |
| 2025-12-02 14:00:00 | SPY | ETF | 681.1 | 682.61 | 680.76 | 682.35 | 6121034.0 |
| 2025-12-02 15:00:00 | SPY | ETF | 682.36 | 682.88 | 681.36 | 681.48 | 10431668.0 |
| 2025-12-02 16:00:00 | SPY | ETF | 681.49 | 681.84 | 681.36 | 681.8 | 2128616.0 |
| 2025-12-02 17:00:00 | SPY | ETF | 681.78 | 681.93 | 681.7 | 681.92 | 51750.0 |
| 2025-12-02 18:00:00 | SPY | ETF | 681.88 | 682.29 | 681.75 | 682.14 | 43825.0 |
| 2025-12-02 19:00:00 | SPY | ETF | 682.2568 | 682.58 | 681.329 | 682.4 | 38664.0 |
| 2025-12-02 04:00:00 | QQQ | ETF | 617.68 | 618.44 | 617.67 | 618.22 | 54750.0 |
| 2025-12-02 05:00:00 | QQQ | ETF | 618.3 | 619.6 | 618.13 | 619.35 | 67029.0 |
| 2025-12-02 06:00:00 | QQQ | ETF | 619.45 | 619.83 | 619.12 | 619.18 | 79368.0 |
| 2025-12-02 07:00:00 | QQQ | ETF | 619.17 | 619.64 | 618.63 | 619.64 | 134123.0 |
| 2025-12-02 08:00:00 | QQQ | ETF | 619.18 | 619.98 | 615.49 | 619.79 | 317762.0 |
| 2025-12-02 09:00:00 | QQQ | ETF | 619.84 | 622.3655 | 618.98 | 621.99 | 6872008.0 |
| 2025-12-02 10:00:00 | QQQ | ETF | 622.0 | 623.75 | 620.4 | 623.2 | 8511489.0 |
| 2025-12-02 11:00:00 | QQQ | ETF | 623.22 | 623.58 | 617.59 | 619.87 | 9996115.0 |
| 2025-12-02 12:00:00 | QQQ | ETF | 619.86 | 622.63 | 619.75 | 619.7855 | 4539241.0 |
| 2025-12-02 13:00:00 | QQQ | ETF | 619.78 | 621.7599 | 619.575 | 621.52 | 4083485.0 |
| 2025-12-02 14:00:00 | QQQ | ETF | 621.49 | 623.11 | 621.2 | 622.87 | 4128388.0 |
| 2025-12-02 15:00:00 | QQQ | ETF | 622.88 | 623.22 | 621.86 | 622.07 | 5874564.0 |
| 2025-12-02 16:00:00 | QQQ | ETF | 622.04 | 622.22 | 621.4917 | 622.21 | 1333080.0 |
| 2025-12-02 17:00:00 | QQQ | ETF | 622.14 | 622.5 | 622.04 | 622.39 | 79362.0 |
| 2025-12-02 18:00:00 | QQQ | ETF | 622.49 | 622.82 | 622.3516 | 622.75 | 56892.0 |
| 2025-12-02 19:00:00 | QQQ | ETF | 622.67 | 622.9856 | 621.5151 | 622.73 | 140184.0 |
| 2025-12-02 04:00:00 | IWM | ETF | 246.51 | 246.92 | 246.42 | 246.71 | 35294.0 |
| 2025-12-02 05:00:00 | IWM | ETF | 246.67 | 247.1 | 246.53 | 247.1 | 20563.0 |
| 2025-12-02 06:00:00 | IWM | ETF | 247.11 | 247.23 | 246.9 | 246.94 | 47781.0 |
| 2025-12-02 07:00:00 | IWM | ETF | 246.99 | 246.99 | 246.69 | 246.91 | 64637.0 |
| 2025-12-02 08:00:00 | IWM | ETF | 246.87 | 247.39 | 245.89 | 247.35 | 134345.0 |
| 2025-12-02 09:00:00 | IWM | ETF | 247.35 | 247.55 | 246.16 | 247.09 | 3809935.0 |
| 2025-12-02 10:00:00 | IWM | ETF | 247.06 | 247.265 | 245.86 | 246.57 | 4074088.0 |
| 2025-12-02 11:00:00 | IWM | ETF | 246.57 | 246.91 | 245.28 | 245.68 | 4739417.0 |
| 2025-12-02 12:00:00 | IWM | ETF | 245.69 | 246.54 | 245.63 | 245.74 | 2049335.0 |
| 2025-12-02 13:00:00 | IWM | ETF | 245.73 | 246.37 | 245.661 | 246.05 | 2716918.0 |
| 2025-12-02 14:00:00 | IWM | ETF | 246.04 | 246.43 | 245.88 | 246.305 | 2177360.0 |
| 2025-12-02 15:00:00 | IWM | ETF | 246.3 | 246.43 | 245.12 | 245.18 | 4608435.0 |
| 2025-12-02 16:00:00 | IWM | ETF | 245.18 | 245.33 | 245.0 | 245.26 | 989585.0 |
| 2025-12-02 17:00:00 | IWM | ETF | 245.1807 | 245.43 | 245.11 | 245.38 | 37375.0 |
| 2025-12-02 18:00:00 | IWM | ETF | 245.36 | 245.49 | 245.24 | 245.49 | 9394.0 |
| 2025-12-02 19:00:00 | IWM | ETF | 245.54 | 245.58 | 245.0888 | 245.5313 | 30696.0 |
| 2025-12-02 04:00:00 | DIA | ETF | 473.52 | 473.78 | 473.46 | 473.64 | 1845.0 |
| 2025-12-02 05:00:00 | DIA | ETF | 473.68 | 474.17 | 473.66 | 474.17 | 1290.0 |
> showing 50 of 27,478 rows — these rows as CSV