PREVIEW / stock_1min / 2014-04-16
file: by_date/stock_1min/2014/2014-04-16.parquet size: 14.1 MB rows: 1,037,306 symbols: 2,881
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-16 04:06:00 | AAPL | Stock | 18.5436 | 18.5436 | 18.5436 | 18.5436 | 2800.0 |
| 2014-04-16 04:57:00 | AAPL | Stock | 18.5464 | 18.5464 | 18.5464 | 18.5464 | 2800.0 |
| 2014-04-16 05:08:00 | AAPL | Stock | 18.5464 | 18.5464 | 18.5464 | 18.5464 | 2800.0 |
| 2014-04-16 05:35:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 5600.0 |
| 2014-04-16 05:41:00 | AAPL | Stock | 18.5679 | 18.5714 | 18.5679 | 18.5714 | 12572.0 |
| 2014-04-16 06:03:00 | AAPL | Stock | 18.5714 | 18.5714 | 18.5714 | 18.5714 | 2800.0 |
| 2014-04-16 06:13:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 3080.0 |
| 2014-04-16 06:30:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5571 | 18.5571 | 2800.0 |
| 2014-04-16 06:52:00 | AAPL | Stock | 18.5571 | 18.5571 | 18.5536 | 18.5536 | 7000.0 |
| 2014-04-16 07:02:00 | AAPL | Stock | 18.5693 | 18.5711 | 18.5693 | 18.5711 | 11200.0 |
| 2014-04-16 07:15:00 | AAPL | Stock | 18.5707 | 18.5707 | 18.5707 | 18.5707 | 2800.0 |
| 2014-04-16 07:36:00 | AAPL | Stock | 18.5536 | 18.5536 | 18.5536 | 18.5536 | 2940.0 |
| 2014-04-16 07:39:00 | AAPL | Stock | 18.55 | 18.55 | 18.55 | 18.55 | 19600.0 |
| 2014-04-16 07:43:00 | AAPL | Stock | 18.55 | 18.55 | 18.55 | 18.55 | 6328.0 |
| 2014-04-16 07:44:00 | AAPL | Stock | 18.5504 | 18.5793 | 18.5504 | 18.5793 | 16800.0 |
| 2014-04-16 07:46:00 | AAPL | Stock | 18.5721 | 18.5721 | 18.5721 | 18.5721 | 15316.0 |
| 2014-04-16 07:51:00 | AAPL | Stock | 18.5721 | 18.5721 | 18.5721 | 18.5721 | 5600.0 |
| 2014-04-16 07:53:00 | AAPL | Stock | 18.5711 | 18.5736 | 18.5711 | 18.5736 | 22960.0 |
| 2014-04-16 08:00:00 | AAPL | Stock | 18.5764 | 18.5875 | 18.5375 | 18.5693 | 84756.0 |
| 2014-04-16 08:05:00 | AAPL | Stock | 18.5811 | 18.5811 | 18.5625 | 18.5625 | 37996.0 |
| 2014-04-16 08:06:00 | AAPL | Stock | 18.5625 | 18.5671 | 18.5625 | 18.5671 | 5600.0 |
| 2014-04-16 08:07:00 | AAPL | Stock | 18.5679 | 18.5679 | 18.5679 | 18.5679 | 2800.0 |
| 2014-04-16 08:08:00 | AAPL | Stock | 18.5675 | 18.5675 | 18.5675 | 18.5675 | 2800.0 |
| 2014-04-16 08:09:00 | AAPL | Stock | 18.5579 | 18.5579 | 18.5579 | 18.5579 | 5600.0 |
| 2014-04-16 08:12:00 | AAPL | Stock | 18.5618 | 18.5621 | 18.5618 | 18.5621 | 10080.0 |
| 2014-04-16 08:18:00 | AAPL | Stock | 18.5446 | 18.5446 | 18.5446 | 18.5446 | 2800.0 |
| 2014-04-16 08:21:00 | AAPL | Stock | 18.5389 | 18.5389 | 18.5375 | 18.5375 | 5600.0 |
| 2014-04-16 08:22:00 | AAPL | Stock | 18.5414 | 18.5414 | 18.5361 | 18.5361 | 8400.0 |
| 2014-04-16 08:23:00 | AAPL | Stock | 18.5375 | 18.5379 | 18.5357 | 18.5357 | 19488.0 |
| 2014-04-16 08:25:00 | AAPL | Stock | 18.5254 | 18.5254 | 18.5189 | 18.5214 | 53648.0 |
| 2014-04-16 08:26:00 | AAPL | Stock | 18.5193 | 18.5193 | 18.5193 | 18.5193 | 2800.0 |
| 2014-04-16 08:27:00 | AAPL | Stock | 18.5339 | 18.5354 | 18.5339 | 18.5354 | 22400.0 |
| 2014-04-16 08:30:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5268 | 18.5268 | 5600.0 |
| 2014-04-16 08:34:00 | AAPL | Stock | 18.5236 | 18.5236 | 18.5182 | 18.5182 | 25200.0 |
| 2014-04-16 08:35:00 | AAPL | Stock | 18.5357 | 18.5357 | 18.5193 | 18.5193 | 29372.0 |
| 2014-04-16 08:37:00 | AAPL | Stock | 18.5307 | 18.5307 | 18.5307 | 18.5307 | 2800.0 |
| 2014-04-16 08:38:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5268 | 18.5268 | 2800.0 |
| 2014-04-16 08:40:00 | AAPL | Stock | 18.5268 | 18.5268 | 18.5268 | 18.5268 | 2800.0 |
| 2014-04-16 08:41:00 | AAPL | Stock | 18.5321 | 18.5325 | 18.5321 | 18.5325 | 5600.0 |
| 2014-04-16 08:42:00 | AAPL | Stock | 18.5218 | 18.5218 | 18.5218 | 18.5218 | 5600.0 |
| 2014-04-16 08:43:00 | AAPL | Stock | 18.5218 | 18.5218 | 18.5196 | 18.5196 | 11200.0 |
| 2014-04-16 08:46:00 | AAPL | Stock | 18.5146 | 18.5154 | 18.4975 | 18.5007 | 117768.0 |
| 2014-04-16 08:47:00 | AAPL | Stock | 18.4857 | 18.4857 | 18.4857 | 18.4857 | 7000.0 |
| 2014-04-16 08:48:00 | AAPL | Stock | 18.4929 | 18.4929 | 18.4929 | 18.4929 | 2800.0 |
| 2014-04-16 08:50:00 | AAPL | Stock | 18.4857 | 18.4914 | 18.485 | 18.4914 | 20244.0 |
| 2014-04-16 08:51:00 | AAPL | Stock | 18.4971 | 18.4993 | 18.4971 | 18.4986 | 16800.0 |
| 2014-04-16 08:52:00 | AAPL | Stock | 18.4964 | 18.4964 | 18.4964 | 18.4964 | 2800.0 |
| 2014-04-16 08:57:00 | AAPL | Stock | 18.4993 | 18.4993 | 18.4993 | 18.4993 | 2800.0 |
| 2014-04-16 08:58:00 | AAPL | Stock | 18.4936 | 18.4936 | 18.4886 | 18.4886 | 33600.0 |
| 2014-04-16 09:00:00 | AAPL | Stock | 18.4886 | 18.5029 | 18.4886 | 18.5029 | 56980.0 |
> showing 50 of 1,037,306 rows — these rows as CSV