PREVIEW / etf_1hour / 2024-07-18
file: by_date/etf_1hour/2024/2024-07-18.parquet size: 561 KB rows: 20,854
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-18 04:00:00 | SPY | ETF | 558.27 | 558.85 | 557.89 | 558.84 | 16609.0 |
| 2024-07-18 05:00:00 | SPY | ETF | 558.82 | 559.0 | 557.82 | 557.93 | 11855.0 |
| 2024-07-18 06:00:00 | SPY | ETF | 558.02 | 558.05 | 557.16 | 557.99 | 44528.0 |
| 2024-07-18 07:00:00 | SPY | ETF | 557.92 | 558.289 | 557.71 | 558.27 | 243412.0 |
| 2024-07-18 08:00:00 | SPY | ETF | 557.75 | 559.5 | 557.61 | 558.8 | 221704.0 |
| 2024-07-18 09:00:00 | SPY | ETF | 558.79 | 559.1 | 557.705 | 558.845 | 3695309.0 |
| 2024-07-18 10:00:00 | SPY | ETF | 558.835 | 559.52 | 555.639 | 556.87 | 5884215.0 |
| 2024-07-18 11:00:00 | SPY | ETF | 556.84 | 557.14 | 552.75 | 552.94 | 5685040.0 |
| 2024-07-18 12:00:00 | SPY | ETF | 552.93 | 554.31 | 552.38 | 554.29 | 3649428.0 |
| 2024-07-18 13:00:00 | SPY | ETF | 554.295 | 554.945 | 553.46 | 553.65 | 2224814.0 |
| 2024-07-18 14:00:00 | SPY | ETF | 553.69 | 553.74 | 551.426 | 552.38 | 4796477.0 |
| 2024-07-18 15:00:00 | SPY | ETF | 552.37 | 553.85 | 550.43 | 552.66 | 12555466.0 |
| 2024-07-18 16:00:00 | SPY | ETF | 552.66 | 553.6 | 552.48 | 553.46 | 3531925.0 |
| 2024-07-18 17:00:00 | SPY | ETF | 553.31 | 553.75 | 552.66 | 553.74 | 66860.0 |
| 2024-07-18 18:00:00 | SPY | ETF | 553.69 | 553.92 | 553.43 | 553.8 | 166370.0 |
| 2024-07-18 19:00:00 | SPY | ETF | 553.77 | 553.86 | 553.5 | 553.6 | 40389.0 |
| 2024-07-18 04:00:00 | QQQ | ETF | 483.55 | 485.14 | 483.55 | 485.14 | 70150.0 |
| 2024-07-18 05:00:00 | QQQ | ETF | 485.15 | 485.19 | 483.6 | 483.64 | 109561.0 |
| 2024-07-18 06:00:00 | QQQ | ETF | 483.42 | 484.0 | 482.57 | 483.92 | 92315.0 |
| 2024-07-18 07:00:00 | QQQ | ETF | 483.84 | 484.29 | 483.56 | 484.22 | 175439.0 |
| 2024-07-18 08:00:00 | QQQ | ETF | 483.83 | 485.9 | 482.131 | 485.63 | 697324.0 |
| 2024-07-18 09:00:00 | QQQ | ETF | 485.63 | 486.04 | 482.56 | 483.71 | 4391959.0 |
| 2024-07-18 10:00:00 | QQQ | ETF | 483.67 | 484.655 | 479.47 | 481.78 | 6085518.0 |
| 2024-07-18 11:00:00 | QQQ | ETF | 481.8 | 482.15 | 476.8625 | 477.16 | 5690982.0 |
| 2024-07-18 12:00:00 | QQQ | ETF | 477.14 | 479.99 | 476.58 | 479.96 | 3898672.0 |
| 2024-07-18 13:00:00 | QQQ | ETF | 479.95 | 480.7606 | 478.58 | 479.0 | 3134893.0 |
| 2024-07-18 14:00:00 | QQQ | ETF | 479.05 | 479.45 | 477.28 | 478.4 | 2725942.0 |
| 2024-07-18 15:00:00 | QQQ | ETF | 478.39 | 481.13 | 476.27 | 479.53 | 6912431.0 |
| 2024-07-18 16:00:00 | QQQ | ETF | 479.47 | 480.95 | 478.85 | 480.61 | 2090814.0 |
| 2024-07-18 17:00:00 | QQQ | ETF | 480.66 | 481.22 | 479.49 | 481.05 | 69317.0 |
| 2024-07-18 18:00:00 | QQQ | ETF | 481.04 | 481.52 | 480.58 | 481.03 | 111301.0 |
| 2024-07-18 19:00:00 | QQQ | ETF | 481.05 | 481.24 | 480.78 | 480.86 | 85746.0 |
| 2024-07-18 04:00:00 | IWM | ETF | 222.34 | 223.57 | 221.75 | 221.76 | 73752.0 |
| 2024-07-18 05:00:00 | IWM | ETF | 221.85 | 222.36 | 221.56 | 221.56 | 70660.0 |
| 2024-07-18 06:00:00 | IWM | ETF | 221.58 | 222.33 | 221.46 | 222.27 | 132360.0 |
| 2024-07-18 07:00:00 | IWM | ETF | 222.36 | 222.4 | 221.76 | 222.03 | 120403.0 |
| 2024-07-18 08:00:00 | IWM | ETF | 222.2 | 223.72 | 221.33 | 221.37 | 485154.0 |
| 2024-07-18 09:00:00 | IWM | ETF | 221.4 | 224.07 | 220.97 | 224.03 | 5039469.0 |
| 2024-07-18 10:00:00 | IWM | ETF | 224.03 | 224.78 | 221.8 | 222.28 | 6155746.0 |
| 2024-07-18 11:00:00 | IWM | ETF | 222.275 | 222.84 | 220.15 | 220.33 | 4349381.0 |
| 2024-07-18 12:00:00 | IWM | ETF | 220.3121 | 221.05 | 219.62 | 221.0496 | 3204530.0 |
| 2024-07-18 13:00:00 | IWM | ETF | 221.04 | 221.17 | 219.22 | 219.26 | 2066048.0 |
| 2024-07-18 14:00:00 | IWM | ETF | 219.27 | 219.28 | 217.225 | 217.9406 | 6092870.0 |
| 2024-07-18 15:00:00 | IWM | ETF | 217.93 | 218.8 | 216.98 | 217.99 | 8399613.0 |
| 2024-07-18 16:00:00 | IWM | ETF | 217.95 | 218.5 | 217.95 | 218.46 | 1804043.0 |
| 2024-07-18 17:00:00 | IWM | ETF | 218.47 | 218.78 | 217.95 | 218.61 | 19511.0 |
| 2024-07-18 18:00:00 | IWM | ETF | 218.53 | 218.7 | 218.35 | 218.66 | 22021.0 |
| 2024-07-18 19:00:00 | IWM | ETF | 218.67 | 218.8 | 218.6 | 218.7317 | 46763.0 |
| 2024-07-18 04:00:00 | DIA | ETF | 411.86 | 411.86 | 411.68 | 411.75 | 5175.0 |
| 2024-07-18 05:00:00 | DIA | ETF | 411.73 | 411.92 | 411.57 | 411.6 | 4750.0 |
> showing 50 of 20,854 rows — these rows as CSV