PREVIEW / stock_1min / 2018-07-02
file: by_date/stock_1min/2018/2018-07-02.parquet size: 15.0 MB rows: 1,082,973 symbols: 2,329
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-02 04:05:00 | AAPL | Stock | 45.9675 | 45.9675 | 45.9675 | 45.9675 | 400.0 |
| 2018-07-02 04:12:00 | AAPL | Stock | 45.9975 | 45.9975 | 45.9975 | 45.9975 | 1200.0 |
| 2018-07-02 04:16:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 2000.0 |
| 2018-07-02 04:26:00 | AAPL | Stock | 45.9975 | 45.9975 | 45.9975 | 45.9975 | 400.0 |
| 2018-07-02 05:25:00 | AAPL | Stock | 46.0025 | 46.0025 | 46.0025 | 46.0025 | 400.0 |
| 2018-07-02 05:27:00 | AAPL | Stock | 46.0025 | 46.0025 | 46.0025 | 46.0025 | 400.0 |
| 2018-07-02 05:28:00 | AAPL | Stock | 46.0025 | 46.0025 | 46.0025 | 46.0025 | 800.0 |
| 2018-07-02 05:35:00 | AAPL | Stock | 46.0025 | 46.0125 | 46.0025 | 46.0125 | 1080.0 |
| 2018-07-02 06:20:00 | AAPL | Stock | 45.975 | 45.975 | 45.975 | 45.975 | 9996.0 |
| 2018-07-02 06:22:00 | AAPL | Stock | 46.0 | 46.0 | 45.9875 | 45.9875 | 800.0 |
| 2018-07-02 06:36:00 | AAPL | Stock | 45.9775 | 45.9775 | 45.9775 | 45.9775 | 1600.0 |
| 2018-07-02 06:53:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 400.0 |
| 2018-07-02 07:00:00 | AAPL | Stock | 46.065 | 46.07 | 45.9275 | 45.9275 | 5812.0 |
| 2018-07-02 07:01:00 | AAPL | Stock | 46.0 | 46.0625 | 46.0 | 46.0625 | 22052.0 |
| 2018-07-02 07:10:00 | AAPL | Stock | 46.0175 | 46.0175 | 46.0175 | 46.0175 | 400.0 |
| 2018-07-02 07:16:00 | AAPL | Stock | 46.06 | 46.07 | 46.06 | 46.07 | 1464.0 |
| 2018-07-02 07:17:00 | AAPL | Stock | 46.07 | 46.07 | 46.07 | 46.07 | 816.0 |
| 2018-07-02 07:18:00 | AAPL | Stock | 46.07 | 46.07 | 46.07 | 46.07 | 2000.0 |
| 2018-07-02 07:20:00 | AAPL | Stock | 46.05 | 46.05 | 46.05 | 46.05 | 800.0 |
| 2018-07-02 07:28:00 | AAPL | Stock | 46.05 | 46.05 | 46.05 | 46.05 | 11600.0 |
| 2018-07-02 07:32:00 | AAPL | Stock | 46.0125 | 46.0125 | 46.0125 | 46.0125 | 400.0 |
| 2018-07-02 07:37:00 | AAPL | Stock | 46.0375 | 46.0375 | 46.0375 | 46.0375 | 3600.0 |
| 2018-07-02 07:38:00 | AAPL | Stock | 46.0375 | 46.0375 | 46.0375 | 46.0375 | 5352.0 |
| 2018-07-02 07:45:00 | AAPL | Stock | 46.0075 | 46.0125 | 46.0075 | 46.0125 | 800.0 |
| 2018-07-02 07:46:00 | AAPL | Stock | 46.0125 | 46.0125 | 46.0125 | 46.0125 | 800.0 |
| 2018-07-02 07:52:00 | AAPL | Stock | 46.0625 | 46.0625 | 46.0625 | 46.0625 | 400.0 |
| 2018-07-02 07:53:00 | AAPL | Stock | 46.05 | 46.05 | 46.05 | 46.05 | 688.0 |
| 2018-07-02 08:00:00 | AAPL | Stock | 45.97 | 46.1125 | 45.97 | 46.015 | 46468.0 |
| 2018-07-02 08:03:00 | AAPL | Stock | 46.095 | 46.095 | 46.095 | 46.095 | 400.0 |
| 2018-07-02 08:07:00 | AAPL | Stock | 46.075 | 46.0825 | 46.075 | 46.0825 | 800.0 |
| 2018-07-02 08:09:00 | AAPL | Stock | 46.0375 | 46.0375 | 46.005 | 46.005 | 2380.0 |
| 2018-07-02 08:10:00 | AAPL | Stock | 46.0075 | 46.0075 | 46.0 | 46.0 | 1200.0 |
| 2018-07-02 08:11:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 1428.0 |
| 2018-07-02 08:12:00 | AAPL | Stock | 45.9975 | 45.9975 | 45.9975 | 45.9975 | 400.0 |
| 2018-07-02 08:13:00 | AAPL | Stock | 45.9875 | 46.0 | 45.9875 | 46.0 | 5732.0 |
| 2018-07-02 08:14:00 | AAPL | Stock | 45.9975 | 45.9975 | 45.9975 | 45.9975 | 432.0 |
| 2018-07-02 08:15:00 | AAPL | Stock | 45.9875 | 45.9875 | 45.9875 | 45.9875 | 768.0 |
| 2018-07-02 08:16:00 | AAPL | Stock | 45.9875 | 45.9875 | 45.9875 | 45.9875 | 800.0 |
| 2018-07-02 08:17:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 1080.0 |
| 2018-07-02 08:19:00 | AAPL | Stock | 46.0 | 46.0 | 45.975 | 45.9975 | 8068.0 |
| 2018-07-02 08:20:00 | AAPL | Stock | 46.0 | 46.0 | 45.9975 | 45.9975 | 2760.0 |
| 2018-07-02 08:23:00 | AAPL | Stock | 45.9975 | 46.025 | 45.9975 | 46.025 | 2556.0 |
| 2018-07-02 08:30:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 1600.0 |
| 2018-07-02 08:32:00 | AAPL | Stock | 46.0 | 46.0 | 46.0 | 46.0 | 892.0 |
| 2018-07-02 08:33:00 | AAPL | Stock | 45.985 | 45.985 | 45.9825 | 45.9825 | 1056.0 |
| 2018-07-02 08:34:00 | AAPL | Stock | 45.9975 | 46.0 | 45.9975 | 46.0 | 2736.0 |
| 2018-07-02 08:36:00 | AAPL | Stock | 45.9825 | 46.03 | 45.9825 | 46.03 | 1808.0 |
| 2018-07-02 08:38:00 | AAPL | Stock | 45.9875 | 46.0325 | 45.9875 | 46.0325 | 948.0 |
| 2018-07-02 08:39:00 | AAPL | Stock | 46.025 | 46.025 | 46.025 | 46.025 | 400.0 |
| 2018-07-02 08:40:00 | AAPL | Stock | 46.0025 | 46.0025 | 46.0 | 46.0 | 6020.0 |
> showing 50 of 1,082,973 rows — these rows as CSV