PREVIEW / stock_1min / 2018-05-16
file: by_date/stock_1min/2018/2018-05-16.parquet size: 15.4 MB rows: 1,101,459 symbols: 2,373
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-16 04:00:00 | AAPL | Stock | 46.54 | 46.54 | 46.54 | 46.54 | 3704.0 |
| 2018-05-16 04:43:00 | AAPL | Stock | 46.605 | 46.605 | 46.605 | 46.605 | 400.0 |
| 2018-05-16 06:33:00 | AAPL | Stock | 46.4875 | 46.4875 | 46.4875 | 46.4875 | 800.0 |
| 2018-05-16 07:00:00 | AAPL | Stock | 46.56 | 46.56 | 46.56 | 46.56 | 7920.0 |
| 2018-05-16 07:02:00 | AAPL | Stock | 46.6 | 46.6075 | 46.6 | 46.6075 | 2676.0 |
| 2018-05-16 07:04:00 | AAPL | Stock | 46.6075 | 46.6075 | 46.6075 | 46.6075 | 1324.0 |
| 2018-05-16 07:05:00 | AAPL | Stock | 46.5925 | 46.5925 | 46.5925 | 46.5925 | 400.0 |
| 2018-05-16 07:06:00 | AAPL | Stock | 46.585 | 46.585 | 46.585 | 46.585 | 1600.0 |
| 2018-05-16 07:08:00 | AAPL | Stock | 46.5975 | 46.6075 | 46.5975 | 46.6075 | 3328.0 |
| 2018-05-16 07:09:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 2000.0 |
| 2018-05-16 07:10:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 4000.0 |
| 2018-05-16 07:11:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 1848.0 |
| 2018-05-16 07:17:00 | AAPL | Stock | 46.61 | 46.61 | 46.61 | 46.61 | 12000.0 |
| 2018-05-16 07:18:00 | AAPL | Stock | 46.6075 | 46.61 | 46.6075 | 46.61 | 7840.0 |
| 2018-05-16 07:20:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 3840.0 |
| 2018-05-16 07:23:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 1200.0 |
| 2018-05-16 07:31:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 400.0 |
| 2018-05-16 07:33:00 | AAPL | Stock | 46.5925 | 46.5925 | 46.5925 | 46.5925 | 400.0 |
| 2018-05-16 07:35:00 | AAPL | Stock | 46.5775 | 46.5775 | 46.575 | 46.575 | 7920.0 |
| 2018-05-16 07:36:00 | AAPL | Stock | 46.55 | 46.55 | 46.5375 | 46.5375 | 2660.0 |
| 2018-05-16 07:37:00 | AAPL | Stock | 46.575 | 46.575 | 46.575 | 46.575 | 800.0 |
| 2018-05-16 07:41:00 | AAPL | Stock | 46.5275 | 46.5275 | 46.5275 | 46.5275 | 1272.0 |
| 2018-05-16 07:49:00 | AAPL | Stock | 46.57 | 46.57 | 46.57 | 46.57 | 2400.0 |
| 2018-05-16 08:00:00 | AAPL | Stock | 46.639 | 46.64 | 46.5252 | 46.5325 | 23312.0 |
| 2018-05-16 08:02:00 | AAPL | Stock | 46.55 | 46.55 | 46.55 | 46.55 | 400.0 |
| 2018-05-16 08:03:00 | AAPL | Stock | 46.5675 | 46.5675 | 46.5675 | 46.5675 | 600.0 |
| 2018-05-16 08:06:00 | AAPL | Stock | 46.5675 | 46.5675 | 46.5675 | 46.5675 | 400.0 |
| 2018-05-16 08:08:00 | AAPL | Stock | 46.55 | 46.55 | 46.55 | 46.55 | 1200.0 |
| 2018-05-16 08:10:00 | AAPL | Stock | 46.56 | 46.56 | 46.55 | 46.55 | 800.0 |
| 2018-05-16 08:12:00 | AAPL | Stock | 46.5325 | 46.5325 | 46.5275 | 46.5275 | 7292.0 |
| 2018-05-16 08:14:00 | AAPL | Stock | 46.525 | 46.525 | 46.525 | 46.525 | 5600.0 |
| 2018-05-16 08:15:00 | AAPL | Stock | 46.525 | 46.5375 | 46.525 | 46.5375 | 6400.0 |
| 2018-05-16 08:16:00 | AAPL | Stock | 46.5475 | 46.5475 | 46.525 | 46.525 | 800.0 |
| 2018-05-16 08:17:00 | AAPL | Stock | 46.525 | 46.545 | 46.525 | 46.545 | 2304.0 |
| 2018-05-16 08:18:00 | AAPL | Stock | 46.545 | 46.545 | 46.545 | 46.545 | 4000.0 |
| 2018-05-16 08:20:00 | AAPL | Stock | 46.56 | 46.56 | 46.56 | 46.56 | 1600.0 |
| 2018-05-16 08:21:00 | AAPL | Stock | 46.56 | 46.5675 | 46.5525 | 46.5675 | 3960.0 |
| 2018-05-16 08:23:00 | AAPL | Stock | 46.5675 | 46.5675 | 46.5575 | 46.5575 | 1240.0 |
| 2018-05-16 08:24:00 | AAPL | Stock | 46.5575 | 46.5575 | 46.5575 | 46.5575 | 400.0 |
| 2018-05-16 08:25:00 | AAPL | Stock | 46.575 | 46.575 | 46.575 | 46.575 | 5532.0 |
| 2018-05-16 08:26:00 | AAPL | Stock | 46.575 | 46.575 | 46.575 | 46.575 | 9600.0 |
| 2018-05-16 08:27:00 | AAPL | Stock | 46.575 | 46.5875 | 46.5675 | 46.5875 | 7972.0 |
| 2018-05-16 08:29:00 | AAPL | Stock | 46.585 | 46.5875 | 46.5725 | 46.575 | 3200.0 |
| 2018-05-16 08:32:00 | AAPL | Stock | 46.575 | 46.575 | 46.5625 | 46.575 | 3360.0 |
| 2018-05-16 08:35:00 | AAPL | Stock | 46.5625 | 46.5625 | 46.5625 | 46.5625 | 1508.0 |
| 2018-05-16 08:36:00 | AAPL | Stock | 46.5675 | 46.5725 | 46.5675 | 46.5725 | 3200.0 |
| 2018-05-16 08:37:00 | AAPL | Stock | 46.55 | 46.5525 | 46.5125 | 46.5125 | 7320.0 |
| 2018-05-16 08:38:00 | AAPL | Stock | 46.5025 | 46.505 | 46.485 | 46.4875 | 61308.0 |
| 2018-05-16 08:39:00 | AAPL | Stock | 46.4875 | 46.4875 | 46.475 | 46.4775 | 6592.0 |
| 2018-05-16 08:40:00 | AAPL | Stock | 46.475 | 46.475 | 46.4675 | 46.4675 | 2844.0 |
> showing 50 of 1,101,459 rows — these rows as CSV