PREVIEW / stock_5min / 2010-12-20
file: by_date/stock_5min/2010/2010-12-20.parquet size: 5.0 MB rows: 344,310 symbols: 3,556
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-20 04:05:00 | AAPL | Stock | 11.4686 | 11.4686 | 11.4686 | 11.4686 | 2800.0 |
| 2010-12-20 04:10:00 | AAPL | Stock | 11.4771 | 11.4771 | 11.4771 | 11.4771 | 2800.0 |
| 2010-12-20 04:30:00 | AAPL | Stock | 11.47 | 11.5 | 11.47 | 11.4961 | 14000.0 |
| 2010-12-20 04:35:00 | AAPL | Stock | 11.4879 | 11.4879 | 11.4857 | 11.4857 | 5600.0 |
| 2010-12-20 04:55:00 | AAPL | Stock | 11.4643 | 11.4643 | 11.4643 | 11.4643 | 2800.0 |
| 2010-12-20 06:25:00 | AAPL | Stock | 11.4746 | 11.475 | 11.4746 | 11.475 | 16800.0 |
| 2010-12-20 06:30:00 | AAPL | Stock | 11.475 | 11.475 | 11.4729 | 11.4729 | 8400.0 |
| 2010-12-20 06:45:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 06:50:00 | AAPL | Stock | 11.475 | 11.475 | 11.475 | 11.475 | 2800.0 |
| 2010-12-20 06:55:00 | AAPL | Stock | 11.475 | 11.475 | 11.4654 | 11.4654 | 5600.0 |
| 2010-12-20 07:00:00 | AAPL | Stock | 11.4768 | 11.4829 | 11.4757 | 11.4821 | 33320.0 |
| 2010-12-20 07:05:00 | AAPL | Stock | 11.4714 | 11.4821 | 11.4714 | 11.4821 | 9800.0 |
| 2010-12-20 07:10:00 | AAPL | Stock | 11.4818 | 11.4818 | 11.4732 | 11.4732 | 14000.0 |
| 2010-12-20 07:15:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4714 | 11.4714 | 5600.0 |
| 2010-12-20 07:20:00 | AAPL | Stock | 11.4757 | 11.4857 | 11.4657 | 11.4829 | 126560.0 |
| 2010-12-20 07:25:00 | AAPL | Stock | 11.4904 | 11.4904 | 11.4904 | 11.4904 | 2800.0 |
| 2010-12-20 07:35:00 | AAPL | Stock | 11.4861 | 11.4886 | 11.4861 | 11.4886 | 30800.0 |
| 2010-12-20 07:40:00 | AAPL | Stock | 11.4825 | 11.4829 | 11.4825 | 11.4825 | 14000.0 |
| 2010-12-20 07:45:00 | AAPL | Stock | 11.4825 | 11.4825 | 11.4825 | 11.4825 | 5600.0 |
| 2010-12-20 07:50:00 | AAPL | Stock | 11.4821 | 11.4821 | 11.4821 | 11.4821 | 5600.0 |
| 2010-12-20 07:55:00 | AAPL | Stock | 11.475 | 11.4821 | 11.475 | 11.4757 | 15400.0 |
| 2010-12-20 08:00:00 | AAPL | Stock | 11.4786 | 11.4821 | 11.4729 | 11.4793 | 154140.0 |
| 2010-12-20 08:05:00 | AAPL | Stock | 11.48 | 11.4857 | 11.4796 | 11.4804 | 268604.0 |
| 2010-12-20 08:10:00 | AAPL | Stock | 11.4804 | 11.4821 | 11.4768 | 11.4804 | 135240.0 |
| 2010-12-20 08:15:00 | AAPL | Stock | 11.4804 | 11.4821 | 11.4771 | 11.4796 | 77840.0 |
| 2010-12-20 08:20:00 | AAPL | Stock | 11.48 | 11.4811 | 11.48 | 11.4811 | 25536.0 |
| 2010-12-20 08:25:00 | AAPL | Stock | 11.4804 | 11.4821 | 11.4786 | 11.4786 | 54180.0 |
| 2010-12-20 08:30:00 | AAPL | Stock | 11.4779 | 11.4786 | 11.4764 | 11.4775 | 49560.0 |
| 2010-12-20 08:35:00 | AAPL | Stock | 11.48 | 11.48 | 11.48 | 11.48 | 2800.0 |
| 2010-12-20 08:40:00 | AAPL | Stock | 11.4782 | 11.4782 | 11.4739 | 11.4743 | 174860.0 |
| 2010-12-20 08:45:00 | AAPL | Stock | 11.4725 | 11.475 | 11.4661 | 11.4718 | 219240.0 |
| 2010-12-20 08:50:00 | AAPL | Stock | 11.4718 | 11.4775 | 11.4714 | 11.4775 | 14000.0 |
| 2010-12-20 08:55:00 | AAPL | Stock | 11.4761 | 11.4761 | 11.4714 | 11.4714 | 84000.0 |
| 2010-12-20 09:00:00 | AAPL | Stock | 11.4714 | 11.4757 | 11.4682 | 11.4757 | 39200.0 |
| 2010-12-20 09:05:00 | AAPL | Stock | 11.4757 | 11.4782 | 11.4711 | 11.4775 | 33600.0 |
| 2010-12-20 09:10:00 | AAPL | Stock | 11.4782 | 11.4786 | 11.4711 | 11.4718 | 122808.0 |
| 2010-12-20 09:15:00 | AAPL | Stock | 11.4754 | 11.4775 | 11.475 | 11.475 | 60200.0 |
| 2010-12-20 09:20:00 | AAPL | Stock | 11.4782 | 11.4786 | 11.4732 | 11.4739 | 46760.0 |
| 2010-12-20 09:25:00 | AAPL | Stock | 11.4739 | 11.4839 | 11.4714 | 11.4839 | 485352.0 |
| 2010-12-20 09:30:00 | AAPL | Stock | 11.4857 | 11.4857 | 11.4507 | 11.46 | 11443740.0 |
| 2010-12-20 09:35:00 | AAPL | Stock | 11.4604 | 11.4725 | 11.4504 | 11.4525 | 7490980.0 |
| 2010-12-20 09:40:00 | AAPL | Stock | 11.4525 | 11.4571 | 11.4357 | 11.4454 | 7827316.0 |
| 2010-12-20 09:45:00 | AAPL | Stock | 11.4443 | 11.4493 | 11.4329 | 11.4471 | 4709992.0 |
| 2010-12-20 09:50:00 | AAPL | Stock | 11.4486 | 11.4518 | 11.4382 | 11.4436 | 5347020.0 |
| 2010-12-20 09:55:00 | AAPL | Stock | 11.445 | 11.4504 | 11.4411 | 11.4475 | 5297488.0 |
| 2010-12-20 10:00:00 | AAPL | Stock | 11.4475 | 11.4479 | 11.4243 | 11.4254 | 9621612.0 |
| 2010-12-20 10:05:00 | AAPL | Stock | 11.4275 | 11.4275 | 11.4118 | 11.4182 | 6381788.0 |
| 2010-12-20 10:10:00 | AAPL | Stock | 11.4186 | 11.4214 | 11.3964 | 11.4118 | 8417024.0 |
| 2010-12-20 10:15:00 | AAPL | Stock | 11.4089 | 11.4121 | 11.3696 | 11.3811 | 10905440.0 |
| 2010-12-20 10:20:00 | AAPL | Stock | 11.3807 | 11.39 | 11.3714 | 11.3743 | 6879880.0 |
> showing 50 of 344,310 rows — these rows as CSV