PREVIEW / stock_1min / 2013-10-16
file: by_date/stock_1min/2013/2013-10-16.parquet size: 13.8 MB rows: 1,006,349 symbols: 2,889
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-10-16 04:00:00 | AAPL | Stock | 17.7514 | 17.8611 | 17.7514 | 17.7889 | 70560.0 |
| 2013-10-16 04:01:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 5600.0 |
| 2013-10-16 04:02:00 | AAPL | Stock | 17.8007 | 17.8007 | 17.7857 | 17.7857 | 29596.0 |
| 2013-10-16 04:07:00 | AAPL | Stock | 17.7743 | 17.7743 | 17.7743 | 17.7743 | 8400.0 |
| 2013-10-16 04:08:00 | AAPL | Stock | 17.7743 | 17.7743 | 17.7743 | 17.7743 | 14000.0 |
| 2013-10-16 04:11:00 | AAPL | Stock | 17.7661 | 17.7661 | 17.7661 | 17.7661 | 2800.0 |
| 2013-10-16 04:16:00 | AAPL | Stock | 17.7211 | 17.7636 | 17.7211 | 17.75 | 14000.0 |
| 2013-10-16 04:17:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 45472.0 |
| 2013-10-16 04:23:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7321 | 17.7321 | 4200.0 |
| 2013-10-16 04:25:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7232 | 17.7232 | 30240.0 |
| 2013-10-16 04:31:00 | AAPL | Stock | 17.7318 | 17.7321 | 17.7318 | 17.7321 | 5600.0 |
| 2013-10-16 04:32:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7232 | 17.7232 | 28000.0 |
| 2013-10-16 04:39:00 | AAPL | Stock | 17.7239 | 17.7239 | 17.7239 | 17.7239 | 2800.0 |
| 2013-10-16 04:48:00 | AAPL | Stock | 17.7286 | 17.7286 | 17.7239 | 17.7239 | 11200.0 |
| 2013-10-16 04:49:00 | AAPL | Stock | 17.7257 | 17.7257 | 17.7239 | 17.7239 | 28000.0 |
| 2013-10-16 04:50:00 | AAPL | Stock | 17.7286 | 17.7286 | 17.7286 | 17.7286 | 6580.0 |
| 2013-10-16 04:55:00 | AAPL | Stock | 17.7357 | 17.7357 | 17.7357 | 17.7357 | 2800.0 |
| 2013-10-16 04:57:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7321 | 17.7321 | 2800.0 |
| 2013-10-16 04:58:00 | AAPL | Stock | 17.7404 | 17.7404 | 17.7404 | 17.7404 | 2800.0 |
| 2013-10-16 05:00:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 05:10:00 | AAPL | Stock | 17.7429 | 17.7429 | 17.7429 | 17.7429 | 2800.0 |
| 2013-10-16 05:11:00 | AAPL | Stock | 17.7539 | 17.7593 | 17.7539 | 17.7593 | 5600.0 |
| 2013-10-16 05:14:00 | AAPL | Stock | 17.7489 | 17.75 | 17.7489 | 17.75 | 63000.0 |
| 2013-10-16 05:15:00 | AAPL | Stock | 17.7593 | 17.7736 | 17.7593 | 17.7736 | 5600.0 |
| 2013-10-16 05:16:00 | AAPL | Stock | 17.7679 | 17.7679 | 17.7679 | 17.7679 | 2800.0 |
| 2013-10-16 05:17:00 | AAPL | Stock | 17.7589 | 17.7589 | 17.75 | 17.75 | 22400.0 |
| 2013-10-16 05:21:00 | AAPL | Stock | 17.7661 | 17.7782 | 17.75 | 17.7782 | 67200.0 |
| 2013-10-16 05:26:00 | AAPL | Stock | 17.7554 | 17.7554 | 17.7525 | 17.7525 | 26908.0 |
| 2013-10-16 05:27:00 | AAPL | Stock | 17.7764 | 17.7764 | 17.7564 | 17.7564 | 5600.0 |
| 2013-10-16 05:35:00 | AAPL | Stock | 17.7746 | 17.7843 | 17.75 | 17.75 | 39200.0 |
| 2013-10-16 05:39:00 | AAPL | Stock | 17.7536 | 17.7536 | 17.7536 | 17.7536 | 2800.0 |
| 2013-10-16 05:41:00 | AAPL | Stock | 17.7536 | 17.7536 | 17.75 | 17.75 | 11200.0 |
| 2013-10-16 05:43:00 | AAPL | Stock | 17.75 | 17.75 | 17.7482 | 17.7493 | 33600.0 |
| 2013-10-16 05:52:00 | AAPL | Stock | 17.7364 | 17.7364 | 17.7364 | 17.7364 | 2800.0 |
| 2013-10-16 05:53:00 | AAPL | Stock | 17.7371 | 17.7429 | 17.7357 | 17.7357 | 28000.0 |
| 2013-10-16 05:55:00 | AAPL | Stock | 17.7429 | 17.7429 | 17.7357 | 17.7357 | 14000.0 |
| 2013-10-16 05:58:00 | AAPL | Stock | 17.7357 | 17.7357 | 17.7357 | 17.7357 | 5824.0 |
| 2013-10-16 05:59:00 | AAPL | Stock | 17.7325 | 17.7325 | 17.7325 | 17.7325 | 2800.0 |
| 2013-10-16 06:06:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 06:07:00 | AAPL | Stock | 17.755 | 17.7761 | 17.755 | 17.7761 | 19600.0 |
| 2013-10-16 06:08:00 | AAPL | Stock | 17.7518 | 17.7518 | 17.7493 | 17.7493 | 11200.0 |
| 2013-10-16 06:09:00 | AAPL | Stock | 17.7493 | 17.7493 | 17.7379 | 17.7379 | 14000.0 |
| 2013-10-16 06:11:00 | AAPL | Stock | 17.7482 | 17.7482 | 17.7321 | 17.7321 | 30212.0 |
| 2013-10-16 06:19:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7321 | 17.7321 | 38248.0 |
| 2013-10-16 06:20:00 | AAPL | Stock | 17.7446 | 17.7464 | 17.7446 | 17.7464 | 22400.0 |
| 2013-10-16 06:21:00 | AAPL | Stock | 17.75 | 17.7568 | 17.75 | 17.7568 | 5600.0 |
| 2013-10-16 06:22:00 | AAPL | Stock | 17.7539 | 17.7539 | 17.7539 | 17.7539 | 3304.0 |
| 2013-10-16 06:23:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 5600.0 |
| 2013-10-16 06:26:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 2800.0 |
| 2013-10-16 06:31:00 | AAPL | Stock | 17.75 | 17.75 | 17.75 | 17.75 | 5712.0 |
> showing 50 of 1,006,349 rows — these rows as CSV