PREVIEW / stock_1min / 2012-11-08
file: by_date/stock_1min/2012/2012-11-08.parquet size: 12.9 MB rows: 958,603 symbols: 2,797
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-11-08 04:03:00 | AAPL | Stock | 20.0011 | 20.0011 | 20.0011 | 20.0011 | 2800.0 |
| 2012-11-08 05:16:00 | AAPL | Stock | 19.9736 | 19.9736 | 19.9732 | 19.9732 | 5600.0 |
| 2012-11-08 05:18:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 60088.0 |
| 2012-11-08 05:19:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 11200.0 |
| 2012-11-08 05:20:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 9296.0 |
| 2012-11-08 05:24:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 5600.0 |
| 2012-11-08 05:25:00 | AAPL | Stock | 19.9643 | 19.9643 | 19.9643 | 19.9643 | 4200.0 |
| 2012-11-08 05:29:00 | AAPL | Stock | 20.0 | 20.0 | 20.0 | 20.0 | 11200.0 |
| 2012-11-08 05:30:00 | AAPL | Stock | 19.9821 | 19.9821 | 19.9821 | 19.9821 | 5600.0 |
| 2012-11-08 05:44:00 | AAPL | Stock | 20.0143 | 20.0232 | 20.0143 | 20.0232 | 53200.0 |
| 2012-11-08 05:45:00 | AAPL | Stock | 20.0536 | 20.0714 | 20.0536 | 20.0714 | 11200.0 |
| 2012-11-08 05:47:00 | AAPL | Stock | 20.08 | 20.1071 | 20.08 | 20.1071 | 16800.0 |
| 2012-11-08 05:48:00 | AAPL | Stock | 20.1046 | 20.1071 | 20.1046 | 20.1071 | 22764.0 |
| 2012-11-08 05:49:00 | AAPL | Stock | 20.1007 | 20.1071 | 20.1007 | 20.1071 | 30800.0 |
| 2012-11-08 05:52:00 | AAPL | Stock | 20.1054 | 20.1064 | 20.1054 | 20.1064 | 5600.0 |
| 2012-11-08 05:54:00 | AAPL | Stock | 20.1082 | 20.1082 | 20.1082 | 20.1082 | 2800.0 |
| 2012-11-08 05:57:00 | AAPL | Stock | 20.1071 | 20.1071 | 20.1071 | 20.1071 | 14000.0 |
| 2012-11-08 05:58:00 | AAPL | Stock | 20.1068 | 20.1071 | 20.1057 | 20.1071 | 65772.0 |
| 2012-11-08 06:03:00 | AAPL | Stock | 20.0932 | 20.0932 | 20.0932 | 20.0932 | 2800.0 |
| 2012-11-08 06:29:00 | AAPL | Stock | 20.0821 | 20.0821 | 20.0821 | 20.0821 | 2800.0 |
| 2012-11-08 06:34:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 2800.0 |
| 2012-11-08 06:46:00 | AAPL | Stock | 20.0893 | 20.0893 | 20.0786 | 20.0786 | 16800.0 |
| 2012-11-08 06:48:00 | AAPL | Stock | 20.0786 | 20.0786 | 20.0714 | 20.0714 | 8400.0 |
| 2012-11-08 06:49:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 11200.0 |
| 2012-11-08 06:55:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 11200.0 |
| 2012-11-08 06:56:00 | AAPL | Stock | 20.0714 | 20.0714 | 20.0714 | 20.0714 | 58240.0 |
| 2012-11-08 06:59:00 | AAPL | Stock | 20.0214 | 20.0214 | 20.0214 | 20.0214 | 2800.0 |
| 2012-11-08 07:00:00 | AAPL | Stock | 20.0357 | 20.0357 | 20.0357 | 20.0357 | 2800.0 |
| 2012-11-08 07:01:00 | AAPL | Stock | 20.0661 | 20.0675 | 20.0661 | 20.0675 | 14000.0 |
| 2012-11-08 07:05:00 | AAPL | Stock | 20.0368 | 20.0368 | 20.0286 | 20.0286 | 5600.0 |
| 2012-11-08 07:06:00 | AAPL | Stock | 20.0307 | 20.0307 | 20.0304 | 20.0304 | 5600.0 |
| 2012-11-08 07:07:00 | AAPL | Stock | 20.0304 | 20.0304 | 20.0304 | 20.0304 | 4200.0 |
| 2012-11-08 07:08:00 | AAPL | Stock | 20.025 | 20.0393 | 20.025 | 20.0393 | 8400.0 |
| 2012-11-08 07:10:00 | AAPL | Stock | 20.0357 | 20.0393 | 20.0357 | 20.0393 | 10332.0 |
| 2012-11-08 07:11:00 | AAPL | Stock | 20.0429 | 20.0429 | 20.0429 | 20.0429 | 2800.0 |
| 2012-11-08 07:12:00 | AAPL | Stock | 20.0432 | 20.0432 | 20.0432 | 20.0432 | 2800.0 |
| 2012-11-08 07:14:00 | AAPL | Stock | 20.0425 | 20.0461 | 20.0425 | 20.0461 | 5600.0 |
| 2012-11-08 07:15:00 | AAPL | Stock | 20.0393 | 20.0446 | 20.0393 | 20.0446 | 5600.0 |
| 2012-11-08 07:16:00 | AAPL | Stock | 20.0493 | 20.0714 | 20.0493 | 20.0714 | 16380.0 |
| 2012-11-08 07:19:00 | AAPL | Stock | 20.0629 | 20.0629 | 20.0629 | 20.0629 | 2800.0 |
| 2012-11-08 07:21:00 | AAPL | Stock | 20.0596 | 20.0596 | 20.0596 | 20.0596 | 5600.0 |
| 2012-11-08 07:23:00 | AAPL | Stock | 20.0604 | 20.0714 | 20.0604 | 20.0714 | 48020.0 |
| 2012-11-08 07:24:00 | AAPL | Stock | 20.0554 | 20.0639 | 20.0554 | 20.0639 | 9800.0 |
| 2012-11-08 07:25:00 | AAPL | Stock | 20.0643 | 20.0696 | 20.0643 | 20.0696 | 24640.0 |
| 2012-11-08 07:26:00 | AAPL | Stock | 20.0661 | 20.0686 | 20.0643 | 20.0643 | 33600.0 |
| 2012-11-08 07:27:00 | AAPL | Stock | 20.0643 | 20.0643 | 20.0571 | 20.0571 | 14000.0 |
| 2012-11-08 07:31:00 | AAPL | Stock | 20.0604 | 20.0604 | 20.0604 | 20.0604 | 2800.0 |
| 2012-11-08 07:32:00 | AAPL | Stock | 20.0675 | 20.0889 | 20.0675 | 20.0718 | 43904.0 |
| 2012-11-08 07:33:00 | AAPL | Stock | 20.0721 | 20.0732 | 20.0604 | 20.0604 | 50400.0 |
| 2012-11-08 07:34:00 | AAPL | Stock | 20.0657 | 20.0657 | 20.035 | 20.0357 | 99792.0 |
> showing 50 of 958,603 rows — these rows as CSV