PREVIEW / stock_1min / 2012-01-11
file: by_date/stock_1min/2012/2012-01-11.parquet size: 12.6 MB rows: 941,055 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 |
|---|---|---|---|---|---|---|---|
| 2012-01-11 04:04:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 2800.0 |
| 2012-01-11 06:33:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 2800.0 |
| 2012-01-11 07:01:00 | AAPL | Stock | 15.0557 | 15.0557 | 15.0557 | 15.0557 | 5600.0 |
| 2012-01-11 07:02:00 | AAPL | Stock | 15.0632 | 15.0714 | 15.0632 | 15.0714 | 11032.0 |
| 2012-01-11 07:05:00 | AAPL | Stock | 15.0589 | 15.0589 | 15.0589 | 15.0589 | 2800.0 |
| 2012-01-11 07:09:00 | AAPL | Stock | 15.0625 | 15.0625 | 15.0625 | 15.0625 | 2800.0 |
| 2012-01-11 07:19:00 | AAPL | Stock | 15.0679 | 15.0679 | 15.0679 | 15.0679 | 14000.0 |
| 2012-01-11 07:20:00 | AAPL | Stock | 15.0625 | 15.0625 | 15.0625 | 15.0625 | 8400.0 |
| 2012-01-11 07:22:00 | AAPL | Stock | 15.0589 | 15.0589 | 15.0589 | 15.0589 | 2800.0 |
| 2012-01-11 07:24:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 2800.0 |
| 2012-01-11 07:27:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 2800.0 |
| 2012-01-11 07:32:00 | AAPL | Stock | 15.0718 | 15.0718 | 15.0714 | 15.0714 | 13664.0 |
| 2012-01-11 07:34:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0714 | 15.0714 | 42336.0 |
| 2012-01-11 07:48:00 | AAPL | Stock | 15.0925 | 15.0925 | 15.0925 | 15.0925 | 2800.0 |
| 2012-01-11 07:49:00 | AAPL | Stock | 15.0946 | 15.0946 | 15.0946 | 15.0946 | 5600.0 |
| 2012-01-11 07:55:00 | AAPL | Stock | 15.1029 | 15.1071 | 15.1029 | 15.1071 | 22400.0 |
| 2012-01-11 07:56:00 | AAPL | Stock | 15.1071 | 15.1421 | 15.1071 | 15.1321 | 22400.0 |
| 2012-01-11 07:59:00 | AAPL | Stock | 15.1071 | 15.1071 | 15.1071 | 15.1071 | 2800.0 |
| 2012-01-11 08:00:00 | AAPL | Stock | 15.1071 | 15.1086 | 15.0857 | 15.0857 | 72268.0 |
| 2012-01-11 08:01:00 | AAPL | Stock | 15.0946 | 15.0946 | 15.0768 | 15.0768 | 10864.0 |
| 2012-01-11 08:02:00 | AAPL | Stock | 15.0893 | 15.0893 | 15.0893 | 15.0893 | 2800.0 |
| 2012-01-11 08:03:00 | AAPL | Stock | 15.0893 | 15.1036 | 15.0836 | 15.1036 | 60340.0 |
| 2012-01-11 08:04:00 | AAPL | Stock | 15.0893 | 15.0893 | 15.0893 | 15.0893 | 5600.0 |
| 2012-01-11 08:05:00 | AAPL | Stock | 15.0957 | 15.0957 | 15.0957 | 15.0957 | 140000.0 |
| 2012-01-11 08:10:00 | AAPL | Stock | 15.0911 | 15.0911 | 15.0893 | 15.0893 | 8400.0 |
| 2012-01-11 08:12:00 | AAPL | Stock | 15.0929 | 15.0929 | 15.0896 | 15.0896 | 11200.0 |
| 2012-01-11 08:13:00 | AAPL | Stock | 15.0914 | 15.0914 | 15.0896 | 15.0896 | 5600.0 |
| 2012-01-11 08:17:00 | AAPL | Stock | 15.0896 | 15.1036 | 15.0896 | 15.1 | 61600.0 |
| 2012-01-11 08:18:00 | AAPL | Stock | 15.0964 | 15.0982 | 15.0964 | 15.0982 | 9156.0 |
| 2012-01-11 08:20:00 | AAPL | Stock | 15.09 | 15.09 | 15.0896 | 15.0896 | 11956.0 |
| 2012-01-11 08:21:00 | AAPL | Stock | 15.0864 | 15.0864 | 15.075 | 15.075 | 17360.0 |
| 2012-01-11 08:22:00 | AAPL | Stock | 15.0725 | 15.0725 | 15.0714 | 15.0714 | 19600.0 |
| 2012-01-11 08:23:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0643 | 15.0714 | 25200.0 |
| 2012-01-11 08:24:00 | AAPL | Stock | 15.0643 | 15.0643 | 15.0643 | 15.0643 | 15400.0 |
| 2012-01-11 08:25:00 | AAPL | Stock | 15.0675 | 15.0675 | 15.0675 | 15.0675 | 2800.0 |
| 2012-01-11 08:27:00 | AAPL | Stock | 15.0557 | 15.0557 | 15.0557 | 15.0557 | 8400.0 |
| 2012-01-11 08:28:00 | AAPL | Stock | 15.0557 | 15.0632 | 15.0536 | 15.055 | 36960.0 |
| 2012-01-11 08:29:00 | AAPL | Stock | 15.0621 | 15.0621 | 15.0621 | 15.0621 | 2800.0 |
| 2012-01-11 08:31:00 | AAPL | Stock | 15.0682 | 15.0682 | 15.0682 | 15.0682 | 2800.0 |
| 2012-01-11 08:34:00 | AAPL | Stock | 15.0671 | 15.0693 | 15.0604 | 15.0604 | 22400.0 |
| 2012-01-11 08:35:00 | AAPL | Stock | 15.0657 | 15.0657 | 15.0657 | 15.0657 | 2800.0 |
| 2012-01-11 08:36:00 | AAPL | Stock | 15.0675 | 15.0789 | 15.0675 | 15.0679 | 107940.0 |
| 2012-01-11 08:37:00 | AAPL | Stock | 15.0714 | 15.0714 | 15.0671 | 15.0714 | 27440.0 |
| 2012-01-11 08:38:00 | AAPL | Stock | 15.0707 | 15.0707 | 15.0707 | 15.0707 | 9072.0 |
| 2012-01-11 08:39:00 | AAPL | Stock | 15.0707 | 15.0707 | 15.0707 | 15.0707 | 2800.0 |
| 2012-01-11 08:40:00 | AAPL | Stock | 15.0657 | 15.0689 | 15.0657 | 15.0689 | 5600.0 |
| 2012-01-11 08:41:00 | AAPL | Stock | 15.0693 | 15.0693 | 15.0693 | 15.0693 | 2800.0 |
| 2012-01-11 08:42:00 | AAPL | Stock | 15.0707 | 15.0714 | 15.0696 | 15.0696 | 108724.0 |
| 2012-01-11 08:43:00 | AAPL | Stock | 15.0711 | 15.0821 | 15.0696 | 15.0821 | 67200.0 |
| 2012-01-11 08:44:00 | AAPL | Stock | 15.0818 | 15.0818 | 15.0757 | 15.08 | 14000.0 |
> showing 50 of 941,055 rows — these rows as CSV