PREVIEW / stock_1min / 2012-06-12
file: by_date/stock_1min/2012/2012-06-12.parquet size: 12.9 MB rows: 975,246 symbols: 2,839
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-12 04:43:00 | AAPL | Stock | 20.4311 | 20.4311 | 20.4311 | 20.4311 | 2800.0 |
| 2012-06-12 04:59:00 | AAPL | Stock | 20.4582 | 20.4582 | 20.4582 | 20.4582 | 2800.0 |
| 2012-06-12 05:38:00 | AAPL | Stock | 20.4586 | 20.4586 | 20.4586 | 20.4586 | 2800.0 |
| 2012-06-12 05:45:00 | AAPL | Stock | 20.4586 | 20.4586 | 20.4586 | 20.4586 | 2800.0 |
| 2012-06-12 05:51:00 | AAPL | Stock | 20.4854 | 20.4854 | 20.4854 | 20.4854 | 2800.0 |
| 2012-06-12 06:07:00 | AAPL | Stock | 20.5139 | 20.5264 | 20.5139 | 20.5264 | 28000.0 |
| 2012-06-12 06:42:00 | AAPL | Stock | 20.4914 | 20.4914 | 20.4914 | 20.4914 | 2800.0 |
| 2012-06-12 06:51:00 | AAPL | Stock | 20.4904 | 20.4904 | 20.4904 | 20.4904 | 2800.0 |
| 2012-06-12 07:00:00 | AAPL | Stock | 20.4582 | 20.4582 | 20.4582 | 20.4582 | 13580.0 |
| 2012-06-12 07:02:00 | AAPL | Stock | 20.4893 | 20.4893 | 20.4893 | 20.4893 | 5600.0 |
| 2012-06-12 07:03:00 | AAPL | Stock | 20.4554 | 20.4821 | 20.4536 | 20.4821 | 22372.0 |
| 2012-06-12 07:04:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 2800.0 |
| 2012-06-12 07:05:00 | AAPL | Stock | 20.4543 | 20.455 | 20.4543 | 20.455 | 5600.0 |
| 2012-06-12 07:07:00 | AAPL | Stock | 20.4379 | 20.4643 | 20.4375 | 20.4643 | 50400.0 |
| 2012-06-12 07:08:00 | AAPL | Stock | 20.465 | 20.465 | 20.465 | 20.465 | 2800.0 |
| 2012-06-12 07:11:00 | AAPL | Stock | 20.4714 | 20.4714 | 20.4714 | 20.4714 | 6300.0 |
| 2012-06-12 07:13:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 2800.0 |
| 2012-06-12 07:14:00 | AAPL | Stock | 20.4714 | 20.4821 | 20.4714 | 20.4821 | 6580.0 |
| 2012-06-12 07:15:00 | AAPL | Stock | 20.4818 | 20.4857 | 20.4818 | 20.4857 | 24920.0 |
| 2012-06-12 07:16:00 | AAPL | Stock | 20.4893 | 20.4925 | 20.4893 | 20.4893 | 35448.0 |
| 2012-06-12 07:17:00 | AAPL | Stock | 20.4925 | 20.4925 | 20.4925 | 20.4925 | 2800.0 |
| 2012-06-12 07:21:00 | AAPL | Stock | 20.4839 | 20.4839 | 20.4839 | 20.4839 | 2800.0 |
| 2012-06-12 07:25:00 | AAPL | Stock | 20.4786 | 20.4893 | 20.4786 | 20.4893 | 28000.0 |
| 2012-06-12 07:26:00 | AAPL | Stock | 20.4821 | 20.4893 | 20.4821 | 20.4893 | 11200.0 |
| 2012-06-12 07:27:00 | AAPL | Stock | 20.4771 | 20.4771 | 20.4714 | 20.4714 | 36400.0 |
| 2012-06-12 07:28:00 | AAPL | Stock | 20.4679 | 20.4761 | 20.4643 | 20.4761 | 23408.0 |
| 2012-06-12 07:30:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4611 | 20.4643 | 19348.0 |
| 2012-06-12 07:31:00 | AAPL | Stock | 20.4714 | 20.4786 | 20.4714 | 20.4786 | 25200.0 |
| 2012-06-12 07:33:00 | AAPL | Stock | 20.4714 | 20.4714 | 20.4714 | 20.4714 | 2800.0 |
| 2012-06-12 07:34:00 | AAPL | Stock | 20.4689 | 20.4689 | 20.4689 | 20.4689 | 2800.0 |
| 2012-06-12 07:35:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 5600.0 |
| 2012-06-12 07:37:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4643 | 20.4643 | 8400.0 |
| 2012-06-12 07:39:00 | AAPL | Stock | 20.4786 | 20.4786 | 20.4786 | 20.4786 | 2800.0 |
| 2012-06-12 07:40:00 | AAPL | Stock | 20.4857 | 20.4857 | 20.4857 | 20.4857 | 7000.0 |
| 2012-06-12 07:43:00 | AAPL | Stock | 20.4857 | 20.5039 | 20.4857 | 20.5039 | 52332.0 |
| 2012-06-12 07:44:00 | AAPL | Stock | 20.5104 | 20.5125 | 20.5104 | 20.5125 | 9996.0 |
| 2012-06-12 07:45:00 | AAPL | Stock | 20.5125 | 20.5325 | 20.5125 | 20.5314 | 34720.0 |
| 2012-06-12 07:46:00 | AAPL | Stock | 20.5254 | 20.5254 | 20.5225 | 20.5229 | 87948.0 |
| 2012-06-12 07:47:00 | AAPL | Stock | 20.5182 | 20.5186 | 20.5182 | 20.5186 | 8400.0 |
| 2012-06-12 07:48:00 | AAPL | Stock | 20.5246 | 20.5268 | 20.5246 | 20.5268 | 34552.0 |
| 2012-06-12 07:49:00 | AAPL | Stock | 20.525 | 20.525 | 20.5179 | 20.5196 | 51800.0 |
| 2012-06-12 07:51:00 | AAPL | Stock | 20.5129 | 20.5129 | 20.5125 | 20.5125 | 25200.0 |
| 2012-06-12 07:52:00 | AAPL | Stock | 20.5125 | 20.5246 | 20.5125 | 20.5179 | 56000.0 |
| 2012-06-12 07:53:00 | AAPL | Stock | 20.5129 | 20.5132 | 20.5075 | 20.5075 | 21448.0 |
| 2012-06-12 07:54:00 | AAPL | Stock | 20.5007 | 20.5025 | 20.5007 | 20.5025 | 5600.0 |
| 2012-06-12 07:55:00 | AAPL | Stock | 20.495 | 20.495 | 20.495 | 20.495 | 2800.0 |
| 2012-06-12 07:57:00 | AAPL | Stock | 20.4989 | 20.5 | 20.4989 | 20.4996 | 22232.0 |
| 2012-06-12 07:59:00 | AAPL | Stock | 20.4896 | 20.4896 | 20.4896 | 20.4896 | 13384.0 |
| 2012-06-12 08:00:00 | AAPL | Stock | 20.5 | 20.5229 | 20.4643 | 20.4829 | 137704.0 |
| 2012-06-12 08:01:00 | AAPL | Stock | 20.4829 | 20.4893 | 20.4829 | 20.4843 | 30800.0 |
> showing 50 of 975,246 rows — these rows as CSV