PREVIEW / etf_1hour / 2024-10-22
file: by_date/etf_1hour/2024/2024-10-22.parquet size: 576 KB rows: 21,442
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-10-22 04:00:00 | SPY | ETF | 582.78 | 582.78 | 581.72 | 582.29 | 16950.0 |
| 2024-10-22 05:00:00 | SPY | ETF | 581.65 | 581.74 | 580.56 | 580.76 | 49930.0 |
| 2024-10-22 06:00:00 | SPY | ETF | 580.77 | 581.29 | 580.63 | 580.88 | 47822.0 |
| 2024-10-22 07:00:00 | SPY | ETF | 580.9 | 581.49 | 580.88 | 581.12 | 141267.0 |
| 2024-10-22 08:00:00 | SPY | ETF | 580.97 | 582.89 | 580.31 | 580.93 | 340957.0 |
| 2024-10-22 09:00:00 | SPY | ETF | 580.92 | 581.5 | 580.05 | 581.32 | 3177749.0 |
| 2024-10-22 10:00:00 | SPY | ETF | 581.33 | 582.24 | 581.02 | 581.99 | 2923091.0 |
| 2024-10-22 11:00:00 | SPY | ETF | 581.985 | 582.5 | 581.54 | 582.02 | 1803767.0 |
| 2024-10-22 12:00:00 | SPY | ETF | 582.01 | 582.6592 | 581.57 | 582.5601 | 1674458.0 |
| 2024-10-22 13:00:00 | SPY | ETF | 582.57 | 583.98 | 582.28 | 583.98 | 2067047.0 |
| 2024-10-22 14:00:00 | SPY | ETF | 583.96 | 584.5 | 582.85 | 583.0201 | 2642568.0 |
| 2024-10-22 15:00:00 | SPY | ETF | 583.01 | 584.26 | 582.89 | 583.32 | 4883944.0 |
| 2024-10-22 16:00:00 | SPY | ETF | 583.32 | 583.4 | 582.8 | 582.8 | 3483766.0 |
| 2024-10-22 17:00:00 | SPY | ETF | 582.83 | 583.32 | 582.78 | 582.95 | 451746.0 |
| 2024-10-22 18:00:00 | SPY | ETF | 582.92 | 582.92 | 582.28 | 582.48 | 84394.0 |
| 2024-10-22 19:00:00 | SPY | ETF | 582.55 | 583.12 | 582.45 | 583.07 | 31675.0 |
| 2024-10-22 04:00:00 | QQQ | ETF | 494.5 | 494.5 | 493.48 | 493.5 | 36092.0 |
| 2024-10-22 05:00:00 | QQQ | ETF | 493.33 | 493.39 | 492.1 | 492.37 | 91047.0 |
| 2024-10-22 06:00:00 | QQQ | ETF | 492.31 | 492.95 | 492.09 | 492.55 | 47962.0 |
| 2024-10-22 07:00:00 | QQQ | ETF | 492.55 | 493.47 | 492.55 | 492.93 | 392618.0 |
| 2024-10-22 08:00:00 | QQQ | ETF | 492.82 | 494.6 | 491.74 | 492.56 | 517124.0 |
| 2024-10-22 09:00:00 | QQQ | ETF | 492.55 | 494.57 | 491.81 | 494.11 | 3377296.0 |
| 2024-10-22 10:00:00 | QQQ | ETF | 494.186 | 495.5 | 493.63 | 494.87 | 3047435.0 |
| 2024-10-22 11:00:00 | QQQ | ETF | 494.87 | 495.31 | 494.0 | 494.4075 | 1545213.0 |
| 2024-10-22 12:00:00 | QQQ | ETF | 494.3902 | 495.11 | 493.27 | 494.99 | 2566159.0 |
| 2024-10-22 13:00:00 | QQQ | ETF | 494.99 | 496.855 | 494.57 | 496.81 | 2798279.0 |
| 2024-10-22 14:00:00 | QQQ | ETF | 496.81 | 497.445 | 495.36 | 495.555 | 2934744.0 |
| 2024-10-22 15:00:00 | QQQ | ETF | 495.44 | 496.74 | 495.4113 | 496.03 | 3168108.0 |
| 2024-10-22 16:00:00 | QQQ | ETF | 495.98 | 496.03 | 495.23 | 495.5 | 832058.0 |
| 2024-10-22 17:00:00 | QQQ | ETF | 495.49 | 495.63 | 495.41 | 495.5 | 24355.0 |
| 2024-10-22 18:00:00 | QQQ | ETF | 495.45 | 495.45 | 494.87 | 495.12 | 45042.0 |
| 2024-10-22 19:00:00 | QQQ | ETF | 495.2 | 495.81 | 495.06 | 495.75 | 32539.0 |
| 2024-10-22 04:00:00 | IWM | ETF | 221.23 | 221.24 | 220.81 | 220.88 | 26240.0 |
| 2024-10-22 05:00:00 | IWM | ETF | 220.78 | 220.8 | 220.11 | 220.27 | 43949.0 |
| 2024-10-22 06:00:00 | IWM | ETF | 220.36 | 220.68 | 220.24 | 220.51 | 68115.0 |
| 2024-10-22 07:00:00 | IWM | ETF | 220.54 | 220.99 | 220.42 | 220.5 | 86545.0 |
| 2024-10-22 08:00:00 | IWM | ETF | 220.5394 | 221.54 | 220.476 | 221.21 | 196974.0 |
| 2024-10-22 09:00:00 | IWM | ETF | 221.15 | 221.83 | 220.8002 | 220.99 | 1918888.0 |
| 2024-10-22 10:00:00 | IWM | ETF | 220.9925 | 221.47 | 220.3 | 221.22 | 2290011.0 |
| 2024-10-22 11:00:00 | IWM | ETF | 221.225 | 221.4 | 220.86 | 220.98 | 1333102.0 |
| 2024-10-22 12:00:00 | IWM | ETF | 220.98 | 221.22 | 220.67 | 221.11 | 1270392.0 |
| 2024-10-22 13:00:00 | IWM | ETF | 221.11 | 221.64 | 221.09 | 221.55 | 777175.0 |
| 2024-10-22 14:00:00 | IWM | ETF | 221.54 | 221.71 | 221.15 | 221.22 | 1192094.0 |
| 2024-10-22 15:00:00 | IWM | ETF | 221.22 | 221.46 | 221.18 | 221.23 | 1984737.0 |
| 2024-10-22 16:00:00 | IWM | ETF | 221.23 | 221.26 | 220.88 | 220.88 | 891606.0 |
| 2024-10-22 17:00:00 | IWM | ETF | 220.98 | 221.26 | 220.9 | 220.92 | 18715.0 |
| 2024-10-22 18:00:00 | IWM | ETF | 221.0 | 221.04 | 220.82 | 220.956 | 2838.0 |
| 2024-10-22 19:00:00 | IWM | ETF | 221.04 | 221.3697 | 220.97 | 221.33 | 16467.0 |
| 2024-10-22 04:00:00 | DIA | ETF | 428.44 | 428.58 | 428.09 | 428.36 | 4594.0 |
| 2024-10-22 05:00:00 | DIA | ETF | 428.15 | 428.2 | 427.23 | 427.23 | 5450.0 |
> showing 50 of 21,442 rows — these rows as CSV