PREVIEW / stock_1min / 2013-10-03
file: by_date/stock_1min/2013/2013-10-03.parquet size: 13.8 MB rows: 1,012,172 symbols: 2,862
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-03 04:00:00 | AAPL | Stock | 17.3982 | 17.3982 | 17.3982 | 17.3982 | 8400.0 |
| 2013-10-03 04:08:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5600.0 |
| 2013-10-03 05:32:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 2800.0 |
| 2013-10-03 05:34:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 2800.0 |
| 2013-10-03 05:41:00 | AAPL | Stock | 17.4186 | 17.4186 | 17.4186 | 17.4186 | 2800.0 |
| 2013-10-03 05:42:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 3360.0 |
| 2013-10-03 05:51:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5600.0 |
| 2013-10-03 05:55:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 3360.0 |
| 2013-10-03 06:03:00 | AAPL | Stock | 17.4107 | 17.4107 | 17.4107 | 17.4107 | 5040.0 |
| 2013-10-03 06:46:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 5600.0 |
| 2013-10-03 06:54:00 | AAPL | Stock | 17.4286 | 17.4286 | 17.4286 | 17.4286 | 2800.0 |
| 2013-10-03 06:57:00 | AAPL | Stock | 17.4354 | 17.4354 | 17.4354 | 17.4354 | 2800.0 |
| 2013-10-03 07:11:00 | AAPL | Stock | 17.4561 | 17.4561 | 17.4536 | 17.4536 | 11200.0 |
| 2013-10-03 07:12:00 | AAPL | Stock | 17.4414 | 17.4414 | 17.4339 | 17.4339 | 25200.0 |
| 2013-10-03 07:15:00 | AAPL | Stock | 17.45 | 17.45 | 17.45 | 17.45 | 5600.0 |
| 2013-10-03 07:16:00 | AAPL | Stock | 17.4586 | 17.4586 | 17.4586 | 17.4586 | 2800.0 |
| 2013-10-03 07:21:00 | AAPL | Stock | 17.4382 | 17.4382 | 17.4382 | 17.4382 | 2800.0 |
| 2013-10-03 07:23:00 | AAPL | Stock | 17.4396 | 17.4396 | 17.4396 | 17.4396 | 2800.0 |
| 2013-10-03 07:27:00 | AAPL | Stock | 17.4464 | 17.4568 | 17.4464 | 17.4568 | 7280.0 |
| 2013-10-03 07:28:00 | AAPL | Stock | 17.4571 | 17.4571 | 17.4571 | 17.4571 | 7140.0 |
| 2013-10-03 07:30:00 | AAPL | Stock | 17.4571 | 17.4571 | 17.4571 | 17.4571 | 2800.0 |
| 2013-10-03 07:32:00 | AAPL | Stock | 17.4596 | 17.4607 | 17.4596 | 17.4607 | 5600.0 |
| 2013-10-03 07:34:00 | AAPL | Stock | 17.4607 | 17.4643 | 17.4607 | 17.4643 | 16800.0 |
| 2013-10-03 07:37:00 | AAPL | Stock | 17.4571 | 17.4571 | 17.4571 | 17.4571 | 23100.0 |
| 2013-10-03 07:39:00 | AAPL | Stock | 17.4589 | 17.4589 | 17.4589 | 17.4589 | 2800.0 |
| 2013-10-03 07:47:00 | AAPL | Stock | 17.4679 | 17.4679 | 17.4679 | 17.4679 | 28000.0 |
| 2013-10-03 07:49:00 | AAPL | Stock | 17.4732 | 17.4732 | 17.4732 | 17.4732 | 7028.0 |
| 2013-10-03 07:50:00 | AAPL | Stock | 17.4814 | 17.4821 | 17.4814 | 17.4821 | 5600.0 |
| 2013-10-03 07:51:00 | AAPL | Stock | 17.4821 | 17.4821 | 17.4821 | 17.4821 | 2800.0 |
| 2013-10-03 07:53:00 | AAPL | Stock | 17.4843 | 17.4939 | 17.4843 | 17.4939 | 36400.0 |
| 2013-10-03 07:56:00 | AAPL | Stock | 17.4982 | 17.5118 | 17.4975 | 17.4979 | 46900.0 |
| 2013-10-03 07:58:00 | AAPL | Stock | 17.5036 | 17.5036 | 17.5036 | 17.5036 | 5600.0 |
| 2013-10-03 07:59:00 | AAPL | Stock | 17.5 | 17.5 | 17.5 | 17.5 | 5600.0 |
| 2013-10-03 08:00:00 | AAPL | Stock | 17.4964 | 17.5082 | 17.4354 | 17.4864 | 78428.0 |
| 2013-10-03 08:01:00 | AAPL | Stock | 17.5 | 17.5036 | 17.4893 | 17.4911 | 34300.0 |
| 2013-10-03 08:02:00 | AAPL | Stock | 17.5071 | 17.5079 | 17.5 | 17.5 | 25200.0 |
| 2013-10-03 08:03:00 | AAPL | Stock | 17.4982 | 17.5118 | 17.4464 | 17.4464 | 29008.0 |
| 2013-10-03 08:04:00 | AAPL | Stock | 17.5132 | 17.5214 | 17.5061 | 17.5214 | 101752.0 |
| 2013-10-03 08:05:00 | AAPL | Stock | 17.5268 | 17.5339 | 17.5161 | 17.5339 | 19320.0 |
| 2013-10-03 08:06:00 | AAPL | Stock | 17.5179 | 17.52 | 17.5179 | 17.5179 | 20300.0 |
| 2013-10-03 08:07:00 | AAPL | Stock | 17.5182 | 17.5318 | 17.5179 | 17.525 | 55440.0 |
| 2013-10-03 08:08:00 | AAPL | Stock | 17.5311 | 17.5311 | 17.5286 | 17.5286 | 27972.0 |
| 2013-10-03 08:09:00 | AAPL | Stock | 17.5282 | 17.5282 | 17.5282 | 17.5282 | 2800.0 |
| 2013-10-03 08:10:00 | AAPL | Stock | 17.5179 | 17.5179 | 17.5136 | 17.5136 | 30240.0 |
| 2013-10-03 08:11:00 | AAPL | Stock | 17.5229 | 17.5229 | 17.5229 | 17.5229 | 2800.0 |
| 2013-10-03 08:12:00 | AAPL | Stock | 17.5146 | 17.5146 | 17.5 | 17.5 | 30128.0 |
| 2013-10-03 08:13:00 | AAPL | Stock | 17.5004 | 17.5011 | 17.5 | 17.5 | 70000.0 |
| 2013-10-03 08:14:00 | AAPL | Stock | 17.5 | 17.5025 | 17.5 | 17.5025 | 23212.0 |
| 2013-10-03 08:15:00 | AAPL | Stock | 17.4911 | 17.4911 | 17.4857 | 17.4904 | 8400.0 |
| 2013-10-03 08:19:00 | AAPL | Stock | 17.4893 | 17.4893 | 17.4893 | 17.4893 | 13300.0 |
> showing 50 of 1,012,172 rows — these rows as CSV