PREVIEW / stock_1min / 2011-05-11
file: by_date/stock_1min/2011/2011-05-11.parquet size: 13.6 MB rows: 1,012,281 symbols: 2,882
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-05-11 04:42:00 | AAPL | Stock | 12.4689 | 12.4689 | 12.4689 | 12.4689 | 2800.0 |
| 2011-05-11 04:43:00 | AAPL | Stock | 12.4689 | 12.4689 | 12.4689 | 12.4689 | 5600.0 |
| 2011-05-11 05:41:00 | AAPL | Stock | 12.4696 | 12.4696 | 12.4696 | 12.4696 | 2800.0 |
| 2011-05-11 06:25:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 5600.0 |
| 2011-05-11 06:26:00 | AAPL | Stock | 12.475 | 12.475 | 12.475 | 12.475 | 2800.0 |
| 2011-05-11 06:32:00 | AAPL | Stock | 12.4696 | 12.4696 | 12.4696 | 12.4696 | 9520.0 |
| 2011-05-11 06:39:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-05-11 06:53:00 | AAPL | Stock | 12.4636 | 12.4636 | 12.4636 | 12.4636 | 2800.0 |
| 2011-05-11 06:57:00 | AAPL | Stock | 12.4636 | 12.4636 | 12.4636 | 12.4636 | 8400.0 |
| 2011-05-11 07:04:00 | AAPL | Stock | 12.4607 | 12.4607 | 12.4607 | 12.4607 | 14000.0 |
| 2011-05-11 07:07:00 | AAPL | Stock | 12.4521 | 12.4521 | 12.4521 | 12.4521 | 19600.0 |
| 2011-05-11 07:08:00 | AAPL | Stock | 12.4468 | 12.4468 | 12.4468 | 12.4468 | 27300.0 |
| 2011-05-11 07:09:00 | AAPL | Stock | 12.4464 | 12.4464 | 12.4464 | 12.4464 | 11200.0 |
| 2011-05-11 07:18:00 | AAPL | Stock | 12.4468 | 12.4468 | 12.4464 | 12.4464 | 11900.0 |
| 2011-05-11 07:22:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 2800.0 |
| 2011-05-11 07:23:00 | AAPL | Stock | 12.4536 | 12.4543 | 12.4536 | 12.4543 | 5600.0 |
| 2011-05-11 07:26:00 | AAPL | Stock | 12.4543 | 12.4543 | 12.4543 | 12.4543 | 2800.0 |
| 2011-05-11 07:28:00 | AAPL | Stock | 12.4543 | 12.4543 | 12.4543 | 12.4543 | 2800.0 |
| 2011-05-11 07:30:00 | AAPL | Stock | 12.4621 | 12.4714 | 12.4621 | 12.4689 | 29400.0 |
| 2011-05-11 07:31:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 2800.0 |
| 2011-05-11 07:32:00 | AAPL | Stock | 12.4646 | 12.4675 | 12.4646 | 12.4646 | 8400.0 |
| 2011-05-11 07:33:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 11200.0 |
| 2011-05-11 07:35:00 | AAPL | Stock | 12.4679 | 12.4679 | 12.4679 | 12.4679 | 5600.0 |
| 2011-05-11 07:36:00 | AAPL | Stock | 12.4671 | 12.4671 | 12.4671 | 12.4671 | 2800.0 |
| 2011-05-11 07:37:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 21000.0 |
| 2011-05-11 07:50:00 | AAPL | Stock | 12.4671 | 12.4671 | 12.4607 | 12.4607 | 16800.0 |
| 2011-05-11 07:51:00 | AAPL | Stock | 12.4643 | 12.4643 | 12.4643 | 12.4643 | 6300.0 |
| 2011-05-11 07:54:00 | AAPL | Stock | 12.4614 | 12.4614 | 12.4607 | 12.4607 | 14000.0 |
| 2011-05-11 07:56:00 | AAPL | Stock | 12.4661 | 12.4661 | 12.4661 | 12.4661 | 14000.0 |
| 2011-05-11 07:57:00 | AAPL | Stock | 12.4661 | 12.4661 | 12.4661 | 12.4661 | 5600.0 |
| 2011-05-11 07:58:00 | AAPL | Stock | 12.4625 | 12.4625 | 12.4625 | 12.4625 | 5600.0 |
| 2011-05-11 07:59:00 | AAPL | Stock | 12.4582 | 12.4582 | 12.4571 | 12.4571 | 5740.0 |
| 2011-05-11 08:00:00 | AAPL | Stock | 12.4607 | 12.4643 | 12.4536 | 12.4561 | 105000.0 |
| 2011-05-11 08:01:00 | AAPL | Stock | 12.4589 | 12.4596 | 12.4586 | 12.4596 | 63000.0 |
| 2011-05-11 08:02:00 | AAPL | Stock | 12.4589 | 12.4621 | 12.4589 | 12.4596 | 14000.0 |
| 2011-05-11 08:04:00 | AAPL | Stock | 12.455 | 12.455 | 12.4536 | 12.4536 | 18676.0 |
| 2011-05-11 08:05:00 | AAPL | Stock | 12.4546 | 12.4546 | 12.4546 | 12.4546 | 8176.0 |
| 2011-05-11 08:06:00 | AAPL | Stock | 12.45 | 12.4504 | 12.45 | 12.4504 | 14000.0 |
| 2011-05-11 08:07:00 | AAPL | Stock | 12.45 | 12.4536 | 12.4468 | 12.4475 | 20720.0 |
| 2011-05-11 08:08:00 | AAPL | Stock | 12.4536 | 12.4536 | 12.4536 | 12.4536 | 8400.0 |
| 2011-05-11 08:09:00 | AAPL | Stock | 12.4571 | 12.4575 | 12.4571 | 12.4571 | 16800.0 |
| 2011-05-11 08:10:00 | AAPL | Stock | 12.4604 | 12.4604 | 12.4604 | 12.4604 | 14000.0 |
| 2011-05-11 08:14:00 | AAPL | Stock | 12.4554 | 12.4554 | 12.4514 | 12.4514 | 42812.0 |
| 2011-05-11 08:15:00 | AAPL | Stock | 12.4464 | 12.4468 | 12.4446 | 12.4446 | 80500.0 |
| 2011-05-11 08:16:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4393 | 12.4393 | 16240.0 |
| 2011-05-11 08:18:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4375 | 12.4411 | 41720.0 |
| 2011-05-11 08:19:00 | AAPL | Stock | 12.4411 | 12.4411 | 12.4411 | 12.4411 | 5040.0 |
| 2011-05-11 08:20:00 | AAPL | Stock | 12.4429 | 12.4429 | 12.4414 | 12.4414 | 19600.0 |
| 2011-05-11 08:23:00 | AAPL | Stock | 12.4414 | 12.4414 | 12.4357 | 12.4357 | 40600.0 |
| 2011-05-11 08:24:00 | AAPL | Stock | 12.4321 | 12.4321 | 12.4314 | 12.4314 | 5600.0 |
> showing 50 of 1,012,281 rows — these rows as CSV