PREVIEW / stock_1min / 2012-05-15
file: by_date/stock_1min/2012/2012-05-15.parquet size: 13.2 MB rows: 979,433 symbols: 2,858
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 |
|---|---|---|---|---|---|---|---|
| 2012-05-15 04:00:00 | AAPL | Stock | 20.0521 | 20.0714 | 20.0521 | 20.0714 | 28728.0 |
| 2012-05-15 04:19:00 | AAPL | Stock | 20.0471 | 20.0471 | 20.0471 | 20.0471 | 2800.0 |
| 2012-05-15 04:22:00 | AAPL | Stock | 20.0675 | 20.0675 | 20.0675 | 20.0675 | 2800.0 |
| 2012-05-15 04:24:00 | AAPL | Stock | 20.0636 | 20.0636 | 20.0636 | 20.0636 | 2800.0 |
| 2012-05-15 04:32:00 | AAPL | Stock | 20.105 | 20.105 | 20.105 | 20.105 | 2800.0 |
| 2012-05-15 04:36:00 | AAPL | Stock | 20.0821 | 20.0821 | 20.0821 | 20.0821 | 5600.0 |
| 2012-05-15 04:37:00 | AAPL | Stock | 20.0636 | 20.0636 | 20.0636 | 20.0636 | 11200.0 |
| 2012-05-15 04:40:00 | AAPL | Stock | 20.0636 | 20.0636 | 20.0636 | 20.0636 | 10388.0 |
| 2012-05-15 04:41:00 | AAPL | Stock | 20.0636 | 20.0636 | 20.0536 | 20.0536 | 20412.0 |
| 2012-05-15 04:44:00 | AAPL | Stock | 20.0536 | 20.0536 | 20.0536 | 20.0536 | 5600.0 |
| 2012-05-15 04:50:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 05:26:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 05:42:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0643 | 20.0696 | 16800.0 |
| 2012-05-15 05:57:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 9016.0 |
| 2012-05-15 06:09:00 | AAPL | Stock | 20.0696 | 20.0696 | 20.0696 | 20.0696 | 2800.0 |
| 2012-05-15 06:11:00 | AAPL | Stock | 20.0707 | 20.0714 | 20.0707 | 20.0714 | 8400.0 |
| 2012-05-15 06:12:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 06:17:00 | AAPL | Stock | 20.0875 | 20.1071 | 20.0875 | 20.1071 | 14000.0 |
| 2012-05-15 06:18:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 2800.0 |
| 2012-05-15 06:21:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 7868.0 |
| 2012-05-15 06:23:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 8400.0 |
| 2012-05-15 06:24:00 | AAPL | Stock | 20.1139 | 20.1143 | 20.1071 | 20.1071 | 15400.0 |
| 2012-05-15 06:35:00 | AAPL | Stock | 20.0839 | 20.0839 | 20.0839 | 20.0839 | 2800.0 |
| 2012-05-15 06:57:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0893 | 20.0893 | 2800.0 |
| 2012-05-15 07:00:00 | AAPL | Stock | 20.0807 | 20.0807 | 20.0714 | 20.0714 | 27972.0 |
| 2012-05-15 07:01:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 18200.0 |
| 2012-05-15 07:02:00 | AAPL | Stock | 20.0575 | 20.0575 | 20.0575 | 20.0575 | 2800.0 |
| 2012-05-15 07:04:00 | AAPL | Stock | 20.0643 | 20.0643 | 20.0643 | 20.0643 | 2800.0 |
| 2012-05-15 07:05:00 | AAPL | Stock | 20.0514 | 20.0536 | 20.0446 | 20.0446 | 39144.0 |
| 2012-05-15 07:06:00 | AAPL | Stock | 20.0418 | 20.0418 | 20.0357 | 20.0357 | 11200.0 |
| 2012-05-15 07:07:00 | AAPL | Stock | 20.0286 | 20.0286 | 20.0282 | 20.0282 | 11200.0 |
| 2012-05-15 07:08:00 | AAPL | Stock | 20.0282 | 20.0282 | 20.0282 | 20.0282 | 2800.0 |
| 2012-05-15 07:09:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 6440.0 |
| 2012-05-15 07:10:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 4900.0 |
| 2012-05-15 07:12:00 | AAPL | Stock | 20.05 | 20.0536 | 20.05 | 20.05 | 47432.0 |
| 2012-05-15 07:13:00 | AAPL | Stock | 20.05 | 20.05 | 20.04 | 20.04 | 14000.0 |
| 2012-05-15 07:16:00 | AAPL | Stock | 20.0507 | 20.0657 | 20.0507 | 20.0657 | 9380.0 |
| 2012-05-15 07:17:00 | AAPL | Stock | 20.0679 | 20.0679 | 20.0679 | 20.0679 | 2800.0 |
| 2012-05-15 07:19:00 | AAPL | Stock | 20.0457 | 20.0457 | 20.0457 | 20.0457 | 2800.0 |
| 2012-05-15 07:33:00 | AAPL | Stock | 20.0707 | 20.0707 | 20.0707 | 20.0707 | 2800.0 |
| 2012-05-15 07:34:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 07:35:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 07:36:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 07:37:00 | AAPL | Stock | 20.0761 | 20.0761 | 20.0714 | 20.0714 | 11200.0 |
| 2012-05-15 07:38:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-05-15 07:39:00 | AAPL | Stock | 20.0754 | 20.0757 | 20.0714 | 20.0714 | 8400.0 |
| 2012-05-15 07:41:00 | AAPL | Stock | 20.0732 | 20.075 | 20.0732 | 20.075 | 25200.0 |
| 2012-05-15 07:44:00 | AAPL | Stock | 20.0782 | 20.0793 | 20.0782 | 20.0793 | 19600.0 |
| 2012-05-15 07:46:00 | AAPL | Stock | 20.0857 | 20.0875 | 20.0857 | 20.0857 | 25172.0 |
| 2012-05-15 07:47:00 | AAPL | Stock | 20.0786 | 20.0786 | 20.0786 | 20.0786 | 4144.0 |
> showing 50 of 979,433 rows — these rows as CSV