PREVIEW / etf_1hour / 2024-09-27
file: by_date/etf_1hour/2024/2024-09-27.parquet size: 563 KB rows: 21,097
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-27 04:00:00 | SPY | ETF | 571.44 | 572.52 | 571.4 | 572.0 | 13063.0 |
| 2024-09-27 05:00:00 | SPY | ETF | 572.07 | 572.54 | 571.85 | 572.4 | 9244.0 |
| 2024-09-27 06:00:00 | SPY | ETF | 572.37 | 572.55 | 571.98 | 572.11 | 12235.0 |
| 2024-09-27 07:00:00 | SPY | ETF | 572.07 | 572.71 | 572.02 | 572.64 | 36015.0 |
| 2024-09-27 08:00:00 | SPY | ETF | 572.0942 | 573.9 | 571.5 | 573.58 | 342608.0 |
| 2024-09-27 09:00:00 | SPY | ETF | 573.55 | 573.7 | 572.705 | 573.0 | 2846853.0 |
| 2024-09-27 10:00:00 | SPY | ETF | 573.02 | 574.22 | 572.64 | 573.71 | 3585425.0 |
| 2024-09-27 11:00:00 | SPY | ETF | 573.665 | 573.72 | 572.41 | 572.44 | 2134990.0 |
| 2024-09-27 12:00:00 | SPY | ETF | 572.435 | 572.63 | 571.85 | 572.19 | 2123642.0 |
| 2024-09-27 13:00:00 | SPY | ETF | 572.1916 | 572.71 | 571.53 | 572.43 | 2058382.0 |
| 2024-09-27 14:00:00 | SPY | ETF | 572.43 | 572.65 | 570.42 | 572.19 | 4056919.0 |
| 2024-09-27 15:00:00 | SPY | ETF | 572.19 | 572.34 | 571.32 | 571.41 | 6877947.0 |
| 2024-09-27 16:00:00 | SPY | ETF | 571.4 | 571.7531 | 570.84 | 570.92 | 2632948.0 |
| 2024-09-27 17:00:00 | SPY | ETF | 570.81 | 571.47 | 570.81 | 571.23 | 170216.0 |
| 2024-09-27 18:00:00 | SPY | ETF | 571.23 | 571.23 | 570.77 | 571.0 | 26711.0 |
| 2024-09-27 19:00:00 | SPY | ETF | 570.81 | 571.09 | 570.65 | 570.67 | 15362.0 |
| 2024-09-27 04:00:00 | QQQ | ETF | 487.38 | 489.18 | 487.38 | 488.38 | 96168.0 |
| 2024-09-27 05:00:00 | QQQ | ETF | 488.62 | 489.22 | 488.22 | 488.81 | 36865.0 |
| 2024-09-27 06:00:00 | QQQ | ETF | 489.0 | 489.14 | 488.23 | 488.53 | 24212.0 |
| 2024-09-27 07:00:00 | QQQ | ETF | 488.53 | 489.75 | 488.47 | 489.73 | 76996.0 |
| 2024-09-27 08:00:00 | QQQ | ETF | 489.73 | 490.96 | 487.3 | 490.5 | 313198.0 |
| 2024-09-27 09:00:00 | QQQ | ETF | 490.5 | 490.85 | 488.9 | 489.2258 | 1843346.0 |
| 2024-09-27 10:00:00 | QQQ | ETF | 489.28 | 490.38 | 487.92 | 488.74 | 2503816.0 |
| 2024-09-27 11:00:00 | QQQ | ETF | 488.715 | 488.83 | 486.98 | 487.08 | 2163191.0 |
| 2024-09-27 12:00:00 | QQQ | ETF | 487.06 | 487.86 | 486.48 | 487.71 | 1483851.0 |
| 2024-09-27 13:00:00 | QQQ | ETF | 487.7101 | 488.28 | 486.67 | 488.12 | 1840803.0 |
| 2024-09-27 14:00:00 | QQQ | ETF | 488.13 | 488.44 | 485.56 | 487.4 | 2229847.0 |
| 2024-09-27 15:00:00 | QQQ | ETF | 487.4 | 487.52 | 486.52 | 486.78 | 3201061.0 |
| 2024-09-27 16:00:00 | QQQ | ETF | 486.75 | 486.86 | 485.99 | 486.07 | 1060296.0 |
| 2024-09-27 17:00:00 | QQQ | ETF | 486.031 | 486.33 | 486.0 | 486.2699 | 39045.0 |
| 2024-09-27 18:00:00 | QQQ | ETF | 486.26 | 486.27 | 485.9 | 485.94 | 4604.0 |
| 2024-09-27 19:00:00 | QQQ | ETF | 485.94 | 486.29 | 485.8816 | 485.9 | 32111.0 |
| 2024-09-27 04:00:00 | IWM | ETF | 218.96 | 219.58 | 218.84 | 219.01 | 32890.0 |
| 2024-09-27 05:00:00 | IWM | ETF | 219.26 | 219.84 | 219.22 | 219.62 | 17600.0 |
| 2024-09-27 06:00:00 | IWM | ETF | 219.69 | 219.77 | 219.39 | 219.4 | 3958.0 |
| 2024-09-27 07:00:00 | IWM | ETF | 219.41 | 219.85 | 219.38 | 219.79 | 77247.0 |
| 2024-09-27 08:00:00 | IWM | ETF | 219.4213 | 221.58 | 218.41 | 221.46 | 683721.0 |
| 2024-09-27 09:00:00 | IWM | ETF | 221.38 | 221.74 | 220.0 | 220.5101 | 2273204.0 |
| 2024-09-27 10:00:00 | IWM | ETF | 220.55 | 222.599 | 220.0 | 222.27 | 2716289.0 |
| 2024-09-27 11:00:00 | IWM | ETF | 222.25 | 222.41 | 221.84 | 221.91 | 1954020.0 |
| 2024-09-27 12:00:00 | IWM | ETF | 221.92 | 221.94 | 220.79 | 220.985 | 1726906.0 |
| 2024-09-27 13:00:00 | IWM | ETF | 220.995 | 221.19 | 220.38 | 220.91 | 1402296.0 |
| 2024-09-27 14:00:00 | IWM | ETF | 220.9 | 220.9 | 219.53 | 220.665 | 1513132.0 |
| 2024-09-27 15:00:00 | IWM | ETF | 220.65 | 220.7 | 219.87 | 220.31 | 3011860.0 |
| 2024-09-27 16:00:00 | IWM | ETF | 220.33 | 220.54 | 220.2 | 220.27 | 1073586.0 |
| 2024-09-27 17:00:00 | IWM | ETF | 220.27 | 220.53 | 220.21 | 220.53 | 29818.0 |
| 2024-09-27 18:00:00 | IWM | ETF | 220.5 | 220.5 | 220.28 | 220.28 | 4585.0 |
| 2024-09-27 19:00:00 | IWM | ETF | 220.32 | 220.3445 | 220.2 | 220.29 | 5324.0 |
| 2024-09-27 05:00:00 | DIA | ETF | 421.59 | 421.59 | 421.59 | 421.59 | 100.0 |
| 2024-09-27 06:00:00 | DIA | ETF | 421.8 | 421.8 | 421.8 | 421.8 | 100.0 |
> showing 50 of 21,097 rows — these rows as CSV