PREVIEW / stock_1min / 2017-10-12
file: by_date/stock_1min/2017/2017-10-12.parquet size: 14.0 MB rows: 1,011,564 symbols: 2,443
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-10-12 05:52:00 | AAPL | Stock | 39.1 | 39.1 | 39.1 | 39.1 | 400.0 |
| 2017-10-12 05:54:00 | AAPL | Stock | 39.1 | 39.1 | 39.1 | 39.1 | 640.0 |
| 2017-10-12 07:00:00 | AAPL | Stock | 39.0625 | 39.0625 | 39.0625 | 39.0625 | 400.0 |
| 2017-10-12 07:05:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 796.0 |
| 2017-10-12 07:08:00 | AAPL | Stock | 39.0975 | 39.1 | 39.0975 | 39.1 | 896.0 |
| 2017-10-12 07:15:00 | AAPL | Stock | 39.0975 | 39.0975 | 39.0975 | 39.0975 | 3680.0 |
| 2017-10-12 07:21:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 800.0 |
| 2017-10-12 07:35:00 | AAPL | Stock | 39.1 | 39.1 | 39.1 | 39.1 | 1304.0 |
| 2017-10-12 07:42:00 | AAPL | Stock | 39.0675 | 39.075 | 39.0675 | 39.0675 | 4232.0 |
| 2017-10-12 07:43:00 | AAPL | Stock | 39.065 | 39.065 | 39.05 | 39.05 | 10272.0 |
| 2017-10-12 07:48:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 1600.0 |
| 2017-10-12 07:58:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 400.0 |
| 2017-10-12 08:00:00 | AAPL | Stock | 39.1 | 39.1 | 39.05 | 39.1 | 34236.0 |
| 2017-10-12 08:02:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 400.0 |
| 2017-10-12 08:03:00 | AAPL | Stock | 39.09 | 39.225 | 39.09 | 39.225 | 14000.0 |
| 2017-10-12 08:04:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 2000.0 |
| 2017-10-12 08:06:00 | AAPL | Stock | 39.08 | 39.08 | 39.075 | 39.075 | 2048.0 |
| 2017-10-12 08:09:00 | AAPL | Stock | 39.0925 | 39.095 | 39.0925 | 39.095 | 4000.0 |
| 2017-10-12 08:10:00 | AAPL | Stock | 39.095 | 39.095 | 39.095 | 39.095 | 400.0 |
| 2017-10-12 08:11:00 | AAPL | Stock | 39.095 | 39.1 | 39.095 | 39.1 | 6800.0 |
| 2017-10-12 08:12:00 | AAPL | Stock | 39.1075 | 39.1075 | 39.1025 | 39.1075 | 2000.0 |
| 2017-10-12 08:18:00 | AAPL | Stock | 39.1075 | 39.1075 | 39.1075 | 39.1075 | 800.0 |
| 2017-10-12 08:20:00 | AAPL | Stock | 39.0775 | 39.0775 | 39.0775 | 39.0775 | 444.0 |
| 2017-10-12 08:29:00 | AAPL | Stock | 39.0925 | 39.0925 | 39.0925 | 39.0925 | 400.0 |
| 2017-10-12 08:31:00 | AAPL | Stock | 39.1 | 39.1125 | 39.1 | 39.1125 | 7852.0 |
| 2017-10-12 08:38:00 | AAPL | Stock | 39.0925 | 39.0925 | 39.0875 | 39.0875 | 4400.0 |
| 2017-10-12 08:40:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 2800.0 |
| 2017-10-12 08:41:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 2400.0 |
| 2017-10-12 08:42:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 400.0 |
| 2017-10-12 08:43:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 3996.0 |
| 2017-10-12 08:44:00 | AAPL | Stock | 39.075 | 39.075 | 39.0625 | 39.0625 | 11600.0 |
| 2017-10-12 08:48:00 | AAPL | Stock | 39.0675 | 39.0675 | 39.065 | 39.065 | 2000.0 |
| 2017-10-12 08:50:00 | AAPL | Stock | 39.065 | 39.065 | 39.0625 | 39.0625 | 4400.0 |
| 2017-10-12 08:51:00 | AAPL | Stock | 39.0525 | 39.0525 | 39.0525 | 39.0525 | 444.0 |
| 2017-10-12 08:57:00 | AAPL | Stock | 39.0575 | 39.0575 | 39.0425 | 39.05 | 10000.0 |
| 2017-10-12 09:00:00 | AAPL | Stock | 39.0425 | 39.0425 | 39.0425 | 39.0425 | 668.0 |
| 2017-10-12 09:02:00 | AAPL | Stock | 39.05 | 39.065 | 39.05 | 39.065 | 4656.0 |
| 2017-10-12 09:03:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.05 | 39.05 | 23200.0 |
| 2017-10-12 09:04:00 | AAPL | Stock | 39.05 | 39.05 | 39.05 | 39.05 | 1600.0 |
| 2017-10-12 09:05:00 | AAPL | Stock | 39.075 | 39.075 | 39.075 | 39.075 | 4000.0 |
| 2017-10-12 09:07:00 | AAPL | Stock | 39.0825 | 39.0825 | 39.0825 | 39.0825 | 4000.0 |
| 2017-10-12 09:10:00 | AAPL | Stock | 39.07 | 39.07 | 39.07 | 39.07 | 400.0 |
| 2017-10-12 09:13:00 | AAPL | Stock | 39.0725 | 39.0725 | 39.07 | 39.07 | 3320.0 |
| 2017-10-12 09:14:00 | AAPL | Stock | 39.07 | 39.0725 | 39.07 | 39.0725 | 3572.0 |
| 2017-10-12 09:16:00 | AAPL | Stock | 39.055 | 39.055 | 39.055 | 39.055 | 1220.0 |
| 2017-10-12 09:17:00 | AAPL | Stock | 39.055 | 39.055 | 39.055 | 39.055 | 1600.0 |
| 2017-10-12 09:21:00 | AAPL | Stock | 39.065 | 39.0725 | 39.065 | 39.0675 | 1400.0 |
| 2017-10-12 09:22:00 | AAPL | Stock | 39.0725 | 39.0725 | 39.0725 | 39.0725 | 6148.0 |
| 2017-10-12 09:23:00 | AAPL | Stock | 39.0875 | 39.0875 | 39.0875 | 39.0875 | 400.0 |
| 2017-10-12 09:24:00 | AAPL | Stock | 39.1025 | 39.125 | 39.1025 | 39.125 | 31492.0 |
> showing 50 of 1,011,564 rows — these rows as CSV