PREVIEW / stock_5min / 2011-12-30
file: by_date/stock_5min/2011/2011-12-30.parquet size: 4.7 MB rows: 320,675 symbols: 3,599
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:35:00 | AAPL | Stock | 14.4457 | 14.4457 | 14.4457 | 14.4457 | 16800.0 |
| 2011-12-30 05:40: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:40:00 | AAPL | Stock | 14.4554 | 14.4554 | 14.4554 | 14.4554 | 3500.0 |
| 2011-12-30 06:45:00 | AAPL | Stock | 14.4571 | 14.4571 | 14.4571 | 14.4571 | 11200.0 |
| 2011-12-30 07:00:00 | AAPL | Stock | 14.4718 | 14.4743 | 14.4718 | 14.4743 | 12600.0 |
| 2011-12-30 07:05:00 | AAPL | Stock | 14.4761 | 14.4839 | 14.4714 | 14.4714 | 51800.0 |
| 2011-12-30 07:15:00 | AAPL | Stock | 14.4746 | 14.4746 | 14.4746 | 14.4746 | 5600.0 |
| 2011-12-30 07:20: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 | 8400.0 |
| 2011-12-30 07:30:00 | AAPL | Stock | 14.4664 | 14.4664 | 14.4643 | 14.4643 | 8400.0 |
| 2011-12-30 07:35:00 | AAPL | Stock | 14.4646 | 14.4646 | 14.4604 | 14.4604 | 16800.0 |
| 2011-12-30 07:45:00 | AAPL | Stock | 14.4629 | 14.4629 | 14.4629 | 14.4629 | 5600.0 |
| 2011-12-30 07:50:00 | AAPL | Stock | 14.4643 | 14.4643 | 14.4643 | 14.4643 | 3640.0 |
| 2011-12-30 07:55:00 | AAPL | Stock | 14.4643 | 14.4754 | 14.4643 | 14.4714 | 33740.0 |
| 2011-12-30 08:05:00 | AAPL | Stock | 14.4714 | 14.4714 | 14.4643 | 14.4711 | 83580.0 |
| 2011-12-30 08:15:00 | AAPL | Stock | 14.4607 | 14.4607 | 14.46 | 14.46 | 14000.0 |
| 2011-12-30 08:20:00 | AAPL | Stock | 14.46 | 14.46 | 14.46 | 14.46 | 2800.0 |
| 2011-12-30 08:25:00 | AAPL | Stock | 14.455 | 14.455 | 14.45 | 14.45 | 40880.0 |
| 2011-12-30 08:30:00 | AAPL | Stock | 14.45 | 14.4607 | 14.4471 | 14.4607 | 14000.0 |
| 2011-12-30 08:35:00 | AAPL | Stock | 14.4596 | 14.4604 | 14.45 | 14.4571 | 45304.0 |
| 2011-12-30 08:40:00 | AAPL | Stock | 14.455 | 14.455 | 14.4529 | 14.4532 | 14000.0 |
| 2011-12-30 08:45:00 | AAPL | Stock | 14.4536 | 14.4536 | 14.4429 | 14.4429 | 171248.0 |
| 2011-12-30 08:50:00 | AAPL | Stock | 14.4325 | 14.4357 | 14.4286 | 14.4357 | 38444.0 |
| 2011-12-30 08:55:00 | AAPL | Stock | 14.4382 | 14.4382 | 14.4332 | 14.4357 | 19880.0 |
| 2011-12-30 09:00:00 | AAPL | Stock | 14.4389 | 14.4404 | 14.4386 | 14.4404 | 67984.0 |
| 2011-12-30 09:05:00 | AAPL | Stock | 14.4361 | 14.4379 | 14.4357 | 14.4357 | 22960.0 |
| 2011-12-30 09:10:00 | AAPL | Stock | 14.4386 | 14.4504 | 14.4386 | 14.4464 | 43792.0 |
| 2011-12-30 09:15:00 | AAPL | Stock | 14.4446 | 14.4464 | 14.4436 | 14.4464 | 35588.0 |
| 2011-12-30 09:20:00 | AAPL | Stock | 14.45 | 14.45 | 14.4496 | 14.4496 | 11200.0 |
| 2011-12-30 09:25:00 | AAPL | Stock | 14.4464 | 14.4464 | 14.3925 | 14.4204 | 936460.0 |
| 2011-12-30 09:30:00 | AAPL | Stock | 14.4189 | 14.4779 | 14.4104 | 14.4663 | 9711128.0 |
| 2011-12-30 09:35:00 | AAPL | Stock | 14.4679 | 14.4721 | 14.4518 | 14.4693 | 4059748.0 |
| 2011-12-30 09:40:00 | AAPL | Stock | 14.4693 | 14.4804 | 14.4607 | 14.4646 | 2892316.0 |
| 2011-12-30 09:45:00 | AAPL | Stock | 14.4643 | 14.4786 | 14.4625 | 14.4657 | 2198840.0 |
| 2011-12-30 09:50:00 | AAPL | Stock | 14.4666 | 14.4707 | 14.4618 | 14.4639 | 3789632.0 |
| 2011-12-30 09:55:00 | AAPL | Stock | 14.4643 | 14.4775 | 14.4625 | 14.4772 | 2346512.0 |
| 2011-12-30 10:00:00 | AAPL | Stock | 14.4775 | 14.5079 | 14.4753 | 14.5057 | 5869472.0 |
| 2011-12-30 10:05:00 | AAPL | Stock | 14.5057 | 14.51 | 14.4936 | 14.5006 | 4024048.0 |
| 2011-12-30 10:10:00 | AAPL | Stock | 14.5003 | 14.5005 | 14.4807 | 14.49 | 2906960.0 |
| 2011-12-30 10:15:00 | AAPL | Stock | 14.49 | 14.4939 | 14.4739 | 14.4818 | 3097724.0 |
| 2011-12-30 10:20:00 | AAPL | Stock | 14.4836 | 14.4886 | 14.4782 | 14.4857 | 1432172.0 |
| 2011-12-30 10:25:00 | AAPL | Stock | 14.4864 | 14.49 | 14.4804 | 14.4825 | 1313004.0 |
| 2011-12-30 10:30:00 | AAPL | Stock | 14.4825 | 14.4875 | 14.4811 | 14.4861 | 1041656.0 |
| 2011-12-30 10:35:00 | AAPL | Stock | 14.4857 | 14.4904 | 14.4814 | 14.4861 | 1510964.0 |
| 2011-12-30 10:40:00 | AAPL | Stock | 14.4852 | 14.4857 | 14.4686 | 14.4739 | 2880640.0 |
| 2011-12-30 10:45:00 | AAPL | Stock | 14.4739 | 14.481 | 14.4696 | 14.48 | 1309896.0 |
| 2011-12-30 10:50:00 | AAPL | Stock | 14.4807 | 14.4854 | 14.4779 | 14.4839 | 1640996.0 |
| 2011-12-30 10:55:00 | AAPL | Stock | 14.4839 | 14.485 | 14.4714 | 14.4732 | 1369844.0 |
| 2011-12-30 11:00:00 | AAPL | Stock | 14.4711 | 14.4781 | 14.4664 | 14.475 | 1697080.0 |
> showing 50 of 320,675 rows — these rows as CSV