PREVIEW / etf_30min / 2022-02-03
file: by_date/etf_30min/2022/2022-02-03.parquet size: 675 KB rows: 26,595
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-03 04:00:00 | SPY | ETF | 453.28 | 453.57 | 453.03 | 453.11 | 6245.0 |
| 2022-02-03 04:30:00 | SPY | ETF | 453.22 | 453.22 | 452.03 | 452.07 | 31690.0 |
| 2022-02-03 05:00:00 | SPY | ETF | 452.19 | 452.79 | 452.14 | 452.62 | 34966.0 |
| 2022-02-03 05:30:00 | SPY | ETF | 452.37 | 452.4 | 451.93 | 452.19 | 15337.0 |
| 2022-02-03 06:00:00 | SPY | ETF | 452.2 | 452.64 | 451.61 | 451.83 | 10523.0 |
| 2022-02-03 06:30:00 | SPY | ETF | 451.7 | 452.5 | 451.59 | 452.5 | 38023.0 |
| 2022-02-03 07:00:00 | SPY | ETF | 452.44 | 452.8 | 451.9 | 452.65 | 196637.0 |
| 2022-02-03 07:30:00 | SPY | ETF | 452.66 | 453.59 | 452.33 | 453.15 | 238913.0 |
| 2022-02-03 08:00:00 | SPY | ETF | 452.9 | 457.693 | 451.6896 | 452.5 | 345723.0 |
| 2022-02-03 08:30:00 | SPY | ETF | 452.67 | 452.9 | 450.71 | 450.78 | 473489.0 |
| 2022-02-03 09:00:00 | SPY | ETF | 450.75 | 451.3 | 450.37 | 451.0 | 543965.0 |
| 2022-02-03 09:30:00 | SPY | ETF | 450.95 | 452.34 | 450.0 | 450.27 | 11042298.0 |
| 2022-02-03 10:00:00 | SPY | ETF | 450.29 | 452.82 | 450.05 | 452.52 | 8143974.0 |
| 2022-02-03 10:30:00 | SPY | ETF | 452.515 | 452.92 | 451.44 | 451.98 | 4215961.0 |
| 2022-02-03 11:00:00 | SPY | ETF | 451.97 | 452.97 | 451.16 | 451.58 | 3875142.0 |
| 2022-02-03 11:30:00 | SPY | ETF | 451.58 | 451.74 | 450.17 | 450.21 | 3834968.0 |
| 2022-02-03 12:00:00 | SPY | ETF | 450.21 | 450.63 | 449.15 | 450.18 | 4673779.0 |
| 2022-02-03 12:30:00 | SPY | ETF | 450.17 | 450.62 | 449.23 | 449.91 | 3575979.0 |
| 2022-02-03 13:00:00 | SPY | ETF | 449.9199 | 450.4605 | 449.04 | 450.07 | 3787670.0 |
| 2022-02-03 13:30:00 | SPY | ETF | 450.065 | 450.7049 | 449.68 | 449.9728 | 2563230.0 |
| 2022-02-03 14:00:00 | SPY | ETF | 449.97 | 450.59 | 449.2614 | 449.56 | 2923826.0 |
| 2022-02-03 14:30:00 | SPY | ETF | 449.55 | 449.61 | 447.7 | 448.27 | 6008569.0 |
| 2022-02-03 15:00:00 | SPY | ETF | 448.265 | 449.37 | 447.56 | 448.61 | 6743830.0 |
| 2022-02-03 15:30:00 | SPY | ETF | 448.62 | 448.64 | 445.71 | 446.65 | 18391494.0 |
| 2022-02-03 16:00:00 | SPY | ETF | 446.68 | 451.35 | 446.4033 | 451.01 | 5164630.0 |
| 2022-02-03 16:30:00 | SPY | ETF | 451.04 | 452.0 | 450.98 | 451.65 | 504741.0 |
| 2022-02-03 17:00:00 | SPY | ETF | 451.83 | 451.99 | 446.6 | 450.85 | 99513.0 |
| 2022-02-03 17:30:00 | SPY | ETF | 450.78 | 452.0 | 450.72 | 451.2 | 195419.0 |
| 2022-02-03 18:00:00 | SPY | ETF | 451.24 | 451.89 | 450.78 | 451.43 | 210665.0 |
| 2022-02-03 18:30:00 | SPY | ETF | 446.6 | 451.82 | 446.6 | 451.39 | 48705.0 |
| 2022-02-03 19:00:00 | SPY | ETF | 451.45 | 451.85 | 451.25 | 451.45 | 9463.0 |
| 2022-02-03 19:30:00 | SPY | ETF | 451.5 | 451.5 | 451.07 | 451.29 | 59427.0 |
| 2022-02-03 04:00:00 | QQQ | ETF | 361.06 | 362.08 | 360.0 | 361.7 | 57242.0 |
| 2022-02-03 04:30:00 | QQQ | ETF | 361.73 | 361.81 | 360.46 | 360.62 | 42048.0 |
| 2022-02-03 05:00:00 | QQQ | ETF | 360.62 | 361.01 | 360.49 | 360.75 | 37316.0 |
| 2022-02-03 05:30:00 | QQQ | ETF | 360.79 | 360.99 | 360.3 | 360.37 | 19755.0 |
| 2022-02-03 06:00:00 | QQQ | ETF | 360.56 | 360.79 | 359.66 | 360.04 | 161039.0 |
| 2022-02-03 06:30:00 | QQQ | ETF | 360.11 | 360.99 | 359.93 | 360.76 | 106674.0 |
| 2022-02-03 07:00:00 | QQQ | ETF | 360.83 | 360.88 | 359.85 | 360.49 | 226518.0 |
| 2022-02-03 07:30:00 | QQQ | ETF | 360.58 | 361.55 | 360.31 | 361.02 | 327002.0 |
| 2022-02-03 08:00:00 | QQQ | ETF | 360.6401 | 368.766 | 359.8696 | 360.83 | 299390.0 |
| 2022-02-03 08:30:00 | QQQ | ETF | 360.89 | 361.34 | 358.3 | 358.5 | 633268.0 |
| 2022-02-03 09:00:00 | QQQ | ETF | 358.39 | 358.9 | 357.87 | 358.6 | 648359.0 |
| 2022-02-03 09:30:00 | QQQ | ETF | 358.58 | 360.86 | 357.89 | 358.7 | 10227412.0 |
| 2022-02-03 10:00:00 | QQQ | ETF | 358.7 | 361.6665 | 357.99 | 361.45 | 5937749.0 |
| 2022-02-03 10:30:00 | QQQ | ETF | 361.45 | 361.93 | 359.15 | 359.62 | 4615159.0 |
| 2022-02-03 11:00:00 | QQQ | ETF | 359.62 | 361.0 | 358.6215 | 359.06 | 3784444.0 |
| 2022-02-03 11:30:00 | QQQ | ETF | 359.07 | 359.28 | 357.6 | 357.66 | 3286384.0 |
| 2022-02-03 12:00:00 | QQQ | ETF | 357.67 | 358.17 | 356.74 | 357.9 | 3946950.0 |
| 2022-02-03 12:30:00 | QQQ | ETF | 357.89 | 358.3 | 357.01 | 357.67 | 2844941.0 |
> showing 50 of 26,595 rows — these rows as CSV