PREVIEW / etf_1min / 2016-06-21
file: by_date/etf_1min/2016/2016-06-21.parquet size: 2.4 MB rows: 130,606
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 |
|---|---|---|---|---|---|---|---|
| 2016-06-21 04:00:00 | SPY | ETF | 208.6 | 208.64 | 208.6 | 208.61 | 1011.0 |
| 2016-06-21 04:01:00 | SPY | ETF | 208.64 | 208.64 | 208.63 | 208.63 | 1049.0 |
| 2016-06-21 04:02:00 | SPY | ETF | 208.58 | 208.58 | 208.58 | 208.58 | 100.0 |
| 2016-06-21 04:07:00 | SPY | ETF | 208.55 | 208.55 | 208.55 | 208.55 | 102.0 |
| 2016-06-21 04:08:00 | SPY | ETF | 208.49 | 208.49 | 208.49 | 208.49 | 354.0 |
| 2016-06-21 04:09:00 | SPY | ETF | 208.52 | 208.53 | 208.52 | 208.53 | 405.0 |
| 2016-06-21 04:14:00 | SPY | ETF | 208.5 | 208.5 | 208.5 | 208.5 | 203.0 |
| 2016-06-21 04:16:00 | SPY | ETF | 208.57 | 208.57 | 208.57 | 208.57 | 100.0 |
| 2016-06-21 04:17:00 | SPY | ETF | 208.59 | 208.59 | 208.59 | 208.59 | 353.0 |
| 2016-06-21 04:18:00 | SPY | ETF | 208.61 | 208.63 | 208.61 | 208.63 | 5101.0 |
| 2016-06-21 04:21:00 | SPY | ETF | 208.63 | 208.67 | 208.63 | 208.67 | 5504.0 |
| 2016-06-21 04:22:00 | SPY | ETF | 208.68 | 208.73 | 208.68 | 208.7 | 10487.0 |
| 2016-06-21 04:23:00 | SPY | ETF | 208.7 | 208.7 | 208.7 | 208.7 | 5001.0 |
| 2016-06-21 04:24:00 | SPY | ETF | 208.7 | 208.7 | 208.7 | 208.7 | 5000.0 |
| 2016-06-21 04:25:00 | SPY | ETF | 208.73 | 208.73 | 208.73 | 208.73 | 5002.0 |
| 2016-06-21 04:31:00 | SPY | ETF | 208.73 | 208.73 | 208.7 | 208.7 | 8123.0 |
| 2016-06-21 04:36:00 | SPY | ETF | 208.68 | 208.68 | 208.65 | 208.65 | 5500.0 |
| 2016-06-21 04:38:00 | SPY | ETF | 208.67 | 208.67 | 208.67 | 208.67 | 5000.0 |
| 2016-06-21 04:41:00 | SPY | ETF | 208.74 | 208.79 | 208.74 | 208.79 | 7005.0 |
| 2016-06-21 04:43:00 | SPY | ETF | 208.75 | 208.75 | 208.75 | 208.75 | 501.0 |
| 2016-06-21 04:44:00 | SPY | ETF | 208.75 | 208.75 | 208.72 | 208.72 | 701.0 |
| 2016-06-21 04:50:00 | SPY | ETF | 208.61 | 208.61 | 208.61 | 208.61 | 201.0 |
| 2016-06-21 04:51:00 | SPY | ETF | 208.63 | 208.63 | 208.63 | 208.63 | 5001.0 |
| 2016-06-21 04:57:00 | SPY | ETF | 208.65 | 208.65 | 208.65 | 208.65 | 4001.0 |
| 2016-06-21 05:00:00 | SPY | ETF | 208.58 | 208.58 | 208.58 | 208.58 | 5002.0 |
| 2016-06-21 05:03:00 | SPY | ETF | 208.55 | 208.55 | 208.55 | 208.55 | 5000.0 |
| 2016-06-21 05:04:00 | SPY | ETF | 208.56 | 208.56 | 208.56 | 208.56 | 301.0 |
| 2016-06-21 05:05:00 | SPY | ETF | 208.52 | 208.52 | 208.52 | 208.52 | 5000.0 |
| 2016-06-21 05:06:00 | SPY | ETF | 208.52 | 208.52 | 208.52 | 208.52 | 5000.0 |
| 2016-06-21 05:07:00 | SPY | ETF | 208.52 | 208.52 | 208.51 | 208.51 | 15000.0 |
| 2016-06-21 05:11:00 | SPY | ETF | 208.6 | 208.6 | 208.6 | 208.6 | 5003.0 |
| 2016-06-21 05:13:00 | SPY | ETF | 208.55 | 208.55 | 208.55 | 208.55 | 3001.0 |
| 2016-06-21 05:16:00 | SPY | ETF | 208.48 | 208.48 | 208.48 | 208.48 | 202.0 |
| 2016-06-21 05:17:00 | SPY | ETF | 208.47 | 208.47 | 208.45 | 208.45 | 7299.0 |
| 2016-06-21 05:18:00 | SPY | ETF | 208.45 | 208.52 | 208.45 | 208.52 | 6201.0 |
| 2016-06-21 05:19:00 | SPY | ETF | 208.48 | 208.48 | 208.44 | 208.44 | 5500.0 |
| 2016-06-21 05:20:00 | SPY | ETF | 208.48 | 208.48 | 208.44 | 208.44 | 5301.0 |
| 2016-06-21 05:23:00 | SPY | ETF | 208.44 | 208.44 | 208.44 | 208.44 | 300.0 |
| 2016-06-21 05:24:00 | SPY | ETF | 208.45 | 208.45 | 208.45 | 208.45 | 300.0 |
| 2016-06-21 05:26:00 | SPY | ETF | 208.42 | 208.42 | 208.42 | 208.42 | 5000.0 |
| 2016-06-21 05:27:00 | SPY | ETF | 208.45 | 208.45 | 208.45 | 208.45 | 2003.0 |
| 2016-06-21 05:28:00 | SPY | ETF | 208.45 | 208.48 | 208.45 | 208.45 | 3802.0 |
| 2016-06-21 05:30:00 | SPY | ETF | 208.45 | 208.45 | 208.45 | 208.45 | 1501.0 |
| 2016-06-21 05:33:00 | SPY | ETF | 208.45 | 208.45 | 208.44 | 208.45 | 6000.0 |
| 2016-06-21 05:37:00 | SPY | ETF | 208.44 | 208.44 | 208.43 | 208.43 | 1203.0 |
| 2016-06-21 05:39:00 | SPY | ETF | 208.45 | 208.45 | 208.44 | 208.44 | 400.0 |
| 2016-06-21 05:40:00 | SPY | ETF | 208.46 | 208.46 | 208.46 | 208.46 | 200.0 |
| 2016-06-21 05:41:00 | SPY | ETF | 208.47 | 208.47 | 208.47 | 208.47 | 175.0 |
| 2016-06-21 05:42:00 | SPY | ETF | 208.42 | 208.42 | 208.42 | 208.42 | 201.0 |
| 2016-06-21 05:43:00 | SPY | ETF | 208.48 | 208.48 | 208.48 | 208.48 | 101.0 |
> showing 50 of 130,606 rows — these rows as CSV