PREVIEW / stock_1min / 2016-12-06
file: by_date/stock_1min/2016/2016-12-06.parquet size: 15.2 MB rows: 1,089,393 symbols: 2,601
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-12-06 04:17:00 | AAPL | Stock | 27.335 | 27.335 | 27.335 | 27.335 | 720.0 |
| 2016-12-06 04:20:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 432.0 |
| 2016-12-06 04:27:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2875 | 27.2875 | 704.0 |
| 2016-12-06 04:47:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 1020.0 |
| 2016-12-06 05:58:00 | AAPL | Stock | 27.2775 | 27.2775 | 27.2775 | 27.2775 | 400.0 |
| 2016-12-06 06:04:00 | AAPL | Stock | 27.28 | 27.28 | 27.28 | 27.28 | 600.0 |
| 2016-12-06 06:11:00 | AAPL | Stock | 27.3 | 27.3 | 27.3 | 27.3 | 1380.0 |
| 2016-12-06 06:12:00 | AAPL | Stock | 27.3625 | 27.3625 | 27.3625 | 27.3625 | 1060.0 |
| 2016-12-06 06:17:00 | AAPL | Stock | 27.3875 | 27.3875 | 27.3875 | 27.3875 | 816.0 |
| 2016-12-06 06:28:00 | AAPL | Stock | 27.3025 | 27.3025 | 27.3 | 27.3025 | 6448.0 |
| 2016-12-06 06:32:00 | AAPL | Stock | 27.305 | 27.305 | 27.305 | 27.305 | 1624.0 |
| 2016-12-06 06:42:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.285 | 27.285 | 1000.0 |
| 2016-12-06 06:58:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 2000.0 |
| 2016-12-06 07:02:00 | AAPL | Stock | 27.3125 | 27.3125 | 27.3125 | 27.3125 | 2000.0 |
| 2016-12-06 07:06:00 | AAPL | Stock | 27.3375 | 27.3375 | 27.3375 | 27.3375 | 800.0 |
| 2016-12-06 07:08:00 | AAPL | Stock | 27.375 | 27.375 | 27.3625 | 27.3625 | 3240.0 |
| 2016-12-06 07:15:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 400.0 |
| 2016-12-06 07:25:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 400.0 |
| 2016-12-06 07:28:00 | AAPL | Stock | 27.375 | 27.375 | 27.375 | 27.375 | 6000.0 |
| 2016-12-06 07:30:00 | AAPL | Stock | 27.35 | 27.375 | 27.345 | 27.375 | 1600.0 |
| 2016-12-06 07:32:00 | AAPL | Stock | 27.395 | 27.4 | 27.3525 | 27.3525 | 2944.0 |
| 2016-12-06 07:36:00 | AAPL | Stock | 27.3975 | 27.4 | 27.39 | 27.4 | 2648.0 |
| 2016-12-06 07:42:00 | AAPL | Stock | 27.4 | 27.4075 | 27.4 | 27.4075 | 2824.0 |
| 2016-12-06 07:43:00 | AAPL | Stock | 27.4225 | 27.4375 | 27.4225 | 27.4375 | 4064.0 |
| 2016-12-06 07:44:00 | AAPL | Stock | 27.4425 | 27.4425 | 27.4425 | 27.4425 | 692.0 |
| 2016-12-06 07:45:00 | AAPL | Stock | 27.4675 | 27.5 | 27.4675 | 27.5 | 17764.0 |
| 2016-12-06 07:46:00 | AAPL | Stock | 27.5 | 27.5525 | 27.4975 | 27.5525 | 24436.0 |
| 2016-12-06 07:47:00 | AAPL | Stock | 27.555 | 27.555 | 27.55 | 27.55 | 9020.0 |
| 2016-12-06 07:48:00 | AAPL | Stock | 27.55 | 27.55 | 27.5475 | 27.5475 | 1148.0 |
| 2016-12-06 07:50:00 | AAPL | Stock | 27.545 | 27.545 | 27.5425 | 27.545 | 3600.0 |
| 2016-12-06 07:51:00 | AAPL | Stock | 27.545 | 27.5875 | 27.545 | 27.575 | 52244.0 |
| 2016-12-06 07:53:00 | AAPL | Stock | 27.5625 | 27.5875 | 27.5625 | 27.5875 | 24000.0 |
| 2016-12-06 07:55:00 | AAPL | Stock | 27.575 | 27.61 | 27.575 | 27.61 | 1888.0 |
| 2016-12-06 07:56:00 | AAPL | Stock | 27.61 | 27.61 | 27.6 | 27.6 | 10000.0 |
| 2016-12-06 07:57:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.5875 | 27.5875 | 3800.0 |
| 2016-12-06 07:58:00 | AAPL | Stock | 27.6 | 27.6 | 27.6 | 27.6 | 5720.0 |
| 2016-12-06 07:59:00 | AAPL | Stock | 27.61 | 27.6125 | 27.5875 | 27.6 | 11860.0 |
| 2016-12-06 08:00:00 | AAPL | Stock | 27.5875 | 27.6 | 27.325 | 27.5875 | 27928.0 |
| 2016-12-06 08:01:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.56 | 27.56 | 10232.0 |
| 2016-12-06 08:02:00 | AAPL | Stock | 27.56 | 27.56 | 27.55 | 27.55 | 7548.0 |
| 2016-12-06 08:03:00 | AAPL | Stock | 27.55 | 27.5625 | 27.55 | 27.5625 | 800.0 |
| 2016-12-06 08:04:00 | AAPL | Stock | 27.5625 | 27.5625 | 27.555 | 27.555 | 6760.0 |
| 2016-12-06 08:05:00 | AAPL | Stock | 27.555 | 27.56 | 27.555 | 27.555 | 10000.0 |
| 2016-12-06 08:06:00 | AAPL | Stock | 27.555 | 27.5575 | 27.555 | 27.555 | 3200.0 |
| 2016-12-06 08:07:00 | AAPL | Stock | 27.555 | 27.555 | 27.5425 | 27.5425 | 4868.0 |
| 2016-12-06 08:08:00 | AAPL | Stock | 27.5375 | 27.5375 | 27.5375 | 27.5375 | 400.0 |
| 2016-12-06 08:09:00 | AAPL | Stock | 27.5325 | 27.5325 | 27.5325 | 27.5325 | 800.0 |
| 2016-12-06 08:10:00 | AAPL | Stock | 27.5425 | 27.5425 | 27.5425 | 27.5425 | 400.0 |
| 2016-12-06 08:11:00 | AAPL | Stock | 27.5425 | 27.55 | 27.5375 | 27.5438 | 14560.0 |
| 2016-12-06 08:12:00 | AAPL | Stock | 27.5438 | 27.55 | 27.5438 | 27.55 | 2920.0 |
> showing 50 of 1,089,393 rows — these rows as CSV