PREVIEW / stock_1min / 2012-06-15
file: by_date/stock_1min/2012/2012-06-15.parquet size: 13.0 MB rows: 987,270 symbols: 2,854
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-15 04:19:00 | AAPL | Stock | 20.4714 | 20.4714 | 20.4714 | 20.4714 | 2800.0 |
| 2012-06-15 05:57:00 | AAPL | Stock | 20.48 | 20.48 | 20.48 | 20.48 | 2800.0 |
| 2012-06-15 06:04:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 2800.0 |
| 2012-06-15 06:05:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 5600.0 |
| 2012-06-15 06:08:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 5600.0 |
| 2012-06-15 06:10:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 5600.0 |
| 2012-06-15 06:17:00 | AAPL | Stock | 20.4821 | 20.4821 | 20.4821 | 20.4821 | 8960.0 |
| 2012-06-15 07:00:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 11648.0 |
| 2012-06-15 07:01:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 7000.0 |
| 2012-06-15 07:03:00 | AAPL | Stock | 20.4732 | 20.4732 | 20.4732 | 20.4732 | 2800.0 |
| 2012-06-15 07:04:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 5600.0 |
| 2012-06-15 07:09:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 5600.0 |
| 2012-06-15 07:10:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 14000.0 |
| 2012-06-15 07:11:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 2800.0 |
| 2012-06-15 07:12:00 | AAPL | Stock | 20.4736 | 20.4736 | 20.4679 | 20.4679 | 19600.0 |
| 2012-06-15 07:22:00 | AAPL | Stock | 20.4786 | 20.4804 | 20.4786 | 20.4804 | 5600.0 |
| 2012-06-15 07:24:00 | AAPL | Stock | 20.4804 | 20.4804 | 20.4804 | 20.4804 | 5600.0 |
| 2012-06-15 07:26:00 | AAPL | Stock | 20.4804 | 20.4857 | 20.4804 | 20.4857 | 8792.0 |
| 2012-06-15 07:27:00 | AAPL | Stock | 20.4925 | 20.4925 | 20.4925 | 20.4925 | 5600.0 |
| 2012-06-15 07:31:00 | AAPL | Stock | 20.4957 | 20.4964 | 20.4957 | 20.4964 | 8400.0 |
| 2012-06-15 07:43:00 | AAPL | Stock | 20.4957 | 20.4957 | 20.4957 | 20.4957 | 5600.0 |
| 2012-06-15 07:52:00 | AAPL | Stock | 20.4829 | 20.4829 | 20.4807 | 20.4807 | 8400.0 |
| 2012-06-15 07:58:00 | AAPL | Stock | 20.4679 | 20.4679 | 20.4679 | 20.4679 | 4200.0 |
| 2012-06-15 08:00:00 | AAPL | Stock | 20.4793 | 20.4804 | 20.4625 | 20.4625 | 62972.0 |
| 2012-06-15 08:01:00 | AAPL | Stock | 20.4607 | 20.4643 | 20.4604 | 20.4604 | 19600.0 |
| 2012-06-15 08:02:00 | AAPL | Stock | 20.4643 | 20.4782 | 20.4643 | 20.4782 | 37240.0 |
| 2012-06-15 08:03:00 | AAPL | Stock | 20.4768 | 20.4796 | 20.4768 | 20.4775 | 14000.0 |
| 2012-06-15 08:04:00 | AAPL | Stock | 20.4779 | 20.485 | 20.4779 | 20.4821 | 19992.0 |
| 2012-06-15 08:05:00 | AAPL | Stock | 20.4839 | 20.4921 | 20.4779 | 20.4779 | 22400.0 |
| 2012-06-15 08:06:00 | AAPL | Stock | 20.4796 | 20.4804 | 20.4689 | 20.4689 | 8400.0 |
| 2012-06-15 08:07:00 | AAPL | Stock | 20.4682 | 20.4689 | 20.4643 | 20.4643 | 29120.0 |
| 2012-06-15 08:08:00 | AAPL | Stock | 20.4514 | 20.4621 | 20.4493 | 20.4493 | 32452.0 |
| 2012-06-15 08:09:00 | AAPL | Stock | 20.45 | 20.4557 | 20.45 | 20.45 | 14000.0 |
| 2012-06-15 08:12:00 | AAPL | Stock | 20.4554 | 20.4554 | 20.4554 | 20.4554 | 2800.0 |
| 2012-06-15 08:17:00 | AAPL | Stock | 20.4521 | 20.4521 | 20.445 | 20.445 | 36540.0 |
| 2012-06-15 08:18:00 | AAPL | Stock | 20.4543 | 20.4579 | 20.4543 | 20.4579 | 5600.0 |
| 2012-06-15 08:19:00 | AAPL | Stock | 20.4554 | 20.4554 | 20.4554 | 20.4554 | 2800.0 |
| 2012-06-15 08:20:00 | AAPL | Stock | 20.455 | 20.455 | 20.455 | 20.455 | 5152.0 |
| 2012-06-15 08:21:00 | AAPL | Stock | 20.4571 | 20.4571 | 20.4571 | 20.4571 | 2800.0 |
| 2012-06-15 08:23:00 | AAPL | Stock | 20.4518 | 20.4568 | 20.4518 | 20.4568 | 10780.0 |
| 2012-06-15 08:24:00 | AAPL | Stock | 20.4554 | 20.4589 | 20.4554 | 20.4589 | 11200.0 |
| 2012-06-15 08:26:00 | AAPL | Stock | 20.4557 | 20.465 | 20.4557 | 20.465 | 29400.0 |
| 2012-06-15 08:27:00 | AAPL | Stock | 20.4646 | 20.4732 | 20.4646 | 20.4646 | 64400.0 |
| 2012-06-15 08:28:00 | AAPL | Stock | 20.4729 | 20.4729 | 20.4668 | 20.4668 | 29680.0 |
| 2012-06-15 08:30:00 | AAPL | Stock | 20.4579 | 20.4579 | 20.445 | 20.4504 | 72800.0 |
| 2012-06-15 08:31:00 | AAPL | Stock | 20.4614 | 20.4614 | 20.4486 | 20.4514 | 19600.0 |
| 2012-06-15 08:32:00 | AAPL | Stock | 20.4471 | 20.4475 | 20.4411 | 20.4411 | 44800.0 |
| 2012-06-15 08:33:00 | AAPL | Stock | 20.4464 | 20.4486 | 20.4393 | 20.4393 | 98000.0 |
| 2012-06-15 08:34:00 | AAPL | Stock | 20.4482 | 20.4482 | 20.4482 | 20.4482 | 2800.0 |
| 2012-06-15 08:35:00 | AAPL | Stock | 20.4461 | 20.4546 | 20.4461 | 20.4546 | 8400.0 |
> showing 50 of 987,270 rows — these rows as CSV