PREVIEW / etf_1hour / 2025-11-11
file: by_date/etf_1hour/2025/2025-11-11.parquet size: 690 KB rows: 26,617
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-11-11 04:00:00 | SPY | ETF | 680.88 | 680.88 | 679.64 | 679.75 | 41856.0 |
| 2025-11-11 05:00:00 | SPY | ETF | 679.69 | 680.19 | 679.62 | 680.0 | 26231.0 |
| 2025-11-11 06:00:00 | SPY | ETF | 680.05 | 680.41 | 679.88 | 679.98 | 31617.0 |
| 2025-11-11 07:00:00 | SPY | ETF | 680.12 | 680.39 | 679.5 | 679.69 | 78537.0 |
| 2025-11-11 08:00:00 | SPY | ETF | 680.1384 | 681.26 | 679.28 | 679.83 | 350490.0 |
| 2025-11-11 09:00:00 | SPY | ETF | 679.83 | 681.62 | 679.42 | 680.7 | 4982610.0 |
| 2025-11-11 10:00:00 | SPY | ETF | 680.68 | 680.69 | 678.73 | 679.14 | 6062090.0 |
| 2025-11-11 11:00:00 | SPY | ETF | 679.14 | 680.74 | 678.76 | 679.76 | 4763288.0 |
| 2025-11-11 12:00:00 | SPY | ETF | 679.74 | 682.25 | 679.69 | 682.085 | 4501796.0 |
| 2025-11-11 13:00:00 | SPY | ETF | 682.07 | 683.31 | 682.03 | 683.205 | 5640573.0 |
| 2025-11-11 14:00:00 | SPY | ETF | 683.2 | 683.42 | 682.45 | 683.14 | 4472015.0 |
| 2025-11-11 15:00:00 | SPY | ETF | 683.15 | 683.57 | 682.29 | 682.9 | 11636270.0 |
| 2025-11-11 16:00:00 | SPY | ETF | 682.88 | 683.58 | 682.54 | 683.02 | 2806627.0 |
| 2025-11-11 17:00:00 | SPY | ETF | 683.01 | 683.07 | 682.9 | 683.0 | 98868.0 |
| 2025-11-11 18:00:00 | SPY | ETF | 683.1 | 683.18 | 682.43 | 682.75 | 112307.0 |
| 2025-11-11 19:00:00 | SPY | ETF | 682.75 | 683.51 | 682.71 | 683.32 | 55447.0 |
| 2025-11-11 04:00:00 | QQQ | ETF | 622.38 | 622.38 | 620.38 | 620.52 | 123420.0 |
| 2025-11-11 05:00:00 | QQQ | ETF | 620.53 | 621.23 | 620.35 | 620.97 | 72177.0 |
| 2025-11-11 06:00:00 | QQQ | ETF | 621.01 | 621.57 | 620.66 | 621.02 | 98036.0 |
| 2025-11-11 07:00:00 | QQQ | ETF | 621.0 | 621.4 | 620.05 | 620.31 | 234443.0 |
| 2025-11-11 08:00:00 | QQQ | ETF | 620.26 | 623.697 | 619.82 | 620.37 | 708656.0 |
| 2025-11-11 09:00:00 | QQQ | ETF | 620.43 | 621.57 | 619.48 | 621.08 | 5074901.0 |
| 2025-11-11 10:00:00 | QQQ | ETF | 621.06 | 621.12 | 617.69 | 618.33 | 5550318.0 |
| 2025-11-11 11:00:00 | QQQ | ETF | 618.32 | 620.23 | 617.52 | 618.26 | 4233958.0 |
| 2025-11-11 12:00:00 | QQQ | ETF | 618.26 | 621.18 | 618.19 | 620.87 | 3530534.0 |
| 2025-11-11 13:00:00 | QQQ | ETF | 620.85 | 622.72 | 620.6 | 622.59 | 4432683.0 |
| 2025-11-11 14:00:00 | QQQ | ETF | 622.59 | 622.6 | 621.4 | 621.94 | 3278090.0 |
| 2025-11-11 15:00:00 | QQQ | ETF | 621.955 | 622.6 | 620.89 | 621.52 | 6316003.0 |
| 2025-11-11 16:00:00 | QQQ | ETF | 621.53 | 622.51 | 621.04 | 621.79 | 915623.0 |
| 2025-11-11 17:00:00 | QQQ | ETF | 621.88 | 622.25 | 621.84 | 622.1 | 35201.0 |
| 2025-11-11 18:00:00 | QQQ | ETF | 622.08 | 622.16 | 621.16 | 621.7 | 87319.0 |
| 2025-11-11 19:00:00 | QQQ | ETF | 621.79 | 622.82 | 621.66 | 622.47 | 98964.0 |
| 2025-11-11 04:00:00 | IWM | ETF | 243.43 | 243.66 | 243.41 | 243.46 | 47903.0 |
| 2025-11-11 05:00:00 | IWM | ETF | 243.47 | 243.66 | 243.47 | 243.55 | 3571.0 |
| 2025-11-11 06:00:00 | IWM | ETF | 243.75 | 243.81 | 243.68 | 243.76 | 5540.0 |
| 2025-11-11 07:00:00 | IWM | ETF | 243.73 | 243.85 | 243.4 | 243.45 | 84398.0 |
| 2025-11-11 08:00:00 | IWM | ETF | 243.7499 | 244.06 | 243.0 | 243.54 | 163806.0 |
| 2025-11-11 09:00:00 | IWM | ETF | 243.51 | 244.155 | 242.52 | 243.94 | 3814303.0 |
| 2025-11-11 10:00:00 | IWM | ETF | 243.87 | 244.04 | 242.78 | 242.99 | 4010690.0 |
| 2025-11-11 11:00:00 | IWM | ETF | 243.0 | 243.84 | 242.73 | 243.56 | 2560648.0 |
| 2025-11-11 12:00:00 | IWM | ETF | 243.54 | 244.38 | 243.395 | 244.29 | 2164784.0 |
| 2025-11-11 13:00:00 | IWM | ETF | 244.28 | 244.74 | 244.0801 | 244.66 | 2409382.0 |
| 2025-11-11 14:00:00 | IWM | ETF | 244.66 | 244.67 | 244.15 | 244.3 | 1670067.0 |
| 2025-11-11 15:00:00 | IWM | ETF | 244.31 | 244.535 | 243.77 | 244.25 | 4650199.0 |
| 2025-11-11 16:00:00 | IWM | ETF | 244.24 | 244.31 | 243.95 | 243.97 | 516560.0 |
| 2025-11-11 17:00:00 | IWM | ETF | 244.04 | 244.14 | 243.77 | 244.03 | 21123.0 |
| 2025-11-11 18:00:00 | IWM | ETF | 243.93 | 244.09 | 243.86 | 243.96 | 31261.0 |
| 2025-11-11 19:00:00 | IWM | ETF | 243.9 | 244.1992 | 243.9 | 243.98 | 14624.0 |
| 2025-11-11 04:00:00 | DIA | ETF | 473.37 | 473.58 | 473.33 | 473.58 | 1146.0 |
| 2025-11-11 05:00:00 | DIA | ETF | 473.63 | 473.75 | 473.63 | 473.75 | 445.0 |
> showing 50 of 26,617 rows — these rows as CSV