PREVIEW / stock_1min / 2016-12-12
file: by_date/stock_1min/2016/2016-12-12.parquet size: 15.7 MB rows: 1,117,224 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-12 04:11:00 | AAPL | Stock | 28.355 | 28.355 | 28.355 | 28.355 | 400.0 |
| 2016-12-12 04:17:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 400.0 |
| 2016-12-12 04:26:00 | AAPL | Stock | 28.2625 | 28.2625 | 28.22 | 28.22 | 1200.0 |
| 2016-12-12 04:28:00 | AAPL | Stock | 28.22 | 28.22 | 28.2175 | 28.2175 | 1936.0 |
| 2016-12-12 04:33:00 | AAPL | Stock | 28.2175 | 28.2175 | 28.2175 | 28.2175 | 1724.0 |
| 2016-12-12 04:47:00 | AAPL | Stock | 28.2125 | 28.2125 | 28.2125 | 28.2125 | 2000.0 |
| 2016-12-12 04:58:00 | AAPL | Stock | 28.24 | 28.24 | 28.24 | 28.24 | 400.0 |
| 2016-12-12 05:29:00 | AAPL | Stock | 28.24 | 28.24 | 28.24 | 28.24 | 1520.0 |
| 2016-12-12 05:30:00 | AAPL | Stock | 28.24 | 28.24 | 28.24 | 28.24 | 1120.0 |
| 2016-12-12 06:08:00 | AAPL | Stock | 28.305 | 28.305 | 28.305 | 28.305 | 400.0 |
| 2016-12-12 06:32:00 | AAPL | Stock | 28.3025 | 28.3025 | 28.3025 | 28.3025 | 1200.0 |
| 2016-12-12 06:35:00 | AAPL | Stock | 28.2825 | 28.2825 | 28.2825 | 28.2825 | 1200.0 |
| 2016-12-12 06:37:00 | AAPL | Stock | 28.3025 | 28.3125 | 28.3025 | 28.3125 | 2512.0 |
| 2016-12-12 06:38:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 2400.0 |
| 2016-12-12 06:40:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 1488.0 |
| 2016-12-12 06:46:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 400.0 |
| 2016-12-12 06:53:00 | AAPL | Stock | 28.315 | 28.315 | 28.3125 | 28.3125 | 1200.0 |
| 2016-12-12 06:54:00 | AAPL | Stock | 28.315 | 28.315 | 28.315 | 28.315 | 580.0 |
| 2016-12-12 07:01:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 400.0 |
| 2016-12-12 07:02:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 400.0 |
| 2016-12-12 07:06:00 | AAPL | Stock | 28.315 | 28.315 | 28.315 | 28.315 | 516.0 |
| 2016-12-12 07:10:00 | AAPL | Stock | 28.315 | 28.325 | 28.315 | 28.325 | 12400.0 |
| 2016-12-12 07:13:00 | AAPL | Stock | 28.325 | 28.325 | 28.325 | 28.325 | 1776.0 |
| 2016-12-12 07:14:00 | AAPL | Stock | 28.325 | 28.325 | 28.3125 | 28.3125 | 23280.0 |
| 2016-12-12 07:23:00 | AAPL | Stock | 28.29 | 28.29 | 28.29 | 28.29 | 400.0 |
| 2016-12-12 07:24:00 | AAPL | Stock | 28.3375 | 28.3375 | 28.3375 | 28.3375 | 400.0 |
| 2016-12-12 07:30:00 | AAPL | Stock | 28.335 | 28.335 | 28.335 | 28.335 | 400.0 |
| 2016-12-12 07:31:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 720.0 |
| 2016-12-12 07:37:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3 | 28.3 | 2880.0 |
| 2016-12-12 07:44:00 | AAPL | Stock | 28.3 | 28.3 | 28.3 | 28.3 | 2000.0 |
| 2016-12-12 07:45:00 | AAPL | Stock | 28.2975 | 28.2975 | 28.2975 | 28.2975 | 800.0 |
| 2016-12-12 07:46:00 | AAPL | Stock | 28.3 | 28.3 | 28.3 | 28.3 | 1096.0 |
| 2016-12-12 07:47:00 | AAPL | Stock | 28.295 | 28.295 | 28.295 | 28.295 | 2400.0 |
| 2016-12-12 07:48:00 | AAPL | Stock | 28.295 | 28.3 | 28.295 | 28.3 | 8000.0 |
| 2016-12-12 07:55:00 | AAPL | Stock | 28.3075 | 28.3075 | 28.3075 | 28.3075 | 1000.0 |
| 2016-12-12 07:57:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 8176.0 |
| 2016-12-12 07:58:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.3125 | 28.3125 | 1820.0 |
| 2016-12-12 07:59:00 | AAPL | Stock | 28.32 | 28.32 | 28.32 | 28.32 | 800.0 |
| 2016-12-12 08:00:00 | AAPL | Stock | 28.2875 | 28.3375 | 28.2875 | 28.32 | 16016.0 |
| 2016-12-12 08:01:00 | AAPL | Stock | 28.3275 | 28.33 | 28.3125 | 28.3125 | 9408.0 |
| 2016-12-12 08:02:00 | AAPL | Stock | 28.3175 | 28.3175 | 28.3175 | 28.3175 | 17592.0 |
| 2016-12-12 08:03:00 | AAPL | Stock | 28.33 | 28.3375 | 28.33 | 28.3375 | 5696.0 |
| 2016-12-12 08:04:00 | AAPL | Stock | 28.3375 | 28.3375 | 28.335 | 28.335 | 2980.0 |
| 2016-12-12 08:06:00 | AAPL | Stock | 28.3275 | 28.3375 | 28.3275 | 28.3375 | 7400.0 |
| 2016-12-12 08:07:00 | AAPL | Stock | 28.335 | 28.335 | 28.33 | 28.33 | 4400.0 |
| 2016-12-12 08:08:00 | AAPL | Stock | 28.3325 | 28.335 | 28.33 | 28.335 | 6400.0 |
| 2016-12-12 08:09:00 | AAPL | Stock | 28.3325 | 28.3375 | 28.3325 | 28.335 | 9272.0 |
| 2016-12-12 08:10:00 | AAPL | Stock | 28.335 | 28.335 | 28.3325 | 28.3325 | 6400.0 |
| 2016-12-12 08:11:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 400.0 |
| 2016-12-12 08:13:00 | AAPL | Stock | 28.3375 | 28.3375 | 28.3375 | 28.3375 | 2000.0 |
> showing 50 of 1,117,224 rows — these rows as CSV