PREVIEW / etf_1hour / 2025-12-05
file: by_date/etf_1hour/2025/2025-12-05.parquet size: 705 KB rows: 27,054
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-05 04:00:00 | SPY | ETF | 685.3 | 686.06 | 685.3 | 685.81 | 25021.0 |
| 2025-12-05 05:00:00 | SPY | ETF | 685.79 | 686.05 | 685.68 | 685.68 | 9317.0 |
| 2025-12-05 06:00:00 | SPY | ETF | 685.57 | 686.1 | 685.53 | 686.0 | 19251.0 |
| 2025-12-05 07:00:00 | SPY | ETF | 685.95 | 686.15 | 685.57 | 685.88 | 55551.0 |
| 2025-12-05 08:00:00 | SPY | ETF | 685.75 | 686.48 | 683.66 | 684.35 | 396281.0 |
| 2025-12-05 09:00:00 | SPY | ETF | 684.35 | 687.03 | 684.32 | 686.895 | 6459221.0 |
| 2025-12-05 10:00:00 | SPY | ETF | 686.92 | 688.39 | 686.26 | 686.67 | 9041410.0 |
| 2025-12-05 11:00:00 | SPY | ETF | 686.67 | 687.12 | 685.02 | 686.02 | 7190669.0 |
| 2025-12-05 12:00:00 | SPY | ETF | 686.02 | 686.43 | 684.58 | 686.25 | 4932288.0 |
| 2025-12-05 13:00:00 | SPY | ETF | 686.245 | 686.97 | 685.52 | 686.19 | 4247128.0 |
| 2025-12-05 14:00:00 | SPY | ETF | 686.19 | 686.4 | 685.57 | 686.25 | 3761578.0 |
| 2025-12-05 15:00:00 | SPY | ETF | 686.26 | 686.3 | 684.6 | 685.65 | 11125941.0 |
| 2025-12-05 16:00:00 | SPY | ETF | 685.65 | 686.1 | 685.61 | 685.92 | 4761174.0 |
| 2025-12-05 17:00:00 | SPY | ETF | 685.9499 | 686.05 | 685.67 | 685.85 | 94017.0 |
| 2025-12-05 18:00:00 | SPY | ETF | 685.8988 | 686.03 | 685.71 | 685.85 | 21837.0 |
| 2025-12-05 19:00:00 | SPY | ETF | 685.8 | 685.99 | 685.8 | 685.97 | 21339.0 |
| 2025-12-05 04:00:00 | QQQ | ETF | 625.3 | 625.74 | 625.06 | 625.35 | 93734.0 |
| 2025-12-05 05:00:00 | QQQ | ETF | 625.34 | 625.71 | 625.21 | 625.3 | 44987.0 |
| 2025-12-05 06:00:00 | QQQ | ETF | 625.24 | 625.51 | 625.02 | 625.34 | 33297.0 |
| 2025-12-05 07:00:00 | QQQ | ETF | 625.34 | 625.67 | 624.65 | 624.97 | 92626.0 |
| 2025-12-05 08:00:00 | QQQ | ETF | 625.23 | 626.1 | 621.98 | 622.81 | 648841.0 |
| 2025-12-05 09:00:00 | QQQ | ETF | 622.8 | 627.37 | 622.78 | 627.0799 | 7405430.0 |
| 2025-12-05 10:00:00 | QQQ | ETF | 627.08 | 628.92 | 625.29 | 625.94 | 9100535.0 |
| 2025-12-05 11:00:00 | QQQ | ETF | 625.93 | 626.53 | 623.71 | 625.59 | 7394622.0 |
| 2025-12-05 12:00:00 | QQQ | ETF | 625.58 | 625.86 | 624.02 | 625.61 | 4439990.0 |
| 2025-12-05 13:00:00 | QQQ | ETF | 625.6 | 626.29 | 624.87 | 625.53 | 3761272.0 |
| 2025-12-05 14:00:00 | QQQ | ETF | 625.54 | 625.94 | 624.95 | 625.7818 | 3372492.0 |
| 2025-12-05 15:00:00 | QQQ | ETF | 625.79 | 625.85 | 624.32 | 625.51 | 6122471.0 |
| 2025-12-05 16:00:00 | QQQ | ETF | 625.48 | 625.95 | 625.44 | 625.7 | 1691216.0 |
| 2025-12-05 17:00:00 | QQQ | ETF | 625.72 | 625.82 | 625.55 | 625.74 | 43615.0 |
| 2025-12-05 18:00:00 | QQQ | ETF | 625.71 | 625.7499 | 625.63 | 625.63 | 39804.0 |
| 2025-12-05 19:00:00 | QQQ | ETF | 625.63 | 625.74 | 625.46 | 625.51 | 28635.0 |
| 2025-12-05 04:00:00 | IWM | ETF | 251.74 | 251.91 | 251.58 | 251.8 | 19184.0 |
| 2025-12-05 05:00:00 | IWM | ETF | 251.8 | 251.93 | 251.73 | 251.83 | 11928.0 |
| 2025-12-05 06:00:00 | IWM | ETF | 251.8 | 252.03 | 251.8 | 251.86 | 8751.0 |
| 2025-12-05 07:00:00 | IWM | ETF | 251.85 | 251.96 | 251.58 | 251.96 | 50789.0 |
| 2025-12-05 08:00:00 | IWM | ETF | 251.62 | 252.17 | 251.26 | 251.36 | 165779.0 |
| 2025-12-05 09:00:00 | IWM | ETF | 251.39 | 251.62 | 250.8 | 251.27 | 3751771.0 |
| 2025-12-05 10:00:00 | IWM | ETF | 251.28 | 252.66 | 251.18 | 252.03 | 4736483.0 |
| 2025-12-05 11:00:00 | IWM | ETF | 252.03 | 252.195 | 250.57 | 250.955 | 5148636.0 |
| 2025-12-05 12:00:00 | IWM | ETF | 250.95 | 251.25 | 250.275 | 251.23 | 3616146.0 |
| 2025-12-05 13:00:00 | IWM | ETF | 251.23 | 251.61 | 250.86 | 251.395 | 3426312.0 |
| 2025-12-05 14:00:00 | IWM | ETF | 251.39 | 251.46 | 250.85 | 251.455 | 2940973.0 |
| 2025-12-05 15:00:00 | IWM | ETF | 251.46 | 251.46 | 250.55 | 250.75 | 5181722.0 |
| 2025-12-05 16:00:00 | IWM | ETF | 250.77 | 251.1 | 250.64 | 250.91 | 1267466.0 |
| 2025-12-05 17:00:00 | IWM | ETF | 250.94 | 251.16 | 250.77 | 251.16 | 30107.0 |
| 2025-12-05 18:00:00 | IWM | ETF | 251.12 | 251.16 | 251.0 | 251.06 | 8088.0 |
| 2025-12-05 19:00:00 | IWM | ETF | 251.05 | 251.08 | 250.66 | 250.76 | 8986.0 |
| 2025-12-05 04:00:00 | DIA | ETF | 479.22 | 479.45 | 479.07 | 479.14 | 9430.0 |
| 2025-12-05 05:00:00 | DIA | ETF | 479.17 | 479.31 | 479.04 | 479.17 | 2751.0 |
> showing 50 of 27,054 rows — these rows as CSV