PREVIEW / etf_1hour / 2025-12-10
file: by_date/etf_1hour/2025/2025-12-10.parquet size: 719 KB rows: 27,636
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-10 04:00:00 | SPY | ETF | 683.71 | 683.9 | 683.27 | 683.48 | 9101.0 |
| 2025-12-10 05:00:00 | SPY | ETF | 683.58 | 683.91 | 681.7 | 682.43 | 174270.0 |
| 2025-12-10 06:00:00 | SPY | ETF | 682.34 | 683.2 | 682.21 | 682.72 | 86817.0 |
| 2025-12-10 07:00:00 | SPY | ETF | 682.72 | 682.75 | 682.07 | 682.56 | 85190.0 |
| 2025-12-10 08:00:00 | SPY | ETF | 682.46 | 684.1 | 681.91 | 682.88 | 401061.0 |
| 2025-12-10 09:00:00 | SPY | ETF | 682.95 | 683.33 | 681.31 | 683.12 | 6189066.0 |
| 2025-12-10 10:00:00 | SPY | ETF | 683.115 | 683.46 | 681.67 | 682.25 | 6866698.0 |
| 2025-12-10 11:00:00 | SPY | ETF | 682.25 | 683.87 | 681.45 | 683.6 | 5712912.0 |
| 2025-12-10 12:00:00 | SPY | ETF | 683.57 | 684.22 | 682.9201 | 683.84 | 3411527.0 |
| 2025-12-10 13:00:00 | SPY | ETF | 683.83 | 684.06 | 682.445 | 682.87 | 4724762.0 |
| 2025-12-10 14:00:00 | SPY | ETF | 682.86 | 688.06 | 682.67 | 687.88 | 19110476.0 |
| 2025-12-10 15:00:00 | SPY | ETF | 687.87 | 688.97 | 687.08 | 687.46 | 19340665.0 |
| 2025-12-10 16:00:00 | SPY | ETF | 687.45 | 687.82 | 686.73 | 687.55 | 3966786.0 |
| 2025-12-10 17:00:00 | SPY | ETF | 687.52 | 687.69 | 686.91 | 687.07 | 512901.0 |
| 2025-12-10 18:00:00 | SPY | ETF | 687.04 | 687.32 | 686.29 | 686.52 | 217712.0 |
| 2025-12-10 19:00:00 | SPY | ETF | 686.5692 | 686.5692 | 685.5 | 685.7206 | 162007.0 |
| 2025-12-10 04:00:00 | QQQ | ETF | 625.58 | 625.9 | 625.23 | 625.37 | 44984.0 |
| 2025-12-10 05:00:00 | QQQ | ETF | 625.27 | 625.84 | 623.1 | 623.95 | 92856.0 |
| 2025-12-10 06:00:00 | QQQ | ETF | 623.8 | 624.92 | 623.68 | 624.28 | 102781.0 |
| 2025-12-10 07:00:00 | QQQ | ETF | 624.3 | 624.32 | 623.39 | 623.89 | 89939.0 |
| 2025-12-10 08:00:00 | QQQ | ETF | 623.84 | 626.21 | 623.18 | 624.45 | 294982.0 |
| 2025-12-10 09:00:00 | QQQ | ETF | 624.63 | 624.67 | 621.92 | 623.45 | 4655346.0 |
| 2025-12-10 10:00:00 | QQQ | ETF | 623.43 | 624.06 | 621.52 | 621.9 | 5061970.0 |
| 2025-12-10 11:00:00 | QQQ | ETF | 621.91 | 624.0897 | 620.99 | 623.92 | 4387940.0 |
| 2025-12-10 12:00:00 | QQQ | ETF | 623.91 | 624.67 | 623.08 | 624.26 | 2146737.0 |
| 2025-12-10 13:00:00 | QQQ | ETF | 624.26 | 624.32 | 622.59 | 623.13 | 3016562.0 |
| 2025-12-10 14:00:00 | QQQ | ETF | 623.115 | 628.37 | 622.87 | 628.14 | 13698944.0 |
| 2025-12-10 15:00:00 | QQQ | ETF | 628.13 | 629.21 | 627.23 | 627.55 | 9980677.0 |
| 2025-12-10 16:00:00 | QQQ | ETF | 627.54 | 627.79 | 626.52 | 627.59 | 1651779.0 |
| 2025-12-10 17:00:00 | QQQ | ETF | 627.54 | 627.62 | 626.4 | 626.68 | 193933.0 |
| 2025-12-10 18:00:00 | QQQ | ETF | 626.7 | 627.29 | 625.5273 | 625.8709 | 287489.0 |
| 2025-12-10 19:00:00 | QQQ | ETF | 625.87 | 625.91 | 624.47 | 624.75 | 166779.0 |
| 2025-12-10 04:00:00 | IWM | ETF | 251.05 | 251.12 | 250.81 | 250.93 | 12415.0 |
| 2025-12-10 05:00:00 | IWM | ETF | 250.92 | 251.12 | 250.43 | 250.64 | 10537.0 |
| 2025-12-10 06:00:00 | IWM | ETF | 250.61 | 251.1 | 250.59 | 251.0 | 17014.0 |
| 2025-12-10 07:00:00 | IWM | ETF | 251.02 | 251.07 | 250.72 | 250.84 | 31249.0 |
| 2025-12-10 08:00:00 | IWM | ETF | 251.0 | 251.49 | 250.7 | 250.91 | 75517.0 |
| 2025-12-10 09:00:00 | IWM | ETF | 250.9 | 251.77 | 250.46 | 251.6 | 2093048.0 |
| 2025-12-10 10:00:00 | IWM | ETF | 251.59 | 252.13 | 250.83 | 251.5007 | 2763352.0 |
| 2025-12-10 11:00:00 | IWM | ETF | 251.53 | 252.5 | 251.11 | 252.36 | 2061180.0 |
| 2025-12-10 12:00:00 | IWM | ETF | 252.35 | 252.405 | 251.5 | 252.12 | 1750431.0 |
| 2025-12-10 13:00:00 | IWM | ETF | 252.11 | 252.48 | 251.385 | 251.58 | 2558839.0 |
| 2025-12-10 14:00:00 | IWM | ETF | 251.59 | 255.58 | 251.54 | 255.4999 | 11530378.0 |
| 2025-12-10 15:00:00 | IWM | ETF | 255.48 | 256.565 | 254.66 | 254.8 | 10532992.0 |
| 2025-12-10 16:00:00 | IWM | ETF | 254.81 | 255.5899 | 254.76 | 255.5 | 1639928.0 |
| 2025-12-10 17:00:00 | IWM | ETF | 255.49 | 255.56 | 255.1 | 255.26 | 47892.0 |
| 2025-12-10 18:00:00 | IWM | ETF | 255.33 | 255.54 | 255.21 | 255.44 | 27623.0 |
| 2025-12-10 19:00:00 | IWM | ETF | 255.21 | 255.42 | 255.1 | 255.189 | 17564.0 |
| 2025-12-10 04:00:00 | DIA | ETF | 476.51 | 476.71 | 476.43 | 476.62 | 452.0 |
| 2025-12-10 05:00:00 | DIA | ETF | 476.48 | 476.6 | 475.63 | 475.9 | 2819.0 |
> showing 50 of 27,636 rows — these rows as CSV