PREVIEW / stock_1min / 2017-11-08
file: by_date/stock_1min/2017/2017-11-08.parquet size: 15.2 MB rows: 1,086,322 symbols: 2,434
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-11-08 04:08:00 | AAPL | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 800.0 |
| 2017-11-08 04:32:00 | AAPL | Stock | 43.675 | 43.675 | 43.675 | 43.675 | 792.0 |
| 2017-11-08 05:09:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 1596.0 |
| 2017-11-08 05:36:00 | AAPL | Stock | 43.55 | 43.55 | 43.55 | 43.55 | 6724.0 |
| 2017-11-08 05:51:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 400.0 |
| 2017-11-08 05:52:00 | AAPL | Stock | 43.5925 | 43.5925 | 43.5925 | 43.5925 | 1600.0 |
| 2017-11-08 05:57:00 | AAPL | Stock | 43.59 | 43.59 | 43.575 | 43.575 | 1200.0 |
| 2017-11-08 05:59:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 4000.0 |
| 2017-11-08 06:00:00 | AAPL | Stock | 43.5875 | 43.6 | 43.5875 | 43.6 | 15924.0 |
| 2017-11-08 06:01:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 800.0 |
| 2017-11-08 06:13:00 | AAPL | Stock | 43.595 | 43.595 | 43.595 | 43.595 | 800.0 |
| 2017-11-08 06:17:00 | AAPL | Stock | 43.625 | 43.625 | 43.625 | 43.625 | 1256.0 |
| 2017-11-08 07:00:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.61 | 43.61 | 1600.0 |
| 2017-11-08 07:06:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 1600.0 |
| 2017-11-08 07:07:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 400.0 |
| 2017-11-08 07:08:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6 | 43.6 | 6996.0 |
| 2017-11-08 07:09:00 | AAPL | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 2568.0 |
| 2017-11-08 07:11:00 | AAPL | Stock | 43.595 | 43.595 | 43.595 | 43.595 | 4000.0 |
| 2017-11-08 07:13:00 | AAPL | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 1292.0 |
| 2017-11-08 07:17:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 800.0 |
| 2017-11-08 07:18:00 | AAPL | Stock | 43.6125 | 43.6125 | 43.6125 | 43.6125 | 7600.0 |
| 2017-11-08 07:26:00 | AAPL | Stock | 43.6025 | 43.6025 | 43.6 | 43.6 | 7204.0 |
| 2017-11-08 07:30:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 1200.0 |
| 2017-11-08 07:31:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.575 | 43.575 | 14892.0 |
| 2017-11-08 07:32:00 | AAPL | Stock | 43.575 | 43.575 | 43.5625 | 43.565 | 10384.0 |
| 2017-11-08 07:33:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 452.0 |
| 2017-11-08 07:35:00 | AAPL | Stock | 43.57 | 43.57 | 43.57 | 43.57 | 400.0 |
| 2017-11-08 07:37:00 | AAPL | Stock | 43.575 | 43.585 | 43.575 | 43.585 | 12348.0 |
| 2017-11-08 07:39:00 | AAPL | Stock | 43.5975 | 43.5975 | 43.5975 | 43.5975 | 400.0 |
| 2017-11-08 07:40:00 | AAPL | Stock | 43.6 | 43.6225 | 43.6 | 43.6025 | 12640.0 |
| 2017-11-08 07:45:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 1196.0 |
| 2017-11-08 07:46:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2000.0 |
| 2017-11-08 07:50:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 800.0 |
| 2017-11-08 07:52:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 400.0 |
| 2017-11-08 07:54:00 | AAPL | Stock | 43.59 | 43.6 | 43.59 | 43.6 | 23896.0 |
| 2017-11-08 07:58:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2780.0 |
| 2017-11-08 07:59:00 | AAPL | Stock | 43.5775 | 43.585 | 43.575 | 43.575 | 6200.0 |
| 2017-11-08 08:00:00 | AAPL | Stock | 43.6125 | 43.6175 | 43.585 | 43.5875 | 45272.0 |
| 2017-11-08 08:02:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 964.0 |
| 2017-11-08 08:03:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2400.0 |
| 2017-11-08 08:04:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 1600.0 |
| 2017-11-08 08:06:00 | AAPL | Stock | 43.575 | 43.5875 | 43.575 | 43.5875 | 23280.0 |
| 2017-11-08 08:08:00 | AAPL | Stock | 43.575 | 43.575 | 43.575 | 43.575 | 740.0 |
| 2017-11-08 08:09:00 | AAPL | Stock | 43.575 | 43.5875 | 43.575 | 43.5875 | 8892.0 |
| 2017-11-08 08:10:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2800.0 |
| 2017-11-08 08:11:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 8000.0 |
| 2017-11-08 08:13:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 2000.0 |
| 2017-11-08 08:15:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 400.0 |
| 2017-11-08 08:18:00 | AAPL | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 10000.0 |
| 2017-11-08 08:20:00 | AAPL | Stock | 43.59 | 43.59 | 43.59 | 43.59 | 400.0 |
> showing 50 of 1,086,322 rows — these rows as CSV