PREVIEW / etf_1hour / 2024-09-03
file: by_date/etf_1hour/2024/2024-09-03.parquet size: 556 KB rows: 21,608
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-09-03 04:00:00 | SPY | ETF | 563.5 | 564.22 | 561.8 | 561.8 | 11505.0 |
| 2024-09-03 05:00:00 | SPY | ETF | 561.76 | 562.02 | 560.7 | 560.81 | 54832.0 |
| 2024-09-03 06:00:00 | SPY | ETF | 560.75 | 561.41 | 560.5 | 561.29 | 135622.0 |
| 2024-09-03 07:00:00 | SPY | ETF | 561.29 | 561.45 | 560.6 | 561.05 | 141462.0 |
| 2024-09-03 08:00:00 | SPY | ETF | 561.2884 | 564.0 | 560.62 | 560.7 | 203827.0 |
| 2024-09-03 09:00:00 | SPY | ETF | 560.68 | 561.1215 | 558.14 | 559.08 | 4681937.0 |
| 2024-09-03 10:00:00 | SPY | ETF | 559.12 | 559.14 | 555.1 | 555.3399 | 6854775.0 |
| 2024-09-03 11:00:00 | SPY | ETF | 555.35 | 556.99 | 555.15 | 555.6 | 4008421.0 |
| 2024-09-03 12:00:00 | SPY | ETF | 555.59 | 556.5 | 554.755 | 554.9 | 2704229.0 |
| 2024-09-03 13:00:00 | SPY | ETF | 554.88 | 555.87 | 554.26 | 554.34 | 2750303.0 |
| 2024-09-03 14:00:00 | SPY | ETF | 554.33 | 554.38 | 552.47 | 552.6302 | 4526864.0 |
| 2024-09-03 15:00:00 | SPY | ETF | 552.63 | 553.16 | 549.51 | 552.16 | 12716697.0 |
| 2024-09-03 16:00:00 | SPY | ETF | 552.16 | 552.55 | 551.09 | 551.6599 | 2992356.0 |
| 2024-09-03 17:00:00 | SPY | ETF | 551.59 | 551.64 | 551.34 | 551.44 | 106331.0 |
| 2024-09-03 18:00:00 | SPY | ETF | 551.53 | 551.8 | 551.0 | 551.33 | 78971.0 |
| 2024-09-03 19:00:00 | SPY | ETF | 551.2215 | 551.5 | 550.7 | 551.0 | 58780.0 |
| 2024-09-03 04:00:00 | QQQ | ETF | 476.2 | 476.85 | 473.71 | 473.73 | 67813.0 |
| 2024-09-03 05:00:00 | QQQ | ETF | 473.55 | 474.05 | 472.44 | 473.04 | 75705.0 |
| 2024-09-03 06:00:00 | QQQ | ETF | 472.99 | 473.92 | 472.69 | 473.73 | 63606.0 |
| 2024-09-03 07:00:00 | QQQ | ETF | 473.68 | 473.96 | 472.72 | 473.66 | 122200.0 |
| 2024-09-03 08:00:00 | QQQ | ETF | 473.74 | 477.0 | 472.7804 | 473.29 | 172643.0 |
| 2024-09-03 09:00:00 | QQQ | ETF | 473.2 | 473.96 | 469.675 | 470.6199 | 4924942.0 |
| 2024-09-03 10:00:00 | QQQ | ETF | 470.6 | 470.96 | 465.46 | 465.54 | 6491814.0 |
| 2024-09-03 11:00:00 | QQQ | ETF | 465.555 | 467.31 | 465.1 | 465.2 | 3591104.0 |
| 2024-09-03 12:00:00 | QQQ | ETF | 465.21 | 466.56 | 464.84 | 464.98 | 2497470.0 |
| 2024-09-03 13:00:00 | QQQ | ETF | 464.98 | 465.93 | 464.14 | 464.23 | 2323988.0 |
| 2024-09-03 14:00:00 | QQQ | ETF | 464.24 | 464.3599 | 462.34 | 462.69 | 3502276.0 |
| 2024-09-03 15:00:00 | QQQ | ETF | 462.68 | 463.34 | 459.4101 | 461.84 | 7795150.0 |
| 2024-09-03 16:00:00 | QQQ | ETF | 461.84 | 462.46 | 460.85 | 461.41 | 2359197.0 |
| 2024-09-03 17:00:00 | QQQ | ETF | 461.26 | 461.81 | 460.83 | 461.06 | 119251.0 |
| 2024-09-03 18:00:00 | QQQ | ETF | 461.08 | 461.65 | 460.25 | 460.6516 | 183088.0 |
| 2024-09-03 19:00:00 | QQQ | ETF | 460.66 | 460.921 | 459.99 | 460.51 | 115248.0 |
| 2024-09-03 04:00:00 | IWM | ETF | 219.71 | 219.88 | 218.61 | 218.71 | 16563.0 |
| 2024-09-03 05:00:00 | IWM | ETF | 218.59 | 218.64 | 218.07 | 218.1 | 17238.0 |
| 2024-09-03 06:00:00 | IWM | ETF | 218.12 | 218.43 | 217.8 | 218.4 | 41621.0 |
| 2024-09-03 07:00:00 | IWM | ETF | 218.36 | 218.61 | 218.07 | 218.3 | 98666.0 |
| 2024-09-03 08:00:00 | IWM | ETF | 218.19 | 220.08 | 217.93 | 217.96 | 133605.0 |
| 2024-09-03 09:00:00 | IWM | ETF | 217.95 | 219.37 | 217.54 | 218.08 | 3607958.0 |
| 2024-09-03 10:00:00 | IWM | ETF | 218.05 | 218.05 | 214.98 | 215.44 | 4612082.0 |
| 2024-09-03 11:00:00 | IWM | ETF | 215.48 | 216.06 | 215.19 | 215.25 | 2492873.0 |
| 2024-09-03 12:00:00 | IWM | ETF | 215.24 | 215.4 | 214.04 | 214.185 | 2172969.0 |
| 2024-09-03 13:00:00 | IWM | ETF | 214.165 | 214.65 | 213.864 | 213.89 | 1700266.0 |
| 2024-09-03 14:00:00 | IWM | ETF | 213.9 | 213.91 | 213.47 | 213.54 | 1752396.0 |
| 2024-09-03 15:00:00 | IWM | ETF | 213.54 | 213.99 | 212.91 | 213.39 | 5537338.0 |
| 2024-09-03 16:00:00 | IWM | ETF | 213.39 | 213.63 | 213.17 | 213.5 | 1928407.0 |
| 2024-09-03 17:00:00 | IWM | ETF | 213.54 | 213.57 | 213.16 | 213.33 | 49886.0 |
| 2024-09-03 18:00:00 | IWM | ETF | 213.37 | 213.79 | 213.2 | 213.3 | 43682.0 |
| 2024-09-03 19:00:00 | IWM | ETF | 213.33 | 213.5 | 212.82 | 213.02 | 84700.0 |
| 2024-09-03 04:00:00 | DIA | ETF | 415.77 | 415.77 | 414.98 | 414.98 | 2267.0 |
| 2024-09-03 06:00:00 | DIA | ETF | 414.21 | 414.31 | 414.21 | 414.28 | 1100.0 |
> showing 50 of 21,608 rows — these rows as CSV