PREVIEW / stock_1min / 2018-03-15
file: by_date/stock_1min/2018/2018-03-15.parquet size: 15.4 MB rows: 1,097,718 symbols: 2,381
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-03-15 04:37:00 | AAPL | Stock | 44.6075 | 44.6075 | 44.6075 | 44.6075 | 3832.0 |
| 2018-03-15 04:42:00 | AAPL | Stock | 44.6375 | 44.6375 | 44.6375 | 44.6375 | 2000.0 |
| 2018-03-15 04:49:00 | AAPL | Stock | 44.6375 | 44.7175 | 44.6375 | 44.7175 | 5200.0 |
| 2018-03-15 05:29:00 | AAPL | Stock | 44.7175 | 44.7175 | 44.7175 | 44.7175 | 1360.0 |
| 2018-03-15 05:45:00 | AAPL | Stock | 44.7125 | 44.7125 | 44.7 | 44.7 | 2356.0 |
| 2018-03-15 05:52:00 | AAPL | Stock | 44.7 | 44.7 | 44.7 | 44.7 | 1600.0 |
| 2018-03-15 06:08:00 | AAPL | Stock | 44.65 | 44.65 | 44.65 | 44.65 | 400.0 |
| 2018-03-15 06:17:00 | AAPL | Stock | 44.61 | 44.61 | 44.61 | 44.61 | 400.0 |
| 2018-03-15 06:26:00 | AAPL | Stock | 44.645 | 44.645 | 44.645 | 44.645 | 800.0 |
| 2018-03-15 06:40:00 | AAPL | Stock | 44.5875 | 44.5875 | 44.5875 | 44.5875 | 400.0 |
| 2018-03-15 06:50:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 2000.0 |
| 2018-03-15 06:51:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 1340.0 |
| 2018-03-15 06:56:00 | AAPL | Stock | 44.55 | 44.55 | 44.55 | 44.55 | 660.0 |
| 2018-03-15 07:00:00 | AAPL | Stock | 44.595 | 44.5975 | 44.595 | 44.5975 | 2000.0 |
| 2018-03-15 07:04:00 | AAPL | Stock | 44.535 | 44.55 | 44.535 | 44.55 | 5756.0 |
| 2018-03-15 07:05:00 | AAPL | Stock | 44.555 | 44.5925 | 44.555 | 44.5925 | 4800.0 |
| 2018-03-15 07:06:00 | AAPL | Stock | 44.5825 | 44.5875 | 44.5575 | 44.5575 | 16400.0 |
| 2018-03-15 07:07:00 | AAPL | Stock | 44.5575 | 44.5575 | 44.5575 | 44.5575 | 400.0 |
| 2018-03-15 07:08:00 | AAPL | Stock | 44.5575 | 44.5575 | 44.5575 | 44.5575 | 1600.0 |
| 2018-03-15 07:09:00 | AAPL | Stock | 44.545 | 44.5775 | 44.545 | 44.5775 | 6200.0 |
| 2018-03-15 07:10:00 | AAPL | Stock | 44.5775 | 44.5775 | 44.5775 | 44.5775 | 14400.0 |
| 2018-03-15 07:11:00 | AAPL | Stock | 44.5825 | 44.5825 | 44.5825 | 44.5825 | 10000.0 |
| 2018-03-15 07:12:00 | AAPL | Stock | 44.5675 | 44.5675 | 44.565 | 44.565 | 2084.0 |
| 2018-03-15 07:13:00 | AAPL | Stock | 44.575 | 44.575 | 44.5625 | 44.5625 | 8380.0 |
| 2018-03-15 07:18:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 5800.0 |
| 2018-03-15 07:20:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 1200.0 |
| 2018-03-15 07:21:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5575 | 44.5575 | 1800.0 |
| 2018-03-15 07:27:00 | AAPL | Stock | 44.565 | 44.565 | 44.565 | 44.565 | 400.0 |
| 2018-03-15 07:28:00 | AAPL | Stock | 44.575 | 44.575 | 44.57 | 44.57 | 3700.0 |
| 2018-03-15 07:32:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 400.0 |
| 2018-03-15 07:33:00 | AAPL | Stock | 44.56 | 44.56 | 44.56 | 44.56 | 500.0 |
| 2018-03-15 07:35:00 | AAPL | Stock | 44.57 | 44.575 | 44.57 | 44.575 | 2800.0 |
| 2018-03-15 07:38:00 | AAPL | Stock | 44.5675 | 44.5675 | 44.5625 | 44.5625 | 1476.0 |
| 2018-03-15 07:39:00 | AAPL | Stock | 44.58 | 44.58 | 44.58 | 44.58 | 400.0 |
| 2018-03-15 07:45:00 | AAPL | Stock | 44.6 | 44.6 | 44.6 | 44.6 | 400.0 |
| 2018-03-15 07:54:00 | AAPL | Stock | 44.58 | 44.61 | 44.58 | 44.61 | 5076.0 |
| 2018-03-15 07:55:00 | AAPL | Stock | 44.58 | 44.58 | 44.5575 | 44.5575 | 9012.0 |
| 2018-03-15 07:58:00 | AAPL | Stock | 44.5625 | 44.58 | 44.5625 | 44.58 | 2000.0 |
| 2018-03-15 08:00:00 | AAPL | Stock | 44.59 | 44.59 | 44.545 | 44.55 | 28232.0 |
| 2018-03-15 08:01:00 | AAPL | Stock | 44.5725 | 44.5725 | 44.5725 | 44.5725 | 400.0 |
| 2018-03-15 08:02:00 | AAPL | Stock | 44.5725 | 44.58 | 44.5725 | 44.58 | 1076.0 |
| 2018-03-15 08:03:00 | AAPL | Stock | 44.58 | 44.58 | 44.58 | 44.58 | 400.0 |
| 2018-03-15 08:04:00 | AAPL | Stock | 44.56 | 44.5775 | 44.545 | 44.5775 | 7124.0 |
| 2018-03-15 08:05:00 | AAPL | Stock | 44.5725 | 44.5825 | 44.56 | 44.56 | 14676.0 |
| 2018-03-15 08:06:00 | AAPL | Stock | 44.575 | 44.575 | 44.575 | 44.575 | 400.0 |
| 2018-03-15 08:07:00 | AAPL | Stock | 44.5675 | 44.5675 | 44.5675 | 44.5675 | 400.0 |
| 2018-03-15 08:09:00 | AAPL | Stock | 44.5625 | 44.5625 | 44.5625 | 44.5625 | 800.0 |
| 2018-03-15 08:11:00 | AAPL | Stock | 44.5625 | 44.5825 | 44.5525 | 44.5825 | 10400.0 |
| 2018-03-15 08:12:00 | AAPL | Stock | 44.5525 | 44.5525 | 44.545 | 44.545 | 7324.0 |
| 2018-03-15 08:13:00 | AAPL | Stock | 44.5375 | 44.5375 | 44.5375 | 44.5375 | 800.0 |
> showing 50 of 1,097,718 rows — these rows as CSV