PREVIEW / stock_1min / 2016-11-21
file: by_date/stock_1min/2016/2016-11-21.parquet size: 14.8 MB rows: 1,065,101 symbols: 2,622
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-11-21 04:00:00 | AAPL | Stock | 27.55 | 27.55 | 27.55 | 27.55 | 800.0 |
| 2016-11-21 04:29:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 400.0 |
| 2016-11-21 04:36:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.52 | 27.52 | 12000.0 |
| 2016-11-21 04:37:00 | AAPL | Stock | 27.52 | 27.52 | 27.52 | 27.52 | 2800.0 |
| 2016-11-21 04:57:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 3200.0 |
| 2016-11-21 05:21:00 | AAPL | Stock | 27.5975 | 27.5975 | 27.5975 | 27.5975 | 516.0 |
| 2016-11-21 05:32:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 772.0 |
| 2016-11-21 06:32:00 | AAPL | Stock | 27.5525 | 27.5525 | 27.5525 | 27.5525 | 680.0 |
| 2016-11-21 06:46:00 | AAPL | Stock | 27.5975 | 27.6 | 27.5975 | 27.6 | 2136.0 |
| 2016-11-21 06:47:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 1544.0 |
| 2016-11-21 07:03:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 1144.0 |
| 2016-11-21 07:10:00 | AAPL | Stock | 27.6125 | 27.6125 | 27.6125 | 27.6125 | 400.0 |
| 2016-11-21 07:28:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 400.0 |
| 2016-11-21 07:39:00 | AAPL | Stock | 27.585 | 27.585 | 27.585 | 27.585 | 400.0 |
| 2016-11-21 07:49:00 | AAPL | Stock | 27.585 | 27.585 | 27.58 | 27.58 | 4868.0 |
| 2016-11-21 07:50:00 | AAPL | Stock | 27.58 | 27.58 | 27.58 | 27.58 | 800.0 |
| 2016-11-21 07:52:00 | AAPL | Stock | 27.58 | 27.58 | 27.58 | 27.58 | 1200.0 |
| 2016-11-21 07:53:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.575 | 27.575 | 19588.0 |
| 2016-11-21 07:54:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 400.0 |
| 2016-11-21 07:55:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.5775 | 27.5775 | 800.0 |
| 2016-11-21 08:00:00 | AAPL | Stock | 27.5775 | 27.6 | 27.5725 | 27.5775 | 51648.0 |
| 2016-11-21 08:01:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.5775 | 27.5775 | 4000.0 |
| 2016-11-21 08:02:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.5775 | 27.5775 | 800.0 |
| 2016-11-21 08:03:00 | AAPL | Stock | 27.5775 | 27.5775 | 27.575 | 27.575 | 22700.0 |
| 2016-11-21 08:05:00 | AAPL | Stock | 27.5725 | 27.5725 | 27.5725 | 27.5725 | 1008.0 |
| 2016-11-21 08:07:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 2864.0 |
| 2016-11-21 08:08:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 600.0 |
| 2016-11-21 08:09:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 1372.0 |
| 2016-11-21 08:10:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 4000.0 |
| 2016-11-21 08:12:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 4000.0 |
| 2016-11-21 08:13:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 1208.0 |
| 2016-11-21 08:15:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 3800.0 |
| 2016-11-21 08:16:00 | AAPL | Stock | 27.57 | 27.57 | 27.5675 | 27.57 | 8600.0 |
| 2016-11-21 08:17:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.5625 | 27.5625 | 400.0 |
| 2016-11-21 08:19:00 | AAPL | Stock | 27.5675 | 27.57 | 27.5675 | 27.57 | 3200.0 |
| 2016-11-21 08:21:00 | AAPL | Stock | 27.57 | 27.57 | 27.57 | 27.57 | 3936.0 |
| 2016-11-21 08:25:00 | AAPL | Stock | 27.575 | 27.575 | 27.575 | 27.575 | 1600.0 |
| 2016-11-21 08:32:00 | AAPL | Stock | 27.585 | 27.585 | 27.585 | 27.585 | 592.0 |
| 2016-11-21 08:34:00 | AAPL | Stock | 27.59 | 27.5925 | 27.59 | 27.5925 | 12400.0 |
| 2016-11-21 08:35:00 | AAPL | Stock | 27.595 | 27.605 | 27.595 | 27.6025 | 43596.0 |
| 2016-11-21 08:38:00 | AAPL | Stock | 27.605 | 27.6075 | 27.6 | 27.6 | 19572.0 |
| 2016-11-21 08:39:00 | AAPL | Stock | 27.6175 | 27.6175 | 27.6175 | 27.6175 | 1800.0 |
| 2016-11-21 08:40:00 | AAPL | Stock | 27.6125 | 27.62 | 27.6125 | 27.62 | 5572.0 |
| 2016-11-21 08:42:00 | AAPL | Stock | 27.62 | 27.62 | 27.62 | 27.62 | 800.0 |
| 2016-11-21 08:43:00 | AAPL | Stock | 27.62 | 27.6325 | 27.62 | 27.6325 | 7888.0 |
| 2016-11-21 08:44:00 | AAPL | Stock | 27.6425 | 27.6425 | 27.6425 | 27.6425 | 400.0 |
| 2016-11-21 08:45:00 | AAPL | Stock | 27.6325 | 27.6325 | 27.6225 | 27.625 | 3000.0 |
| 2016-11-21 08:46:00 | AAPL | Stock | 27.6375 | 27.6375 | 27.6375 | 27.6375 | 1200.0 |
| 2016-11-21 08:47:00 | AAPL | Stock | 27.625 | 27.6325 | 27.6225 | 27.6225 | 8940.0 |
| 2016-11-21 08:48:00 | AAPL | Stock | 27.625 | 27.625 | 27.625 | 27.625 | 1060.0 |
> showing 50 of 1,065,101 rows — these rows as CSV