PREVIEW / stock_1min / 2017-08-11
file: by_date/stock_1min/2017/2017-08-11.parquet size: 15.2 MB rows: 1,106,973 symbols: 2,468
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-08-11 04:11:00 | AAPL | Stock | 38.7375 | 38.75 | 38.7375 | 38.75 | 13500.0 |
| 2017-08-11 04:23:00 | AAPL | Stock | 38.6175 | 38.6175 | 38.6175 | 38.6175 | 404.0 |
| 2017-08-11 04:34:00 | AAPL | Stock | 38.575 | 38.575 | 38.5525 | 38.5525 | 4296.0 |
| 2017-08-11 04:36:00 | AAPL | Stock | 38.6125 | 38.6125 | 38.6 | 38.6125 | 7428.0 |
| 2017-08-11 04:39:00 | AAPL | Stock | 38.5825 | 38.5825 | 38.5825 | 38.5825 | 1200.0 |
| 2017-08-11 04:45:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 500.0 |
| 2017-08-11 04:50:00 | AAPL | Stock | 38.62 | 38.62 | 38.59 | 38.59 | 1600.0 |
| 2017-08-11 04:51:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 800.0 |
| 2017-08-11 04:52:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 1960.0 |
| 2017-08-11 04:55:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 1880.0 |
| 2017-08-11 04:56:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 1880.0 |
| 2017-08-11 05:02:00 | AAPL | Stock | 38.5875 | 38.5875 | 38.5875 | 38.5875 | 2400.0 |
| 2017-08-11 05:12:00 | AAPL | Stock | 38.6175 | 38.6175 | 38.6175 | 38.6175 | 476.0 |
| 2017-08-11 05:24:00 | AAPL | Stock | 38.585 | 38.585 | 38.585 | 38.585 | 1600.0 |
| 2017-08-11 05:25:00 | AAPL | Stock | 38.5775 | 38.5775 | 38.5775 | 38.5775 | 4104.0 |
| 2017-08-11 05:26:00 | AAPL | Stock | 38.5625 | 38.5625 | 38.5625 | 38.5625 | 400.0 |
| 2017-08-11 05:43:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6525 | 38.6525 | 2200.0 |
| 2017-08-11 05:44:00 | AAPL | Stock | 38.7175 | 38.7475 | 38.7175 | 38.7475 | 2704.0 |
| 2017-08-11 05:45:00 | AAPL | Stock | 38.6775 | 38.6775 | 38.6775 | 38.6775 | 1600.0 |
| 2017-08-11 05:52:00 | AAPL | Stock | 38.735 | 38.745 | 38.735 | 38.745 | 2444.0 |
| 2017-08-11 05:53:00 | AAPL | Stock | 38.745 | 38.745 | 38.745 | 38.745 | 4800.0 |
| 2017-08-11 05:55:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.68 | 38.68 | 4400.0 |
| 2017-08-11 05:56:00 | AAPL | Stock | 38.68 | 38.68 | 38.65 | 38.65 | 19296.0 |
| 2017-08-11 05:58:00 | AAPL | Stock | 38.615 | 38.615 | 38.5875 | 38.5875 | 24044.0 |
| 2017-08-11 06:00:00 | AAPL | Stock | 38.6075 | 38.6175 | 38.565 | 38.6175 | 11208.0 |
| 2017-08-11 06:22:00 | AAPL | Stock | 38.65 | 38.675 | 38.65 | 38.675 | 4400.0 |
| 2017-08-11 06:24:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 400.0 |
| 2017-08-11 06:26:00 | AAPL | Stock | 38.73 | 38.73 | 38.73 | 38.73 | 400.0 |
| 2017-08-11 06:29:00 | AAPL | Stock | 38.7325 | 38.7325 | 38.65 | 38.65 | 14284.0 |
| 2017-08-11 06:30:00 | AAPL | Stock | 38.65 | 38.65 | 38.625 | 38.625 | 1784.0 |
| 2017-08-11 06:39:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 400.0 |
| 2017-08-11 06:41:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.6875 | 38.6875 | 1200.0 |
| 2017-08-11 06:44:00 | AAPL | Stock | 38.6875 | 38.6875 | 38.6875 | 38.6875 | 800.0 |
| 2017-08-11 06:49:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 400.0 |
| 2017-08-11 06:50:00 | AAPL | Stock | 38.6975 | 38.6975 | 38.6975 | 38.6975 | 3200.0 |
| 2017-08-11 06:51:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 2400.0 |
| 2017-08-11 06:57:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 400.0 |
| 2017-08-11 06:59:00 | AAPL | Stock | 38.685 | 38.685 | 38.685 | 38.685 | 1600.0 |
| 2017-08-11 07:01:00 | AAPL | Stock | 38.675 | 38.675 | 38.675 | 38.675 | 4000.0 |
| 2017-08-11 07:02:00 | AAPL | Stock | 38.6725 | 38.6725 | 38.6725 | 38.6725 | 800.0 |
| 2017-08-11 07:06:00 | AAPL | Stock | 38.6725 | 38.6725 | 38.6725 | 38.6725 | 3200.0 |
| 2017-08-11 07:07:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 400.0 |
| 2017-08-11 07:08:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.65 | 38.65 | 7200.0 |
| 2017-08-11 07:09:00 | AAPL | Stock | 38.655 | 38.655 | 38.655 | 38.655 | 400.0 |
| 2017-08-11 07:11:00 | AAPL | Stock | 38.6575 | 38.6575 | 38.65 | 38.65 | 2400.0 |
| 2017-08-11 07:14:00 | AAPL | Stock | 38.64 | 38.6625 | 38.635 | 38.6625 | 1668.0 |
| 2017-08-11 07:15:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 900.0 |
| 2017-08-11 07:16:00 | AAPL | Stock | 38.6625 | 38.6625 | 38.6625 | 38.6625 | 400.0 |
| 2017-08-11 07:17:00 | AAPL | Stock | 38.6625 | 38.675 | 38.6625 | 38.675 | 7976.0 |
| 2017-08-11 07:18:00 | AAPL | Stock | 38.68 | 38.68 | 38.68 | 38.68 | 19532.0 |
> showing 50 of 1,106,973 rows — these rows as CSV