PREVIEW / stock_1min / 2013-09-04
file: by_date/stock_1min/2013/2013-09-04.parquet size: 13.5 MB rows: 993,579 symbols: 2,854
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-09-04 04:01:00 | AAPL | Stock | 17.4464 | 17.4464 | 17.4464 | 17.4464 | 9660.0 |
| 2013-09-04 04:32:00 | AAPL | Stock | 17.4225 | 17.4225 | 17.4225 | 17.4225 | 5600.0 |
| 2013-09-04 04:33:00 | AAPL | Stock | 17.4171 | 17.4171 | 17.4171 | 17.4171 | 28000.0 |
| 2013-09-04 04:34:00 | AAPL | Stock | 17.4225 | 17.4375 | 17.4225 | 17.4375 | 5600.0 |
| 2013-09-04 05:20:00 | AAPL | Stock | 17.4332 | 17.4332 | 17.4332 | 17.4332 | 2800.0 |
| 2013-09-04 06:04:00 | AAPL | Stock | 17.4607 | 17.4607 | 17.4607 | 17.4607 | 2800.0 |
| 2013-09-04 06:23:00 | AAPL | Stock | 17.4339 | 17.4339 | 17.4125 | 17.4125 | 11200.0 |
| 2013-09-04 06:26:00 | AAPL | Stock | 17.4875 | 17.4875 | 17.4875 | 17.4875 | 2800.0 |
| 2013-09-04 06:36:00 | AAPL | Stock | 17.4871 | 17.4871 | 17.4871 | 17.4871 | 2800.0 |
| 2013-09-04 06:37:00 | AAPL | Stock | 17.485 | 17.4971 | 17.485 | 17.4971 | 22400.0 |
| 2013-09-04 06:40:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 2800.0 |
| 2013-09-04 06:45:00 | AAPL | Stock | 17.5125 | 17.5175 | 17.5125 | 17.5175 | 16800.0 |
| 2013-09-04 06:46:00 | AAPL | Stock | 17.5257 | 17.5257 | 17.5257 | 17.5257 | 19600.0 |
| 2013-09-04 06:50:00 | AAPL | Stock | 17.5286 | 17.5286 | 17.5286 | 17.5286 | 2800.0 |
| 2013-09-04 06:54:00 | AAPL | Stock | 17.5486 | 17.5714 | 17.5486 | 17.5714 | 81200.0 |
| 2013-09-04 06:56:00 | AAPL | Stock | 17.5893 | 17.6 | 17.5893 | 17.6 | 14000.0 |
| 2013-09-04 06:59:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 55440.0 |
| 2013-09-04 07:00:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 8400.0 |
| 2013-09-04 07:01:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 2800.0 |
| 2013-09-04 07:03:00 | AAPL | Stock | 17.6071 | 17.6071 | 17.6071 | 17.6071 | 2800.0 |
| 2013-09-04 07:04:00 | AAPL | Stock | 17.625 | 17.6429 | 17.625 | 17.6429 | 30016.0 |
| 2013-09-04 07:05:00 | AAPL | Stock | 17.6425 | 17.6436 | 17.6425 | 17.6429 | 30800.0 |
| 2013-09-04 07:07:00 | AAPL | Stock | 17.65 | 17.65 | 17.6493 | 17.6493 | 8400.0 |
| 2013-09-04 07:08:00 | AAPL | Stock | 17.6607 | 17.6886 | 17.6607 | 17.6886 | 39816.0 |
| 2013-09-04 07:09:00 | AAPL | Stock | 17.6718 | 17.6936 | 17.6718 | 17.6832 | 29400.0 |
| 2013-09-04 07:10:00 | AAPL | Stock | 17.6893 | 17.6893 | 17.6729 | 17.6782 | 30800.0 |
| 2013-09-04 07:11:00 | AAPL | Stock | 17.675 | 17.6786 | 17.6643 | 17.6786 | 84700.0 |
| 2013-09-04 07:12:00 | AAPL | Stock | 17.6782 | 17.6786 | 17.6782 | 17.6786 | 15288.0 |
| 2013-09-04 07:13:00 | AAPL | Stock | 17.6796 | 17.6796 | 17.6796 | 17.6796 | 2800.0 |
| 2013-09-04 07:14:00 | AAPL | Stock | 17.6807 | 17.6954 | 17.6804 | 17.6875 | 50120.0 |
| 2013-09-04 07:15:00 | AAPL | Stock | 17.6843 | 17.6875 | 17.6843 | 17.6875 | 5600.0 |
| 2013-09-04 07:16:00 | AAPL | Stock | 17.68 | 17.6857 | 17.6607 | 17.6786 | 99428.0 |
| 2013-09-04 07:17:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6718 | 17.6786 | 30800.0 |
| 2013-09-04 07:18:00 | AAPL | Stock | 17.6786 | 17.6786 | 17.6671 | 17.6671 | 49700.0 |
| 2013-09-04 07:20:00 | AAPL | Stock | 17.6836 | 17.7371 | 17.6836 | 17.7371 | 175112.0 |
| 2013-09-04 07:22:00 | AAPL | Stock | 17.7136 | 17.7136 | 17.7136 | 17.7136 | 2800.0 |
| 2013-09-04 07:23:00 | AAPL | Stock | 17.7075 | 17.7143 | 17.7071 | 17.7143 | 66696.0 |
| 2013-09-04 07:25:00 | AAPL | Stock | 17.7182 | 17.7182 | 17.7143 | 17.7143 | 29680.0 |
| 2013-09-04 07:26:00 | AAPL | Stock | 17.73 | 17.7421 | 17.7146 | 17.7146 | 94920.0 |
| 2013-09-04 07:27:00 | AAPL | Stock | 17.7314 | 17.7321 | 17.7314 | 17.7321 | 5600.0 |
| 2013-09-04 07:28:00 | AAPL | Stock | 17.7321 | 17.745 | 17.7321 | 17.7325 | 24080.0 |
| 2013-09-04 07:29:00 | AAPL | Stock | 17.7411 | 17.7475 | 17.7321 | 17.7475 | 105840.0 |
| 2013-09-04 07:30:00 | AAPL | Stock | 17.7336 | 17.7336 | 17.7321 | 17.7321 | 12488.0 |
| 2013-09-04 07:31:00 | AAPL | Stock | 17.7275 | 17.7275 | 17.7239 | 17.7239 | 5600.0 |
| 2013-09-04 07:32:00 | AAPL | Stock | 17.7232 | 17.7275 | 17.7232 | 17.7275 | 31360.0 |
| 2013-09-04 07:33:00 | AAPL | Stock | 17.7186 | 17.7411 | 17.7143 | 17.7411 | 122948.0 |
| 2013-09-04 07:34:00 | AAPL | Stock | 17.7307 | 17.735 | 17.7307 | 17.735 | 5600.0 |
| 2013-09-04 07:35:00 | AAPL | Stock | 17.7357 | 17.7357 | 17.7357 | 17.7357 | 2800.0 |
| 2013-09-04 07:37:00 | AAPL | Stock | 17.7321 | 17.7361 | 17.7321 | 17.7361 | 28000.0 |
| 2013-09-04 07:38:00 | AAPL | Stock | 17.74 | 17.7482 | 17.7357 | 17.7357 | 52192.0 |
> showing 50 of 993,579 rows — these rows as CSV