PREVIEW / stock_1min / 2013-12-05
file: by_date/stock_1min/2013/2013-12-05.parquet size: 14.1 MB rows: 1,042,687 symbols: 2,861
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-12-05 04:00:00 | AAPL | Stock | 20.1821 | 20.5 | 20.1821 | 20.5 | 79100.0 |
| 2013-12-05 04:01:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 8400.0 |
| 2013-12-05 04:04:00 | AAPL | Stock | 20.5 | 20.5 | 20.4975 | 20.4975 | 8400.0 |
| 2013-12-05 04:05:00 | AAPL | Stock | 20.5071 | 20.5071 | 20.5071 | 20.5071 | 2800.0 |
| 2013-12-05 04:06:00 | AAPL | Stock | 20.5161 | 20.5179 | 20.5161 | 20.5179 | 5600.0 |
| 2013-12-05 04:07:00 | AAPL | Stock | 20.5257 | 20.5575 | 20.5257 | 20.5575 | 16800.0 |
| 2013-12-05 04:08:00 | AAPL | Stock | 20.5575 | 20.5575 | 20.5575 | 20.5575 | 8400.0 |
| 2013-12-05 04:13:00 | AAPL | Stock | 20.56 | 20.56 | 20.56 | 20.56 | 2800.0 |
| 2013-12-05 04:15:00 | AAPL | Stock | 20.5182 | 20.5593 | 20.5182 | 20.5543 | 11200.0 |
| 2013-12-05 04:18:00 | AAPL | Stock | 20.5268 | 20.5268 | 20.5268 | 20.5268 | 2800.0 |
| 2013-12-05 04:20:00 | AAPL | Stock | 20.5064 | 20.5064 | 20.5046 | 20.5046 | 16800.0 |
| 2013-12-05 04:23:00 | AAPL | Stock | 20.5268 | 20.5268 | 20.5268 | 20.5268 | 2800.0 |
| 2013-12-05 04:24:00 | AAPL | Stock | 20.5268 | 20.5268 | 20.5268 | 20.5268 | 2800.0 |
| 2013-12-05 04:33:00 | AAPL | Stock | 20.5457 | 20.5457 | 20.5457 | 20.5457 | 2800.0 |
| 2013-12-05 04:41:00 | AAPL | Stock | 20.555 | 20.555 | 20.555 | 20.555 | 3640.0 |
| 2013-12-05 04:42:00 | AAPL | Stock | 20.5696 | 20.5714 | 20.5696 | 20.5714 | 23184.0 |
| 2013-12-05 04:43:00 | AAPL | Stock | 20.5704 | 20.5704 | 20.5704 | 20.5704 | 2800.0 |
| 2013-12-05 04:50:00 | AAPL | Stock | 20.5654 | 20.5654 | 20.5464 | 20.5464 | 32900.0 |
| 2013-12-05 04:51:00 | AAPL | Stock | 20.5439 | 20.5439 | 20.5432 | 20.5432 | 16800.0 |
| 2013-12-05 04:52:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 26320.0 |
| 2013-12-05 04:58:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 5600.0 |
| 2013-12-05 04:59:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5321 | 20.5321 | 14896.0 |
| 2013-12-05 05:00:00 | AAPL | Stock | 20.5321 | 20.5321 | 20.5321 | 20.5321 | 2800.0 |
| 2013-12-05 05:01:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5175 | 20.5175 | 76104.0 |
| 2013-12-05 05:03:00 | AAPL | Stock | 20.5107 | 20.5175 | 20.5107 | 20.5175 | 14000.0 |
| 2013-12-05 05:04:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5179 | 20.5179 | 5600.0 |
| 2013-12-05 05:09:00 | AAPL | Stock | 20.5179 | 20.5214 | 20.5179 | 20.5214 | 15400.0 |
| 2013-12-05 05:13:00 | AAPL | Stock | 20.5179 | 20.5179 | 20.5143 | 20.5143 | 22428.0 |
| 2013-12-05 05:15:00 | AAPL | Stock | 20.5046 | 20.5046 | 20.5 | 20.5 | 33068.0 |
| 2013-12-05 05:16:00 | AAPL | Stock | 20.4971 | 20.5 | 20.4971 | 20.5 | 8400.0 |
| 2013-12-05 05:17:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 2800.0 |
| 2013-12-05 05:18:00 | AAPL | Stock | 20.4939 | 20.4939 | 20.4821 | 20.4821 | 14000.0 |
| 2013-12-05 05:19:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4757 | 20.4757 | 5600.0 |
| 2013-12-05 05:20:00 | AAPL | Stock | 20.4921 | 20.4921 | 20.4921 | 20.4921 | 2800.0 |
| 2013-12-05 05:22:00 | AAPL | Stock | 20.4911 | 20.4911 | 20.4911 | 20.4911 | 2800.0 |
| 2013-12-05 05:24:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 5600.0 |
| 2013-12-05 05:25:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 10220.0 |
| 2013-12-05 05:29:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 5600.0 |
| 2013-12-05 05:34:00 | AAPL | Stock | 20.4857 | 20.4857 | 20.4857 | 20.4857 | 11200.0 |
| 2013-12-05 05:35:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 4116.0 |
| 2013-12-05 05:36:00 | AAPL | Stock | 20.4739 | 20.4743 | 20.4664 | 20.4664 | 13356.0 |
| 2013-12-05 05:39:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 28000.0 |
| 2013-12-05 05:40:00 | AAPL | Stock | 20.4646 | 20.4743 | 20.4643 | 20.4643 | 35000.0 |
| 2013-12-05 05:46:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4757 | 20.4757 | 2800.0 |
| 2013-12-05 05:49:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 5880.0 |
| 2013-12-05 05:50:00 | AAPL | Stock | 20.465 | 20.465 | 20.465 | 20.465 | 2800.0 |
| 2013-12-05 05:54:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4757 | 20.4757 | 11424.0 |
| 2013-12-05 05:55:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4718 | 20.4718 | 5600.0 |
| 2013-12-05 05:59:00 | AAPL | Stock | 20.4718 | 20.4718 | 20.4718 | 20.4718 | 2800.0 |
| 2013-12-05 06:00:00 | AAPL | Stock | 20.4757 | 20.5036 | 20.4757 | 20.5 | 30296.0 |
> showing 50 of 1,042,687 rows — these rows as CSV