PREVIEW / stock_1min / 2012-06-29
file: by_date/stock_1min/2012/2012-06-29.parquet size: 13.3 MB rows: 997,672 symbols: 2,864
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 |
|---|---|---|---|---|---|---|---|
| 2012-06-29 04:00:00 | AAPL | Stock | 20.3393 | 20.4286 | 20.3393 | 20.4286 | 30800.0 |
| 2012-06-29 04:01:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 28000.0 |
| 2012-06-29 04:19:00 | AAPL | Stock | 20.4496 | 20.4496 | 20.4496 | 20.4496 | 2800.0 |
| 2012-06-29 05:02:00 | AAPL | Stock | 20.4554 | 20.4554 | 20.4554 | 20.4554 | 5600.0 |
| 2012-06-29 05:15:00 | AAPL | Stock | 20.4514 | 20.4514 | 20.4514 | 20.4514 | 6440.0 |
| 2012-06-29 05:25:00 | AAPL | Stock | 20.4286 | 20.4286 | 20.4286 | 20.4286 | 2800.0 |
| 2012-06-29 05:49:00 | AAPL | Stock | 20.4514 | 20.4514 | 20.4514 | 20.4514 | 2800.0 |
| 2012-06-29 05:50:00 | AAPL | Stock | 20.4514 | 20.4514 | 20.4514 | 20.4514 | 2800.0 |
| 2012-06-29 05:51:00 | AAPL | Stock | 20.4514 | 20.4539 | 20.4514 | 20.4539 | 14000.0 |
| 2012-06-29 06:02:00 | AAPL | Stock | 20.4464 | 20.4464 | 20.4464 | 20.4464 | 4200.0 |
| 2012-06-29 06:03:00 | AAPL | Stock | 20.4607 | 20.4643 | 20.4607 | 20.4643 | 8400.0 |
| 2012-06-29 06:06:00 | AAPL | Stock | 20.4839 | 20.4839 | 20.4839 | 20.4839 | 5600.0 |
| 2012-06-29 06:12:00 | AAPL | Stock | 20.4729 | 20.4732 | 20.4729 | 20.4732 | 8400.0 |
| 2012-06-29 06:18:00 | AAPL | Stock | 20.4607 | 20.4607 | 20.4607 | 20.4607 | 4200.0 |
| 2012-06-29 06:20:00 | AAPL | Stock | 20.4614 | 20.4614 | 20.4607 | 20.4607 | 19600.0 |
| 2012-06-29 06:21:00 | AAPL | Stock | 20.4836 | 20.4836 | 20.4836 | 20.4836 | 2800.0 |
| 2012-06-29 06:23:00 | AAPL | Stock | 20.475 | 20.475 | 20.475 | 20.475 | 2800.0 |
| 2012-06-29 06:37:00 | AAPL | Stock | 20.4689 | 20.4689 | 20.4621 | 20.4621 | 8400.0 |
| 2012-06-29 06:43:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 2800.0 |
| 2012-06-29 07:00:00 | AAPL | Stock | 20.4732 | 20.4732 | 20.4646 | 20.4646 | 8400.0 |
| 2012-06-29 07:01:00 | AAPL | Stock | 20.4654 | 20.4732 | 20.4646 | 20.4661 | 19600.0 |
| 2012-06-29 07:02:00 | AAPL | Stock | 20.4804 | 20.4821 | 20.4786 | 20.4786 | 32424.0 |
| 2012-06-29 07:03:00 | AAPL | Stock | 20.4782 | 20.4911 | 20.4782 | 20.4911 | 34860.0 |
| 2012-06-29 07:04:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 2800.0 |
| 2012-06-29 07:05:00 | AAPL | Stock | 20.4929 | 20.4946 | 20.4929 | 20.4946 | 6440.0 |
| 2012-06-29 07:06:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 22400.0 |
| 2012-06-29 07:07:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4929 | 20.4929 | 8400.0 |
| 2012-06-29 07:11:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4929 | 20.4929 | 2800.0 |
| 2012-06-29 07:13:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 2800.0 |
| 2012-06-29 07:15:00 | AAPL | Stock | 20.4825 | 20.4825 | 20.4821 | 20.4821 | 8400.0 |
| 2012-06-29 07:16:00 | AAPL | Stock | 20.4821 | 20.4871 | 20.4821 | 20.4821 | 16800.0 |
| 2012-06-29 07:17:00 | AAPL | Stock | 20.4757 | 20.4757 | 20.4757 | 20.4757 | 2800.0 |
| 2012-06-29 07:18:00 | AAPL | Stock | 20.4768 | 20.4768 | 20.4757 | 20.4764 | 16800.0 |
| 2012-06-29 07:19:00 | AAPL | Stock | 20.475 | 20.4793 | 20.475 | 20.4793 | 29932.0 |
| 2012-06-29 07:22:00 | AAPL | Stock | 20.4821 | 20.4832 | 20.4821 | 20.4832 | 5600.0 |
| 2012-06-29 07:25:00 | AAPL | Stock | 20.4918 | 20.5107 | 20.4907 | 20.5104 | 31500.0 |
| 2012-06-29 07:26:00 | AAPL | Stock | 20.5104 | 20.5104 | 20.5104 | 20.5104 | 2800.0 |
| 2012-06-29 07:27:00 | AAPL | Stock | 20.5275 | 20.5275 | 20.5214 | 20.5214 | 8400.0 |
| 2012-06-29 07:28:00 | AAPL | Stock | 20.5143 | 20.5143 | 20.5143 | 20.5143 | 2800.0 |
| 2012-06-29 07:29:00 | AAPL | Stock | 20.5307 | 20.5354 | 20.5307 | 20.535 | 15400.0 |
| 2012-06-29 07:30:00 | AAPL | Stock | 20.5218 | 20.5218 | 20.5143 | 20.5179 | 63140.0 |
| 2012-06-29 07:31:00 | AAPL | Stock | 20.5179 | 20.5214 | 20.5179 | 20.5214 | 15204.0 |
| 2012-06-29 07:32:00 | AAPL | Stock | 20.5218 | 20.5236 | 20.5118 | 20.5118 | 8400.0 |
| 2012-06-29 07:33:00 | AAPL | Stock | 20.5011 | 20.5011 | 20.5011 | 20.5011 | 2800.0 |
| 2012-06-29 07:36:00 | AAPL | Stock | 20.4986 | 20.4986 | 20.4986 | 20.4986 | 2800.0 |
| 2012-06-29 07:38:00 | AAPL | Stock | 20.4993 | 20.4993 | 20.4993 | 20.4993 | 2800.0 |
| 2012-06-29 07:39:00 | AAPL | Stock | 20.4964 | 20.4964 | 20.4911 | 20.4911 | 8400.0 |
| 2012-06-29 07:40:00 | AAPL | Stock | 20.4875 | 20.4875 | 20.4821 | 20.4875 | 14000.0 |
| 2012-06-29 07:41:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 27664.0 |
| 2012-06-29 07:42:00 | AAPL | Stock | 20.4996 | 20.4996 | 20.4996 | 20.4996 | 2800.0 |
> showing 50 of 997,672 rows — these rows as CSV