PREVIEW / stock_1min / 2017-06-20
file: by_date/stock_1min/2017/2017-06-20.parquet size: 14.2 MB rows: 1,033,647 symbols: 2,494
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-20 04:21:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 1292.0 |
| 2017-06-20 04:54:00 | AAPL | Stock | 36.75 | 36.8225 | 36.75 | 36.8225 | 4908.0 |
| 2017-06-20 05:01:00 | AAPL | Stock | 36.82 | 36.82 | 36.82 | 36.82 | 3760.0 |
| 2017-06-20 05:07:00 | AAPL | Stock | 36.775 | 36.775 | 36.775 | 36.775 | 796.0 |
| 2017-06-20 05:14:00 | AAPL | Stock | 36.775 | 36.775 | 36.775 | 36.775 | 3204.0 |
| 2017-06-20 06:28:00 | AAPL | Stock | 36.7725 | 36.7725 | 36.7725 | 36.7725 | 400.0 |
| 2017-06-20 06:32:00 | AAPL | Stock | 36.7725 | 36.7725 | 36.7725 | 36.7725 | 600.0 |
| 2017-06-20 06:44:00 | AAPL | Stock | 36.69 | 36.69 | 36.69 | 36.69 | 400.0 |
| 2017-06-20 06:48:00 | AAPL | Stock | 36.695 | 36.695 | 36.695 | 36.695 | 2000.0 |
| 2017-06-20 06:49:00 | AAPL | Stock | 36.725 | 36.75 | 36.725 | 36.75 | 1200.0 |
| 2017-06-20 06:50:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 1200.0 |
| 2017-06-20 06:51:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 9200.0 |
| 2017-06-20 06:53:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 2704.0 |
| 2017-06-20 07:01:00 | AAPL | Stock | 36.7625 | 36.7675 | 36.7625 | 36.7675 | 3804.0 |
| 2017-06-20 07:02:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 400.0 |
| 2017-06-20 07:03:00 | AAPL | Stock | 36.77 | 36.77 | 36.7525 | 36.7525 | 5476.0 |
| 2017-06-20 07:04:00 | AAPL | Stock | 36.7625 | 36.7625 | 36.7625 | 36.7625 | 960.0 |
| 2017-06-20 07:05:00 | AAPL | Stock | 36.7625 | 36.7625 | 36.75 | 36.75 | 3200.0 |
| 2017-06-20 07:08:00 | AAPL | Stock | 36.755 | 36.755 | 36.755 | 36.755 | 800.0 |
| 2017-06-20 07:09:00 | AAPL | Stock | 36.755 | 36.755 | 36.755 | 36.755 | 7200.0 |
| 2017-06-20 07:10:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 800.0 |
| 2017-06-20 07:11:00 | AAPL | Stock | 36.75 | 36.75 | 36.75 | 36.75 | 11932.0 |
| 2017-06-20 07:16:00 | AAPL | Stock | 36.73 | 36.7325 | 36.73 | 36.7325 | 5040.0 |
| 2017-06-20 07:18:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 5696.0 |
| 2017-06-20 07:19:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 1800.0 |
| 2017-06-20 07:21:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 2000.0 |
| 2017-06-20 07:23:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 4000.0 |
| 2017-06-20 07:29:00 | AAPL | Stock | 36.69 | 36.69 | 36.6875 | 36.6875 | 2676.0 |
| 2017-06-20 07:30:00 | AAPL | Stock | 36.72 | 36.725 | 36.72 | 36.725 | 7188.0 |
| 2017-06-20 07:31:00 | AAPL | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 3984.0 |
| 2017-06-20 07:34:00 | AAPL | Stock | 36.7 | 36.7125 | 36.7 | 36.7125 | 5128.0 |
| 2017-06-20 07:35:00 | AAPL | Stock | 36.7225 | 36.7225 | 36.7225 | 36.7225 | 716.0 |
| 2017-06-20 07:49:00 | AAPL | Stock | 36.7475 | 36.7475 | 36.7475 | 36.7475 | 1860.0 |
| 2017-06-20 07:54:00 | AAPL | Stock | 36.7275 | 36.7275 | 36.725 | 36.725 | 2800.0 |
| 2017-06-20 07:55:00 | AAPL | Stock | 36.7475 | 36.75 | 36.7475 | 36.75 | 8000.0 |
| 2017-06-20 07:59:00 | AAPL | Stock | 36.77 | 36.7725 | 36.77 | 36.7725 | 4000.0 |
| 2017-06-20 08:00:00 | AAPL | Stock | 36.79 | 36.79 | 36.69 | 36.7375 | 24268.0 |
| 2017-06-20 08:01:00 | AAPL | Stock | 36.7475 | 36.7475 | 36.725 | 36.725 | 44220.0 |
| 2017-06-20 08:02:00 | AAPL | Stock | 36.7375 | 36.7375 | 36.7125 | 36.7125 | 8800.0 |
| 2017-06-20 08:03:00 | AAPL | Stock | 36.7125 | 36.725 | 36.7125 | 36.725 | 47200.0 |
| 2017-06-20 08:04:00 | AAPL | Stock | 36.725 | 36.725 | 36.7075 | 36.7075 | 3600.0 |
| 2017-06-20 08:05:00 | AAPL | Stock | 36.7075 | 36.7225 | 36.7075 | 36.7075 | 4040.0 |
| 2017-06-20 08:06:00 | AAPL | Stock | 36.7075 | 36.7075 | 36.7075 | 36.7075 | 4800.0 |
| 2017-06-20 08:07:00 | AAPL | Stock | 36.725 | 36.725 | 36.715 | 36.72 | 9000.0 |
| 2017-06-20 08:08:00 | AAPL | Stock | 36.72 | 36.72 | 36.72 | 36.72 | 7600.0 |
| 2017-06-20 08:09:00 | AAPL | Stock | 36.715 | 36.715 | 36.7 | 36.7 | 17676.0 |
| 2017-06-20 08:10:00 | AAPL | Stock | 36.7 | 36.71 | 36.6775 | 36.68 | 28412.0 |
| 2017-06-20 08:11:00 | AAPL | Stock | 36.68 | 36.685 | 36.6625 | 36.6625 | 23276.0 |
| 2017-06-20 08:12:00 | AAPL | Stock | 36.665 | 36.665 | 36.6625 | 36.6625 | 15200.0 |
| 2017-06-20 08:13:00 | AAPL | Stock | 36.665 | 36.665 | 36.6525 | 36.655 | 16904.0 |
> showing 50 of 1,033,647 rows — these rows as CSV