PREVIEW / etf_1hour / 2024-11-19
file: by_date/etf_1hour/2024/2024-11-19.parquet size: 598 KB rows: 22,481
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-19 04:00:00 | SPY | ETF | 588.4 | 588.4 | 584.63 | 585.43 | 80968.0 |
| 2024-11-19 05:00:00 | SPY | ETF | 585.7 | 586.4 | 585.2 | 585.93 | 28073.0 |
| 2024-11-19 06:00:00 | SPY | ETF | 586.01 | 586.22 | 585.35 | 585.81 | 55516.0 |
| 2024-11-19 07:00:00 | SPY | ETF | 586.03 | 587.06 | 585.93 | 587.04 | 97843.0 |
| 2024-11-19 08:00:00 | SPY | ETF | 587.0 | 589.35 | 582.45 | 582.59 | 624796.0 |
| 2024-11-19 09:00:00 | SPY | ETF | 582.6 | 585.7996 | 581.901 | 585.2501 | 4101692.0 |
| 2024-11-19 10:00:00 | SPY | ETF | 585.25 | 588.09 | 584.645 | 587.73 | 3930659.0 |
| 2024-11-19 11:00:00 | SPY | ETF | 587.73 | 589.24 | 587.65 | 588.829 | 2936583.0 |
| 2024-11-19 12:00:00 | SPY | ETF | 588.83 | 589.5399 | 588.03 | 589.17 | 2021361.0 |
| 2024-11-19 13:00:00 | SPY | ETF | 589.18 | 591.045 | 588.76 | 590.9 | 2521409.0 |
| 2024-11-19 14:00:00 | SPY | ETF | 590.9 | 590.98 | 589.09 | 589.63 | 3849292.0 |
| 2024-11-19 15:00:00 | SPY | ETF | 589.63 | 590.6 | 589.365 | 590.29 | 5443609.0 |
| 2024-11-19 16:00:00 | SPY | ETF | 590.28 | 590.8 | 590.2 | 590.24 | 2327374.0 |
| 2024-11-19 17:00:00 | SPY | ETF | 590.15 | 590.2199 | 590.0 | 590.12 | 54688.0 |
| 2024-11-19 18:00:00 | SPY | ETF | 590.12 | 590.91 | 590.1 | 590.869 | 50797.0 |
| 2024-11-19 19:00:00 | SPY | ETF | 590.91 | 591.74 | 590.89 | 591.39 | 42804.0 |
| 2024-11-19 04:00:00 | QQQ | ETF | 499.98 | 500.45 | 496.75 | 497.88 | 151663.0 |
| 2024-11-19 05:00:00 | QQQ | ETF | 498.0 | 499.09 | 497.66 | 498.85 | 51693.0 |
| 2024-11-19 06:00:00 | QQQ | ETF | 498.83 | 498.97 | 497.82 | 498.86 | 46541.0 |
| 2024-11-19 07:00:00 | QQQ | ETF | 498.86 | 499.88 | 498.76 | 499.69 | 137497.0 |
| 2024-11-19 08:00:00 | QQQ | ETF | 499.78 | 501.2 | 494.9 | 495.04 | 444731.0 |
| 2024-11-19 09:00:00 | QQQ | ETF | 494.98 | 499.0 | 494.11 | 498.2301 | 2828086.0 |
| 2024-11-19 10:00:00 | QQQ | ETF | 498.19 | 500.7 | 497.52 | 500.2593 | 2267066.0 |
| 2024-11-19 11:00:00 | QQQ | ETF | 500.25 | 501.74 | 500.22 | 501.019 | 2221240.0 |
| 2024-11-19 12:00:00 | QQQ | ETF | 501.02 | 501.9499 | 500.39 | 501.62 | 1210891.0 |
| 2024-11-19 13:00:00 | QQQ | ETF | 501.62 | 503.9536 | 501.26 | 503.76 | 1857641.0 |
| 2024-11-19 14:00:00 | QQQ | ETF | 503.77 | 503.925 | 501.99 | 502.7023 | 2036560.0 |
| 2024-11-19 15:00:00 | QQQ | ETF | 502.71 | 503.7 | 502.4699 | 503.39 | 2618038.0 |
| 2024-11-19 16:00:00 | QQQ | ETF | 503.39 | 503.97 | 503.12 | 503.12 | 665559.0 |
| 2024-11-19 17:00:00 | QQQ | ETF | 503.19 | 503.29 | 503.01 | 503.19 | 35182.0 |
| 2024-11-19 18:00:00 | QQQ | ETF | 503.09 | 503.85 | 503.07 | 503.73 | 71708.0 |
| 2024-11-19 19:00:00 | QQQ | ETF | 503.81 | 504.95 | 503.8 | 504.54 | 89416.0 |
| 2024-11-19 04:00:00 | IWM | ETF | 228.91 | 229.1 | 226.29 | 226.45 | 116737.0 |
| 2024-11-19 05:00:00 | IWM | ETF | 226.54 | 226.86 | 226.0 | 226.47 | 47472.0 |
| 2024-11-19 06:00:00 | IWM | ETF | 226.6 | 227.1 | 226.25 | 227.1 | 142530.0 |
| 2024-11-19 07:00:00 | IWM | ETF | 227.2 | 228.05 | 227.09 | 228.04 | 136692.0 |
| 2024-11-19 08:00:00 | IWM | ETF | 227.63 | 229.45 | 225.81 | 225.95 | 281345.0 |
| 2024-11-19 09:00:00 | IWM | ETF | 225.95 | 227.64 | 225.58 | 227.43 | 2404436.0 |
| 2024-11-19 10:00:00 | IWM | ETF | 227.42 | 228.86 | 226.81 | 228.6 | 2323154.0 |
| 2024-11-19 11:00:00 | IWM | ETF | 228.58 | 229.68 | 228.4 | 229.5861 | 2009353.0 |
| 2024-11-19 12:00:00 | IWM | ETF | 229.585 | 229.88 | 229.11 | 229.35 | 1661557.0 |
| 2024-11-19 13:00:00 | IWM | ETF | 229.35 | 230.36 | 229.12 | 230.34 | 1269945.0 |
| 2024-11-19 14:00:00 | IWM | ETF | 230.33 | 230.535 | 229.71 | 229.8899 | 1769396.0 |
| 2024-11-19 15:00:00 | IWM | ETF | 229.9 | 230.82 | 229.68 | 230.64 | 4030795.0 |
| 2024-11-19 16:00:00 | IWM | ETF | 230.63 | 230.9 | 230.56 | 230.6 | 1248576.0 |
| 2024-11-19 17:00:00 | IWM | ETF | 230.59 | 230.65 | 230.38 | 230.44 | 30606.0 |
| 2024-11-19 18:00:00 | IWM | ETF | 230.52 | 231.24 | 230.52 | 231.12 | 39973.0 |
| 2024-11-19 19:00:00 | IWM | ETF | 231.12 | 231.5 | 231.12 | 231.25 | 33322.0 |
| 2024-11-19 04:00:00 | DIA | ETF | 433.83 | 433.89 | 431.56 | 431.69 | 2782.0 |
| 2024-11-19 05:00:00 | DIA | ETF | 431.76 | 431.99 | 431.35 | 431.89 | 2727.0 |
> showing 50 of 22,481 rows — these rows as CSV