PREVIEW / etf_5min / 2017-11-08
file: by_date/etf_5min/2017/2017-11-08.parquet size: 1.3 MB rows: 54,185
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 |
|---|---|---|---|---|---|---|---|
| 2017-11-08 04:00:00 | SPY | ETF | 258.52 | 258.52 | 258.52 | 258.52 | 100.0 |
| 2017-11-08 04:05:00 | SPY | ETF | 258.55 | 258.6 | 258.55 | 258.6 | 4800.0 |
| 2017-11-08 04:10:00 | SPY | ETF | 258.6 | 258.6 | 258.6 | 258.6 | 500.0 |
| 2017-11-08 04:15:00 | SPY | ETF | 258.66 | 258.66 | 258.66 | 258.66 | 5000.0 |
| 2017-11-08 04:20:00 | SPY | ETF | 258.62 | 258.62 | 258.62 | 258.62 | 250.0 |
| 2017-11-08 04:35:00 | SPY | ETF | 258.68 | 258.68 | 258.68 | 258.68 | 2400.0 |
| 2017-11-08 04:40:00 | SPY | ETF | 258.71 | 258.71 | 258.71 | 258.71 | 2500.0 |
| 2017-11-08 04:55:00 | SPY | ETF | 258.63 | 258.63 | 258.63 | 258.63 | 100.0 |
| 2017-11-08 05:00:00 | SPY | ETF | 258.63 | 258.63 | 258.63 | 258.63 | 100.0 |
| 2017-11-08 05:05:00 | SPY | ETF | 258.54 | 258.54 | 258.52 | 258.52 | 1250.0 |
| 2017-11-08 05:10:00 | SPY | ETF | 258.54 | 258.54 | 258.53 | 258.53 | 1131.0 |
| 2017-11-08 05:15:00 | SPY | ETF | 258.53 | 258.53 | 258.53 | 258.53 | 500.0 |
| 2017-11-08 05:25:00 | SPY | ETF | 258.54 | 258.54 | 258.54 | 258.54 | 130.0 |
| 2017-11-08 05:30:00 | SPY | ETF | 258.61 | 258.61 | 258.58 | 258.58 | 300.0 |
| 2017-11-08 05:35:00 | SPY | ETF | 258.6 | 258.6 | 258.6 | 258.6 | 1651.0 |
| 2017-11-08 05:40:00 | SPY | ETF | 258.6 | 258.6 | 258.6 | 258.6 | 5500.0 |
| 2017-11-08 05:45:00 | SPY | ETF | 258.61 | 258.61 | 258.57 | 258.57 | 700.0 |
| 2017-11-08 05:50:00 | SPY | ETF | 258.57 | 258.57 | 258.57 | 258.57 | 500.0 |
| 2017-11-08 06:00:00 | SPY | ETF | 258.55 | 258.55 | 258.52 | 258.55 | 5603.0 |
| 2017-11-08 06:05:00 | SPY | ETF | 258.58 | 258.58 | 258.58 | 258.58 | 838.0 |
| 2017-11-08 06:10:00 | SPY | ETF | 258.56 | 258.56 | 258.55 | 258.55 | 800.0 |
| 2017-11-08 06:20:00 | SPY | ETF | 258.56 | 258.56 | 258.55 | 258.55 | 600.0 |
| 2017-11-08 06:25:00 | SPY | ETF | 258.5 | 258.5 | 258.5 | 258.5 | 305.0 |
| 2017-11-08 06:30:00 | SPY | ETF | 258.48 | 258.48 | 258.48 | 258.48 | 201.0 |
| 2017-11-08 06:35:00 | SPY | ETF | 258.47 | 258.47 | 258.47 | 258.47 | 300.0 |
| 2017-11-08 06:45:00 | SPY | ETF | 258.47 | 258.47 | 258.47 | 258.47 | 600.0 |
| 2017-11-08 06:50:00 | SPY | ETF | 258.39 | 258.39 | 258.32 | 258.38 | 9310.0 |
| 2017-11-08 07:00:00 | SPY | ETF | 258.4 | 258.43 | 258.4 | 258.43 | 12100.0 |
| 2017-11-08 07:05:00 | SPY | ETF | 258.4 | 258.43 | 258.39 | 258.42 | 7816.0 |
| 2017-11-08 07:10:00 | SPY | ETF | 258.45 | 258.47 | 258.45 | 258.47 | 2703.0 |
| 2017-11-08 07:15:00 | SPY | ETF | 258.48 | 258.48 | 258.46 | 258.46 | 2002.0 |
| 2017-11-08 07:20:00 | SPY | ETF | 258.47 | 258.47 | 258.42 | 258.43 | 2302.0 |
| 2017-11-08 07:25:00 | SPY | ETF | 258.42 | 258.42 | 258.37 | 258.37 | 7903.0 |
| 2017-11-08 07:30:00 | SPY | ETF | 258.35 | 258.35 | 258.3 | 258.3 | 8353.0 |
| 2017-11-08 07:35:00 | SPY | ETF | 258.33 | 258.34 | 258.33 | 258.34 | 1810.0 |
| 2017-11-08 07:40:00 | SPY | ETF | 258.35 | 258.37 | 258.31 | 258.31 | 1423.0 |
| 2017-11-08 07:45:00 | SPY | ETF | 258.3 | 258.3 | 258.25 | 258.25 | 27102.0 |
| 2017-11-08 07:50:00 | SPY | ETF | 258.25 | 258.3 | 258.25 | 258.29 | 1450.0 |
| 2017-11-08 07:55:00 | SPY | ETF | 258.29 | 258.37 | 258.29 | 258.34 | 20273.0 |
| 2017-11-08 08:00:00 | SPY | ETF | 258.42 | 258.42 | 258.29 | 258.4 | 24245.0 |
| 2017-11-08 08:05:00 | SPY | ETF | 258.37 | 258.46 | 258.37 | 258.44 | 17075.0 |
| 2017-11-08 08:10:00 | SPY | ETF | 258.47 | 258.47 | 258.45 | 258.46 | 12468.0 |
| 2017-11-08 08:15:00 | SPY | ETF | 258.47 | 258.57 | 258.47 | 258.5 | 48694.0 |
| 2017-11-08 08:20:00 | SPY | ETF | 258.5 | 258.55 | 258.5 | 258.53 | 18155.0 |
| 2017-11-08 08:25:00 | SPY | ETF | 258.53 | 258.53 | 258.5 | 258.5 | 2342.0 |
| 2017-11-08 08:30:00 | SPY | ETF | 258.49 | 258.51 | 258.44 | 258.44 | 35673.0 |
| 2017-11-08 08:35:00 | SPY | ETF | 258.42 | 258.42 | 258.39 | 258.39 | 15703.0 |
| 2017-11-08 08:40:00 | SPY | ETF | 258.37 | 258.44 | 258.37 | 258.44 | 20440.0 |
| 2017-11-08 08:45:00 | SPY | ETF | 258.45 | 258.53 | 258.45 | 258.53 | 10444.0 |
| 2017-11-08 08:50:00 | SPY | ETF | 258.53 | 258.54 | 258.5 | 258.52 | 14995.0 |
> showing 50 of 54,185 rows — these rows as CSV