PREVIEW / stock_1min / 2013-11-21
file: by_date/stock_1min/2013/2013-11-21.parquet size: 14.0 MB rows: 1,025,168 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-11-21 04:29:00 | AAPL | Stock | 18.3889 | 18.3889 | 18.3768 | 18.3889 | 8400.0 |
| 2013-11-21 04:30:00 | AAPL | Stock | 18.3818 | 18.3946 | 18.3818 | 18.3946 | 25564.0 |
| 2013-11-21 04:32:00 | AAPL | Stock | 18.3771 | 18.3771 | 18.3771 | 18.3771 | 2800.0 |
| 2013-11-21 04:38:00 | AAPL | Stock | 18.3854 | 18.3854 | 18.3854 | 18.3854 | 2800.0 |
| 2013-11-21 04:39:00 | AAPL | Stock | 18.3871 | 18.3918 | 18.3871 | 18.3918 | 14252.0 |
| 2013-11-21 05:12:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 14000.0 |
| 2013-11-21 05:15:00 | AAPL | Stock | 18.3929 | 18.3929 | 18.3929 | 18.3929 | 14000.0 |
| 2013-11-21 05:22:00 | AAPL | Stock | 18.4114 | 18.4114 | 18.4114 | 18.4114 | 2800.0 |
| 2013-11-21 05:45:00 | AAPL | Stock | 18.4161 | 18.4161 | 18.4161 | 18.4161 | 5600.0 |
| 2013-11-21 06:22:00 | AAPL | Stock | 18.4232 | 18.4286 | 18.4161 | 18.4286 | 54544.0 |
| 2013-11-21 06:23:00 | AAPL | Stock | 18.4286 | 18.4286 | 18.415 | 18.415 | 7308.0 |
| 2013-11-21 06:42:00 | AAPL | Stock | 18.4286 | 18.4286 | 18.4286 | 18.4286 | 4620.0 |
| 2013-11-21 07:01:00 | AAPL | Stock | 18.4129 | 18.4129 | 18.4129 | 18.4129 | 2800.0 |
| 2013-11-21 07:02:00 | AAPL | Stock | 18.4118 | 18.4118 | 18.4118 | 18.4118 | 2800.0 |
| 2013-11-21 07:12:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4196 | 18.4196 | 7000.0 |
| 2013-11-21 07:15:00 | AAPL | Stock | 18.4196 | 18.4196 | 18.4196 | 18.4196 | 4452.0 |
| 2013-11-21 07:19:00 | AAPL | Stock | 18.4268 | 18.4268 | 18.4268 | 18.4268 | 15820.0 |
| 2013-11-21 07:20:00 | AAPL | Stock | 18.4214 | 18.4286 | 18.4214 | 18.4286 | 7308.0 |
| 2013-11-21 07:23:00 | AAPL | Stock | 18.4514 | 18.4514 | 18.4514 | 18.4514 | 2800.0 |
| 2013-11-21 07:28:00 | AAPL | Stock | 18.4464 | 18.4464 | 18.4464 | 18.4464 | 2800.0 |
| 2013-11-21 07:31:00 | AAPL | Stock | 18.4607 | 18.4607 | 18.4607 | 18.4607 | 13440.0 |
| 2013-11-21 07:32:00 | AAPL | Stock | 18.4604 | 18.4604 | 18.4486 | 18.4486 | 14000.0 |
| 2013-11-21 07:35:00 | AAPL | Stock | 18.4804 | 18.4864 | 18.4804 | 18.4864 | 21840.0 |
| 2013-11-21 07:42:00 | AAPL | Stock | 18.4679 | 18.4679 | 18.4579 | 18.4579 | 7000.0 |
| 2013-11-21 07:43:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4554 | 18.4554 | 14000.0 |
| 2013-11-21 07:44:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4554 | 18.4643 | 28000.0 |
| 2013-11-21 07:45:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4625 | 18.4625 | 16800.0 |
| 2013-11-21 07:46:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4625 | 18.4625 | 14000.0 |
| 2013-11-21 07:50:00 | AAPL | Stock | 18.4761 | 18.4839 | 18.4761 | 18.4839 | 89600.0 |
| 2013-11-21 07:51:00 | AAPL | Stock | 18.4786 | 18.4804 | 18.4786 | 18.4804 | 16800.0 |
| 2013-11-21 07:52:00 | AAPL | Stock | 18.4786 | 18.4786 | 18.4786 | 18.4786 | 5600.0 |
| 2013-11-21 07:55:00 | AAPL | Stock | 18.4793 | 18.48 | 18.4786 | 18.4786 | 12600.0 |
| 2013-11-21 07:56:00 | AAPL | Stock | 18.4793 | 18.4821 | 18.4793 | 18.4821 | 9240.0 |
| 2013-11-21 07:58:00 | AAPL | Stock | 18.4839 | 18.4864 | 18.4839 | 18.4839 | 25200.0 |
| 2013-11-21 07:59:00 | AAPL | Stock | 18.4821 | 18.4821 | 18.4821 | 18.4821 | 2800.0 |
| 2013-11-21 08:00:00 | AAPL | Stock | 18.4786 | 18.4821 | 18.3893 | 18.4821 | 37800.0 |
| 2013-11-21 08:01:00 | AAPL | Stock | 18.4861 | 18.4861 | 18.4861 | 18.4861 | 2800.0 |
| 2013-11-21 08:03:00 | AAPL | Stock | 18.4839 | 18.4839 | 18.4839 | 18.4839 | 7280.0 |
| 2013-11-21 08:06:00 | AAPL | Stock | 18.4714 | 18.4714 | 18.4714 | 18.4714 | 8400.0 |
| 2013-11-21 08:07:00 | AAPL | Stock | 18.475 | 18.475 | 18.475 | 18.475 | 2800.0 |
| 2013-11-21 08:08:00 | AAPL | Stock | 18.4664 | 18.4664 | 18.4643 | 18.4643 | 38108.0 |
| 2013-11-21 08:09:00 | AAPL | Stock | 18.4736 | 18.475 | 18.4736 | 18.475 | 5600.0 |
| 2013-11-21 08:10:00 | AAPL | Stock | 18.4643 | 18.4643 | 18.4643 | 18.4643 | 2800.0 |
| 2013-11-21 08:12:00 | AAPL | Stock | 18.4657 | 18.4657 | 18.4657 | 18.4657 | 2800.0 |
| 2013-11-21 08:13:00 | AAPL | Stock | 18.4743 | 18.4768 | 18.4743 | 18.4768 | 11200.0 |
| 2013-11-21 08:14:00 | AAPL | Stock | 18.4814 | 18.4857 | 18.4814 | 18.4839 | 56000.0 |
| 2013-11-21 08:15:00 | AAPL | Stock | 18.4857 | 18.4857 | 18.4857 | 18.4857 | 2800.0 |
| 2013-11-21 08:16:00 | AAPL | Stock | 18.4761 | 18.4761 | 18.4761 | 18.4761 | 2800.0 |
| 2013-11-21 08:17:00 | AAPL | Stock | 18.485 | 18.485 | 18.3929 | 18.3929 | 271880.0 |
| 2013-11-21 08:18:00 | AAPL | Stock | 18.485 | 18.485 | 18.485 | 18.485 | 13720.0 |
> showing 50 of 1,025,168 rows — these rows as CSV