PREVIEW / etf_1hour / 2024-07-22
file: by_date/etf_1hour/2024/2024-07-22.parquet size: 563 KB rows: 21,106
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-07-22 04:00:00 | SPY | ETF | 550.51 | 551.34 | 550.5 | 550.92 | 97197.0 |
| 2024-07-22 05:00:00 | SPY | ETF | 550.84 | 551.56 | 550.82 | 551.56 | 59040.0 |
| 2024-07-22 06:00:00 | SPY | ETF | 551.57 | 552.09 | 551.35 | 552.09 | 34123.0 |
| 2024-07-22 07:00:00 | SPY | ETF | 552.09 | 552.23 | 551.4 | 552.07 | 360966.0 |
| 2024-07-22 08:00:00 | SPY | ETF | 552.0916 | 552.88 | 550.17 | 552.27 | 305144.0 |
| 2024-07-22 09:00:00 | SPY | ETF | 552.35 | 554.4101 | 552.23 | 552.6601 | 5232903.0 |
| 2024-07-22 10:00:00 | SPY | ETF | 552.67 | 554.43 | 551.34 | 553.77 | 4368107.0 |
| 2024-07-22 11:00:00 | SPY | ETF | 553.76 | 554.46 | 551.02 | 551.76 | 4334664.0 |
| 2024-07-22 12:00:00 | SPY | ETF | 551.74 | 553.78 | 551.2805 | 553.5314 | 2262492.0 |
| 2024-07-22 13:00:00 | SPY | ETF | 553.55 | 554.85 | 553.55 | 554.515 | 2262461.0 |
| 2024-07-22 14:00:00 | SPY | ETF | 554.5352 | 555.27 | 554.17 | 554.815 | 2417296.0 |
| 2024-07-22 15:00:00 | SPY | ETF | 554.82 | 555.14 | 554.155 | 554.65 | 5831376.0 |
| 2024-07-22 16:00:00 | SPY | ETF | 554.63 | 554.94 | 554.25 | 554.5 | 2458126.0 |
| 2024-07-22 17:00:00 | SPY | ETF | 554.51 | 554.65 | 554.0 | 554.16 | 445020.0 |
| 2024-07-22 18:00:00 | SPY | ETF | 554.21 | 554.85 | 554.21 | 554.65 | 87488.0 |
| 2024-07-22 19:00:00 | SPY | ETF | 554.68 | 554.68 | 554.2 | 554.28 | 37535.0 |
| 2024-07-22 04:00:00 | QQQ | ETF | 477.52 | 478.5 | 477.52 | 477.92 | 107526.0 |
| 2024-07-22 05:00:00 | QQQ | ETF | 477.85 | 478.76 | 477.78 | 478.73 | 41603.0 |
| 2024-07-22 06:00:00 | QQQ | ETF | 478.73 | 479.69 | 478.47 | 479.69 | 103164.0 |
| 2024-07-22 07:00:00 | QQQ | ETF | 479.68 | 479.88 | 479.15 | 479.85 | 231460.0 |
| 2024-07-22 08:00:00 | QQQ | ETF | 479.6703 | 480.65 | 476.21 | 480.2 | 392411.0 |
| 2024-07-22 09:00:00 | QQQ | ETF | 480.2 | 482.86 | 479.44 | 481.5369 | 4384585.0 |
| 2024-07-22 10:00:00 | QQQ | ETF | 481.6 | 482.69 | 479.73 | 481.175 | 4595997.0 |
| 2024-07-22 11:00:00 | QQQ | ETF | 481.2 | 482.21 | 477.76 | 479.065 | 4342298.0 |
| 2024-07-22 12:00:00 | QQQ | ETF | 479.08 | 481.64 | 478.38 | 481.36 | 1993671.0 |
| 2024-07-22 13:00:00 | QQQ | ETF | 481.375 | 482.65 | 481.27 | 482.27 | 1990215.0 |
| 2024-07-22 14:00:00 | QQQ | ETF | 482.28 | 483.35 | 482.11 | 482.545 | 1905093.0 |
| 2024-07-22 15:00:00 | QQQ | ETF | 482.55 | 483.105 | 481.81 | 482.33 | 4616132.0 |
| 2024-07-22 16:00:00 | QQQ | ETF | 482.31 | 482.67 | 478.5 | 481.89 | 1654047.0 |
| 2024-07-22 17:00:00 | QQQ | ETF | 481.86 | 482.32 | 481.5 | 481.7 | 63616.0 |
| 2024-07-22 18:00:00 | QQQ | ETF | 481.74 | 482.29 | 481.73 | 482.03 | 59076.0 |
| 2024-07-22 19:00:00 | QQQ | ETF | 482.03 | 482.09 | 481.24 | 481.2832 | 71539.0 |
| 2024-07-22 04:00:00 | IWM | ETF | 216.78 | 217.47 | 216.72 | 217.34 | 80581.0 |
| 2024-07-22 05:00:00 | IWM | ETF | 217.28 | 217.34 | 217.0 | 217.21 | 19895.0 |
| 2024-07-22 06:00:00 | IWM | ETF | 217.2 | 217.74 | 217.12 | 217.71 | 55526.0 |
| 2024-07-22 07:00:00 | IWM | ETF | 217.67 | 218.08 | 217.52 | 217.9 | 197163.0 |
| 2024-07-22 08:00:00 | IWM | ETF | 217.84 | 218.12 | 216.38 | 217.48 | 293397.0 |
| 2024-07-22 09:00:00 | IWM | ETF | 217.49 | 218.61 | 215.845 | 215.88 | 5168488.0 |
| 2024-07-22 10:00:00 | IWM | ETF | 215.9 | 217.79 | 215.38 | 217.7687 | 5226802.0 |
| 2024-07-22 11:00:00 | IWM | ETF | 217.78 | 218.09 | 217.12 | 217.6 | 3105299.0 |
| 2024-07-22 12:00:00 | IWM | ETF | 217.6 | 218.38 | 217.3 | 218.21 | 1430341.0 |
| 2024-07-22 13:00:00 | IWM | ETF | 218.24 | 219.11 | 218.2 | 218.94 | 1709664.0 |
| 2024-07-22 14:00:00 | IWM | ETF | 218.95 | 219.76 | 218.49 | 219.64 | 2197249.0 |
| 2024-07-22 15:00:00 | IWM | ETF | 219.64 | 220.6499 | 219.21 | 220.25 | 6583766.0 |
| 2024-07-22 16:00:00 | IWM | ETF | 220.29 | 220.48 | 220.21 | 220.44 | 1315679.0 |
| 2024-07-22 17:00:00 | IWM | ETF | 220.44 | 220.52 | 220.33 | 220.47 | 42734.0 |
| 2024-07-22 18:00:00 | IWM | ETF | 220.43 | 220.9 | 220.29 | 220.86 | 61396.0 |
| 2024-07-22 19:00:00 | IWM | ETF | 220.83 | 220.86 | 220.58 | 220.61 | 61576.0 |
| 2024-07-22 04:00:00 | DIA | ETF | 403.51 | 403.51 | 403.5 | 403.51 | 300.0 |
| 2024-07-22 05:00:00 | DIA | ETF | 403.46 | 403.49 | 403.37 | 403.49 | 1322.0 |
> showing 50 of 21,106 rows — these rows as CSV