PREVIEW / stock_1min / 2013-08-08
file: by_date/stock_1min/2013/2013-08-08.parquet size: 13.5 MB rows: 979,170 symbols: 2,845
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-08 04:00:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 10640.0 |
| 2013-08-08 04:19:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5679 | 16.5679 | 2800.0 |
| 2013-08-08 04:56:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 2800.0 |
| 2013-08-08 05:06:00 | AAPL | Stock | 16.5775 | 16.5775 | 16.5775 | 16.5775 | 2800.0 |
| 2013-08-08 05:11:00 | AAPL | Stock | 16.5939 | 16.5939 | 16.5939 | 16.5939 | 2800.0 |
| 2013-08-08 05:16:00 | AAPL | Stock | 16.5971 | 16.5971 | 16.5964 | 16.5964 | 5600.0 |
| 2013-08-08 05:20:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6068 | 16.6068 | 5600.0 |
| 2013-08-08 05:21:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 2800.0 |
| 2013-08-08 05:23:00 | AAPL | Stock | 16.6071 | 16.6071 | 16.6071 | 16.6071 | 2800.0 |
| 2013-08-08 05:40:00 | AAPL | Stock | 16.6075 | 16.6075 | 16.6071 | 16.6071 | 5600.0 |
| 2013-08-08 05:41:00 | AAPL | Stock | 16.6039 | 16.6039 | 16.6 | 16.6 | 8400.0 |
| 2013-08-08 05:42:00 | AAPL | Stock | 16.6032 | 16.6032 | 16.6032 | 16.6032 | 2800.0 |
| 2013-08-08 05:45:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5929 | 16.5929 | 8400.0 |
| 2013-08-08 05:50:00 | AAPL | Stock | 16.5911 | 16.5911 | 16.5911 | 16.5911 | 2800.0 |
| 2013-08-08 05:55:00 | AAPL | Stock | 16.5982 | 16.5982 | 16.5982 | 16.5982 | 2800.0 |
| 2013-08-08 06:05:00 | AAPL | Stock | 16.5857 | 16.5857 | 16.5857 | 16.5857 | 2800.0 |
| 2013-08-08 06:06:00 | AAPL | Stock | 16.5857 | 16.5857 | 16.5857 | 16.5857 | 2800.0 |
| 2013-08-08 06:07:00 | AAPL | Stock | 16.5825 | 16.5825 | 16.5825 | 16.5825 | 2800.0 |
| 2013-08-08 06:11:00 | AAPL | Stock | 16.5893 | 16.5893 | 16.5893 | 16.5893 | 5600.0 |
| 2013-08-08 06:21:00 | AAPL | Stock | 16.5825 | 16.5825 | 16.5782 | 16.5782 | 11200.0 |
| 2013-08-08 06:22:00 | AAPL | Stock | 16.5786 | 16.5786 | 16.5768 | 16.5768 | 5600.0 |
| 2013-08-08 06:23:00 | AAPL | Stock | 16.5786 | 16.5786 | 16.5786 | 16.5786 | 2800.0 |
| 2013-08-08 06:29:00 | AAPL | Stock | 16.5754 | 16.5754 | 16.5714 | 16.5714 | 8400.0 |
| 2013-08-08 06:35:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 9800.0 |
| 2013-08-08 06:39:00 | AAPL | Stock | 16.5507 | 16.5507 | 16.5464 | 16.5464 | 11200.0 |
| 2013-08-08 06:50:00 | AAPL | Stock | 16.5696 | 16.5714 | 16.5696 | 16.5714 | 11200.0 |
| 2013-08-08 07:05:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 30800.0 |
| 2013-08-08 07:12:00 | AAPL | Stock | 16.5679 | 16.5679 | 16.5625 | 16.5625 | 8400.0 |
| 2013-08-08 07:18:00 | AAPL | Stock | 16.5682 | 16.5682 | 16.5668 | 16.5668 | 5600.0 |
| 2013-08-08 07:19:00 | AAPL | Stock | 16.5654 | 16.5654 | 16.5654 | 16.5654 | 2800.0 |
| 2013-08-08 07:24:00 | AAPL | Stock | 16.5686 | 16.5686 | 16.5679 | 16.5686 | 19208.0 |
| 2013-08-08 07:25:00 | AAPL | Stock | 16.5714 | 16.5714 | 16.5714 | 16.5714 | 14000.0 |
| 2013-08-08 07:26:00 | AAPL | Stock | 16.5768 | 16.5768 | 16.5768 | 16.5768 | 2800.0 |
| 2013-08-08 07:27:00 | AAPL | Stock | 16.5725 | 16.5725 | 16.5725 | 16.5725 | 2800.0 |
| 2013-08-08 07:28:00 | AAPL | Stock | 16.5786 | 16.5786 | 16.5725 | 16.5725 | 20916.0 |
| 2013-08-08 07:29:00 | AAPL | Stock | 16.5775 | 16.5857 | 16.575 | 16.575 | 39200.0 |
| 2013-08-08 07:33:00 | AAPL | Stock | 16.5789 | 16.5789 | 16.5789 | 16.5789 | 5320.0 |
| 2013-08-08 07:37:00 | AAPL | Stock | 16.5725 | 16.5725 | 16.5725 | 16.5725 | 5600.0 |
| 2013-08-08 07:38:00 | AAPL | Stock | 16.5643 | 16.5643 | 16.5643 | 16.5643 | 2800.0 |
| 2013-08-08 07:44:00 | AAPL | Stock | 16.565 | 16.565 | 16.5643 | 16.5643 | 11200.0 |
| 2013-08-08 07:45:00 | AAPL | Stock | 16.5557 | 16.5557 | 16.5557 | 16.5557 | 5600.0 |
| 2013-08-08 07:48:00 | AAPL | Stock | 16.5504 | 16.5504 | 16.5464 | 16.5464 | 8400.0 |
| 2013-08-08 07:49:00 | AAPL | Stock | 16.5436 | 16.5436 | 16.5396 | 16.5396 | 11200.0 |
| 2013-08-08 07:50:00 | AAPL | Stock | 16.5439 | 16.5439 | 16.5361 | 16.5361 | 33600.0 |
| 2013-08-08 07:51:00 | AAPL | Stock | 16.5361 | 16.5361 | 16.535 | 16.535 | 30940.0 |
| 2013-08-08 07:52:00 | AAPL | Stock | 16.5354 | 16.5354 | 16.5214 | 16.5214 | 14000.0 |
| 2013-08-08 07:55:00 | AAPL | Stock | 16.5346 | 16.5346 | 16.5346 | 16.5346 | 2800.0 |
| 2013-08-08 07:58:00 | AAPL | Stock | 16.5357 | 16.5357 | 16.5357 | 16.5357 | 16800.0 |
| 2013-08-08 07:59:00 | AAPL | Stock | 16.5357 | 16.5357 | 16.5357 | 16.5357 | 11200.0 |
| 2013-08-08 08:00:00 | AAPL | Stock | 16.5357 | 16.5786 | 16.5311 | 16.5475 | 142660.0 |
> showing 50 of 979,170 rows — these rows as CSV