PREVIEW / etf_5min / 2019-02-08
file: by_date/etf_5min/2019/2019-02-08.parquet size: 1.4 MB rows: 61,275
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-08 04:00:00 | SPY | ETF | 269.45 | 269.47 | 269.45 | 269.47 | 338.0 |
| 2019-02-08 04:05:00 | SPY | ETF | 269.54 | 269.55 | 269.52 | 269.54 | 1195.0 |
| 2019-02-08 04:10:00 | SPY | ETF | 269.62 | 269.62 | 269.6 | 269.6 | 700.0 |
| 2019-02-08 04:15:00 | SPY | ETF | 269.55 | 269.58 | 269.55 | 269.55 | 1400.0 |
| 2019-02-08 04:20:00 | SPY | ETF | 269.58 | 269.58 | 269.48 | 269.48 | 2650.0 |
| 2019-02-08 04:25:00 | SPY | ETF | 269.46 | 269.46 | 269.43 | 269.46 | 1169.0 |
| 2019-02-08 04:30:00 | SPY | ETF | 269.42 | 269.43 | 269.38 | 269.38 | 3346.0 |
| 2019-02-08 04:40:00 | SPY | ETF | 269.36 | 269.36 | 269.34 | 269.34 | 1000.0 |
| 2019-02-08 04:50:00 | SPY | ETF | 269.36 | 269.36 | 269.24 | 269.24 | 300.0 |
| 2019-02-08 04:55:00 | SPY | ETF | 269.26 | 269.31 | 269.26 | 269.31 | 601.0 |
| 2019-02-08 05:00:00 | SPY | ETF | 269.31 | 269.36 | 269.31 | 269.36 | 200.0 |
| 2019-02-08 05:05:00 | SPY | ETF | 269.2 | 269.2 | 269.2 | 269.2 | 300.0 |
| 2019-02-08 05:20:00 | SPY | ETF | 269.28 | 269.33 | 269.28 | 269.33 | 1269.0 |
| 2019-02-08 05:25:00 | SPY | ETF | 269.35 | 269.35 | 269.31 | 269.31 | 507.0 |
| 2019-02-08 05:30:00 | SPY | ETF | 269.33 | 269.33 | 269.19 | 269.19 | 4838.0 |
| 2019-02-08 05:35:00 | SPY | ETF | 269.26 | 269.26 | 269.21 | 269.22 | 3676.0 |
| 2019-02-08 05:40:00 | SPY | ETF | 269.22 | 269.22 | 269.01 | 269.06 | 4964.0 |
| 2019-02-08 05:45:00 | SPY | ETF | 269.15 | 269.16 | 269.1 | 269.11 | 3069.0 |
| 2019-02-08 05:50:00 | SPY | ETF | 269.15 | 269.3 | 269.15 | 269.28 | 4200.0 |
| 2019-02-08 05:55:00 | SPY | ETF | 269.25 | 269.3 | 269.2 | 269.2 | 2125.0 |
| 2019-02-08 06:00:00 | SPY | ETF | 269.26 | 269.3 | 269.24 | 269.3 | 2400.0 |
| 2019-02-08 06:05:00 | SPY | ETF | 269.27 | 269.27 | 269.2 | 269.2 | 2600.0 |
| 2019-02-08 06:10:00 | SPY | ETF | 269.21 | 269.29 | 269.21 | 269.24 | 3818.0 |
| 2019-02-08 06:15:00 | SPY | ETF | 269.23 | 269.24 | 269.2 | 269.2 | 3200.0 |
| 2019-02-08 06:20:00 | SPY | ETF | 269.2 | 269.21 | 269.1 | 269.19 | 6004.0 |
| 2019-02-08 06:25:00 | SPY | ETF | 269.1 | 269.15 | 269.06 | 269.15 | 2682.0 |
| 2019-02-08 06:30:00 | SPY | ETF | 269.1 | 269.1 | 269.05 | 269.05 | 1300.0 |
| 2019-02-08 06:35:00 | SPY | ETF | 269.05 | 269.06 | 269.05 | 269.06 | 1200.0 |
| 2019-02-08 06:40:00 | SPY | ETF | 269.08 | 269.1 | 268.95 | 268.95 | 30920.0 |
| 2019-02-08 06:45:00 | SPY | ETF | 268.8 | 268.8 | 268.66 | 268.67 | 7737.0 |
| 2019-02-08 06:50:00 | SPY | ETF | 268.65 | 268.77 | 268.63 | 268.7 | 4755.0 |
| 2019-02-08 06:55:00 | SPY | ETF | 268.59 | 268.67 | 268.51 | 268.58 | 8208.0 |
| 2019-02-08 07:00:00 | SPY | ETF | 268.62 | 268.65 | 268.49 | 268.61 | 16622.0 |
| 2019-02-08 07:05:00 | SPY | ETF | 268.57 | 268.61 | 268.44 | 268.45 | 26240.0 |
| 2019-02-08 07:10:00 | SPY | ETF | 268.51 | 268.57 | 268.49 | 268.55 | 24311.0 |
| 2019-02-08 07:15:00 | SPY | ETF | 268.54 | 268.59 | 268.48 | 268.5 | 20920.0 |
| 2019-02-08 07:20:00 | SPY | ETF | 268.52 | 268.61 | 268.45 | 268.58 | 7237.0 |
| 2019-02-08 07:25:00 | SPY | ETF | 268.57 | 268.71 | 268.57 | 268.63 | 26553.0 |
| 2019-02-08 07:30:00 | SPY | ETF | 268.59 | 268.71 | 268.59 | 268.71 | 5666.0 |
| 2019-02-08 07:35:00 | SPY | ETF | 268.69 | 268.72 | 268.59 | 268.67 | 19813.0 |
| 2019-02-08 07:40:00 | SPY | ETF | 268.66 | 268.68 | 268.6 | 268.6 | 28955.0 |
| 2019-02-08 07:45:00 | SPY | ETF | 268.6 | 268.62 | 268.46 | 268.46 | 48905.0 |
| 2019-02-08 07:50:00 | SPY | ETF | 268.5 | 268.54 | 268.43 | 268.45 | 16123.0 |
| 2019-02-08 07:55:00 | SPY | ETF | 268.45 | 268.61 | 268.45 | 268.58 | 13475.0 |
| 2019-02-08 08:00:00 | SPY | ETF | 268.53 | 269.3 | 268.45 | 268.61 | 143592.0 |
| 2019-02-08 08:05:00 | SPY | ETF | 268.64 | 268.85 | 268.64 | 268.7 | 49468.0 |
| 2019-02-08 08:10:00 | SPY | ETF | 268.72 | 268.82 | 268.69 | 268.82 | 20804.0 |
| 2019-02-08 08:15:00 | SPY | ETF | 268.8 | 268.84 | 268.77 | 268.79 | 5332.0 |
| 2019-02-08 08:20:00 | SPY | ETF | 268.76 | 268.97 | 268.76 | 268.95 | 48880.0 |
| 2019-02-08 08:25:00 | SPY | ETF | 268.95 | 268.99 | 268.84 | 268.87 | 25243.0 |
> showing 50 of 61,275 rows — these rows as CSV