PREVIEW / stock_1min / 2017-05-02
file: by_date/stock_1min/2017/2017-05-02.parquet size: 14.9 MB rows: 1,077,095 symbols: 2,530
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-05-02 04:00:00 | AAPL | Stock | 36.645 | 36.7 | 36.6375 | 36.7 | 17668.0 |
| 2017-05-02 04:01:00 | AAPL | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 2996.0 |
| 2017-05-02 04:08:00 | AAPL | Stock | 36.6975 | 36.6975 | 36.6975 | 36.6975 | 400.0 |
| 2017-05-02 04:26:00 | AAPL | Stock | 36.6575 | 36.6575 | 36.6575 | 36.6575 | 1460.0 |
| 2017-05-02 05:07:00 | AAPL | Stock | 36.6575 | 36.6575 | 36.6175 | 36.6175 | 1744.0 |
| 2017-05-02 05:09:00 | AAPL | Stock | 36.6 | 36.6 | 36.6 | 36.6 | 560.0 |
| 2017-05-02 05:13:00 | AAPL | Stock | 36.6375 | 36.6375 | 36.6375 | 36.6375 | 3352.0 |
| 2017-05-02 05:14:00 | AAPL | Stock | 36.6375 | 36.6375 | 36.6375 | 36.6375 | 800.0 |
| 2017-05-02 05:44:00 | AAPL | Stock | 36.6625 | 36.6625 | 36.6625 | 36.6625 | 440.0 |
| 2017-05-02 05:48:00 | AAPL | Stock | 36.655 | 36.655 | 36.655 | 36.655 | 400.0 |
| 2017-05-02 05:49:00 | AAPL | Stock | 36.6625 | 36.6625 | 36.6625 | 36.6625 | 492.0 |
| 2017-05-02 05:51:00 | AAPL | Stock | 36.6625 | 36.6625 | 36.6625 | 36.6625 | 1228.0 |
| 2017-05-02 05:56:00 | AAPL | Stock | 36.675 | 36.675 | 36.675 | 36.675 | 2400.0 |
| 2017-05-02 05:58:00 | AAPL | Stock | 36.685 | 36.685 | 36.685 | 36.685 | 524.0 |
| 2017-05-02 06:00:00 | AAPL | Stock | 36.685 | 36.685 | 36.685 | 36.685 | 3000.0 |
| 2017-05-02 06:01:00 | AAPL | Stock | 36.6875 | 36.6875 | 36.6875 | 36.6875 | 400.0 |
| 2017-05-02 06:02:00 | AAPL | Stock | 36.7225 | 36.7225 | 36.7225 | 36.7225 | 680.0 |
| 2017-05-02 06:03:00 | AAPL | Stock | 36.73 | 36.73 | 36.73 | 36.73 | 2672.0 |
| 2017-05-02 06:08:00 | AAPL | Stock | 36.73 | 36.73 | 36.73 | 36.73 | 4000.0 |
| 2017-05-02 06:15:00 | AAPL | Stock | 36.7275 | 36.7275 | 36.7275 | 36.7275 | 2000.0 |
| 2017-05-02 06:20:00 | AAPL | Stock | 36.7025 | 36.7025 | 36.7025 | 36.7025 | 960.0 |
| 2017-05-02 06:22:00 | AAPL | Stock | 36.6875 | 36.6875 | 36.6875 | 36.6875 | 760.0 |
| 2017-05-02 06:36:00 | AAPL | Stock | 36.6875 | 36.6875 | 36.6875 | 36.6875 | 2000.0 |
| 2017-05-02 06:39:00 | AAPL | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 400.0 |
| 2017-05-02 06:40:00 | AAPL | Stock | 36.705 | 36.705 | 36.705 | 36.705 | 5000.0 |
| 2017-05-02 06:42:00 | AAPL | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 1240.0 |
| 2017-05-02 06:50:00 | AAPL | Stock | 36.71 | 36.71 | 36.71 | 36.71 | 2000.0 |
| 2017-05-02 06:51:00 | AAPL | Stock | 36.7125 | 36.7125 | 36.7125 | 36.7125 | 1600.0 |
| 2017-05-02 06:53:00 | AAPL | Stock | 36.7125 | 36.7125 | 36.7125 | 36.7125 | 1160.0 |
| 2017-05-02 06:56:00 | AAPL | Stock | 36.705 | 36.705 | 36.705 | 36.705 | 800.0 |
| 2017-05-02 06:57:00 | AAPL | Stock | 36.705 | 36.705 | 36.705 | 36.705 | 2400.0 |
| 2017-05-02 06:58:00 | AAPL | Stock | 36.69 | 36.69 | 36.6875 | 36.6875 | 2680.0 |
| 2017-05-02 07:00:00 | AAPL | Stock | 36.7025 | 36.7125 | 36.7025 | 36.7125 | 3488.0 |
| 2017-05-02 07:01:00 | AAPL | Stock | 36.7125 | 36.72 | 36.7125 | 36.72 | 7416.0 |
| 2017-05-02 07:02:00 | AAPL | Stock | 36.725 | 36.73 | 36.725 | 36.73 | 5200.0 |
| 2017-05-02 07:03:00 | AAPL | Stock | 36.73 | 36.7325 | 36.725 | 36.725 | 32316.0 |
| 2017-05-02 07:04:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 15200.0 |
| 2017-05-02 07:05:00 | AAPL | Stock | 36.7225 | 36.7225 | 36.7225 | 36.7225 | 400.0 |
| 2017-05-02 07:07:00 | AAPL | Stock | 36.7125 | 36.7125 | 36.7125 | 36.7125 | 9900.0 |
| 2017-05-02 07:10:00 | AAPL | Stock | 36.7175 | 36.7175 | 36.7175 | 36.7175 | 400.0 |
| 2017-05-02 07:12:00 | AAPL | Stock | 36.7225 | 36.7225 | 36.7225 | 36.7225 | 600.0 |
| 2017-05-02 07:13:00 | AAPL | Stock | 36.725 | 36.725 | 36.725 | 36.725 | 540.0 |
| 2017-05-02 07:14:00 | AAPL | Stock | 36.7225 | 36.7225 | 36.7225 | 36.7225 | 800.0 |
| 2017-05-02 07:15:00 | AAPL | Stock | 36.715 | 36.715 | 36.7125 | 36.7125 | 10572.0 |
| 2017-05-02 07:16:00 | AAPL | Stock | 36.7125 | 36.7125 | 36.7125 | 36.7125 | 1528.0 |
| 2017-05-02 07:17:00 | AAPL | Stock | 36.7 | 36.7 | 36.7 | 36.7 | 800.0 |
| 2017-05-02 07:18:00 | AAPL | Stock | 36.6925 | 36.6925 | 36.68 | 36.68 | 31456.0 |
| 2017-05-02 07:19:00 | AAPL | Stock | 36.675 | 36.675 | 36.6725 | 36.6725 | 8000.0 |
| 2017-05-02 07:21:00 | AAPL | Stock | 36.675 | 36.675 | 36.67 | 36.67 | 2000.0 |
| 2017-05-02 07:22:00 | AAPL | Stock | 36.6675 | 36.6675 | 36.6675 | 36.6675 | 4400.0 |
> showing 50 of 1,077,095 rows — these rows as CSV