PREVIEW / etf_1hour / 2022-02-08
file: by_date/etf_1hour/2022/2022-02-08.parquet size: 443 KB rows: 15,781
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 |
|---|---|---|---|---|---|---|---|
| 2022-02-08 04:00:00 | SPY | ETF | 448.5 | 449.12 | 447.76 | 447.76 | 33539.0 |
| 2022-02-08 05:00:00 | SPY | ETF | 447.7 | 447.9 | 447.18 | 447.63 | 27117.0 |
| 2022-02-08 06:00:00 | SPY | ETF | 447.53 | 447.63 | 446.25 | 446.44 | 103675.0 |
| 2022-02-08 07:00:00 | SPY | ETF | 446.57 | 446.76 | 445.94 | 446.58 | 123725.0 |
| 2022-02-08 08:00:00 | SPY | ETF | 446.22 | 447.8996 | 446.0 | 446.86 | 472664.0 |
| 2022-02-08 09:00:00 | SPY | ETF | 446.8 | 447.47 | 446.06 | 446.43 | 6445798.0 |
| 2022-02-08 10:00:00 | SPY | ETF | 446.41 | 448.31 | 445.22 | 447.9 | 9300937.0 |
| 2022-02-08 11:00:00 | SPY | ETF | 447.92 | 450.26 | 447.87 | 450.07 | 8269180.0 |
| 2022-02-08 12:00:00 | SPY | ETF | 450.08 | 451.27 | 449.47 | 450.6 | 5924774.0 |
| 2022-02-08 13:00:00 | SPY | ETF | 450.6 | 450.645 | 449.621 | 450.3599 | 5443092.0 |
| 2022-02-08 14:00:00 | SPY | ETF | 450.36 | 450.83 | 448.17 | 448.71 | 7190610.0 |
| 2022-02-08 15:00:00 | SPY | ETF | 448.71 | 451.92 | 448.09 | 450.89 | 16054334.0 |
| 2022-02-08 16:00:00 | SPY | ETF | 450.89 | 451.68 | 450.67 | 451.38 | 4184911.0 |
| 2022-02-08 17:00:00 | SPY | ETF | 451.31 | 451.51 | 451.2 | 451.3 | 46510.0 |
| 2022-02-08 18:00:00 | SPY | ETF | 451.3 | 452.2 | 450.94 | 452.09 | 66710.0 |
| 2022-02-08 19:00:00 | SPY | ETF | 451.98 | 452.17 | 451.42 | 451.58 | 48682.0 |
| 2022-02-08 04:00:00 | QQQ | ETF | 355.65 | 356.39 | 355.16 | 355.37 | 54546.0 |
| 2022-02-08 05:00:00 | QQQ | ETF | 355.2 | 355.64 | 354.64 | 355.2 | 62236.0 |
| 2022-02-08 06:00:00 | QQQ | ETF | 354.93 | 355.53 | 353.94 | 354.26 | 96581.0 |
| 2022-02-08 07:00:00 | QQQ | ETF | 354.36 | 354.38 | 353.21 | 354.06 | 282553.0 |
| 2022-02-08 08:00:00 | QQQ | ETF | 354.1911 | 356.2104 | 353.3 | 354.28 | 433355.0 |
| 2022-02-08 09:00:00 | QQQ | ETF | 354.3 | 355.72 | 353.59 | 354.0999 | 6475801.0 |
| 2022-02-08 10:00:00 | QQQ | ETF | 354.08 | 356.63 | 352.8 | 356.15 | 8798053.0 |
| 2022-02-08 11:00:00 | QQQ | ETF | 356.14 | 358.52 | 356.1088 | 358.14 | 5855321.0 |
| 2022-02-08 12:00:00 | QQQ | ETF | 358.19 | 359.82 | 357.42 | 359.01 | 4646843.0 |
| 2022-02-08 13:00:00 | QQQ | ETF | 359.01 | 359.01 | 357.47 | 358.225 | 4384863.0 |
| 2022-02-08 14:00:00 | QQQ | ETF | 358.24 | 358.915 | 356.48 | 357.09 | 5277241.0 |
| 2022-02-08 15:00:00 | QQQ | ETF | 357.1 | 360.24 | 356.35 | 359.2 | 8673220.0 |
| 2022-02-08 16:00:00 | QQQ | ETF | 359.23 | 359.82 | 358.91 | 359.53 | 1164002.0 |
| 2022-02-08 17:00:00 | QQQ | ETF | 359.54 | 359.57 | 359.11 | 359.29 | 1413980.0 |
| 2022-02-08 18:00:00 | QQQ | ETF | 359.29 | 360.51 | 359.29 | 360.1896 | 263344.0 |
| 2022-02-08 19:00:00 | QQQ | ETF | 360.27 | 360.3396 | 359.57 | 359.76 | 165922.0 |
| 2022-02-08 04:00:00 | IWM | ETF | 200.14 | 200.82 | 200.01 | 200.01 | 27994.0 |
| 2022-02-08 05:00:00 | IWM | ETF | 200.08 | 200.16 | 199.65 | 199.86 | 6417.0 |
| 2022-02-08 06:00:00 | IWM | ETF | 199.91 | 199.91 | 199.03 | 199.31 | 18557.0 |
| 2022-02-08 07:00:00 | IWM | ETF | 199.34 | 199.52 | 199.07 | 199.31 | 45188.0 |
| 2022-02-08 08:00:00 | IWM | ETF | 199.27 | 200.2 | 199.1304 | 199.48 | 145123.0 |
| 2022-02-08 09:00:00 | IWM | ETF | 199.32 | 200.78 | 199.1 | 200.27 | 3083582.0 |
| 2022-02-08 10:00:00 | IWM | ETF | 200.25 | 201.765 | 199.36 | 201.6 | 3636943.0 |
| 2022-02-08 11:00:00 | IWM | ETF | 201.6 | 202.12 | 201.4 | 202.0 | 2639696.0 |
| 2022-02-08 12:00:00 | IWM | ETF | 202.015 | 202.6686 | 201.58 | 202.38 | 1985497.0 |
| 2022-02-08 13:00:00 | IWM | ETF | 202.36 | 202.53 | 201.95 | 202.36 | 1531420.0 |
| 2022-02-08 14:00:00 | IWM | ETF | 202.37 | 202.675 | 201.29 | 201.62 | 2156301.0 |
| 2022-02-08 15:00:00 | IWM | ETF | 201.63 | 203.12 | 201.2208 | 202.74 | 4570152.0 |
| 2022-02-08 16:00:00 | IWM | ETF | 202.73 | 203.13 | 202.6 | 202.86 | 1371414.0 |
| 2022-02-08 17:00:00 | IWM | ETF | 203.2 | 203.2 | 202.76 | 202.84 | 1516855.0 |
| 2022-02-08 18:00:00 | IWM | ETF | 202.84 | 203.41 | 202.76 | 203.34 | 63178.0 |
| 2022-02-08 19:00:00 | IWM | ETF | 203.35 | 203.46 | 203.01 | 203.07 | 51707.0 |
| 2022-02-08 04:00:00 | DIA | ETF | 351.81 | 352.44 | 351.81 | 352.43 | 3022.0 |
| 2022-02-08 06:00:00 | DIA | ETF | 351.04 | 351.19 | 350.97 | 350.97 | 5472.0 |
> showing 50 of 15,781 rows — these rows as CSV