PREVIEW / etf_1hour / 2024-09-05
file: by_date/etf_1hour/2024/2024-09-05.parquet size: 538 KB rows: 20,561
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-05 04:00:00 | SPY | ETF | 551.94 | 552.04 | 551.52 | 551.85 | 94460.0 |
| 2024-09-05 05:00:00 | SPY | ETF | 551.57 | 551.57 | 550.42 | 551.09 | 25811.0 |
| 2024-09-05 06:00:00 | SPY | ETF | 551.09 | 551.43 | 550.75 | 551.33 | 15656.0 |
| 2024-09-05 07:00:00 | SPY | ETF | 551.37 | 551.72 | 550.6 | 550.74 | 226587.0 |
| 2024-09-05 08:00:00 | SPY | ETF | 551.3901 | 551.95 | 549.29 | 550.42 | 478758.0 |
| 2024-09-05 09:00:00 | SPY | ETF | 550.45 | 552.27 | 550.25 | 551.96 | 3806452.0 |
| 2024-09-05 10:00:00 | SPY | ETF | 551.97 | 553.7995 | 550.33 | 550.3899 | 4697330.0 |
| 2024-09-05 11:00:00 | SPY | ETF | 550.38 | 550.54 | 547.36 | 547.49 | 4569374.0 |
| 2024-09-05 12:00:00 | SPY | ETF | 547.48 | 549.3 | 547.1 | 548.71 | 3228677.0 |
| 2024-09-05 13:00:00 | SPY | ETF | 548.72 | 550.7 | 547.73 | 550.68 | 2362310.0 |
| 2024-09-05 14:00:00 | SPY | ETF | 550.69 | 551.18 | 549.85 | 550.17 | 2822581.0 |
| 2024-09-05 15:00:00 | SPY | ETF | 550.15 | 550.26 | 548.04 | 549.57 | 8219604.0 |
| 2024-09-05 16:00:00 | SPY | ETF | 549.56 | 550.32 | 549.02 | 549.19 | 3347640.0 |
| 2024-09-05 17:00:00 | SPY | ETF | 549.14 | 549.33 | 549.0 | 549.33 | 39668.0 |
| 2024-09-05 18:00:00 | SPY | ETF | 549.33 | 549.4 | 548.73 | 549.11 | 56852.0 |
| 2024-09-05 19:00:00 | SPY | ETF | 549.0 | 549.1024 | 548.65 | 549.05 | 22379.0 |
| 2024-09-05 04:00:00 | QQQ | ETF | 460.67 | 461.67 | 460.67 | 461.1 | 44881.0 |
| 2024-09-05 05:00:00 | QQQ | ETF | 460.94 | 460.94 | 459.31 | 460.23 | 43997.0 |
| 2024-09-05 06:00:00 | QQQ | ETF | 460.0 | 460.64 | 459.86 | 460.45 | 45645.0 |
| 2024-09-05 07:00:00 | QQQ | ETF | 460.44 | 460.88 | 459.55 | 459.719 | 114510.0 |
| 2024-09-05 08:00:00 | QQQ | ETF | 459.96 | 461.6 | 457.56 | 459.01 | 834476.0 |
| 2024-09-05 09:00:00 | QQQ | ETF | 459.02 | 463.2 | 458.87 | 463.05 | 3563389.0 |
| 2024-09-05 10:00:00 | QQQ | ETF | 463.04 | 465.36 | 461.3 | 461.33 | 5025900.0 |
| 2024-09-05 11:00:00 | QQQ | ETF | 461.362 | 461.54 | 457.939 | 458.41 | 4255099.0 |
| 2024-09-05 12:00:00 | QQQ | ETF | 458.37 | 460.88 | 458.32 | 460.12 | 2608472.0 |
| 2024-09-05 13:00:00 | QQQ | ETF | 460.14 | 462.11 | 459.04 | 462.055 | 2221391.0 |
| 2024-09-05 14:00:00 | QQQ | ETF | 462.07 | 462.72 | 461.32 | 461.5 | 2126657.0 |
| 2024-09-05 15:00:00 | QQQ | ETF | 461.53 | 461.7007 | 459.33 | 461.14 | 4142487.0 |
| 2024-09-05 16:00:00 | QQQ | ETF | 461.15 | 462.47 | 459.11 | 459.95 | 1322430.0 |
| 2024-09-05 17:00:00 | QQQ | ETF | 459.89 | 460.0 | 459.83 | 460.0 | 71285.0 |
| 2024-09-05 18:00:00 | QQQ | ETF | 459.95 | 460.1699 | 459.42 | 459.8 | 91051.0 |
| 2024-09-05 19:00:00 | QQQ | ETF | 459.83 | 459.83 | 459.17 | 459.63 | 83552.0 |
| 2024-09-05 04:00:00 | IWM | ETF | 213.0 | 213.23 | 212.92 | 213.07 | 20595.0 |
| 2024-09-05 05:00:00 | IWM | ETF | 213.0 | 213.1 | 212.51 | 212.71 | 8474.0 |
| 2024-09-05 06:00:00 | IWM | ETF | 212.7 | 213.11 | 212.7 | 213.06 | 9217.0 |
| 2024-09-05 07:00:00 | IWM | ETF | 213.08 | 213.82 | 212.98 | 213.39 | 81064.0 |
| 2024-09-05 08:00:00 | IWM | ETF | 213.12 | 213.83 | 212.41 | 213.48 | 374776.0 |
| 2024-09-05 09:00:00 | IWM | ETF | 213.49 | 213.94 | 212.05 | 212.2 | 2729108.0 |
| 2024-09-05 10:00:00 | IWM | ETF | 212.22 | 214.03 | 211.84 | 212.07 | 3757164.0 |
| 2024-09-05 11:00:00 | IWM | ETF | 212.07 | 212.41 | 210.93 | 210.98 | 2237690.0 |
| 2024-09-05 12:00:00 | IWM | ETF | 210.98 | 212.11 | 210.92 | 211.83 | 1583051.0 |
| 2024-09-05 13:00:00 | IWM | ETF | 211.83 | 212.52 | 211.4 | 212.505 | 994369.0 |
| 2024-09-05 14:00:00 | IWM | ETF | 212.52 | 212.77 | 212.15 | 212.18 | 999164.0 |
| 2024-09-05 15:00:00 | IWM | ETF | 212.2 | 212.29 | 211.28 | 211.89 | 3870270.0 |
| 2024-09-05 16:00:00 | IWM | ETF | 211.9 | 212.22 | 211.5224 | 211.99 | 1137447.0 |
| 2024-09-05 17:00:00 | IWM | ETF | 212.1 | 212.1 | 211.8 | 211.96 | 163216.0 |
| 2024-09-05 18:00:00 | IWM | ETF | 212.05 | 212.29 | 211.91 | 212.0 | 38207.0 |
| 2024-09-05 19:00:00 | IWM | ETF | 211.94 | 212.06 | 211.8 | 211.96 | 6217.0 |
| 2024-09-05 04:00:00 | DIA | ETF | 411.08 | 411.08 | 411.08 | 411.08 | 244.0 |
| 2024-09-05 05:00:00 | DIA | ETF | 411.11 | 411.11 | 410.69 | 410.69 | 1563.0 |
> showing 50 of 20,561 rows — these rows as CSV