PREVIEW / stock_1min / 2019-07-12
file: by_date/stock_1min/2019/2019-07-12.parquet size: 14.9 MB rows: 1,064,036 symbols: 2,173
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-12 04:16:00 | AAPL | Stock | 50.54 | 50.59 | 50.54 | 50.59 | 1996.0 |
| 2019-07-12 04:40:00 | AAPL | Stock | 50.6 | 50.6 | 50.6 | 50.6 | 400.0 |
| 2019-07-12 05:01:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 2800.0 |
| 2019-07-12 05:04:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 680.0 |
| 2019-07-12 05:23:00 | AAPL | Stock | 50.5925 | 50.5925 | 50.5925 | 50.5925 | 400.0 |
| 2019-07-12 05:27:00 | AAPL | Stock | 50.555 | 50.555 | 50.55 | 50.55 | 2400.0 |
| 2019-07-12 05:31:00 | AAPL | Stock | 50.54 | 50.54 | 50.5375 | 50.5375 | 3680.0 |
| 2019-07-12 05:46:00 | AAPL | Stock | 50.5625 | 50.5625 | 50.5625 | 50.5625 | 400.0 |
| 2019-07-12 05:50:00 | AAPL | Stock | 50.5675 | 50.5675 | 50.5675 | 50.5675 | 1680.0 |
| 2019-07-12 06:09:00 | AAPL | Stock | 50.6 | 50.625 | 50.5975 | 50.625 | 10372.0 |
| 2019-07-12 06:12:00 | AAPL | Stock | 50.6425 | 50.6425 | 50.6375 | 50.6375 | 2400.0 |
| 2019-07-12 06:20:00 | AAPL | Stock | 50.65 | 50.6875 | 50.65 | 50.6875 | 3200.0 |
| 2019-07-12 06:30:00 | AAPL | Stock | 50.65 | 50.65 | 50.65 | 50.65 | 800.0 |
| 2019-07-12 06:43:00 | AAPL | Stock | 50.63 | 50.63 | 50.63 | 50.63 | 1020.0 |
| 2019-07-12 06:45:00 | AAPL | Stock | 50.675 | 50.675 | 50.675 | 50.675 | 400.0 |
| 2019-07-12 06:48:00 | AAPL | Stock | 50.575 | 50.575 | 50.575 | 50.575 | 800.0 |
| 2019-07-12 06:49:00 | AAPL | Stock | 50.5625 | 50.5625 | 50.5525 | 50.5525 | 1200.0 |
| 2019-07-12 06:53:00 | AAPL | Stock | 50.555 | 50.555 | 50.5275 | 50.5275 | 2000.0 |
| 2019-07-12 06:55:00 | AAPL | Stock | 50.5275 | 50.5275 | 50.5275 | 50.5275 | 1496.0 |
| 2019-07-12 06:56:00 | AAPL | Stock | 50.525 | 50.5275 | 50.525 | 50.5275 | 1200.0 |
| 2019-07-12 06:57:00 | AAPL | Stock | 50.5275 | 50.5275 | 50.5275 | 50.5275 | 400.0 |
| 2019-07-12 06:58:00 | AAPL | Stock | 50.55 | 50.55 | 50.55 | 50.55 | 800.0 |
| 2019-07-12 07:00:00 | AAPL | Stock | 50.54 | 50.575 | 50.53 | 50.575 | 3200.0 |
| 2019-07-12 07:02:00 | AAPL | Stock | 50.575 | 50.575 | 50.565 | 50.565 | 1488.0 |
| 2019-07-12 07:04:00 | AAPL | Stock | 50.595 | 50.595 | 50.59 | 50.59 | 4596.0 |
| 2019-07-12 07:07:00 | AAPL | Stock | 50.575 | 50.575 | 50.575 | 50.575 | 1096.0 |
| 2019-07-12 07:08:00 | AAPL | Stock | 50.5875 | 50.59 | 50.5875 | 50.59 | 19804.0 |
| 2019-07-12 07:09:00 | AAPL | Stock | 50.5675 | 50.5675 | 50.5675 | 50.5675 | 3200.0 |
| 2019-07-12 07:12:00 | AAPL | Stock | 50.575 | 50.575 | 50.5675 | 50.5675 | 7600.0 |
| 2019-07-12 07:14:00 | AAPL | Stock | 50.5825 | 50.5825 | 50.5725 | 50.5725 | 1812.0 |
| 2019-07-12 07:15:00 | AAPL | Stock | 50.575 | 50.575 | 50.5725 | 50.5725 | 2312.0 |
| 2019-07-12 07:16:00 | AAPL | Stock | 50.5725 | 50.5725 | 50.5725 | 50.5725 | 3088.0 |
| 2019-07-12 07:19:00 | AAPL | Stock | 50.5675 | 50.5675 | 50.55 | 50.55 | 3600.0 |
| 2019-07-12 07:20:00 | AAPL | Stock | 50.5525 | 50.5525 | 50.5525 | 50.5525 | 400.0 |
| 2019-07-12 07:21:00 | AAPL | Stock | 50.5825 | 50.5825 | 50.5825 | 50.5825 | 1016.0 |
| 2019-07-12 07:22:00 | AAPL | Stock | 50.575 | 50.575 | 50.575 | 50.575 | 400.0 |
| 2019-07-12 07:25:00 | AAPL | Stock | 50.5775 | 50.59 | 50.5775 | 50.59 | 4036.0 |
| 2019-07-12 07:26:00 | AAPL | Stock | 50.5875 | 50.5875 | 50.5875 | 50.5875 | 400.0 |
| 2019-07-12 07:27:00 | AAPL | Stock | 50.5825 | 50.5825 | 50.5825 | 50.5825 | 400.0 |
| 2019-07-12 07:29:00 | AAPL | Stock | 50.5925 | 50.595 | 50.58 | 50.58 | 2800.0 |
| 2019-07-12 07:30:00 | AAPL | Stock | 50.5575 | 50.5575 | 50.5525 | 50.5575 | 5600.0 |
| 2019-07-12 07:31:00 | AAPL | Stock | 50.5575 | 50.5575 | 50.5525 | 50.555 | 4400.0 |
| 2019-07-12 07:32:00 | AAPL | Stock | 50.555 | 50.555 | 50.5425 | 50.5425 | 4200.0 |
| 2019-07-12 07:33:00 | AAPL | Stock | 50.5425 | 50.5775 | 50.5325 | 50.5325 | 6500.0 |
| 2019-07-12 07:38:00 | AAPL | Stock | 50.5725 | 50.575 | 50.5725 | 50.575 | 1200.0 |
| 2019-07-12 07:42:00 | AAPL | Stock | 50.5825 | 50.5825 | 50.5825 | 50.5825 | 400.0 |
| 2019-07-12 07:43:00 | AAPL | Stock | 50.585 | 50.5925 | 50.585 | 50.5925 | 2000.0 |
| 2019-07-12 07:44:00 | AAPL | Stock | 50.5925 | 50.595 | 50.575 | 50.575 | 2800.0 |
| 2019-07-12 07:48:00 | AAPL | Stock | 50.5975 | 50.6 | 50.5975 | 50.6 | 800.0 |
| 2019-07-12 07:49:00 | AAPL | Stock | 50.6 | 50.6 | 50.6 | 50.6 | 13472.0 |
> showing 50 of 1,064,036 rows — these rows as CSV