PREVIEW / etf_5min / 2021-03-04
file: by_date/etf_5min/2021/2021-03-04.parquet size: 2.1 MB rows: 97,923
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-04 04:00:00 | SPY | ETF | 380.79 | 381.15 | 380.79 | 381.15 | 4325.0 |
| 2021-03-04 04:05:00 | SPY | ETF | 381.16 | 381.16 | 380.65 | 380.71 | 3651.0 |
| 2021-03-04 04:10:00 | SPY | ETF | 380.64 | 380.64 | 380.18 | 380.46 | 6050.0 |
| 2021-03-04 04:15:00 | SPY | ETF | 380.31 | 380.44 | 380.29 | 380.39 | 1260.0 |
| 2021-03-04 04:20:00 | SPY | ETF | 380.26 | 380.26 | 379.72 | 379.72 | 12935.0 |
| 2021-03-04 04:25:00 | SPY | ETF | 379.81 | 380.34 | 379.69 | 379.74 | 11427.0 |
| 2021-03-04 04:30:00 | SPY | ETF | 379.82 | 379.96 | 379.56 | 379.62 | 3750.0 |
| 2021-03-04 04:35:00 | SPY | ETF | 379.55 | 379.94 | 379.55 | 379.94 | 7399.0 |
| 2021-03-04 04:40:00 | SPY | ETF | 379.61 | 379.66 | 379.26 | 379.26 | 7930.0 |
| 2021-03-04 04:45:00 | SPY | ETF | 379.21 | 379.51 | 379.19 | 379.51 | 5011.0 |
| 2021-03-04 04:50:00 | SPY | ETF | 379.51 | 379.86 | 379.49 | 379.86 | 29450.0 |
| 2021-03-04 04:55:00 | SPY | ETF | 379.88 | 380.03 | 379.86 | 379.86 | 5903.0 |
| 2021-03-04 05:00:00 | SPY | ETF | 379.83 | 379.93 | 379.83 | 379.93 | 500.0 |
| 2021-03-04 05:05:00 | SPY | ETF | 380.0 | 380.01 | 379.41 | 379.44 | 5818.0 |
| 2021-03-04 05:10:00 | SPY | ETF | 379.51 | 379.51 | 379.26 | 379.26 | 562.0 |
| 2021-03-04 05:15:00 | SPY | ETF | 379.22 | 379.31 | 379.22 | 379.31 | 1725.0 |
| 2021-03-04 05:20:00 | SPY | ETF | 379.02 | 379.51 | 379.02 | 379.41 | 2445.0 |
| 2021-03-04 05:25:00 | SPY | ETF | 379.4 | 379.4 | 378.84 | 378.96 | 3988.0 |
| 2021-03-04 05:30:00 | SPY | ETF | 379.08 | 379.34 | 378.89 | 379.32 | 2599.0 |
| 2021-03-04 05:35:00 | SPY | ETF | 379.31 | 379.31 | 378.91 | 378.96 | 3600.0 |
| 2021-03-04 05:40:00 | SPY | ETF | 378.88 | 379.01 | 378.85 | 378.85 | 800.0 |
| 2021-03-04 05:45:00 | SPY | ETF | 378.8 | 379.12 | 378.8 | 379.02 | 5630.0 |
| 2021-03-04 05:50:00 | SPY | ETF | 379.04 | 379.34 | 379.04 | 379.34 | 27955.0 |
| 2021-03-04 05:55:00 | SPY | ETF | 379.44 | 379.61 | 379.32 | 379.6 | 29459.0 |
| 2021-03-04 06:00:00 | SPY | ETF | 379.32 | 379.62 | 379.27 | 379.62 | 855.0 |
| 2021-03-04 06:05:00 | SPY | ETF | 379.43 | 379.62 | 379.37 | 379.54 | 2400.0 |
| 2021-03-04 06:10:00 | SPY | ETF | 379.47 | 379.47 | 378.82 | 378.91 | 3400.0 |
| 2021-03-04 06:15:00 | SPY | ETF | 378.85 | 378.92 | 378.82 | 378.82 | 2810.0 |
| 2021-03-04 06:20:00 | SPY | ETF | 378.87 | 379.0 | 378.84 | 378.94 | 10689.0 |
| 2021-03-04 06:25:00 | SPY | ETF | 378.9 | 379.05 | 378.84 | 379.0 | 13465.0 |
| 2021-03-04 06:30:00 | SPY | ETF | 378.85 | 379.1 | 378.85 | 378.93 | 6416.0 |
| 2021-03-04 06:35:00 | SPY | ETF | 378.95 | 379.61 | 378.95 | 379.55 | 63350.0 |
| 2021-03-04 06:40:00 | SPY | ETF | 379.55 | 379.7 | 379.35 | 379.35 | 13100.0 |
| 2021-03-04 06:45:00 | SPY | ETF | 379.53 | 379.72 | 379.34 | 379.52 | 14207.0 |
| 2021-03-04 06:50:00 | SPY | ETF | 379.56 | 380.15 | 379.44 | 380.12 | 83901.0 |
| 2021-03-04 06:55:00 | SPY | ETF | 380.09 | 380.26 | 380.07 | 380.16 | 21996.0 |
| 2021-03-04 07:00:00 | SPY | ETF | 380.21 | 380.4 | 380.11 | 380.3 | 40107.0 |
| 2021-03-04 07:05:00 | SPY | ETF | 380.24 | 380.3 | 380.1 | 380.3 | 17498.0 |
| 2021-03-04 07:10:00 | SPY | ETF | 380.27 | 380.59 | 380.27 | 380.59 | 38065.0 |
| 2021-03-04 07:15:00 | SPY | ETF | 380.57 | 380.91 | 380.56 | 380.91 | 38452.0 |
| 2021-03-04 07:20:00 | SPY | ETF | 380.87 | 380.88 | 380.47 | 380.72 | 38338.0 |
| 2021-03-04 07:25:00 | SPY | ETF | 380.7 | 380.7 | 380.21 | 380.42 | 6750.0 |
| 2021-03-04 07:30:00 | SPY | ETF | 380.57 | 380.59 | 380.04 | 380.04 | 26620.0 |
| 2021-03-04 07:35:00 | SPY | ETF | 380.09 | 380.6 | 380.09 | 380.55 | 12244.0 |
| 2021-03-04 07:40:00 | SPY | ETF | 380.62 | 380.81 | 380.46 | 380.81 | 15302.0 |
| 2021-03-04 07:45:00 | SPY | ETF | 380.83 | 380.86 | 380.52 | 380.84 | 15045.0 |
| 2021-03-04 07:50:00 | SPY | ETF | 380.69 | 380.8 | 380.53 | 380.67 | 17742.0 |
| 2021-03-04 07:55:00 | SPY | ETF | 380.76 | 380.9 | 380.7 | 380.87 | 9514.0 |
| 2021-03-04 08:00:00 | SPY | ETF | 380.8 | 381.51 | 378.8896 | 380.6 | 113942.0 |
| 2021-03-04 08:05:00 | SPY | ETF | 380.55 | 380.66 | 378.93 | 380.42 | 43613.0 |
> showing 50 of 97,923 rows — these rows as CSV