PREVIEW / etf_1hour / 2024-07-24
file: by_date/etf_1hour/2024/2024-07-24.parquet size: 561 KB rows: 21,107
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-24 04:00:00 | SPY | ETF | 549.9 | 550.31 | 549.21 | 550.26 | 39828.0 |
| 2024-07-24 05:00:00 | SPY | ETF | 550.28 | 550.3 | 549.37 | 549.94 | 14940.0 |
| 2024-07-24 06:00:00 | SPY | ETF | 549.87 | 550.46 | 549.78 | 549.82 | 63688.0 |
| 2024-07-24 07:00:00 | SPY | ETF | 549.87 | 550.35 | 549.37 | 549.89 | 158785.0 |
| 2024-07-24 08:00:00 | SPY | ETF | 549.44 | 550.9 | 548.37 | 548.59 | 415511.0 |
| 2024-07-24 09:00:00 | SPY | ETF | 548.6 | 549.17 | 546.33 | 546.76 | 5046380.0 |
| 2024-07-24 10:00:00 | SPY | ETF | 546.74 | 546.9 | 545.271 | 545.61 | 6441616.0 |
| 2024-07-24 11:00:00 | SPY | ETF | 545.61 | 545.685 | 544.19 | 544.39 | 4024960.0 |
| 2024-07-24 12:00:00 | SPY | ETF | 544.38 | 544.92 | 543.63 | 543.9 | 3859455.0 |
| 2024-07-24 13:00:00 | SPY | ETF | 543.89 | 545.03 | 543.74 | 543.88 | 2884465.0 |
| 2024-07-24 14:00:00 | SPY | ETF | 543.9 | 544.19 | 541.81 | 542.48 | 5187666.0 |
| 2024-07-24 15:00:00 | SPY | ETF | 542.47 | 542.9 | 540.29 | 541.21 | 14372241.0 |
| 2024-07-24 16:00:00 | SPY | ETF | 541.2 | 542.43 | 540.9912 | 542.27 | 6833551.0 |
| 2024-07-24 17:00:00 | SPY | ETF | 542.34 | 542.46 | 542.09 | 542.22 | 100980.0 |
| 2024-07-24 18:00:00 | SPY | ETF | 542.23 | 542.87 | 542.23 | 542.69 | 269248.0 |
| 2024-07-24 19:00:00 | SPY | ETF | 542.62 | 542.74 | 542.42 | 542.46 | 23652.0 |
| 2024-07-24 04:00:00 | QQQ | ETF | 475.68 | 476.47 | 474.95 | 476.24 | 71165.0 |
| 2024-07-24 05:00:00 | QQQ | ETF | 476.37 | 476.48 | 475.46 | 475.79 | 87908.0 |
| 2024-07-24 06:00:00 | QQQ | ETF | 475.79 | 476.45 | 475.48 | 475.63 | 105109.0 |
| 2024-07-24 07:00:00 | QQQ | ETF | 475.74 | 476.01 | 475.04 | 475.46 | 146316.0 |
| 2024-07-24 08:00:00 | QQQ | ETF | 475.7 | 477.5 | 473.08 | 473.7 | 748032.0 |
| 2024-07-24 09:00:00 | QQQ | ETF | 473.6602 | 474.19 | 470.56 | 470.82 | 5478290.0 |
| 2024-07-24 10:00:00 | QQQ | ETF | 470.81 | 471.07 | 468.424 | 469.02 | 5197397.0 |
| 2024-07-24 11:00:00 | QQQ | ETF | 469.01 | 469.19 | 467.11 | 467.145 | 3590492.0 |
| 2024-07-24 12:00:00 | QQQ | ETF | 467.1762 | 467.33 | 465.9001 | 466.23 | 3653918.0 |
| 2024-07-24 13:00:00 | QQQ | ETF | 466.23 | 467.65 | 465.94 | 466.193 | 3021076.0 |
| 2024-07-24 14:00:00 | QQQ | ETF | 466.2 | 466.45 | 463.88 | 464.46 | 3300840.0 |
| 2024-07-24 15:00:00 | QQQ | ETF | 464.465 | 465.86 | 462.51 | 463.33 | 10306028.0 |
| 2024-07-24 16:00:00 | QQQ | ETF | 463.33 | 465.05 | 463.05 | 464.9 | 3066008.0 |
| 2024-07-24 17:00:00 | QQQ | ETF | 464.86 | 465.0001 | 463.38 | 464.51 | 326834.0 |
| 2024-07-24 18:00:00 | QQQ | ETF | 464.51 | 465.7 | 464.51 | 465.04 | 198598.0 |
| 2024-07-24 19:00:00 | QQQ | ETF | 465.16 | 465.35 | 464.8 | 465.0 | 118768.0 |
| 2024-07-24 04:00:00 | IWM | ETF | 221.78 | 222.01 | 220.88 | 222.0 | 15693.0 |
| 2024-07-24 05:00:00 | IWM | ETF | 222.04 | 222.35 | 221.83 | 222.2 | 17115.0 |
| 2024-07-24 06:00:00 | IWM | ETF | 222.2 | 222.2 | 221.51 | 221.69 | 18221.0 |
| 2024-07-24 07:00:00 | IWM | ETF | 221.75 | 222.1 | 221.65 | 222.0 | 161319.0 |
| 2024-07-24 08:00:00 | IWM | ETF | 221.74 | 222.63 | 220.9696 | 221.06 | 422960.0 |
| 2024-07-24 09:00:00 | IWM | ETF | 221.12 | 223.86 | 220.35 | 220.73 | 5690904.0 |
| 2024-07-24 10:00:00 | IWM | ETF | 220.71 | 222.716 | 220.51 | 222.01 | 5352460.0 |
| 2024-07-24 11:00:00 | IWM | ETF | 221.94 | 222.56 | 220.97 | 222.23 | 2556594.0 |
| 2024-07-24 12:00:00 | IWM | ETF | 222.23 | 222.47 | 220.88 | 221.29 | 2649332.0 |
| 2024-07-24 13:00:00 | IWM | ETF | 221.28 | 221.62 | 220.865 | 221.23 | 1922220.0 |
| 2024-07-24 14:00:00 | IWM | ETF | 221.25 | 221.4 | 218.52 | 219.2097 | 4148017.0 |
| 2024-07-24 15:00:00 | IWM | ETF | 219.19 | 219.51 | 217.715 | 217.91 | 7320390.0 |
| 2024-07-24 16:00:00 | IWM | ETF | 217.94 | 218.37 | 217.78 | 218.11 | 2152691.0 |
| 2024-07-24 17:00:00 | IWM | ETF | 218.11 | 218.3 | 217.85 | 218.07 | 25974.0 |
| 2024-07-24 18:00:00 | IWM | ETF | 218.19 | 218.81 | 218.0019 | 218.72 | 74112.0 |
| 2024-07-24 19:00:00 | IWM | ETF | 218.63 | 218.898 | 218.58 | 218.77 | 51263.0 |
| 2024-07-24 04:00:00 | DIA | ETF | 401.83 | 401.83 | 401.49 | 401.69 | 1595.0 |
| 2024-07-24 05:00:00 | DIA | ETF | 401.51 | 401.89 | 401.51 | 401.89 | 386.0 |
> showing 50 of 21,107 rows — these rows as CSV