PREVIEW / etf_1hour / 2024-08-22
file: by_date/etf_1hour/2024/2024-08-22.parquet size: 542 KB rows: 20,279
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-22 04:00:00 | SPY | ETF | 561.01 | 561.35 | 560.97 | 561.27 | 7603.0 |
| 2024-08-22 05:00:00 | SPY | ETF | 561.29 | 561.64 | 561.11 | 561.11 | 9325.0 |
| 2024-08-22 06:00:00 | SPY | ETF | 561.14 | 561.75 | 561.14 | 561.75 | 10238.0 |
| 2024-08-22 07:00:00 | SPY | ETF | 561.72 | 562.2 | 561.65 | 562.05 | 142931.0 |
| 2024-08-22 08:00:00 | SPY | ETF | 561.75 | 562.38 | 560.27 | 562.2 | 223791.0 |
| 2024-08-22 09:00:00 | SPY | ETF | 562.23 | 563.18 | 561.63 | 562.3599 | 3640362.0 |
| 2024-08-22 10:00:00 | SPY | ETF | 562.38 | 562.475 | 560.16 | 560.53 | 3767718.0 |
| 2024-08-22 11:00:00 | SPY | ETF | 560.53 | 561.2499 | 557.06 | 557.7401 | 3701377.0 |
| 2024-08-22 12:00:00 | SPY | ETF | 557.73 | 560.07 | 557.261 | 557.58 | 3628363.0 |
| 2024-08-22 13:00:00 | SPY | ETF | 557.5894 | 558.42 | 555.24 | 555.52 | 4195219.0 |
| 2024-08-22 14:00:00 | SPY | ETF | 555.53 | 557.3 | 555.265 | 556.0 | 3033474.0 |
| 2024-08-22 15:00:00 | SPY | ETF | 556.03 | 557.18 | 554.98 | 556.21 | 9319768.0 |
| 2024-08-22 16:00:00 | SPY | ETF | 556.2 | 556.89 | 555.74 | 556.59 | 3304986.0 |
| 2024-08-22 17:00:00 | SPY | ETF | 556.64 | 556.89 | 556.22 | 556.79 | 104188.0 |
| 2024-08-22 18:00:00 | SPY | ETF | 556.67 | 557.09 | 556.66 | 557.06 | 76448.0 |
| 2024-08-22 19:00:00 | SPY | ETF | 557.13 | 557.17 | 556.86 | 557.17 | 16244.0 |
| 2024-08-22 04:00:00 | QQQ | ETF | 482.83 | 483.03 | 482.45 | 482.9 | 16517.0 |
| 2024-08-22 05:00:00 | QQQ | ETF | 483.05 | 483.3 | 482.86 | 482.86 | 24686.0 |
| 2024-08-22 06:00:00 | QQQ | ETF | 483.09 | 483.91 | 483.09 | 483.89 | 18360.0 |
| 2024-08-22 07:00:00 | QQQ | ETF | 483.85 | 484.59 | 483.76 | 484.36 | 109451.0 |
| 2024-08-22 08:00:00 | QQQ | ETF | 484.02 | 484.77 | 482.35 | 484.48 | 289074.0 |
| 2024-08-22 09:00:00 | QQQ | ETF | 484.58 | 485.54 | 483.59 | 484.38 | 2459231.0 |
| 2024-08-22 10:00:00 | QQQ | ETF | 484.44 | 484.55 | 481.44 | 481.99 | 3475287.0 |
| 2024-08-22 11:00:00 | QQQ | ETF | 482.0 | 482.8774 | 476.8 | 477.96 | 4678682.0 |
| 2024-08-22 12:00:00 | QQQ | ETF | 477.95 | 480.829 | 477.49 | 477.85 | 3677954.0 |
| 2024-08-22 13:00:00 | QQQ | ETF | 477.865 | 478.62 | 474.94 | 475.4499 | 3842248.0 |
| 2024-08-22 14:00:00 | QQQ | ETF | 475.45 | 477.06 | 474.865 | 475.53 | 2722323.0 |
| 2024-08-22 15:00:00 | QQQ | ETF | 475.5 | 476.86 | 473.81 | 474.83 | 6641294.0 |
| 2024-08-22 16:00:00 | QQQ | ETF | 474.86 | 475.91 | 474.43 | 475.5 | 2188719.0 |
| 2024-08-22 17:00:00 | QQQ | ETF | 475.6 | 476.08 | 475.54 | 476.08 | 61282.0 |
| 2024-08-22 18:00:00 | QQQ | ETF | 475.86 | 476.07 | 475.57 | 475.97 | 87031.0 |
| 2024-08-22 19:00:00 | QQQ | ETF | 476.01 | 476.14 | 475.72 | 476.14 | 50429.0 |
| 2024-08-22 04:00:00 | IWM | ETF | 215.29 | 216.13 | 215.29 | 215.99 | 6484.0 |
| 2024-08-22 05:00:00 | IWM | ETF | 215.9 | 216.02 | 215.28 | 215.29 | 6570.0 |
| 2024-08-22 06:00:00 | IWM | ETF | 215.23 | 215.49 | 215.03 | 215.46 | 15366.0 |
| 2024-08-22 07:00:00 | IWM | ETF | 215.47 | 215.97 | 215.36 | 215.89 | 57892.0 |
| 2024-08-22 08:00:00 | IWM | ETF | 215.4781 | 216.1696 | 215.24 | 215.59 | 163621.0 |
| 2024-08-22 09:00:00 | IWM | ETF | 215.64 | 216.37 | 214.54 | 214.93 | 2364189.0 |
| 2024-08-22 10:00:00 | IWM | ETF | 214.94 | 214.995 | 214.04 | 214.8 | 1628774.0 |
| 2024-08-22 11:00:00 | IWM | ETF | 214.8 | 215.11 | 213.79 | 213.99 | 1395635.0 |
| 2024-08-22 12:00:00 | IWM | ETF | 214.02 | 215.13 | 213.9801 | 214.13 | 1354396.0 |
| 2024-08-22 13:00:00 | IWM | ETF | 214.12 | 214.41 | 213.45 | 213.52 | 1711203.0 |
| 2024-08-22 14:00:00 | IWM | ETF | 213.51 | 214.47 | 213.37 | 214.0501 | 1203309.0 |
| 2024-08-22 15:00:00 | IWM | ETF | 214.04 | 214.66 | 213.13 | 213.59 | 3057478.0 |
| 2024-08-22 16:00:00 | IWM | ETF | 213.59 | 213.97 | 213.43 | 213.79 | 825888.0 |
| 2024-08-22 17:00:00 | IWM | ETF | 213.72 | 214.13 | 213.68 | 213.9699 | 37118.0 |
| 2024-08-22 18:00:00 | IWM | ETF | 213.88 | 214.1 | 213.78 | 214.02 | 26801.0 |
| 2024-08-22 19:00:00 | IWM | ETF | 214.04 | 214.04 | 213.9 | 214.0 | 7196.0 |
| 2024-08-22 04:00:00 | DIA | ETF | 409.53 | 409.53 | 409.53 | 409.53 | 125.0 |
| 2024-08-22 07:00:00 | DIA | ETF | 409.54 | 409.54 | 409.3 | 409.3 | 622.0 |
> showing 50 of 20,279 rows — these rows as CSV