PREVIEW / stock_1min / 2016-10-26
file: by_date/stock_1min/2016/2016-10-26.parquet size: 13.8 MB rows: 1,012,980 symbols: 2,630
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-26 04:00:00 | AAPL | Stock | 28.5875 | 28.5875 | 28.5825 | 28.5825 | 7080.0 |
| 2016-10-26 04:02:00 | AAPL | Stock | 28.585 | 28.5875 | 28.585 | 28.5875 | 1600.0 |
| 2016-10-26 04:04:00 | AAPL | Stock | 28.5375 | 28.555 | 28.505 | 28.505 | 4400.0 |
| 2016-10-26 04:07:00 | AAPL | Stock | 28.515 | 28.515 | 28.515 | 28.515 | 400.0 |
| 2016-10-26 04:08:00 | AAPL | Stock | 28.535 | 28.535 | 28.525 | 28.525 | 2400.0 |
| 2016-10-26 04:09:00 | AAPL | Stock | 28.525 | 28.525 | 28.5225 | 28.5225 | 3600.0 |
| 2016-10-26 04:11:00 | AAPL | Stock | 28.525 | 28.535 | 28.525 | 28.535 | 1200.0 |
| 2016-10-26 04:13:00 | AAPL | Stock | 28.535 | 28.535 | 28.535 | 28.535 | 732.0 |
| 2016-10-26 04:14:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 600.0 |
| 2016-10-26 04:15:00 | AAPL | Stock | 28.5525 | 28.565 | 28.5525 | 28.565 | 2240.0 |
| 2016-10-26 04:18:00 | AAPL | Stock | 28.5525 | 28.5525 | 28.505 | 28.505 | 4000.0 |
| 2016-10-26 04:20:00 | AAPL | Stock | 28.5475 | 28.5475 | 28.4975 | 28.4975 | 6600.0 |
| 2016-10-26 04:22:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 400.0 |
| 2016-10-26 04:23:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 5840.0 |
| 2016-10-26 04:24:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 1048.0 |
| 2016-10-26 04:25:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 2800.0 |
| 2016-10-26 04:26:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 400.0 |
| 2016-10-26 04:29:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 400.0 |
| 2016-10-26 04:30:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 1880.0 |
| 2016-10-26 04:31:00 | AAPL | Stock | 28.525 | 28.525 | 28.525 | 28.525 | 800.0 |
| 2016-10-26 04:34:00 | AAPL | Stock | 28.5 | 28.5 | 28.5 | 28.5 | 400.0 |
| 2016-10-26 04:39:00 | AAPL | Stock | 28.5375 | 28.5375 | 28.525 | 28.525 | 2560.0 |
| 2016-10-26 04:49:00 | AAPL | Stock | 28.54 | 28.54 | 28.54 | 28.54 | 476.0 |
| 2016-10-26 04:50:00 | AAPL | Stock | 28.55 | 28.55 | 28.5425 | 28.55 | 4844.0 |
| 2016-10-26 04:51:00 | AAPL | Stock | 28.56 | 28.56 | 28.56 | 28.56 | 400.0 |
| 2016-10-26 05:05:00 | AAPL | Stock | 28.55 | 28.55 | 28.55 | 28.55 | 440.0 |
| 2016-10-26 05:07:00 | AAPL | Stock | 28.515 | 28.515 | 28.515 | 28.515 | 1200.0 |
| 2016-10-26 05:08:00 | AAPL | Stock | 28.55 | 28.5575 | 28.515 | 28.5575 | 13160.0 |
| 2016-10-26 05:09:00 | AAPL | Stock | 28.56 | 28.56 | 28.56 | 28.56 | 1160.0 |
| 2016-10-26 05:14:00 | AAPL | Stock | 28.57 | 28.57 | 28.5575 | 28.5575 | 2000.0 |
| 2016-10-26 05:17:00 | AAPL | Stock | 28.5825 | 28.5825 | 28.5825 | 28.5825 | 400.0 |
| 2016-10-26 05:20:00 | AAPL | Stock | 28.5725 | 28.5725 | 28.5675 | 28.5725 | 1200.0 |
| 2016-10-26 05:23:00 | AAPL | Stock | 28.5825 | 28.5825 | 28.5825 | 28.5825 | 800.0 |
| 2016-10-26 05:24:00 | AAPL | Stock | 28.5775 | 28.5775 | 28.575 | 28.575 | 2800.0 |
| 2016-10-26 05:25:00 | AAPL | Stock | 28.575 | 28.575 | 28.575 | 28.575 | 7872.0 |
| 2016-10-26 05:30:00 | AAPL | Stock | 28.5825 | 28.5975 | 28.5825 | 28.5975 | 8356.0 |
| 2016-10-26 05:32:00 | AAPL | Stock | 28.6125 | 28.615 | 28.6125 | 28.615 | 2908.0 |
| 2016-10-26 05:33:00 | AAPL | Stock | 28.6475 | 28.65 | 28.6475 | 28.65 | 2400.0 |
| 2016-10-26 05:34:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 12800.0 |
| 2016-10-26 05:35:00 | AAPL | Stock | 28.6625 | 28.6625 | 28.6525 | 28.6525 | 1600.0 |
| 2016-10-26 05:39:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 4000.0 |
| 2016-10-26 05:40:00 | AAPL | Stock | 28.65 | 28.6575 | 28.65 | 28.65 | 3836.0 |
| 2016-10-26 05:43:00 | AAPL | Stock | 28.65 | 28.65 | 28.65 | 28.65 | 7124.0 |
| 2016-10-26 05:44:00 | AAPL | Stock | 28.6 | 28.6 | 28.6 | 28.6 | 1360.0 |
| 2016-10-26 05:48:00 | AAPL | Stock | 28.63 | 28.6375 | 28.63 | 28.6375 | 4528.0 |
| 2016-10-26 05:49:00 | AAPL | Stock | 28.6375 | 28.6375 | 28.6375 | 28.6375 | 3216.0 |
| 2016-10-26 05:54:00 | AAPL | Stock | 28.675 | 28.6775 | 28.675 | 28.6775 | 10000.0 |
| 2016-10-26 05:57:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 1568.0 |
| 2016-10-26 05:58:00 | AAPL | Stock | 28.6775 | 28.6775 | 28.6775 | 28.6775 | 800.0 |
| 2016-10-26 06:00:00 | AAPL | Stock | 28.675 | 28.675 | 28.675 | 28.675 | 800.0 |
> showing 50 of 1,012,980 rows — these rows as CSV