PREVIEW / etf_5min / 2022-02-04
file: by_date/etf_5min/2022/2022-02-04.parquet size: 2.0 MB rows: 95,186
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-04 04:00:00 | SPY | ETF | 450.19 | 450.58 | 450.15 | 450.26 | 9394.0 |
| 2022-02-04 04:05:00 | SPY | ETF | 450.29 | 450.33 | 450.0 | 450.05 | 13368.0 |
| 2022-02-04 04:10:00 | SPY | ETF | 449.99 | 450.14 | 449.82 | 450.14 | 1415.0 |
| 2022-02-04 04:15:00 | SPY | ETF | 450.18 | 450.25 | 449.92 | 449.92 | 1420.0 |
| 2022-02-04 04:20:00 | SPY | ETF | 449.93 | 449.93 | 449.6 | 449.69 | 600.0 |
| 2022-02-04 04:25:00 | SPY | ETF | 449.64 | 450.15 | 449.5 | 449.89 | 8222.0 |
| 2022-02-04 04:30:00 | SPY | ETF | 449.95 | 449.95 | 449.84 | 449.84 | 2099.0 |
| 2022-02-04 04:35:00 | SPY | ETF | 450.39 | 450.49 | 450.39 | 450.44 | 1234.0 |
| 2022-02-04 04:40:00 | SPY | ETF | 450.01 | 450.01 | 449.74 | 449.74 | 400.0 |
| 2022-02-04 04:45:00 | SPY | ETF | 450.22 | 450.22 | 450.22 | 450.22 | 2000.0 |
| 2022-02-04 04:55:00 | SPY | ETF | 449.95 | 449.95 | 449.83 | 449.83 | 700.0 |
| 2022-02-04 05:00:00 | SPY | ETF | 449.5 | 449.57 | 449.31 | 449.4 | 3711.0 |
| 2022-02-04 05:05:00 | SPY | ETF | 449.2 | 449.27 | 449.0 | 449.0 | 2134.0 |
| 2022-02-04 05:10:00 | SPY | ETF | 449.03 | 449.05 | 448.67 | 448.68 | 3311.0 |
| 2022-02-04 05:15:00 | SPY | ETF | 448.78 | 448.78 | 448.35 | 448.5 | 1100.0 |
| 2022-02-04 05:20:00 | SPY | ETF | 448.16 | 448.3 | 447.75 | 447.83 | 4070.0 |
| 2022-02-04 05:25:00 | SPY | ETF | 447.86 | 448.26 | 447.86 | 447.97 | 7090.0 |
| 2022-02-04 05:30:00 | SPY | ETF | 447.82 | 447.82 | 447.03 | 447.51 | 8487.0 |
| 2022-02-04 05:35:00 | SPY | ETF | 447.6 | 447.8 | 447.36 | 447.66 | 9347.0 |
| 2022-02-04 05:40:00 | SPY | ETF | 447.56 | 447.71 | 447.32 | 447.41 | 5524.0 |
| 2022-02-04 05:45:00 | SPY | ETF | 447.6 | 447.6 | 447.05 | 447.27 | 7535.0 |
| 2022-02-04 05:50:00 | SPY | ETF | 447.36 | 447.7 | 447.34 | 447.36 | 2335.0 |
| 2022-02-04 05:55:00 | SPY | ETF | 447.42 | 447.66 | 446.98 | 447.66 | 34685.0 |
| 2022-02-04 06:00:00 | SPY | ETF | 447.36 | 447.66 | 446.99 | 447.19 | 8803.0 |
| 2022-02-04 06:05:00 | SPY | ETF | 447.03 | 447.09 | 446.37 | 446.53 | 5343.0 |
| 2022-02-04 06:10:00 | SPY | ETF | 446.38 | 446.38 | 445.96 | 446.1 | 34807.0 |
| 2022-02-04 06:15:00 | SPY | ETF | 446.0 | 446.27 | 445.95 | 446.1 | 18756.0 |
| 2022-02-04 06:20:00 | SPY | ETF | 446.06 | 446.1 | 445.33 | 445.61 | 20850.0 |
| 2022-02-04 06:25:00 | SPY | ETF | 445.65 | 446.5 | 445.65 | 446.25 | 28639.0 |
| 2022-02-04 06:30:00 | SPY | ETF | 446.11 | 446.5 | 446.09 | 446.24 | 18390.0 |
| 2022-02-04 06:35:00 | SPY | ETF | 446.16 | 446.87 | 446.06 | 446.69 | 15825.0 |
| 2022-02-04 06:40:00 | SPY | ETF | 446.58 | 446.58 | 446.26 | 446.4 | 2599.0 |
| 2022-02-04 06:45:00 | SPY | ETF | 446.2 | 446.2 | 445.71 | 445.74 | 8632.0 |
| 2022-02-04 06:50:00 | SPY | ETF | 445.8 | 445.8 | 445.44 | 445.46 | 14001.0 |
| 2022-02-04 06:55:00 | SPY | ETF | 445.63 | 445.75 | 445.2 | 445.2 | 20299.0 |
| 2022-02-04 07:00:00 | SPY | ETF | 445.21 | 446.02 | 445.21 | 445.93 | 91082.0 |
| 2022-02-04 07:05:00 | SPY | ETF | 445.91 | 446.06 | 445.62 | 446.06 | 23648.0 |
| 2022-02-04 07:10:00 | SPY | ETF | 445.95 | 446.02 | 445.46 | 445.46 | 27845.0 |
| 2022-02-04 07:15:00 | SPY | ETF | 445.65 | 446.07 | 445.48 | 445.94 | 30035.0 |
| 2022-02-04 07:20:00 | SPY | ETF | 445.94 | 446.37 | 445.84 | 446.23 | 50324.0 |
| 2022-02-04 07:25:00 | SPY | ETF | 446.2 | 446.6 | 446.2 | 446.57 | 87552.0 |
| 2022-02-04 07:30:00 | SPY | ETF | 446.61 | 446.63 | 446.25 | 446.5 | 32073.0 |
| 2022-02-04 07:35:00 | SPY | ETF | 446.41 | 446.73 | 446.39 | 446.64 | 80712.0 |
| 2022-02-04 07:40:00 | SPY | ETF | 446.64 | 446.66 | 446.35 | 446.6 | 33832.0 |
| 2022-02-04 07:45:00 | SPY | ETF | 446.66 | 447.44 | 446.63 | 447.42 | 102017.0 |
| 2022-02-04 07:50:00 | SPY | ETF | 447.42 | 447.77 | 447.2 | 447.57 | 143313.0 |
| 2022-02-04 07:55:00 | SPY | ETF | 447.59 | 447.92 | 447.5 | 447.58 | 83415.0 |
| 2022-02-04 08:00:00 | SPY | ETF | 445.8299 | 452.04 | 445.41 | 447.06 | 129983.0 |
| 2022-02-04 08:05:00 | SPY | ETF | 447.05 | 447.2 | 446.94 | 447.1 | 29728.0 |
| 2022-02-04 08:10:00 | SPY | ETF | 447.1 | 447.44 | 446.9 | 447.38 | 38768.0 |
> showing 50 of 95,186 rows — these rows as CSV