PREVIEW / stock_1min / 2012-06-18
file: by_date/stock_1min/2012/2012-06-18.parquet size: 12.9 MB rows: 974,698 symbols: 2,842
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-18 04:05:00 | AAPL | Stock | 20.5414 | 20.5414 | 20.5411 | 20.5414 | 11200.0 |
| 2012-06-18 04:06:00 | AAPL | Stock | 20.5357 | 20.5357 | 20.5357 | 20.5357 | 2800.0 |
| 2012-06-18 04:07:00 | AAPL | Stock | 20.5361 | 20.5361 | 20.5361 | 20.5361 | 2800.0 |
| 2012-06-18 04:08:00 | AAPL | Stock | 20.5182 | 20.5182 | 20.5182 | 20.5182 | 28000.0 |
| 2012-06-18 04:10:00 | AAPL | Stock | 20.5404 | 20.5404 | 20.5404 | 20.5404 | 5600.0 |
| 2012-06-18 04:13:00 | AAPL | Stock | 20.5125 | 20.5125 | 20.5125 | 20.5125 | 5600.0 |
| 2012-06-18 04:14:00 | AAPL | Stock | 20.5125 | 20.5125 | 20.5125 | 20.5125 | 18620.0 |
| 2012-06-18 04:20:00 | AAPL | Stock | 20.5271 | 20.5271 | 20.5271 | 20.5271 | 2800.0 |
| 2012-06-18 04:24:00 | AAPL | Stock | 20.5086 | 20.5086 | 20.5086 | 20.5086 | 11200.0 |
| 2012-06-18 04:25:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 2800.0 |
| 2012-06-18 04:26:00 | AAPL | Stock | 20.4893 | 20.4893 | 20.4893 | 20.4893 | 2800.0 |
| 2012-06-18 06:47:00 | AAPL | Stock | 20.4886 | 20.4886 | 20.4886 | 20.4886 | 14000.0 |
| 2012-06-18 06:49:00 | AAPL | Stock | 20.4864 | 20.4864 | 20.4864 | 20.4864 | 11200.0 |
| 2012-06-18 07:00:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 3220.0 |
| 2012-06-18 07:02:00 | AAPL | Stock | 20.5 | 20.5 | 20.5 | 20.5 | 5600.0 |
| 2012-06-18 07:04:00 | AAPL | Stock | 20.4861 | 20.4861 | 20.4821 | 20.4821 | 10360.0 |
| 2012-06-18 07:08:00 | AAPL | Stock | 20.4964 | 20.5 | 20.4964 | 20.5 | 37520.0 |
| 2012-06-18 07:10:00 | AAPL | Stock | 20.4911 | 20.4911 | 20.4911 | 20.4911 | 3836.0 |
| 2012-06-18 07:11:00 | AAPL | Stock | 20.4929 | 20.4929 | 20.4929 | 20.4929 | 2800.0 |
| 2012-06-18 07:17:00 | AAPL | Stock | 20.4664 | 20.4664 | 20.4643 | 20.4643 | 25200.0 |
| 2012-06-18 07:19:00 | AAPL | Stock | 20.4571 | 20.4636 | 20.4571 | 20.4636 | 8400.0 |
| 2012-06-18 07:21:00 | AAPL | Stock | 20.4871 | 20.4911 | 20.4871 | 20.4911 | 28000.0 |
| 2012-06-18 07:24:00 | AAPL | Stock | 20.4686 | 20.4686 | 20.4654 | 20.4654 | 6300.0 |
| 2012-06-18 07:25:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4596 | 20.4596 | 5600.0 |
| 2012-06-18 07:28:00 | AAPL | Stock | 20.465 | 20.465 | 20.465 | 20.465 | 2800.0 |
| 2012-06-18 07:36:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 5600.0 |
| 2012-06-18 07:38:00 | AAPL | Stock | 20.4607 | 20.4646 | 20.4571 | 20.4646 | 16800.0 |
| 2012-06-18 07:39:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 2800.0 |
| 2012-06-18 07:41:00 | AAPL | Stock | 20.475 | 20.475 | 20.475 | 20.475 | 2800.0 |
| 2012-06-18 07:43:00 | AAPL | Stock | 20.465 | 20.465 | 20.4646 | 20.4646 | 8400.0 |
| 2012-06-18 07:44:00 | AAPL | Stock | 20.4729 | 20.4729 | 20.4729 | 20.4729 | 2800.0 |
| 2012-06-18 07:45:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 7000.0 |
| 2012-06-18 07:47:00 | AAPL | Stock | 20.4639 | 20.4639 | 20.4639 | 20.4639 | 2800.0 |
| 2012-06-18 07:50:00 | AAPL | Stock | 20.4479 | 20.4496 | 20.4404 | 20.4468 | 24360.0 |
| 2012-06-18 07:57:00 | AAPL | Stock | 20.4382 | 20.4464 | 20.4382 | 20.4464 | 21588.0 |
| 2012-06-18 07:58:00 | AAPL | Stock | 20.4461 | 20.4514 | 20.4461 | 20.4514 | 8400.0 |
| 2012-06-18 08:00:00 | AAPL | Stock | 20.4557 | 20.4643 | 20.4464 | 20.4586 | 62244.0 |
| 2012-06-18 08:01:00 | AAPL | Stock | 20.4504 | 20.4582 | 20.4504 | 20.4582 | 8400.0 |
| 2012-06-18 08:03:00 | AAPL | Stock | 20.4468 | 20.4518 | 20.4425 | 20.4518 | 21980.0 |
| 2012-06-18 08:04:00 | AAPL | Stock | 20.4536 | 20.4586 | 20.4536 | 20.4586 | 5600.0 |
| 2012-06-18 08:05:00 | AAPL | Stock | 20.4525 | 20.4525 | 20.4525 | 20.4525 | 2800.0 |
| 2012-06-18 08:06:00 | AAPL | Stock | 20.4604 | 20.4636 | 20.4604 | 20.4636 | 19600.0 |
| 2012-06-18 08:07:00 | AAPL | Stock | 20.4618 | 20.4643 | 20.4618 | 20.4621 | 22400.0 |
| 2012-06-18 08:08:00 | AAPL | Stock | 20.4643 | 20.4643 | 20.4625 | 20.4643 | 48216.0 |
| 2012-06-18 08:09:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 2800.0 |
| 2012-06-18 08:12:00 | AAPL | Stock | 20.4646 | 20.4646 | 20.4646 | 20.4646 | 5600.0 |
| 2012-06-18 08:14:00 | AAPL | Stock | 20.4671 | 20.4671 | 20.4661 | 20.4661 | 8400.0 |
| 2012-06-18 08:17:00 | AAPL | Stock | 20.4714 | 20.4721 | 20.4711 | 20.4711 | 20748.0 |
| 2012-06-18 08:18:00 | AAPL | Stock | 20.4657 | 20.4657 | 20.4657 | 20.4657 | 2800.0 |
| 2012-06-18 08:19:00 | AAPL | Stock | 20.465 | 20.465 | 20.4554 | 20.4554 | 38500.0 |
> showing 50 of 974,698 rows — these rows as CSV