PREVIEW / etf_1hour / 2024-11-15
file: by_date/etf_1hour/2024/2024-11-15.parquet size: 602 KB rows: 22,385
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-11-15 04:00:00 | SPY | ETF | 590.35 | 590.49 | 589.88 | 590.03 | 31701.0 |
| 2024-11-15 05:00:00 | SPY | ETF | 590.04 | 590.27 | 589.71 | 590.22 | 43951.0 |
| 2024-11-15 06:00:00 | SPY | ETF | 590.22 | 590.77 | 590.22 | 590.75 | 90766.0 |
| 2024-11-15 07:00:00 | SPY | ETF | 590.68 | 591.36 | 590.67 | 591.36 | 207990.0 |
| 2024-11-15 08:00:00 | SPY | ETF | 590.7 | 592.23 | 589.18 | 590.326 | 394660.0 |
| 2024-11-15 09:00:00 | SPY | ETF | 590.41 | 590.49 | 588.46 | 588.66 | 5022723.0 |
| 2024-11-15 10:00:00 | SPY | ETF | 588.66 | 588.74 | 586.04 | 586.43 | 5638126.0 |
| 2024-11-15 11:00:00 | SPY | ETF | 586.4 | 587.38 | 585.47 | 585.7787 | 3894380.0 |
| 2024-11-15 12:00:00 | SPY | ETF | 585.7793 | 585.95 | 584.64 | 585.46 | 3411329.0 |
| 2024-11-15 13:00:00 | SPY | ETF | 585.465 | 585.67 | 583.86 | 584.5 | 3168556.0 |
| 2024-11-15 14:00:00 | SPY | ETF | 584.5 | 585.7799 | 584.03 | 584.97 | 3773952.0 |
| 2024-11-15 15:00:00 | SPY | ETF | 584.96 | 586.2299 | 584.73 | 585.7 | 7679205.0 |
| 2024-11-15 16:00:00 | SPY | ETF | 585.72 | 586.52 | 585.62 | 586.04 | 3757921.0 |
| 2024-11-15 17:00:00 | SPY | ETF | 586.05 | 586.08 | 585.642 | 585.79 | 916664.0 |
| 2024-11-15 18:00:00 | SPY | ETF | 585.79 | 585.99 | 585.7 | 585.95 | 59956.0 |
| 2024-11-15 19:00:00 | SPY | ETF | 585.99 | 586.24 | 585.88 | 586.2 | 29895.0 |
| 2024-11-15 04:00:00 | QQQ | ETF | 505.28 | 505.28 | 504.22 | 504.47 | 97976.0 |
| 2024-11-15 05:00:00 | QQQ | ETF | 504.48 | 504.71 | 504.1 | 504.62 | 118987.0 |
| 2024-11-15 06:00:00 | QQQ | ETF | 504.63 | 505.28 | 504.58 | 505.08 | 122833.0 |
| 2024-11-15 07:00:00 | QQQ | ETF | 505.07 | 505.55 | 504.91 | 505.48 | 169879.0 |
| 2024-11-15 08:00:00 | QQQ | ETF | 505.03 | 506.94 | 503.78 | 504.18 | 341945.0 |
| 2024-11-15 09:00:00 | QQQ | ETF | 504.27 | 504.31 | 501.04 | 501.31 | 4746741.0 |
| 2024-11-15 10:00:00 | QQQ | ETF | 501.34 | 501.48 | 497.76 | 498.18 | 5175934.0 |
| 2024-11-15 11:00:00 | QQQ | ETF | 498.19 | 498.93 | 496.28 | 496.62 | 3790859.0 |
| 2024-11-15 12:00:00 | QQQ | ETF | 496.625 | 497.06 | 495.47 | 496.37 | 3420016.0 |
| 2024-11-15 13:00:00 | QQQ | ETF | 496.37 | 496.53 | 494.49 | 495.06 | 2647881.0 |
| 2024-11-15 14:00:00 | QQQ | ETF | 495.07 | 496.62 | 494.825 | 495.8109 | 3087731.0 |
| 2024-11-15 15:00:00 | QQQ | ETF | 495.7779 | 496.96 | 495.53 | 496.46 | 4610023.0 |
| 2024-11-15 16:00:00 | QQQ | ETF | 496.47 | 497.17 | 496.43 | 496.75 | 1933944.0 |
| 2024-11-15 17:00:00 | QQQ | ETF | 496.76 | 497.0 | 496.69 | 496.8 | 71314.0 |
| 2024-11-15 18:00:00 | QQQ | ETF | 496.84 | 496.97 | 496.71 | 496.96 | 29693.0 |
| 2024-11-15 19:00:00 | QQQ | ETF | 496.93 | 497.1 | 496.89 | 497.0 | 23621.0 |
| 2024-11-15 04:00:00 | IWM | ETF | 232.05 | 232.05 | 230.71 | 230.8 | 17142.0 |
| 2024-11-15 05:00:00 | IWM | ETF | 230.73 | 231.45 | 230.69 | 231.42 | 58771.0 |
| 2024-11-15 06:00:00 | IWM | ETF | 231.36 | 231.99 | 231.36 | 231.8 | 123946.0 |
| 2024-11-15 07:00:00 | IWM | ETF | 231.8 | 232.23 | 231.72 | 232.23 | 124877.0 |
| 2024-11-15 08:00:00 | IWM | ETF | 231.9007 | 232.66 | 230.26 | 231.95 | 406310.0 |
| 2024-11-15 09:00:00 | IWM | ETF | 231.99 | 232.33 | 230.51 | 230.6 | 2646800.0 |
| 2024-11-15 10:00:00 | IWM | ETF | 230.59 | 230.62 | 228.63 | 228.9 | 3904486.0 |
| 2024-11-15 11:00:00 | IWM | ETF | 228.85 | 230.12 | 228.73 | 229.54 | 2620469.0 |
| 2024-11-15 12:00:00 | IWM | ETF | 229.55 | 229.62 | 228.39 | 228.62 | 1947855.0 |
| 2024-11-15 13:00:00 | IWM | ETF | 228.62 | 228.85 | 227.82 | 228.08 | 1779538.0 |
| 2024-11-15 14:00:00 | IWM | ETF | 228.075 | 228.65 | 227.81 | 228.27 | 2133661.0 |
| 2024-11-15 15:00:00 | IWM | ETF | 228.265 | 228.87 | 228.17 | 228.48 | 4928988.0 |
| 2024-11-15 16:00:00 | IWM | ETF | 228.48 | 228.9185 | 228.48 | 228.91 | 2017294.0 |
| 2024-11-15 17:00:00 | IWM | ETF | 228.9183 | 228.9183 | 228.45 | 228.5 | 41316.0 |
| 2024-11-15 18:00:00 | IWM | ETF | 228.5101 | 228.75 | 228.5001 | 228.72 | 5546.0 |
| 2024-11-15 19:00:00 | IWM | ETF | 228.74 | 228.99 | 228.6192 | 228.89 | 16827.0 |
| 2024-11-15 04:00:00 | DIA | ETF | 435.93 | 435.93 | 435.7 | 435.7 | 1653.0 |
| 2024-11-15 05:00:00 | DIA | ETF | 435.78 | 435.78 | 435.5 | 435.65 | 1700.0 |
> showing 50 of 22,385 rows — these rows as CSV