PREVIEW / etf_1hour / 2024-10-25
file: by_date/etf_1hour/2024/2024-10-25.parquet size: 565 KB rows: 20,752
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-25 04:00:00 | SPY | ETF | 580.1 | 580.55 | 579.85 | 580.2 | 13015.0 |
| 2024-10-25 05:00:00 | SPY | ETF | 580.42 | 580.98 | 580.42 | 580.79 | 12019.0 |
| 2024-10-25 06:00:00 | SPY | ETF | 580.85 | 581.06 | 580.7 | 580.7 | 20049.0 |
| 2024-10-25 07:00:00 | SPY | ETF | 580.67 | 581.2 | 580.19 | 581.01 | 160298.0 |
| 2024-10-25 08:00:00 | SPY | ETF | 580.99 | 581.7 | 578.99 | 581.63 | 137150.0 |
| 2024-10-25 09:00:00 | SPY | ETF | 581.63 | 583.49 | 581.45 | 583.3 | 3853634.0 |
| 2024-10-25 10:00:00 | SPY | ETF | 583.3 | 584.46 | 582.99 | 583.46 | 4599756.0 |
| 2024-10-25 11:00:00 | SPY | ETF | 583.48 | 583.8404 | 581.7032 | 582.17 | 3299340.0 |
| 2024-10-25 12:00:00 | SPY | ETF | 582.17 | 582.8 | 581.8 | 582.03 | 1775661.0 |
| 2024-10-25 13:00:00 | SPY | ETF | 582.03 | 582.05 | 578.53 | 579.1899 | 4391928.0 |
| 2024-10-25 14:00:00 | SPY | ETF | 579.25 | 580.52 | 578.08 | 580.2 | 3127723.0 |
| 2024-10-25 15:00:00 | SPY | ETF | 580.2 | 580.2599 | 578.54 | 579.015 | 6847554.0 |
| 2024-10-25 16:00:00 | SPY | ETF | 579.02 | 580.843 | 578.45 | 578.58 | 3151388.0 |
| 2024-10-25 17:00:00 | SPY | ETF | 578.67 | 579.04 | 578.51 | 578.73 | 795849.0 |
| 2024-10-25 18:00:00 | SPY | ETF | 578.73 | 578.74 | 578.36 | 578.5 | 79871.0 |
| 2024-10-25 19:00:00 | SPY | ETF | 578.5 | 578.73 | 577.55 | 577.95 | 66648.0 |
| 2024-10-25 04:00:00 | QQQ | ETF | 493.89 | 494.0 | 492.98 | 493.39 | 45390.0 |
| 2024-10-25 05:00:00 | QQQ | ETF | 493.44 | 494.11 | 493.44 | 493.86 | 33430.0 |
| 2024-10-25 06:00:00 | QQQ | ETF | 493.85 | 494.04 | 493.64 | 493.64 | 26130.0 |
| 2024-10-25 07:00:00 | QQQ | ETF | 493.69 | 494.35 | 493.26 | 494.08 | 82160.0 |
| 2024-10-25 08:00:00 | QQQ | ETF | 493.4 | 495.23 | 492.18 | 495.171 | 237049.0 |
| 2024-10-25 09:00:00 | QQQ | ETF | 495.21 | 499.1 | 495.12 | 498.95 | 4752392.0 |
| 2024-10-25 10:00:00 | QQQ | ETF | 498.93 | 500.28 | 498.24 | 499.09 | 5292424.0 |
| 2024-10-25 11:00:00 | QQQ | ETF | 499.08 | 499.57 | 497.8501 | 498.2825 | 2902319.0 |
| 2024-10-25 12:00:00 | QQQ | ETF | 498.26 | 499.3 | 497.991 | 498.695 | 1767481.0 |
| 2024-10-25 13:00:00 | QQQ | ETF | 498.73 | 498.75 | 495.01 | 495.64 | 3792375.0 |
| 2024-10-25 14:00:00 | QQQ | ETF | 495.63 | 496.83 | 494.43 | 496.4791 | 2806988.0 |
| 2024-10-25 15:00:00 | QQQ | ETF | 496.41 | 496.425 | 494.94 | 495.28 | 3389136.0 |
| 2024-10-25 16:00:00 | QQQ | ETF | 495.29 | 495.45 | 494.71 | 494.77 | 1447804.0 |
| 2024-10-25 17:00:00 | QQQ | ETF | 494.86 | 495.32 | 494.75 | 494.9 | 136826.0 |
| 2024-10-25 18:00:00 | QQQ | ETF | 494.88 | 494.96 | 494.7 | 494.95 | 27525.0 |
| 2024-10-25 19:00:00 | QQQ | ETF | 494.81 | 494.81 | 493.78 | 494.45 | 60200.0 |
| 2024-10-25 04:00:00 | IWM | ETF | 220.4 | 220.77 | 220.32 | 220.68 | 8050.0 |
| 2024-10-25 05:00:00 | IWM | ETF | 220.71 | 221.13 | 220.71 | 220.99 | 11109.0 |
| 2024-10-25 06:00:00 | IWM | ETF | 221.01 | 221.17 | 220.6 | 220.63 | 20649.0 |
| 2024-10-25 07:00:00 | IWM | ETF | 220.6 | 220.75 | 220.44 | 220.63 | 18021.0 |
| 2024-10-25 08:00:00 | IWM | ETF | 220.6386 | 221.0 | 219.68 | 220.88 | 70077.0 |
| 2024-10-25 09:00:00 | IWM | ETF | 220.91 | 221.7 | 220.34 | 220.97 | 2058274.0 |
| 2024-10-25 10:00:00 | IWM | ETF | 220.99 | 221.97 | 220.76 | 220.88 | 2925046.0 |
| 2024-10-25 11:00:00 | IWM | ETF | 220.9 | 221.13 | 219.91 | 220.32 | 1778529.0 |
| 2024-10-25 12:00:00 | IWM | ETF | 220.31 | 220.56 | 219.955 | 219.985 | 1053183.0 |
| 2024-10-25 13:00:00 | IWM | ETF | 220.0 | 220.18 | 218.86 | 219.08 | 2134225.0 |
| 2024-10-25 14:00:00 | IWM | ETF | 219.075 | 219.525 | 218.52 | 219.32 | 1598121.0 |
| 2024-10-25 15:00:00 | IWM | ETF | 219.3 | 219.38 | 218.74 | 218.93 | 3231393.0 |
| 2024-10-25 16:00:00 | IWM | ETF | 218.89 | 220.0063 | 218.62 | 218.68 | 1138614.0 |
| 2024-10-25 17:00:00 | IWM | ETF | 218.87 | 218.89 | 218.74 | 218.89 | 12969.0 |
| 2024-10-25 18:00:00 | IWM | ETF | 218.75 | 218.89 | 218.65 | 218.75 | 11435.0 |
| 2024-10-25 19:00:00 | IWM | ETF | 218.75 | 218.85 | 217.98 | 218.24 | 12182.0 |
| 2024-10-25 05:00:00 | DIA | ETF | 424.43 | 424.43 | 424.43 | 424.43 | 100.0 |
| 2024-10-25 07:00:00 | DIA | ETF | 425.0 | 425.0 | 424.97 | 424.97 | 499.0 |
> showing 50 of 20,752 rows — these rows as CSV