PREVIEW / etf_1hour / 2024-08-19
file: by_date/etf_1hour/2024/2024-08-19.parquet size: 554 KB rows: 20,986
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-19 04:00:00 | SPY | ETF | 554.15 | 554.24 | 553.24 | 554.23 | 31717.0 |
| 2024-08-19 05:00:00 | SPY | ETF | 553.97 | 554.26 | 553.73 | 554.14 | 7381.0 |
| 2024-08-19 06:00:00 | SPY | ETF | 554.17 | 554.55 | 554.1 | 554.1 | 122182.0 |
| 2024-08-19 07:00:00 | SPY | ETF | 554.05 | 554.68 | 554.04 | 554.53 | 103013.0 |
| 2024-08-19 08:00:00 | SPY | ETF | 554.56 | 554.98 | 553.74 | 554.85 | 197450.0 |
| 2024-08-19 09:00:00 | SPY | ETF | 554.85 | 555.5313 | 554.52 | 554.98 | 2985227.0 |
| 2024-08-19 10:00:00 | SPY | ETF | 554.98 | 556.6766 | 553.86 | 556.52 | 3386350.0 |
| 2024-08-19 11:00:00 | SPY | ETF | 556.53 | 556.96 | 555.78 | 556.1926 | 2758371.0 |
| 2024-08-19 12:00:00 | SPY | ETF | 556.21 | 557.47 | 555.93 | 557.31 | 1884461.0 |
| 2024-08-19 13:00:00 | SPY | ETF | 557.3 | 557.56 | 556.89 | 557.55 | 1784596.0 |
| 2024-08-19 14:00:00 | SPY | ETF | 557.54 | 558.48 | 557.355 | 558.1584 | 2964707.0 |
| 2024-08-19 15:00:00 | SPY | ETF | 558.16 | 559.58 | 557.81 | 559.56 | 9340962.0 |
| 2024-08-19 16:00:00 | SPY | ETF | 559.56 | 559.64 | 558.85 | 559.01 | 2473055.0 |
| 2024-08-19 17:00:00 | SPY | ETF | 559.06 | 559.61 | 559.06 | 559.61 | 480222.0 |
| 2024-08-19 18:00:00 | SPY | ETF | 559.26 | 559.61 | 559.26 | 559.46 | 74338.0 |
| 2024-08-19 19:00:00 | SPY | ETF | 559.37 | 559.44 | 559.24 | 559.31 | 35726.0 |
| 2024-08-19 04:00:00 | QQQ | ETF | 474.6 | 474.77 | 473.25 | 474.3 | 68600.0 |
| 2024-08-19 05:00:00 | QQQ | ETF | 474.31 | 474.63 | 473.7 | 474.58 | 14706.0 |
| 2024-08-19 06:00:00 | QQQ | ETF | 474.46 | 475.13 | 474.46 | 474.5 | 48851.0 |
| 2024-08-19 07:00:00 | QQQ | ETF | 474.55 | 475.45 | 474.49 | 475.3 | 104051.0 |
| 2024-08-19 08:00:00 | QQQ | ETF | 474.62 | 476.11 | 474.13 | 475.57 | 163467.0 |
| 2024-08-19 09:00:00 | QQQ | ETF | 475.63 | 475.97 | 473.71 | 474.74 | 2744784.0 |
| 2024-08-19 10:00:00 | QQQ | ETF | 474.77 | 476.52 | 473.37 | 476.35 | 2852097.0 |
| 2024-08-19 11:00:00 | QQQ | ETF | 476.3338 | 476.95 | 475.52 | 475.95 | 1522623.0 |
| 2024-08-19 12:00:00 | QQQ | ETF | 475.96 | 477.42 | 475.545 | 477.26 | 1345197.0 |
| 2024-08-19 13:00:00 | QQQ | ETF | 477.24 | 478.0 | 476.855 | 478.0 | 1142831.0 |
| 2024-08-19 14:00:00 | QQQ | ETF | 477.992 | 479.51 | 477.9198 | 479.13 | 1589534.0 |
| 2024-08-19 15:00:00 | QQQ | ETF | 479.11 | 481.31 | 478.79 | 481.26 | 3962389.0 |
| 2024-08-19 16:00:00 | QQQ | ETF | 481.27 | 481.55 | 480.64 | 481.12 | 1201871.0 |
| 2024-08-19 17:00:00 | QQQ | ETF | 481.13 | 481.27 | 481.08 | 481.24 | 320596.0 |
| 2024-08-19 18:00:00 | QQQ | ETF | 481.26 | 481.7 | 481.26 | 481.54 | 135488.0 |
| 2024-08-19 19:00:00 | QQQ | ETF | 481.52 | 481.65 | 481.23 | 481.24 | 55531.0 |
| 2024-08-19 04:00:00 | IWM | ETF | 212.97 | 213.16 | 212.59 | 213.1 | 13910.0 |
| 2024-08-19 05:00:00 | IWM | ETF | 213.1 | 213.1 | 212.61 | 212.65 | 8124.0 |
| 2024-08-19 06:00:00 | IWM | ETF | 212.65 | 212.91 | 212.45 | 212.5 | 7890.0 |
| 2024-08-19 07:00:00 | IWM | ETF | 212.54 | 212.75 | 212.31 | 212.43 | 112851.0 |
| 2024-08-19 08:00:00 | IWM | ETF | 212.54 | 213.0304 | 212.36 | 212.78 | 38768.0 |
| 2024-08-19 09:00:00 | IWM | ETF | 212.83 | 213.955 | 212.7601 | 213.025 | 1981572.0 |
| 2024-08-19 10:00:00 | IWM | ETF | 213.05 | 213.87 | 212.82 | 213.84 | 1674083.0 |
| 2024-08-19 11:00:00 | IWM | ETF | 213.84 | 214.34 | 213.64 | 213.86 | 1061057.0 |
| 2024-08-19 12:00:00 | IWM | ETF | 213.88 | 214.17 | 213.69 | 214.15 | 705178.0 |
| 2024-08-19 13:00:00 | IWM | ETF | 214.14 | 214.57 | 214.03 | 214.53 | 875959.0 |
| 2024-08-19 14:00:00 | IWM | ETF | 214.54 | 215.05 | 214.43 | 214.94 | 1436268.0 |
| 2024-08-19 15:00:00 | IWM | ETF | 214.93 | 215.21 | 214.42 | 215.19 | 2885478.0 |
| 2024-08-19 16:00:00 | IWM | ETF | 215.2 | 215.28 | 214.98 | 215.06 | 1530866.0 |
| 2024-08-19 17:00:00 | IWM | ETF | 215.08 | 215.2 | 214.95 | 215.2 | 32072.0 |
| 2024-08-19 18:00:00 | IWM | ETF | 215.15 | 215.47 | 215.15 | 215.32 | 37733.0 |
| 2024-08-19 19:00:00 | IWM | ETF | 215.34 | 215.44 | 215.19 | 215.3 | 39520.0 |
| 2024-08-19 04:00:00 | DIA | ETF | 406.62 | 406.95 | 406.62 | 406.95 | 300.0 |
| 2024-08-19 07:00:00 | DIA | ETF | 406.81 | 406.88 | 406.8 | 406.81 | 5922.0 |
> showing 50 of 20,986 rows — these rows as CSV