PREVIEW / etf_1hour / 2024-11-22
file: by_date/etf_1hour/2024/2024-11-22.parquet size: 602 KB rows: 22,429
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-22 04:00:00 | SPY | ETF | 593.74 | 593.74 | 591.1 | 592.52 | 33256.0 |
| 2024-11-22 05:00:00 | SPY | ETF | 592.43 | 592.48 | 591.06 | 592.15 | 72919.0 |
| 2024-11-22 06:00:00 | SPY | ETF | 591.95 | 592.77 | 591.68 | 592.73 | 14412.0 |
| 2024-11-22 07:00:00 | SPY | ETF | 592.86 | 593.62 | 592.81 | 593.55 | 133262.0 |
| 2024-11-22 08:00:00 | SPY | ETF | 593.05 | 594.15 | 592.72 | 593.38 | 244350.0 |
| 2024-11-22 09:00:00 | SPY | ETF | 593.38 | 596.131 | 593.17 | 595.97 | 4240407.0 |
| 2024-11-22 10:00:00 | SPY | ETF | 595.94 | 596.01 | 593.1526 | 595.76 | 3194125.0 |
| 2024-11-22 11:00:00 | SPY | ETF | 595.79 | 595.8965 | 593.71 | 595.04 | 2060403.0 |
| 2024-11-22 12:00:00 | SPY | ETF | 595.05 | 595.88 | 594.66 | 595.7299 | 1786797.0 |
| 2024-11-22 13:00:00 | SPY | ETF | 595.69 | 596.15 | 594.9001 | 595.43 | 1716179.0 |
| 2024-11-22 14:00:00 | SPY | ETF | 595.44 | 595.63 | 594.15 | 595.3999 | 1992739.0 |
| 2024-11-22 15:00:00 | SPY | ETF | 595.39 | 596.1 | 594.17 | 595.48 | 5835453.0 |
| 2024-11-22 16:00:00 | SPY | ETF | 595.48 | 595.93 | 593.67 | 595.86 | 3036675.0 |
| 2024-11-22 17:00:00 | SPY | ETF | 595.89 | 596.32 | 595.86 | 596.25 | 91934.0 |
| 2024-11-22 18:00:00 | SPY | ETF | 596.25 | 596.75 | 596.0 | 596.45 | 123652.0 |
| 2024-11-22 19:00:00 | SPY | ETF | 596.39 | 596.49 | 596.35 | 596.45 | 27619.0 |
| 2024-11-22 04:00:00 | QQQ | ETF | 504.46 | 504.84 | 502.1 | 503.6 | 65950.0 |
| 2024-11-22 05:00:00 | QQQ | ETF | 503.48 | 503.52 | 502.11 | 503.4 | 66912.0 |
| 2024-11-22 06:00:00 | QQQ | ETF | 503.09 | 504.0 | 502.77 | 504.0 | 37258.0 |
| 2024-11-22 07:00:00 | QQQ | ETF | 503.9 | 504.67 | 503.89 | 504.58 | 69718.0 |
| 2024-11-22 08:00:00 | QQQ | ETF | 504.12 | 505.18 | 502.1796 | 504.22 | 237674.0 |
| 2024-11-22 09:00:00 | QQQ | ETF | 504.24 | 506.36 | 503.93 | 505.95 | 2162902.0 |
| 2024-11-22 10:00:00 | QQQ | ETF | 505.96 | 505.96 | 502.78 | 505.66 | 2764760.0 |
| 2024-11-22 11:00:00 | QQQ | ETF | 505.67 | 505.77 | 503.28 | 504.94 | 2211062.0 |
| 2024-11-22 12:00:00 | QQQ | ETF | 504.96 | 506.15 | 504.55 | 505.94 | 1813247.0 |
| 2024-11-22 13:00:00 | QQQ | ETF | 505.9 | 506.53 | 505.22 | 505.75 | 1418281.0 |
| 2024-11-22 14:00:00 | QQQ | ETF | 505.74 | 505.89 | 504.5 | 505.74 | 1453093.0 |
| 2024-11-22 15:00:00 | QQQ | ETF | 505.705 | 506.27 | 504.68 | 505.77 | 2791473.0 |
| 2024-11-22 16:00:00 | QQQ | ETF | 505.74 | 506.53 | 505.62 | 506.45 | 1183880.0 |
| 2024-11-22 17:00:00 | QQQ | ETF | 506.425 | 506.52 | 506.0 | 506.34 | 38354.0 |
| 2024-11-22 18:00:00 | QQQ | ETF | 506.2899 | 506.51 | 506.23 | 506.37 | 26237.0 |
| 2024-11-22 19:00:00 | QQQ | ETF | 506.37 | 506.7 | 506.36 | 506.66 | 17456.0 |
| 2024-11-22 04:00:00 | IWM | ETF | 235.31 | 235.33 | 234.25 | 235.26 | 26631.0 |
| 2024-11-22 05:00:00 | IWM | ETF | 235.19 | 235.27 | 234.44 | 235.02 | 18351.0 |
| 2024-11-22 06:00:00 | IWM | ETF | 234.99 | 235.32 | 234.59 | 235.32 | 22502.0 |
| 2024-11-22 07:00:00 | IWM | ETF | 235.24 | 235.88 | 235.11 | 235.66 | 99227.0 |
| 2024-11-22 08:00:00 | IWM | ETF | 235.4703 | 235.88 | 234.71 | 235.4 | 154267.0 |
| 2024-11-22 09:00:00 | IWM | ETF | 235.37 | 237.25 | 235.28 | 237.21 | 2235376.0 |
| 2024-11-22 10:00:00 | IWM | ETF | 237.18 | 237.64 | 236.25 | 237.635 | 2142935.0 |
| 2024-11-22 11:00:00 | IWM | ETF | 237.63 | 238.28 | 237.25 | 238.255 | 1556416.0 |
| 2024-11-22 12:00:00 | IWM | ETF | 238.26 | 238.73 | 237.95 | 238.49 | 1588264.0 |
| 2024-11-22 13:00:00 | IWM | ETF | 238.5 | 238.8 | 238.26 | 238.62 | 1089600.0 |
| 2024-11-22 14:00:00 | IWM | ETF | 238.61 | 239.235 | 238.48 | 238.77 | 1218075.0 |
| 2024-11-22 15:00:00 | IWM | ETF | 238.76 | 239.11 | 237.93 | 238.74 | 4621824.0 |
| 2024-11-22 16:00:00 | IWM | ETF | 238.77 | 239.23 | 238.71 | 239.14 | 1834564.0 |
| 2024-11-22 17:00:00 | IWM | ETF | 239.09 | 239.13 | 238.77 | 239.05 | 35334.0 |
| 2024-11-22 18:00:00 | IWM | ETF | 239.0 | 239.33 | 239.0 | 239.18 | 8559.0 |
| 2024-11-22 19:00:00 | IWM | ETF | 239.16 | 239.47 | 239.16 | 239.29 | 2535.0 |
| 2024-11-22 05:00:00 | DIA | ETF | 437.74 | 438.33 | 437.74 | 438.33 | 400.0 |
| 2024-11-22 06:00:00 | DIA | ETF | 438.26 | 438.37 | 437.9 | 438.37 | 760.0 |
> showing 50 of 22,429 rows — these rows as CSV