PREVIEW / stock_1min / 2013-05-08
file: by_date/stock_1min/2013/2013-05-08.parquet size: 13.5 MB rows: 985,406 symbols: 2,827
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-05-08 04:00:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 2800.0 |
| 2013-05-08 05:25:00 | AAPL | Stock | 16.4304 | 16.4304 | 16.4304 | 16.4304 | 2800.0 |
| 2013-05-08 05:26:00 | AAPL | Stock | 16.4304 | 16.4304 | 16.4304 | 16.4304 | 4928.0 |
| 2013-05-08 05:38:00 | AAPL | Stock | 16.4268 | 16.4268 | 16.4268 | 16.4268 | 2800.0 |
| 2013-05-08 05:58:00 | AAPL | Stock | 16.4161 | 16.4161 | 16.4161 | 16.4161 | 4704.0 |
| 2013-05-08 06:02:00 | AAPL | Stock | 16.42 | 16.42 | 16.42 | 16.42 | 2800.0 |
| 2013-05-08 06:10:00 | AAPL | Stock | 16.4289 | 16.4289 | 16.4289 | 16.4289 | 2800.0 |
| 2013-05-08 06:19:00 | AAPL | Stock | 16.4379 | 16.4379 | 16.4379 | 16.4379 | 2800.0 |
| 2013-05-08 06:20:00 | AAPL | Stock | 16.4429 | 16.4429 | 16.4429 | 16.4429 | 2800.0 |
| 2013-05-08 06:33:00 | AAPL | Stock | 16.4646 | 16.4646 | 16.4646 | 16.4646 | 2800.0 |
| 2013-05-08 06:42:00 | AAPL | Stock | 16.4889 | 16.4889 | 16.4889 | 16.4889 | 5376.0 |
| 2013-05-08 06:51:00 | AAPL | Stock | 16.465 | 16.465 | 16.465 | 16.465 | 2800.0 |
| 2013-05-08 06:53:00 | AAPL | Stock | 16.4571 | 16.4571 | 16.4571 | 16.4571 | 2800.0 |
| 2013-05-08 06:59:00 | AAPL | Stock | 16.4439 | 16.4439 | 16.4432 | 16.4432 | 8400.0 |
| 2013-05-08 07:00:00 | AAPL | Stock | 16.4182 | 16.4182 | 16.4161 | 16.4161 | 5600.0 |
| 2013-05-08 07:06:00 | AAPL | Stock | 16.4282 | 16.4282 | 16.4282 | 16.4282 | 5600.0 |
| 2013-05-08 07:08:00 | AAPL | Stock | 16.4232 | 16.4232 | 16.4232 | 16.4232 | 5600.0 |
| 2013-05-08 07:09:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4286 | 16.4286 | 5600.0 |
| 2013-05-08 07:11:00 | AAPL | Stock | 16.4375 | 16.4429 | 16.4375 | 16.4429 | 8400.0 |
| 2013-05-08 07:12:00 | AAPL | Stock | 16.4432 | 16.4432 | 16.4432 | 16.4432 | 4200.0 |
| 2013-05-08 07:14:00 | AAPL | Stock | 16.4429 | 16.4436 | 16.4429 | 16.4436 | 14000.0 |
| 2013-05-08 07:15:00 | AAPL | Stock | 16.4604 | 16.4625 | 16.4604 | 16.4625 | 9800.0 |
| 2013-05-08 07:16:00 | AAPL | Stock | 16.4604 | 16.4604 | 16.4604 | 16.4604 | 11200.0 |
| 2013-05-08 07:20:00 | AAPL | Stock | 16.4632 | 16.4632 | 16.4525 | 16.4536 | 8400.0 |
| 2013-05-08 07:24:00 | AAPL | Stock | 16.4625 | 16.4725 | 16.4625 | 16.4725 | 27104.0 |
| 2013-05-08 07:26:00 | AAPL | Stock | 16.4786 | 16.4821 | 16.4786 | 16.4821 | 30996.0 |
| 2013-05-08 07:27:00 | AAPL | Stock | 16.4768 | 16.4768 | 16.4743 | 16.4743 | 60620.0 |
| 2013-05-08 07:28:00 | AAPL | Stock | 16.4821 | 16.4821 | 16.4696 | 16.4696 | 30800.0 |
| 2013-05-08 07:32:00 | AAPL | Stock | 16.4804 | 16.4804 | 16.4804 | 16.4804 | 3080.0 |
| 2013-05-08 07:33:00 | AAPL | Stock | 16.4786 | 16.4821 | 16.4786 | 16.4821 | 28000.0 |
| 2013-05-08 07:35:00 | AAPL | Stock | 16.4893 | 16.5 | 16.4893 | 16.5 | 44520.0 |
| 2013-05-08 07:36:00 | AAPL | Stock | 16.5 | 16.5 | 16.5 | 16.5 | 8400.0 |
| 2013-05-08 07:37:00 | AAPL | Stock | 16.5004 | 16.5004 | 16.5004 | 16.5004 | 5600.0 |
| 2013-05-08 07:38:00 | AAPL | Stock | 16.5064 | 16.5132 | 16.5036 | 16.5071 | 39200.0 |
| 2013-05-08 07:39:00 | AAPL | Stock | 16.5018 | 16.5018 | 16.5018 | 16.5018 | 2800.0 |
| 2013-05-08 07:40:00 | AAPL | Stock | 16.5018 | 16.5018 | 16.5 | 16.5011 | 53592.0 |
| 2013-05-08 07:41:00 | AAPL | Stock | 16.5007 | 16.5007 | 16.5007 | 16.5007 | 2800.0 |
| 2013-05-08 07:42:00 | AAPL | Stock | 16.5004 | 16.5004 | 16.5 | 16.5 | 44800.0 |
| 2013-05-08 07:43:00 | AAPL | Stock | 16.5 | 16.5 | 16.4843 | 16.4843 | 18872.0 |
| 2013-05-08 07:45:00 | AAPL | Stock | 16.4807 | 16.4807 | 16.4807 | 16.4807 | 2800.0 |
| 2013-05-08 07:48:00 | AAPL | Stock | 16.48 | 16.48 | 16.48 | 16.48 | 2800.0 |
| 2013-05-08 07:50:00 | AAPL | Stock | 16.4821 | 16.4854 | 16.4714 | 16.4714 | 57260.0 |
| 2013-05-08 07:51:00 | AAPL | Stock | 16.4729 | 16.4804 | 16.4714 | 16.4804 | 50400.0 |
| 2013-05-08 07:52:00 | AAPL | Stock | 16.4879 | 16.4904 | 16.4829 | 16.4829 | 28280.0 |
| 2013-05-08 07:55:00 | AAPL | Stock | 16.4839 | 16.4839 | 16.4736 | 16.4736 | 78400.0 |
| 2013-05-08 07:56:00 | AAPL | Stock | 16.4729 | 16.4729 | 16.4714 | 16.4714 | 26180.0 |
| 2013-05-08 07:57:00 | AAPL | Stock | 16.4646 | 16.4646 | 16.4468 | 16.4468 | 19600.0 |
| 2013-05-08 07:58:00 | AAPL | Stock | 16.4629 | 16.4629 | 16.4629 | 16.4629 | 2800.0 |
| 2013-05-08 08:00:00 | AAPL | Stock | 16.4607 | 16.5064 | 16.4232 | 16.4714 | 108752.0 |
| 2013-05-08 08:01:00 | AAPL | Stock | 16.4625 | 16.4643 | 16.4521 | 16.4521 | 46060.0 |
> showing 50 of 985,406 rows — these rows as CSV