PREVIEW / etf_1hour / 2024-10-29
file: by_date/etf_1hour/2024/2024-10-29.parquet size: 583 KB rows: 21,748
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-29 04:00:00 | SPY | ETF | 581.19 | 581.56 | 580.21 | 581.2 | 31987.0 |
| 2024-10-29 05:00:00 | SPY | ETF | 581.11 | 581.11 | 580.61 | 580.93 | 19879.0 |
| 2024-10-29 06:00:00 | SPY | ETF | 580.99 | 580.99 | 580.46 | 580.76 | 14585.0 |
| 2024-10-29 07:00:00 | SPY | ETF | 580.65 | 580.7 | 580.01 | 580.08 | 69112.0 |
| 2024-10-29 08:00:00 | SPY | ETF | 580.24 | 581.52 | 579.49 | 579.66 | 322268.0 |
| 2024-10-29 09:00:00 | SPY | ETF | 579.67 | 580.06 | 578.43 | 579.97 | 3228820.0 |
| 2024-10-29 10:00:00 | SPY | ETF | 579.98 | 581.85 | 579.52 | 581.42 | 3658990.0 |
| 2024-10-29 11:00:00 | SPY | ETF | 581.42 | 581.61 | 580.55 | 581.39 | 1948198.0 |
| 2024-10-29 12:00:00 | SPY | ETF | 581.4 | 582.0699 | 580.83 | 581.99 | 2006922.0 |
| 2024-10-29 13:00:00 | SPY | ETF | 581.9962 | 582.77 | 581.51 | 581.97 | 2010421.0 |
| 2024-10-29 14:00:00 | SPY | ETF | 581.97 | 582.88 | 581.6801 | 582.41 | 2104976.0 |
| 2024-10-29 15:00:00 | SPY | ETF | 582.41 | 582.907 | 581.34 | 581.7 | 6444671.0 |
| 2024-10-29 16:00:00 | SPY | ETF | 581.705 | 582.91 | 581.45 | 582.33 | 2679978.0 |
| 2024-10-29 17:00:00 | SPY | ETF | 581.77 | 582.9 | 581.77 | 582.82 | 58180.0 |
| 2024-10-29 18:00:00 | SPY | ETF | 582.85 | 583.26 | 582.6 | 583.26 | 86639.0 |
| 2024-10-29 19:00:00 | SPY | ETF | 583.24 | 583.24 | 582.75 | 583.05 | 17362.0 |
| 2024-10-29 04:00:00 | QQQ | ETF | 496.18 | 496.58 | 495.21 | 496.21 | 75197.0 |
| 2024-10-29 05:00:00 | QQQ | ETF | 496.03 | 496.03 | 495.36 | 495.91 | 21045.0 |
| 2024-10-29 06:00:00 | QQQ | ETF | 495.86 | 495.99 | 495.35 | 495.9 | 46994.0 |
| 2024-10-29 07:00:00 | QQQ | ETF | 495.82 | 495.85 | 495.2 | 495.39 | 82639.0 |
| 2024-10-29 08:00:00 | QQQ | ETF | 495.39 | 496.65 | 494.5 | 495.22 | 136491.0 |
| 2024-10-29 09:00:00 | QQQ | ETF | 495.16 | 496.08 | 493.85 | 495.855 | 2072587.0 |
| 2024-10-29 10:00:00 | QQQ | ETF | 495.855 | 497.93 | 495.45 | 497.79 | 2761422.0 |
| 2024-10-29 11:00:00 | QQQ | ETF | 497.85 | 498.42 | 497.17 | 498.39 | 2557992.0 |
| 2024-10-29 12:00:00 | QQQ | ETF | 498.38 | 499.26 | 497.53 | 499.0 | 2454540.0 |
| 2024-10-29 13:00:00 | QQQ | ETF | 499.03 | 499.95 | 499.015 | 499.5899 | 2117080.0 |
| 2024-10-29 14:00:00 | QQQ | ETF | 499.59 | 500.6 | 499.3 | 500.11 | 1774513.0 |
| 2024-10-29 15:00:00 | QQQ | ETF | 500.1 | 501.35 | 499.79 | 500.14 | 4312581.0 |
| 2024-10-29 16:00:00 | QQQ | ETF | 500.14 | 501.7 | 499.5861 | 500.45 | 1356417.0 |
| 2024-10-29 17:00:00 | QQQ | ETF | 500.4994 | 501.65 | 500.3 | 501.1 | 197936.0 |
| 2024-10-29 18:00:00 | QQQ | ETF | 501.06 | 501.74 | 500.789 | 501.57 | 98030.0 |
| 2024-10-29 19:00:00 | QQQ | ETF | 501.53 | 501.61 | 500.99 | 501.47 | 113105.0 |
| 2024-10-29 04:00:00 | IWM | ETF | 222.81 | 222.96 | 222.14 | 222.39 | 38023.0 |
| 2024-10-29 05:00:00 | IWM | ETF | 222.5 | 222.5 | 222.04 | 222.18 | 8109.0 |
| 2024-10-29 06:00:00 | IWM | ETF | 222.22 | 222.22 | 221.72 | 221.91 | 55028.0 |
| 2024-10-29 07:00:00 | IWM | ETF | 221.88 | 222.3 | 221.83 | 222.0 | 51032.0 |
| 2024-10-29 08:00:00 | IWM | ETF | 221.9089 | 222.99 | 221.07 | 221.17 | 210363.0 |
| 2024-10-29 09:00:00 | IWM | ETF | 221.13 | 221.42 | 219.97 | 220.92 | 2472811.0 |
| 2024-10-29 10:00:00 | IWM | ETF | 220.91 | 221.59 | 220.5 | 221.19 | 2118802.0 |
| 2024-10-29 11:00:00 | IWM | ETF | 221.19 | 221.65 | 220.75 | 221.42 | 1078978.0 |
| 2024-10-29 12:00:00 | IWM | ETF | 221.42 | 221.6 | 220.7299 | 221.06 | 1497498.0 |
| 2024-10-29 13:00:00 | IWM | ETF | 221.07 | 221.73 | 221.01 | 221.49 | 1476215.0 |
| 2024-10-29 14:00:00 | IWM | ETF | 221.5 | 221.74 | 221.29 | 221.65 | 853615.0 |
| 2024-10-29 15:00:00 | IWM | ETF | 221.66 | 221.9 | 221.29 | 221.8 | 3108132.0 |
| 2024-10-29 16:00:00 | IWM | ETF | 221.74 | 222.13 | 221.6246 | 221.97 | 1230584.0 |
| 2024-10-29 17:00:00 | IWM | ETF | 221.91 | 222.02 | 221.9 | 221.93 | 16397.0 |
| 2024-10-29 18:00:00 | IWM | ETF | 221.84 | 221.98 | 221.67 | 221.95 | 43525.0 |
| 2024-10-29 19:00:00 | IWM | ETF | 221.99 | 221.99 | 221.75 | 221.88 | 43476.0 |
| 2024-10-29 04:00:00 | DIA | ETF | 423.82 | 424.18 | 423.82 | 424.18 | 2086.0 |
| 2024-10-29 06:00:00 | DIA | ETF | 423.7 | 423.7 | 423.61 | 423.61 | 2200.0 |
> showing 50 of 21,748 rows — these rows as CSV