PREVIEW / stock_1min / 2011-12-30
file: by_date/stock_1min/2011/2011-12-30.parquet size: 12.0 MB rows: 897,029 symbols: 2,920
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-30 05:38:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 16800.0 |
| 2011-12-30 05:41:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 11200.0 |
| 2011-12-30 06:15:00 | AAPL | Stock | 14.4675 | 14.4675 | 14.4675 | 14.4675 | 2800.0 |
| 2011-12-30 06:43:00 | AAPL | Stock | 14.4554 | 14.4554 | 14.4554 | 14.4554 | 3500.0 |
| 2011-12-30 06:48:00 | AAPL | Stock | 14.4571 | 14.4571 | 14.4571 | 14.4571 | 11200.0 |
| 2011-12-30 07:04:00 | AAPL | Stock | 14.4718 | 14.4743 | 14.4718 | 14.4743 | 12600.0 |
| 2011-12-30 07:06:00 | AAPL | Stock | 14.4761 | 14.4761 | 14.4761 | 14.4761 | 4200.0 |
| 2011-12-30 07:07:00 | AAPL | Stock | 14.4811 | 14.4818 | 14.4811 | 14.4818 | 16800.0 |
| 2011-12-30 07:08:00 | AAPL | Stock | 14.4818 | 14.4839 | 14.475 | 14.475 | 28000.0 |
| 2011-12-30 07:09:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4714 | 14.4714 | 2800.0 |
| 2011-12-30 07:19:00 | AAPL | Stock | 14.4746 | 14.4746 | 14.4746 | 14.4746 | 5600.0 |
| 2011-12-30 07:22:00 | AAPL | Stock | 14.475 | 14.475 | 14.475 | 14.475 | 4200.0 |
| 2011-12-30 07:25:00 | AAPL | Stock | 14.475 | 14.475 | 14.475 | 14.475 | 5600.0 |
| 2011-12-30 07:27:00 | AAPL | Stock | 14.475 | 14.475 | 14.475 | 14.475 | 2800.0 |
| 2011-12-30 07:32:00 | AAPL | Stock | 14.4664 | 14.4664 | 14.4643 | 14.4643 | 8400.0 |
| 2011-12-30 07:38:00 | AAPL | Stock | 14.4646 | 14.4646 | 14.4643 | 14.4643 | 14000.0 |
| 2011-12-30 07:39:00 | AAPL | Stock | 14.4604 | 14.4604 | 14.4604 | 14.4604 | 2800.0 |
| 2011-12-30 07:45:00 | AAPL | Stock | 14.4629 | 14.4629 | 14.4629 | 14.4629 | 5600.0 |
| 2011-12-30 07:53:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 3640.0 |
| 2011-12-30 07:55:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 2800.0 |
| 2011-12-30 07:57:00 | AAPL | Stock | 14.4714 | 14.4754 | 14.4714 | 14.4714 | 30940.0 |
| 2011-12-30 08:05:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4714 | 14.4714 | 16800.0 |
| 2011-12-30 08:06:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4696 | 14.4696 | 11200.0 |
| 2011-12-30 08:07:00 | AAPL | Stock | 14.4686 | 14.4711 | 14.4643 | 14.4711 | 55580.0 |
| 2011-12-30 08:15:00 | AAPL | Stock | 14.4607 | 14.4607 | 14.4607 | 14.4607 | 7000.0 |
| 2011-12-30 08:17:00 | AAPL | Stock | 14.4607 | 14.4607 | 14.4607 | 14.4607 | 4200.0 |
| 2011-12-30 08:18:00 | AAPL | Stock | 14.46 | 14.46 | 14.46 | 14.46 | 2800.0 |
| 2011-12-30 08:23:00 | AAPL | Stock | 14.46 | 14.46 | 14.46 | 14.46 | 2800.0 |
| 2011-12-30 08:29:00 | AAPL | Stock | 14.455 | 14.455 | 14.45 | 14.45 | 40880.0 |
| 2011-12-30 08:31:00 | AAPL | Stock | 14.45 | 14.45 | 14.45 | 14.45 | 2800.0 |
| 2011-12-30 08:32:00 | AAPL | Stock | 14.4489 | 14.4489 | 14.4471 | 14.4471 | 8400.0 |
| 2011-12-30 08:33:00 | AAPL | Stock | 14.4607 | 14.4607 | 14.4607 | 14.4607 | 2800.0 |
| 2011-12-30 08:36:00 | AAPL | Stock | 14.4596 | 14.4604 | 14.4596 | 14.4604 | 14504.0 |
| 2011-12-30 08:37:00 | AAPL | Stock | 14.4504 | 14.4504 | 14.45 | 14.45 | 5600.0 |
| 2011-12-30 08:38:00 | AAPL | Stock | 14.4504 | 14.4507 | 14.4504 | 14.4504 | 14000.0 |
| 2011-12-30 08:39:00 | AAPL | Stock | 14.4589 | 14.4589 | 14.4571 | 14.4571 | 11200.0 |
| 2011-12-30 08:41:00 | AAPL | Stock | 14.455 | 14.455 | 14.4546 | 14.4546 | 5600.0 |
| 2011-12-30 08:42:00 | AAPL | Stock | 14.4529 | 14.4536 | 14.4529 | 14.4532 | 8400.0 |
| 2011-12-30 08:46:00 | AAPL | Stock | 14.4536 | 14.4536 | 14.4536 | 14.4536 | 2800.0 |
| 2011-12-30 08:48:00 | AAPL | Stock | 14.4525 | 14.4525 | 14.4479 | 14.4479 | 146048.0 |
| 2011-12-30 08:49:00 | AAPL | Stock | 14.45 | 14.45 | 14.4429 | 14.4429 | 22400.0 |
| 2011-12-30 08:51:00 | AAPL | Stock | 14.4325 | 14.4325 | 14.4321 | 14.4325 | 10164.0 |
| 2011-12-30 08:52:00 | AAPL | Stock | 14.4321 | 14.4343 | 14.4286 | 14.4339 | 19880.0 |
| 2011-12-30 08:53:00 | AAPL | Stock | 14.4339 | 14.4339 | 14.4339 | 14.4339 | 2800.0 |
| 2011-12-30 08:54:00 | AAPL | Stock | 14.4357 | 14.4357 | 14.4357 | 14.4357 | 5600.0 |
| 2011-12-30 08:55:00 | AAPL | Stock | 14.4382 | 14.4382 | 14.4332 | 14.4339 | 8400.0 |
| 2011-12-30 08:58:00 | AAPL | Stock | 14.4364 | 14.4364 | 14.4357 | 14.4357 | 8400.0 |
| 2011-12-30 08:59:00 | AAPL | Stock | 14.4357 | 14.4357 | 14.4357 | 14.4357 | 3080.0 |
| 2011-12-30 09:00:00 | AAPL | Stock | 14.4389 | 14.4389 | 14.4386 | 14.4389 | 56784.0 |
| 2011-12-30 09:02:00 | AAPL | Stock | 14.4393 | 14.4393 | 14.4393 | 14.4393 | 8400.0 |
> showing 50 of 897,029 rows — these rows as CSV