PREVIEW / stock_1min / 2017-06-07
file: by_date/stock_1min/2017/2017-06-07.parquet size: 14.3 MB rows: 1,045,962 symbols: 2,521
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-07 05:25:00 | AAPL | Stock | 38.6675 | 38.6675 | 38.6675 | 38.6675 | 2792.0 |
| 2017-06-07 05:29:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.685 | 38.685 | 2208.0 |
| 2017-06-07 05:31:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 420.0 |
| 2017-06-07 05:32:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 400.0 |
| 2017-06-07 06:37:00 | AAPL | Stock | 38.67 | 38.67 | 38.67 | 38.67 | 800.0 |
| 2017-06-07 07:06:00 | AAPL | Stock | 38.655 | 38.655 | 38.655 | 38.655 | 800.0 |
| 2017-06-07 07:11:00 | AAPL | Stock | 38.6725 | 38.6725 | 38.655 | 38.655 | 800.0 |
| 2017-06-07 07:16:00 | AAPL | Stock | 38.65 | 38.65 | 38.65 | 38.65 | 400.0 |
| 2017-06-07 07:17:00 | AAPL | Stock | 38.6375 | 38.6375 | 38.6375 | 38.6375 | 2400.0 |
| 2017-06-07 07:22:00 | AAPL | Stock | 38.65 | 38.6625 | 38.65 | 38.6625 | 2388.0 |
| 2017-06-07 07:24:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 2000.0 |
| 2017-06-07 07:26:00 | AAPL | Stock | 38.685 | 38.6875 | 38.685 | 38.6875 | 5088.0 |
| 2017-06-07 07:27:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 400.0 |
| 2017-06-07 07:28:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.6875 | 38.6875 | 4000.0 |
| 2017-06-07 07:29:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 400.0 |
| 2017-06-07 07:30:00 | AAPL | Stock | 38.7 | 38.7 | 38.7 | 38.7 | 800.0 |
| 2017-06-07 07:33:00 | AAPL | Stock | 38.7025 | 38.7025 | 38.7 | 38.7 | 5832.0 |
| 2017-06-07 07:34:00 | AAPL | Stock | 38.7125 | 38.7125 | 38.7125 | 38.7125 | 400.0 |
| 2017-06-07 07:36:00 | AAPL | Stock | 38.71 | 38.71 | 38.71 | 38.71 | 2000.0 |
| 2017-06-07 07:41:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 400.0 |
| 2017-06-07 07:51:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 400.0 |
| 2017-06-07 07:52:00 | AAPL | Stock | 38.7 | 38.7 | 38.7 | 38.7 | 400.0 |
| 2017-06-07 07:54:00 | AAPL | Stock | 38.6975 | 38.7025 | 38.6975 | 38.7025 | 3684.0 |
| 2017-06-07 07:55:00 | AAPL | Stock | 38.7125 | 38.7125 | 38.7125 | 38.7125 | 800.0 |
| 2017-06-07 07:57:00 | AAPL | Stock | 38.7125 | 38.715 | 38.7125 | 38.715 | 1720.0 |
| 2017-06-07 07:58:00 | AAPL | Stock | 38.7175 | 38.7175 | 38.7175 | 38.7175 | 1568.0 |
| 2017-06-07 08:00:00 | AAPL | Stock | 38.6875 | 38.7175 | 38.6875 | 38.6975 | 6800.0 |
| 2017-06-07 08:01:00 | AAPL | Stock | 38.7 | 38.7075 | 38.7 | 38.705 | 3456.0 |
| 2017-06-07 08:04:00 | AAPL | Stock | 38.69 | 38.6925 | 38.69 | 38.6925 | 3600.0 |
| 2017-06-07 08:05:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.6875 | 38.6875 | 1652.0 |
| 2017-06-07 08:06:00 | AAPL | Stock | 38.69 | 38.7 | 38.69 | 38.7 | 5336.0 |
| 2017-06-07 08:11:00 | AAPL | Stock | 38.7 | 38.7 | 38.6975 | 38.6975 | 10868.0 |
| 2017-06-07 08:12:00 | AAPL | Stock | 38.7025 | 38.715 | 38.7025 | 38.715 | 4756.0 |
| 2017-06-07 08:16:00 | AAPL | Stock | 38.7125 | 38.715 | 38.7125 | 38.715 | 4164.0 |
| 2017-06-07 08:18:00 | AAPL | Stock | 38.705 | 38.725 | 38.705 | 38.7175 | 13960.0 |
| 2017-06-07 08:19:00 | AAPL | Stock | 38.7225 | 38.7225 | 38.715 | 38.7175 | 17280.0 |
| 2017-06-07 08:24:00 | AAPL | Stock | 38.7125 | 38.7125 | 38.7125 | 38.7125 | 1200.0 |
| 2017-06-07 08:25:00 | AAPL | Stock | 38.7125 | 38.7175 | 38.7125 | 38.7175 | 4400.0 |
| 2017-06-07 08:27:00 | AAPL | Stock | 38.72 | 38.72 | 38.72 | 38.72 | 800.0 |
| 2017-06-07 08:28:00 | AAPL | Stock | 38.72 | 38.72 | 38.72 | 38.72 | 1200.0 |
| 2017-06-07 08:29:00 | AAPL | Stock | 38.72 | 38.72 | 38.72 | 38.72 | 800.0 |
| 2017-06-07 08:30:00 | AAPL | Stock | 38.72 | 38.72 | 38.715 | 38.72 | 3544.0 |
| 2017-06-07 08:34:00 | AAPL | Stock | 38.715 | 38.715 | 38.715 | 38.715 | 400.0 |
| 2017-06-07 08:35:00 | AAPL | Stock | 38.72 | 38.72 | 38.715 | 38.715 | 2400.0 |
| 2017-06-07 08:36:00 | AAPL | Stock | 38.72 | 38.72 | 38.72 | 38.72 | 1492.0 |
| 2017-06-07 08:37:00 | AAPL | Stock | 38.7175 | 38.7175 | 38.7175 | 38.7175 | 400.0 |
| 2017-06-07 08:38:00 | AAPL | Stock | 38.7175 | 38.7175 | 38.7175 | 38.7175 | 800.0 |
| 2017-06-07 08:40:00 | AAPL | Stock | 38.7175 | 38.72 | 38.7175 | 38.72 | 4384.0 |
| 2017-06-07 08:42:00 | AAPL | Stock | 38.7175 | 38.7175 | 38.7175 | 38.7175 | 400.0 |
| 2017-06-07 08:43:00 | AAPL | Stock | 38.7175 | 38.7175 | 38.71 | 38.71 | 1912.0 |
> showing 50 of 1,045,962 rows — these rows as CSV