PREVIEW / etf_1hour / 2025-12-01
file: by_date/etf_1hour/2025/2025-12-01.parquet size: 728 KB rows: 28,228
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-01 04:00:00 | SPY | ETF | 679.9 | 680.41 | 678.94 | 679.08 | 134378.0 |
| 2025-12-01 05:00:00 | SPY | ETF | 679.19 | 679.99 | 679.15 | 679.54 | 12871.0 |
| 2025-12-01 06:00:00 | SPY | ETF | 679.36 | 679.6 | 679.05 | 679.4 | 43843.0 |
| 2025-12-01 07:00:00 | SPY | ETF | 679.41 | 679.57 | 677.96 | 678.33 | 209719.0 |
| 2025-12-01 08:00:00 | SPY | ETF | 678.35 | 680.37 | 677.71 | 679.16 | 383898.0 |
| 2025-12-01 09:00:00 | SPY | ETF | 679.1496 | 681.86 | 678.65 | 681.45 | 6609346.0 |
| 2025-12-01 10:00:00 | SPY | ETF | 681.455 | 681.83 | 678.84 | 681.64 | 7137105.0 |
| 2025-12-01 11:00:00 | SPY | ETF | 681.65 | 682.44 | 680.12 | 681.925 | 3753020.0 |
| 2025-12-01 12:00:00 | SPY | ETF | 681.96 | 682.79 | 681.295 | 682.03 | 2880943.0 |
| 2025-12-01 13:00:00 | SPY | ETF | 682.04 | 682.99 | 681.975 | 682.8205 | 2939843.0 |
| 2025-12-01 14:00:00 | SPY | ETF | 682.82 | 682.8493 | 679.82 | 680.22 | 6181423.0 |
| 2025-12-01 15:00:00 | SPY | ETF | 680.2 | 681.07 | 679.375 | 680.27 | 14241241.0 |
| 2025-12-01 16:00:00 | SPY | ETF | 680.28 | 680.4 | 679.8986 | 680.09 | 2632408.0 |
| 2025-12-01 17:00:00 | SPY | ETF | 680.17 | 680.42 | 680.03 | 680.34 | 71392.0 |
| 2025-12-01 18:00:00 | SPY | ETF | 680.34 | 680.54 | 679.655 | 679.98 | 87483.0 |
| 2025-12-01 19:00:00 | SPY | ETF | 679.88 | 680.3 | 679.66 | 680.07 | 34071.0 |
| 2025-12-01 04:00:00 | QQQ | ETF | 615.85 | 615.85 | 614.06 | 614.29 | 147592.0 |
| 2025-12-01 05:00:00 | QQQ | ETF | 614.28 | 615.5 | 614.28 | 615.04 | 82283.0 |
| 2025-12-01 06:00:00 | QQQ | ETF | 615.0 | 615.17 | 614.26 | 614.63 | 93866.0 |
| 2025-12-01 07:00:00 | QQQ | ETF | 614.64 | 614.83 | 612.6 | 612.91 | 380659.0 |
| 2025-12-01 08:00:00 | QQQ | ETF | 614.81 | 618.786 | 612.13 | 613.9 | 772759.0 |
| 2025-12-01 09:00:00 | QQQ | ETF | 613.87 | 616.63 | 612.52 | 616.28 | 6643232.0 |
| 2025-12-01 10:00:00 | QQQ | ETF | 616.28 | 617.6087 | 613.9488 | 617.4382 | 5975429.0 |
| 2025-12-01 11:00:00 | QQQ | ETF | 617.43 | 618.36 | 615.28 | 617.96 | 3571090.0 |
| 2025-12-01 12:00:00 | QQQ | ETF | 617.99 | 619.4401 | 617.48 | 618.35 | 2898736.0 |
| 2025-12-01 13:00:00 | QQQ | ETF | 618.35 | 619.36 | 618.27 | 619.215 | 2197174.0 |
| 2025-12-01 14:00:00 | QQQ | ETF | 619.21 | 619.245 | 616.062 | 616.51 | 4019752.0 |
| 2025-12-01 15:00:00 | QQQ | ETF | 616.5141 | 617.66 | 616.3 | 617.2 | 5744416.0 |
| 2025-12-01 16:00:00 | QQQ | ETF | 617.2 | 617.41 | 616.75 | 617.16 | 883174.0 |
| 2025-12-01 17:00:00 | QQQ | ETF | 617.1 | 617.4 | 617.1 | 617.39 | 17977.0 |
| 2025-12-01 18:00:00 | QQQ | ETF | 617.44 | 617.7 | 616.67 | 617.09 | 90863.0 |
| 2025-12-01 19:00:00 | QQQ | ETF | 617.08 | 617.54 | 616.77 | 617.38 | 36785.0 |
| 2025-12-01 04:00:00 | IWM | ETF | 246.75 | 247.5 | 246.64 | 246.64 | 21524.0 |
| 2025-12-01 05:00:00 | IWM | ETF | 246.69 | 246.83 | 246.57 | 246.57 | 19347.0 |
| 2025-12-01 06:00:00 | IWM | ETF | 246.51 | 246.55 | 246.19 | 246.45 | 29334.0 |
| 2025-12-01 07:00:00 | IWM | ETF | 246.39 | 246.6 | 245.81 | 245.89 | 117680.0 |
| 2025-12-01 08:00:00 | IWM | ETF | 246.56 | 246.87 | 245.53 | 246.15 | 213401.0 |
| 2025-12-01 09:00:00 | IWM | ETF | 246.16 | 247.685 | 245.41 | 247.33 | 4327080.0 |
| 2025-12-01 10:00:00 | IWM | ETF | 247.37 | 247.46 | 245.87 | 247.0 | 4014003.0 |
| 2025-12-01 11:00:00 | IWM | ETF | 247.0 | 247.24 | 246.27 | 246.82 | 3199763.0 |
| 2025-12-01 12:00:00 | IWM | ETF | 246.82 | 247.33 | 246.66 | 247.01 | 2607412.0 |
| 2025-12-01 13:00:00 | IWM | ETF | 247.02 | 247.435 | 247.0 | 247.3 | 2296995.0 |
| 2025-12-01 14:00:00 | IWM | ETF | 247.29 | 247.29 | 245.72 | 245.88 | 4181620.0 |
| 2025-12-01 15:00:00 | IWM | ETF | 245.87 | 246.175 | 245.335 | 245.65 | 6781224.0 |
| 2025-12-01 16:00:00 | IWM | ETF | 245.66 | 246.52 | 245.4918 | 245.93 | 1381945.0 |
| 2025-12-01 17:00:00 | IWM | ETF | 245.92 | 246.13 | 245.84 | 245.9925 | 11909.0 |
| 2025-12-01 18:00:00 | IWM | ETF | 246.03 | 246.27 | 245.88 | 246.06 | 37494.0 |
| 2025-12-01 19:00:00 | IWM | ETF | 246.01 | 246.2 | 245.98 | 246.03 | 57008.0 |
| 2025-12-01 04:00:00 | DIA | ETF | 475.6 | 475.6 | 474.83 | 474.83 | 3220.0 |
| 2025-12-01 05:00:00 | DIA | ETF | 474.84 | 475.19 | 474.84 | 475.01 | 1030.0 |
> showing 50 of 28,228 rows — these rows as CSV