PREVIEW / etf_1hour / 2024-01-17
file: by_date/etf_1hour/2024/2024-01-17.parquet size: 531 KB rows: 19,666
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-01-17 04:00:00 | SPY | ETF | 472.6 | 473.02 | 472.11 | 472.97 | 39720.0 |
| 2024-01-17 05:00:00 | SPY | ETF | 473.01 | 473.12 | 472.58 | 472.85 | 14651.0 |
| 2024-01-17 06:00:00 | SPY | ETF | 472.65 | 473.2 | 472.5 | 473.11 | 23996.0 |
| 2024-01-17 07:00:00 | SPY | ETF | 473.19 | 473.67 | 473.05 | 473.26 | 236288.0 |
| 2024-01-17 08:00:00 | SPY | ETF | 473.4601 | 474.77 | 471.8 | 471.97 | 579281.0 |
| 2024-01-17 09:00:00 | SPY | ETF | 471.99 | 472.35 | 471.05 | 471.325 | 7475552.0 |
| 2024-01-17 10:00:00 | SPY | ETF | 471.32 | 472.36 | 471.05 | 472.02 | 8521839.0 |
| 2024-01-17 11:00:00 | SPY | ETF | 472.02 | 472.79 | 472.0 | 472.1789 | 5649250.0 |
| 2024-01-17 12:00:00 | SPY | ETF | 472.18 | 472.3 | 471.12 | 471.68 | 5412549.0 |
| 2024-01-17 13:00:00 | SPY | ETF | 471.68 | 472.04 | 469.87 | 470.6602 | 6701681.0 |
| 2024-01-17 14:00:00 | SPY | ETF | 470.6699 | 471.765 | 470.52 | 471.47 | 5903530.0 |
| 2024-01-17 15:00:00 | SPY | ETF | 471.47 | 472.61 | 470.67 | 472.275 | 11929913.0 |
| 2024-01-17 16:00:00 | SPY | ETF | 472.27 | 472.39 | 471.2009 | 472.13 | 2580880.0 |
| 2024-01-17 17:00:00 | SPY | ETF | 472.09 | 472.19 | 472.01 | 472.03 | 30260.0 |
| 2024-01-17 18:00:00 | SPY | ETF | 472.03 | 472.25 | 471.75 | 472.2 | 72944.0 |
| 2024-01-17 19:00:00 | SPY | ETF | 472.15 | 472.32 | 471.95 | 472.32 | 45508.0 |
| 2024-01-17 04:00:00 | QQQ | ETF | 407.36 | 407.4 | 406.02 | 407.27 | 98450.0 |
| 2024-01-17 05:00:00 | QQQ | ETF | 407.26 | 407.51 | 406.89 | 407.29 | 29555.0 |
| 2024-01-17 06:00:00 | QQQ | ETF | 407.29 | 407.92 | 406.89 | 407.68 | 58528.0 |
| 2024-01-17 07:00:00 | QQQ | ETF | 407.78 | 408.16 | 407.57 | 407.73 | 92475.0 |
| 2024-01-17 08:00:00 | QQQ | ETF | 407.8086 | 409.213 | 405.72 | 406.05 | 652003.0 |
| 2024-01-17 09:00:00 | QQQ | ETF | 406.03 | 406.61 | 403.27 | 403.36 | 8228077.0 |
| 2024-01-17 10:00:00 | QQQ | ETF | 403.35 | 405.28 | 402.92 | 404.88 | 8099111.0 |
| 2024-01-17 11:00:00 | QQQ | ETF | 404.86 | 406.565 | 404.84 | 405.83 | 5088976.0 |
| 2024-01-17 12:00:00 | QQQ | ETF | 405.84 | 406.1499 | 404.93 | 405.78 | 3069750.0 |
| 2024-01-17 13:00:00 | QQQ | ETF | 405.77 | 406.17 | 403.98 | 404.65 | 3572506.0 |
| 2024-01-17 14:00:00 | QQQ | ETF | 404.6485 | 406.585 | 404.5 | 406.23 | 3784107.0 |
| 2024-01-17 15:00:00 | QQQ | ETF | 406.24 | 407.585 | 405.49 | 407.2 | 6415799.0 |
| 2024-01-17 16:00:00 | QQQ | ETF | 407.2 | 407.3 | 406.87 | 406.981 | 1952936.0 |
| 2024-01-17 17:00:00 | QQQ | ETF | 407.0 | 407.02 | 406.85 | 406.9 | 23581.0 |
| 2024-01-17 18:00:00 | QQQ | ETF | 406.86 | 407.0 | 406.4 | 406.83 | 54868.0 |
| 2024-01-17 19:00:00 | QQQ | ETF | 406.8 | 407.1 | 406.6 | 407.08 | 51563.0 |
| 2024-01-17 04:00:00 | IWM | ETF | 188.93 | 189.69 | 188.28 | 188.59 | 68667.0 |
| 2024-01-17 05:00:00 | IWM | ETF | 188.61 | 188.82 | 188.27 | 188.49 | 25458.0 |
| 2024-01-17 06:00:00 | IWM | ETF | 188.44 | 188.67 | 188.08 | 188.5 | 57825.0 |
| 2024-01-17 07:00:00 | IWM | ETF | 188.52 | 188.91 | 188.4 | 188.64 | 152879.0 |
| 2024-01-17 08:00:00 | IWM | ETF | 188.5195 | 190.06 | 187.81 | 187.9 | 438103.0 |
| 2024-01-17 09:00:00 | IWM | ETF | 187.94 | 189.15 | 187.525 | 188.78 | 6155190.0 |
| 2024-01-17 10:00:00 | IWM | ETF | 188.785 | 189.93 | 188.46 | 189.1 | 5435802.0 |
| 2024-01-17 11:00:00 | IWM | ETF | 189.1 | 189.49 | 188.925 | 189.11 | 2445866.0 |
| 2024-01-17 12:00:00 | IWM | ETF | 189.11 | 189.17 | 188.44 | 188.8 | 2098883.0 |
| 2024-01-17 13:00:00 | IWM | ETF | 188.8 | 189.01 | 188.015 | 188.51 | 2603134.0 |
| 2024-01-17 14:00:00 | IWM | ETF | 188.52 | 189.05 | 188.505 | 188.801 | 2769825.0 |
| 2024-01-17 15:00:00 | IWM | ETF | 188.81 | 189.72 | 188.52 | 189.46 | 5668938.0 |
| 2024-01-17 16:00:00 | IWM | ETF | 189.48 | 189.58 | 189.1 | 189.43 | 2142771.0 |
| 2024-01-17 17:00:00 | IWM | ETF | 189.46 | 189.47 | 189.28 | 189.4 | 26868.0 |
| 2024-01-17 18:00:00 | IWM | ETF | 189.4 | 189.57 | 189.3 | 189.4 | 28675.0 |
| 2024-01-17 19:00:00 | IWM | ETF | 189.4 | 189.69 | 189.38 | 189.69 | 70844.0 |
| 2024-01-17 04:00:00 | DIA | ETF | 372.29 | 372.29 | 372.03 | 372.05 | 550.0 |
| 2024-01-17 05:00:00 | DIA | ETF | 372.35 | 372.35 | 372.35 | 372.35 | 200.0 |
> showing 50 of 19,666 rows — these rows as CSV