PREVIEW / etf_1hour / 2025-10-30
file: by_date/etf_1hour/2025/2025-10-30.parquet size: 710 KB rows: 27,923
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-10-30 04:00:00 | SPY | ETF | 687.35 | 687.47 | 686.32 | 686.8 | 56242.0 |
| 2025-10-30 05:00:00 | SPY | ETF | 686.95 | 687.18 | 685.22 | 685.56 | 23321.0 |
| 2025-10-30 06:00:00 | SPY | ETF | 685.5 | 686.57 | 685.31 | 686.4 | 58666.0 |
| 2025-10-30 07:00:00 | SPY | ETF | 686.38 | 687.5 | 686.3 | 686.76 | 65705.0 |
| 2025-10-30 08:00:00 | SPY | ETF | 686.34 | 689.0 | 683.69 | 683.76 | 606724.0 |
| 2025-10-30 09:00:00 | SPY | ETF | 683.7 | 685.64 | 681.39 | 685.005 | 8779248.0 |
| 2025-10-30 10:00:00 | SPY | ETF | 685.005 | 685.94 | 683.25 | 684.41 | 7661057.0 |
| 2025-10-30 11:00:00 | SPY | ETF | 684.41 | 685.53 | 683.01 | 683.38 | 4281752.0 |
| 2025-10-30 12:00:00 | SPY | ETF | 683.4 | 685.15 | 683.22 | 684.44 | 3597495.0 |
| 2025-10-30 13:00:00 | SPY | ETF | 684.42 | 684.64 | 683.07 | 684.3984 | 3466225.0 |
| 2025-10-30 14:00:00 | SPY | ETF | 684.395 | 684.395 | 682.165 | 682.37 | 5391541.0 |
| 2025-10-30 15:00:00 | SPY | ETF | 682.36 | 682.43 | 679.86 | 679.95 | 12981687.0 |
| 2025-10-30 16:00:00 | SPY | ETF | 679.96 | 684.2 | 679.72 | 683.98 | 4242423.0 |
| 2025-10-30 17:00:00 | SPY | ETF | 684.0 | 684.2 | 683.85 | 684.14 | 249998.0 |
| 2025-10-30 18:00:00 | SPY | ETF | 684.11 | 684.46 | 683.74 | 683.92 | 111086.0 |
| 2025-10-30 19:00:00 | SPY | ETF | 683.89 | 684.49 | 683.4304 | 684.48 | 70349.0 |
| 2025-10-30 04:00:00 | QQQ | ETF | 635.54 | 638.41 | 634.85 | 635.64 | 116592.0 |
| 2025-10-30 05:00:00 | QQQ | ETF | 635.79 | 636.18 | 633.88 | 634.13 | 126702.0 |
| 2025-10-30 06:00:00 | QQQ | ETF | 634.17 | 635.05 | 633.92 | 634.78 | 136460.0 |
| 2025-10-30 07:00:00 | QQQ | ETF | 634.74 | 636.07 | 634.58 | 635.44 | 138778.0 |
| 2025-10-30 08:00:00 | QQQ | ETF | 635.44 | 638.11 | 631.22 | 631.221 | 1123813.0 |
| 2025-10-30 09:00:00 | QQQ | ETF | 631.24 | 632.74 | 627.76 | 632.19 | 7795728.0 |
| 2025-10-30 10:00:00 | QQQ | ETF | 632.19 | 633.5 | 628.66 | 629.5614 | 6630780.0 |
| 2025-10-30 11:00:00 | QQQ | ETF | 629.57 | 631.01 | 628.37 | 628.96 | 3563969.0 |
| 2025-10-30 12:00:00 | QQQ | ETF | 628.98 | 631.5 | 628.83 | 630.96 | 2864419.0 |
| 2025-10-30 13:00:00 | QQQ | ETF | 630.96 | 631.0 | 629.17 | 630.8185 | 2345946.0 |
| 2025-10-30 14:00:00 | QQQ | ETF | 630.8 | 630.8 | 628.6 | 628.89 | 2680194.0 |
| 2025-10-30 15:00:00 | QQQ | ETF | 628.88 | 629.0001 | 625.99 | 626.01 | 7001526.0 |
| 2025-10-30 16:00:00 | QQQ | ETF | 626.01 | 632.8 | 625.61 | 632.8 | 3237884.0 |
| 2025-10-30 17:00:00 | QQQ | ETF | 632.8 | 633.5 | 632.65 | 632.8 | 327326.0 |
| 2025-10-30 18:00:00 | QQQ | ETF | 632.8 | 633.5 | 632.42 | 632.64 | 182146.0 |
| 2025-10-30 19:00:00 | QQQ | ETF | 632.75 | 633.36 | 632.25 | 633.28 | 123627.0 |
| 2025-10-30 04:00:00 | IWM | ETF | 248.05 | 248.05 | 247.23 | 247.53 | 138895.0 |
| 2025-10-30 05:00:00 | IWM | ETF | 247.6 | 247.69 | 246.78 | 246.89 | 79394.0 |
| 2025-10-30 06:00:00 | IWM | ETF | 246.91 | 247.15 | 246.67 | 246.93 | 65390.0 |
| 2025-10-30 07:00:00 | IWM | ETF | 246.92 | 247.73 | 246.81 | 246.95 | 141810.0 |
| 2025-10-30 08:00:00 | IWM | ETF | 246.93 | 248.6 | 245.04 | 245.1 | 470593.0 |
| 2025-10-30 09:00:00 | IWM | ETF | 245.18 | 248.14 | 244.78 | 247.27 | 5547747.0 |
| 2025-10-30 10:00:00 | IWM | ETF | 247.28 | 247.96 | 246.63 | 247.46 | 5242377.0 |
| 2025-10-30 11:00:00 | IWM | ETF | 247.46 | 247.98 | 246.935 | 246.97 | 2564271.0 |
| 2025-10-30 12:00:00 | IWM | ETF | 246.96 | 247.64 | 246.57 | 247.03 | 2160986.0 |
| 2025-10-30 13:00:00 | IWM | ETF | 247.01 | 247.02 | 246.19 | 246.63 | 3230044.0 |
| 2025-10-30 14:00:00 | IWM | ETF | 246.62 | 246.67 | 245.53 | 245.62 | 3506801.0 |
| 2025-10-30 15:00:00 | IWM | ETF | 245.63 | 245.7 | 244.63 | 244.84 | 8052802.0 |
| 2025-10-30 16:00:00 | IWM | ETF | 244.86 | 245.2 | 244.08 | 244.61 | 971319.0 |
| 2025-10-30 17:00:00 | IWM | ETF | 244.8 | 244.86 | 244.43 | 244.82 | 73108.0 |
| 2025-10-30 18:00:00 | IWM | ETF | 244.82 | 244.97 | 244.55 | 244.97 | 53120.0 |
| 2025-10-30 19:00:00 | IWM | ETF | 244.89 | 245.12 | 244.64 | 245.11 | 19008.0 |
| 2025-10-30 04:00:00 | DIA | ETF | 475.41 | 475.45 | 475.35 | 475.35 | 958.0 |
| 2025-10-30 05:00:00 | DIA | ETF | 474.75 | 474.75 | 474.74 | 474.75 | 1800.0 |
> showing 50 of 27,923 rows — these rows as CSV