PREVIEW / stock_1min / 2013-11-11
file: by_date/stock_1min/2013/2013-11-11.parquet size: 13.0 MB rows: 956,723 symbols: 2,860
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-11-11 04:00:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 4676.0 |
| 2013-11-11 04:06:00 | AAPL | Stock | 18.5918 | 18.5918 | 18.5918 | 18.5918 | 8400.0 |
| 2013-11-11 04:43:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 2800.0 |
| 2013-11-11 04:45:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 04:56:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 05:08:00 | AAPL | Stock | 18.5843 | 18.5843 | 18.5843 | 18.5843 | 2800.0 |
| 2013-11-11 05:16:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 28000.0 |
| 2013-11-11 05:40:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 05:42:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 05:49:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 11200.0 |
| 2013-11-11 06:03:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 28000.0 |
| 2013-11-11 06:11:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2013-11-11 06:23:00 | AAPL | Stock | 18.565 | 18.565 | 18.565 | 18.565 | 2800.0 |
| 2013-11-11 06:27:00 | AAPL | Stock | 18.5643 | 18.5643 | 18.5611 | 18.5611 | 42000.0 |
| 2013-11-11 06:29:00 | AAPL | Stock | 18.5543 | 18.5543 | 18.5543 | 18.5543 | 2800.0 |
| 2013-11-11 06:40:00 | AAPL | Stock | 18.555 | 18.555 | 18.555 | 18.555 | 5600.0 |
| 2013-11-11 06:57:00 | AAPL | Stock | 18.55 | 18.5507 | 18.5393 | 18.5393 | 21000.0 |
| 2013-11-11 07:03:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5707 | 18.5707 | 2800.0 |
| 2013-11-11 07:06:00 | AAPL | Stock | 18.5696 | 18.5829 | 18.5696 | 18.5829 | 16772.0 |
| 2013-11-11 07:07:00 | AAPL | Stock | 18.5889 | 18.5889 | 18.5889 | 18.5889 | 2800.0 |
| 2013-11-11 07:08:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 36064.0 |
| 2013-11-11 07:15:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 5292.0 |
| 2013-11-11 07:16:00 | AAPL | Stock | 18.5768 | 18.5768 | 18.575 | 18.575 | 8400.0 |
| 2013-11-11 07:26:00 | AAPL | Stock | 18.5893 | 18.5893 | 18.5893 | 18.5893 | 2800.0 |
| 2013-11-11 07:27:00 | AAPL | Stock | 18.6029 | 18.6029 | 18.6029 | 18.6029 | 5600.0 |
| 2013-11-11 07:33:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.5975 | 18.5975 | 5880.0 |
| 2013-11-11 07:34:00 | AAPL | Stock | 18.5975 | 18.5975 | 18.5968 | 18.5968 | 28000.0 |
| 2013-11-11 07:35:00 | AAPL | Stock | 18.6071 | 18.6071 | 18.6071 | 18.6071 | 14000.0 |
| 2013-11-11 07:36:00 | AAPL | Stock | 18.6 | 18.6 | 18.5825 | 18.5825 | 22288.0 |
| 2013-11-11 07:40:00 | AAPL | Stock | 18.6068 | 18.6068 | 18.6068 | 18.6068 | 5600.0 |
| 2013-11-11 07:46:00 | AAPL | Stock | 18.6193 | 18.6207 | 18.6193 | 18.6207 | 14000.0 |
| 2013-11-11 07:47:00 | AAPL | Stock | 18.625 | 18.6275 | 18.625 | 18.6275 | 11200.0 |
| 2013-11-11 07:49:00 | AAPL | Stock | 18.6429 | 18.6429 | 18.6429 | 18.6429 | 5600.0 |
| 2013-11-11 07:52:00 | AAPL | Stock | 18.6536 | 18.6536 | 18.6471 | 18.6471 | 18200.0 |
| 2013-11-11 07:53:00 | AAPL | Stock | 18.655 | 18.6554 | 18.655 | 18.6554 | 11480.0 |
| 2013-11-11 07:54:00 | AAPL | Stock | 18.6621 | 18.6625 | 18.6621 | 18.6625 | 8400.0 |
| 2013-11-11 07:55:00 | AAPL | Stock | 18.6629 | 18.6786 | 18.6629 | 18.6743 | 30240.0 |
| 2013-11-11 07:57:00 | AAPL | Stock | 18.6786 | 18.6786 | 18.6743 | 18.6746 | 28000.0 |
| 2013-11-11 07:59:00 | AAPL | Stock | 18.675 | 18.6789 | 18.6746 | 18.6746 | 11200.0 |
| 2013-11-11 08:00:00 | AAPL | Stock | 18.6714 | 18.6746 | 18.5714 | 18.6432 | 170940.0 |
| 2013-11-11 08:01:00 | AAPL | Stock | 18.6439 | 18.6514 | 18.6429 | 18.6429 | 16828.0 |
| 2013-11-11 08:02:00 | AAPL | Stock | 18.5914 | 18.6429 | 18.5914 | 18.6429 | 498400.0 |
| 2013-11-11 08:03:00 | AAPL | Stock | 18.6496 | 18.6518 | 18.6432 | 18.6432 | 23184.0 |
| 2013-11-11 08:05:00 | AAPL | Stock | 18.6564 | 18.6725 | 18.6564 | 18.6725 | 14000.0 |
| 2013-11-11 08:06:00 | AAPL | Stock | 18.6446 | 18.6475 | 18.6446 | 18.6454 | 70252.0 |
| 2013-11-11 08:08:00 | AAPL | Stock | 18.6457 | 18.6457 | 18.6429 | 18.6429 | 59332.0 |
| 2013-11-11 08:09:00 | AAPL | Stock | 18.6339 | 18.6339 | 18.63 | 18.63 | 28000.0 |
| 2013-11-11 08:11:00 | AAPL | Stock | 18.6418 | 18.6418 | 18.6411 | 18.6418 | 19544.0 |
| 2013-11-11 08:12:00 | AAPL | Stock | 18.6411 | 18.6411 | 18.6411 | 18.6411 | 2800.0 |
| 2013-11-11 08:13:00 | AAPL | Stock | 18.6543 | 18.6546 | 18.6532 | 18.6546 | 8400.0 |
> showing 50 of 956,723 rows — these rows as CSV