PREVIEW / etf_1hour / 2025-08-21
file: by_date/etf_1hour/2025/2025-08-21.parquet size: 657 KB rows: 25,142
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-08-21 04:00:00 | SPY | ETF | 638.01 | 638.36 | 637.06 | 637.07 | 13032.0 |
| 2025-08-21 05:00:00 | SPY | ETF | 637.1 | 637.52 | 636.94 | 637.14 | 6257.0 |
| 2025-08-21 06:00:00 | SPY | ETF | 637.03 | 637.19 | 636.26 | 637.03 | 25958.0 |
| 2025-08-21 07:00:00 | SPY | ETF | 637.08 | 637.79 | 636.26 | 636.55 | 125933.0 |
| 2025-08-21 08:00:00 | SPY | ETF | 637.05 | 638.63 | 635.26 | 635.47 | 526099.0 |
| 2025-08-21 09:00:00 | SPY | ETF | 635.45 | 636.51 | 634.31 | 635.13 | 5943065.0 |
| 2025-08-21 10:00:00 | SPY | ETF | 635.12 | 637.97 | 634.6 | 637.15 | 4914461.0 |
| 2025-08-21 11:00:00 | SPY | ETF | 637.16 | 637.59 | 635.3 | 635.58 | 4224634.0 |
| 2025-08-21 12:00:00 | SPY | ETF | 635.58 | 636.0 | 634.67 | 634.87 | 3710306.0 |
| 2025-08-21 13:00:00 | SPY | ETF | 634.87 | 636.2 | 633.81 | 635.9199 | 4130072.0 |
| 2025-08-21 14:00:00 | SPY | ETF | 635.91 | 636.27 | 635.09 | 636.12 | 3462181.0 |
| 2025-08-21 15:00:00 | SPY | ETF | 636.11 | 636.52 | 635.08 | 635.58 | 7436838.0 |
| 2025-08-21 16:00:00 | SPY | ETF | 635.58 | 635.95 | 635.37 | 635.8 | 3604848.0 |
| 2025-08-21 17:00:00 | SPY | ETF | 635.8 | 635.94 | 635.55 | 635.87 | 71783.0 |
| 2025-08-21 18:00:00 | SPY | ETF | 635.89 | 636.47 | 635.89 | 636.4696 | 75739.0 |
| 2025-08-21 19:00:00 | SPY | ETF | 636.31 | 636.57 | 636.18 | 636.57 | 34389.0 |
| 2025-08-21 04:00:00 | QQQ | ETF | 566.35 | 566.75 | 565.28 | 565.28 | 49611.0 |
| 2025-08-21 05:00:00 | QQQ | ETF | 565.32 | 566.0 | 565.17 | 565.42 | 21122.0 |
| 2025-08-21 06:00:00 | QQQ | ETF | 565.43 | 565.73 | 564.72 | 565.63 | 43704.0 |
| 2025-08-21 07:00:00 | QQQ | ETF | 565.59 | 566.11 | 564.49 | 564.84 | 103688.0 |
| 2025-08-21 08:00:00 | QQQ | ETF | 565.37 | 566.9 | 563.28 | 563.45 | 475948.0 |
| 2025-08-21 09:00:00 | QQQ | ETF | 563.44 | 565.08 | 562.32 | 562.59 | 5607636.0 |
| 2025-08-21 10:00:00 | QQQ | ETF | 562.57 | 566.49 | 561.85 | 565.2 | 6513981.0 |
| 2025-08-21 11:00:00 | QQQ | ETF | 565.23 | 565.63 | 562.718 | 563.03 | 4594050.0 |
| 2025-08-21 12:00:00 | QQQ | ETF | 563.02 | 563.25 | 561.73 | 561.98 | 3519288.0 |
| 2025-08-21 13:00:00 | QQQ | ETF | 561.99 | 563.475 | 560.98 | 563.2548 | 3860868.0 |
| 2025-08-21 14:00:00 | QQQ | ETF | 563.25 | 563.73 | 562.43 | 563.51 | 2626289.0 |
| 2025-08-21 15:00:00 | QQQ | ETF | 563.5 | 564.21 | 562.98 | 563.32 | 4376889.0 |
| 2025-08-21 16:00:00 | QQQ | ETF | 563.32 | 563.5 | 562.9 | 563.39 | 1622254.0 |
| 2025-08-21 17:00:00 | QQQ | ETF | 563.3231 | 563.36 | 563.09 | 563.32 | 39393.0 |
| 2025-08-21 18:00:00 | QQQ | ETF | 563.35 | 564.01 | 563.35 | 563.95 | 107242.0 |
| 2025-08-21 19:00:00 | QQQ | ETF | 563.8706 | 564.0684 | 563.6684 | 564.06 | 112594.0 |
| 2025-08-21 04:00:00 | IWM | ETF | 225.21 | 225.23 | 224.54 | 224.55 | 32998.0 |
| 2025-08-21 05:00:00 | IWM | ETF | 224.57 | 224.8 | 224.48 | 224.56 | 19731.0 |
| 2025-08-21 06:00:00 | IWM | ETF | 224.51 | 224.54 | 223.96 | 224.45 | 43124.0 |
| 2025-08-21 07:00:00 | IWM | ETF | 224.44 | 224.82 | 224.33 | 224.37 | 111347.0 |
| 2025-08-21 08:00:00 | IWM | ETF | 224.54 | 225.55 | 223.87 | 224.02 | 172650.0 |
| 2025-08-21 09:00:00 | IWM | ETF | 223.98 | 224.76 | 223.78 | 224.47 | 2792003.0 |
| 2025-08-21 10:00:00 | IWM | ETF | 224.46 | 225.82 | 224.292 | 225.46 | 2936387.0 |
| 2025-08-21 11:00:00 | IWM | ETF | 225.47 | 226.0 | 224.8 | 225.42 | 2350214.0 |
| 2025-08-21 12:00:00 | IWM | ETF | 225.42 | 225.565 | 224.95 | 225.07 | 1598451.0 |
| 2025-08-21 13:00:00 | IWM | ETF | 225.08 | 225.87 | 224.71 | 225.785 | 2145295.0 |
| 2025-08-21 14:00:00 | IWM | ETF | 225.78 | 226.175 | 225.59 | 226.15 | 2157439.0 |
| 2025-08-21 15:00:00 | IWM | ETF | 226.15 | 226.32 | 225.51 | 225.99 | 3881587.0 |
| 2025-08-21 16:00:00 | IWM | ETF | 225.97 | 226.25 | 225.9169 | 226.12 | 857942.0 |
| 2025-08-21 17:00:00 | IWM | ETF | 226.11 | 226.18 | 226.06 | 226.08 | 12675.0 |
| 2025-08-21 18:00:00 | IWM | ETF | 226.13 | 226.58 | 226.13 | 226.49 | 30422.0 |
| 2025-08-21 19:00:00 | IWM | ETF | 226.45 | 226.6 | 226.38 | 226.58 | 28889.0 |
| 2025-08-21 04:00:00 | DIA | ETF | 448.95 | 449.03 | 448.31 | 448.41 | 3804.0 |
| 2025-08-21 05:00:00 | DIA | ETF | 448.17 | 448.35 | 448.04 | 448.04 | 2800.0 |
> showing 50 of 25,142 rows — these rows as CSV