PREVIEW / etf_5min / 2021-03-08
file: by_date/etf_5min/2021/2021-03-08.parquet size: 2.0 MB rows: 94,700
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-08 04:00:00 | SPY | ETF | 381.26 | 381.45 | 380.74 | 380.74 | 16087.0 |
| 2021-03-08 04:05:00 | SPY | ETF | 380.76 | 380.78 | 380.32 | 380.37 | 7750.0 |
| 2021-03-08 04:10:00 | SPY | ETF | 380.66 | 380.89 | 380.48 | 380.5 | 23601.0 |
| 2021-03-08 04:15:00 | SPY | ETF | 380.55 | 380.7 | 380.37 | 380.37 | 3555.0 |
| 2021-03-08 04:20:00 | SPY | ETF | 380.25 | 380.27 | 379.5 | 379.5 | 7428.0 |
| 2021-03-08 04:25:00 | SPY | ETF | 379.62 | 379.78 | 379.42 | 379.76 | 19334.0 |
| 2021-03-08 04:30:00 | SPY | ETF | 379.7 | 380.0 | 379.6 | 379.95 | 7185.0 |
| 2021-03-08 04:35:00 | SPY | ETF | 380.03 | 380.2 | 379.93 | 380.2 | 10586.0 |
| 2021-03-08 04:40:00 | SPY | ETF | 380.23 | 380.75 | 380.23 | 380.75 | 3991.0 |
| 2021-03-08 04:45:00 | SPY | ETF | 380.82 | 380.9 | 380.7 | 380.75 | 5675.0 |
| 2021-03-08 04:50:00 | SPY | ETF | 380.65 | 380.65 | 380.45 | 380.59 | 1819.0 |
| 2021-03-08 04:55:00 | SPY | ETF | 380.7 | 380.7 | 380.55 | 380.55 | 2700.0 |
| 2021-03-08 05:00:00 | SPY | ETF | 380.8 | 380.83 | 380.66 | 380.83 | 45832.0 |
| 2021-03-08 05:05:00 | SPY | ETF | 380.92 | 381.07 | 380.87 | 380.87 | 18136.0 |
| 2021-03-08 05:10:00 | SPY | ETF | 380.85 | 380.85 | 380.74 | 380.82 | 18763.0 |
| 2021-03-08 05:15:00 | SPY | ETF | 380.85 | 380.85 | 380.55 | 380.61 | 1900.0 |
| 2021-03-08 05:20:00 | SPY | ETF | 380.57 | 380.77 | 380.57 | 380.76 | 3179.0 |
| 2021-03-08 05:25:00 | SPY | ETF | 380.67 | 380.67 | 380.48 | 380.57 | 4848.0 |
| 2021-03-08 05:30:00 | SPY | ETF | 380.7 | 381.32 | 380.7 | 381.29 | 23966.0 |
| 2021-03-08 05:35:00 | SPY | ETF | 381.43 | 381.49 | 381.12 | 381.12 | 12998.0 |
| 2021-03-08 05:40:00 | SPY | ETF | 381.12 | 381.16 | 380.97 | 380.97 | 38860.0 |
| 2021-03-08 05:45:00 | SPY | ETF | 381.02 | 381.13 | 380.75 | 380.77 | 7600.0 |
| 2021-03-08 05:50:00 | SPY | ETF | 380.85 | 381.25 | 380.85 | 381.15 | 27600.0 |
| 2021-03-08 05:55:00 | SPY | ETF | 381.02 | 381.34 | 381.02 | 381.32 | 5300.0 |
| 2021-03-08 06:00:00 | SPY | ETF | 381.32 | 381.69 | 381.32 | 381.4 | 4809.0 |
| 2021-03-08 06:05:00 | SPY | ETF | 381.49 | 381.67 | 381.47 | 381.67 | 3200.0 |
| 2021-03-08 06:10:00 | SPY | ETF | 381.64 | 381.77 | 381.45 | 381.45 | 26335.0 |
| 2021-03-08 06:15:00 | SPY | ETF | 381.49 | 381.62 | 381.32 | 381.51 | 9120.0 |
| 2021-03-08 06:20:00 | SPY | ETF | 381.3 | 381.48 | 381.3 | 381.48 | 1900.0 |
| 2021-03-08 06:25:00 | SPY | ETF | 381.72 | 381.85 | 381.1 | 381.1 | 24197.0 |
| 2021-03-08 06:30:00 | SPY | ETF | 381.08 | 381.5 | 381.07 | 381.45 | 7700.0 |
| 2021-03-08 06:35:00 | SPY | ETF | 381.53 | 381.7 | 381.4 | 381.67 | 15150.0 |
| 2021-03-08 06:40:00 | SPY | ETF | 381.53 | 381.53 | 381.35 | 381.42 | 9199.0 |
| 2021-03-08 06:45:00 | SPY | ETF | 381.38 | 381.7 | 381.38 | 381.65 | 19063.0 |
| 2021-03-08 06:50:00 | SPY | ETF | 381.59 | 381.8 | 381.46 | 381.65 | 20400.0 |
| 2021-03-08 06:55:00 | SPY | ETF | 381.61 | 381.8 | 381.59 | 381.8 | 4800.0 |
| 2021-03-08 07:00:00 | SPY | ETF | 381.89 | 382.03 | 381.5 | 381.55 | 54705.0 |
| 2021-03-08 07:05:00 | SPY | ETF | 381.54 | 381.97 | 381.5 | 381.9 | 13805.0 |
| 2021-03-08 07:10:00 | SPY | ETF | 381.9 | 382.25 | 381.88 | 382.01 | 86456.0 |
| 2021-03-08 07:15:00 | SPY | ETF | 381.99 | 382.07 | 381.71 | 381.99 | 63312.0 |
| 2021-03-08 07:20:00 | SPY | ETF | 381.92 | 381.97 | 381.67 | 381.85 | 21186.0 |
| 2021-03-08 07:25:00 | SPY | ETF | 381.83 | 381.99 | 381.68 | 381.68 | 8236.0 |
| 2021-03-08 07:30:00 | SPY | ETF | 381.61 | 381.84 | 381.16 | 381.22 | 88001.0 |
| 2021-03-08 07:35:00 | SPY | ETF | 381.24 | 381.45 | 381.06 | 381.18 | 36411.0 |
| 2021-03-08 07:40:00 | SPY | ETF | 381.18 | 381.18 | 380.9 | 380.9 | 96398.0 |
| 2021-03-08 07:45:00 | SPY | ETF | 380.93 | 381.1 | 380.83 | 380.95 | 45530.0 |
| 2021-03-08 07:50:00 | SPY | ETF | 380.95 | 381.07 | 380.85 | 381.0 | 63187.0 |
| 2021-03-08 07:55:00 | SPY | ETF | 381.0 | 381.35 | 381.0 | 381.34 | 46176.0 |
| 2021-03-08 08:00:00 | SPY | ETF | 381.36 | 383.0 | 380.53 | 381.46 | 189293.0 |
| 2021-03-08 08:05:00 | SPY | ETF | 381.47 | 381.68 | 381.38 | 381.59 | 68801.0 |
> showing 50 of 94,700 rows — these rows as CSV