PREVIEW / stock_1min / 2016-06-21
file: by_date/stock_1min/2016/2016-06-21.parquet size: 14.2 MB rows: 1,057,495 symbols: 2,686
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-06-21 04:00:00 | AAPL | Stock | 23.77 | 23.77 | 23.77 | 23.77 | 1200.0 |
| 2016-06-21 04:07:00 | AAPL | Stock | 23.77 | 23.77 | 23.77 | 23.77 | 800.0 |
| 2016-06-21 04:14:00 | AAPL | Stock | 23.7675 | 23.7675 | 23.7675 | 23.7675 | 800.0 |
| 2016-06-21 04:50:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 400.0 |
| 2016-06-21 04:55:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 560.0 |
| 2016-06-21 04:58:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 2000.0 |
| 2016-06-21 04:59:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 880.0 |
| 2016-06-21 05:00:00 | AAPL | Stock | 23.7625 | 23.7625 | 23.7625 | 23.7625 | 3336.0 |
| 2016-06-21 05:37:00 | AAPL | Stock | 23.7775 | 23.7775 | 23.7775 | 23.7775 | 400.0 |
| 2016-06-21 05:44:00 | AAPL | Stock | 23.7525 | 23.7525 | 23.7525 | 23.7525 | 1668.0 |
| 2016-06-21 06:38:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 400.0 |
| 2016-06-21 06:50:00 | AAPL | Stock | 23.7775 | 23.7775 | 23.775 | 23.775 | 2400.0 |
| 2016-06-21 06:51:00 | AAPL | Stock | 23.77 | 23.77 | 23.765 | 23.765 | 7776.0 |
| 2016-06-21 06:57:00 | AAPL | Stock | 23.775 | 23.775 | 23.775 | 23.775 | 1116.0 |
| 2016-06-21 06:59:00 | AAPL | Stock | 23.775 | 23.775 | 23.765 | 23.765 | 3252.0 |
| 2016-06-21 07:09:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 1120.0 |
| 2016-06-21 07:13:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 1600.0 |
| 2016-06-21 07:15:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 560.0 |
| 2016-06-21 07:17:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 4400.0 |
| 2016-06-21 07:18:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 400.0 |
| 2016-06-21 07:19:00 | AAPL | Stock | 23.815 | 23.815 | 23.815 | 23.815 | 3200.0 |
| 2016-06-21 07:21:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 4000.0 |
| 2016-06-21 07:27:00 | AAPL | Stock | 23.79 | 23.79 | 23.79 | 23.79 | 3160.0 |
| 2016-06-21 07:33:00 | AAPL | Stock | 23.795 | 23.795 | 23.795 | 23.795 | 656.0 |
| 2016-06-21 07:35:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 800.0 |
| 2016-06-21 07:40:00 | AAPL | Stock | 23.7975 | 23.7975 | 23.7975 | 23.7975 | 400.0 |
| 2016-06-21 07:44:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 800.0 |
| 2016-06-21 07:49:00 | AAPL | Stock | 23.8 | 23.8 | 23.8 | 23.8 | 400.0 |
| 2016-06-21 07:54:00 | AAPL | Stock | 23.795 | 23.795 | 23.785 | 23.785 | 12384.0 |
| 2016-06-21 07:57:00 | AAPL | Stock | 23.7875 | 23.7875 | 23.7875 | 23.7875 | 6000.0 |
| 2016-06-21 08:00:00 | AAPL | Stock | 23.8 | 23.8175 | 23.7625 | 23.815 | 45716.0 |
| 2016-06-21 08:01:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 5200.0 |
| 2016-06-21 08:02:00 | AAPL | Stock | 23.825 | 23.825 | 23.8225 | 23.8225 | 1600.0 |
| 2016-06-21 08:03:00 | AAPL | Stock | 23.8225 | 23.8225 | 23.8225 | 23.8225 | 1200.0 |
| 2016-06-21 08:04:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 2784.0 |
| 2016-06-21 08:05:00 | AAPL | Stock | 23.83 | 23.8325 | 23.83 | 23.8325 | 4000.0 |
| 2016-06-21 08:06:00 | AAPL | Stock | 23.8325 | 23.8325 | 23.825 | 23.825 | 1896.0 |
| 2016-06-21 08:08:00 | AAPL | Stock | 23.825 | 23.825 | 23.825 | 23.825 | 800.0 |
| 2016-06-21 08:09:00 | AAPL | Stock | 23.815 | 23.815 | 23.815 | 23.815 | 2800.0 |
| 2016-06-21 08:10:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.8175 | 23.8175 | 800.0 |
| 2016-06-21 08:13:00 | AAPL | Stock | 23.8175 | 23.8175 | 23.8025 | 23.8025 | 13688.0 |
| 2016-06-21 08:14:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.8125 | 23.8125 | 400.0 |
| 2016-06-21 08:16:00 | AAPL | Stock | 23.8025 | 23.8025 | 23.8025 | 23.8025 | 400.0 |
| 2016-06-21 08:17:00 | AAPL | Stock | 23.8025 | 23.8025 | 23.8 | 23.8 | 3788.0 |
| 2016-06-21 08:18:00 | AAPL | Stock | 23.795 | 23.8025 | 23.7925 | 23.8025 | 2996.0 |
| 2016-06-21 08:25:00 | AAPL | Stock | 23.81 | 23.81 | 23.81 | 23.81 | 4000.0 |
| 2016-06-21 08:26:00 | AAPL | Stock | 23.8075 | 23.8075 | 23.8075 | 23.8075 | 604.0 |
| 2016-06-21 08:27:00 | AAPL | Stock | 23.81 | 23.81 | 23.81 | 23.81 | 400.0 |
| 2016-06-21 08:30:00 | AAPL | Stock | 23.8125 | 23.8125 | 23.7925 | 23.795 | 11560.0 |
| 2016-06-21 08:35:00 | AAPL | Stock | 23.79 | 23.795 | 23.78 | 23.78 | 17444.0 |
> showing 50 of 1,057,495 rows — these rows as CSV