PREVIEW / stock_5min / 2007-09-27
file: by_date/stock_5min/2007/2007-09-27.parquet size: 4.1 MB rows: 299,471 symbols: 3,105
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 |
|---|---|---|---|---|---|---|---|
| 2007-09-27 05:00:00 | AAPL | Stock | 5.4561 | 5.4561 | 5.4561 | 5.4561 | 2800.0 |
| 2007-09-27 05:05:00 | AAPL | Stock | 5.4561 | 5.4561 | 5.4561 | 5.4561 | 11200.0 |
| 2007-09-27 06:25:00 | AAPL | Stock | 5.4725 | 5.4725 | 5.4725 | 5.4725 | 2800.0 |
| 2007-09-27 07:00:00 | AAPL | Stock | 5.4789 | 5.4789 | 5.4789 | 5.4789 | 2800.0 |
| 2007-09-27 07:05:00 | AAPL | Stock | 5.4789 | 5.4832 | 5.4675 | 5.4832 | 121716.0 |
| 2007-09-27 07:10:00 | AAPL | Stock | 5.4821 | 5.4821 | 5.4821 | 5.4821 | 5600.0 |
| 2007-09-27 07:20:00 | AAPL | Stock | 5.4804 | 5.4804 | 5.4804 | 5.4804 | 34720.0 |
| 2007-09-27 07:25:00 | AAPL | Stock | 5.4811 | 5.4814 | 5.4714 | 5.4714 | 33600.0 |
| 2007-09-27 07:50:00 | AAPL | Stock | 5.4721 | 5.4893 | 5.4721 | 5.4893 | 78400.0 |
| 2007-09-27 07:55:00 | AAPL | Stock | 5.4839 | 5.4889 | 5.4836 | 5.4889 | 32872.0 |
| 2007-09-27 08:00:00 | AAPL | Stock | 5.4868 | 5.4882 | 5.4746 | 5.4804 | 1243172.0 |
| 2007-09-27 08:05:00 | AAPL | Stock | 5.4804 | 5.485 | 5.4786 | 5.4786 | 428792.0 |
| 2007-09-27 08:10:00 | AAPL | Stock | 5.4786 | 5.4818 | 5.4754 | 5.4789 | 245280.0 |
| 2007-09-27 08:15:00 | AAPL | Stock | 5.4779 | 5.4779 | 5.4714 | 5.4714 | 547064.0 |
| 2007-09-27 08:20:00 | AAPL | Stock | 5.47 | 5.475 | 5.4696 | 5.4732 | 357840.0 |
| 2007-09-27 08:25:00 | AAPL | Stock | 5.4732 | 5.4821 | 5.4714 | 5.4786 | 414232.0 |
| 2007-09-27 08:30:00 | AAPL | Stock | 5.4807 | 5.4893 | 5.4789 | 5.4789 | 577052.0 |
| 2007-09-27 08:35:00 | AAPL | Stock | 5.4793 | 5.4821 | 5.4754 | 5.4768 | 128100.0 |
| 2007-09-27 08:40:00 | AAPL | Stock | 5.4782 | 5.4839 | 5.4782 | 5.4839 | 123396.0 |
| 2007-09-27 08:45:00 | AAPL | Stock | 5.4832 | 5.4946 | 5.4818 | 5.4921 | 761824.0 |
| 2007-09-27 08:50:00 | AAPL | Stock | 5.4911 | 5.4954 | 5.4857 | 5.4929 | 294728.0 |
| 2007-09-27 08:55:00 | AAPL | Stock | 5.4929 | 5.4946 | 5.4904 | 5.4946 | 316932.0 |
| 2007-09-27 09:00:00 | AAPL | Stock | 5.4936 | 5.4986 | 5.4918 | 5.4986 | 492772.0 |
| 2007-09-27 09:05:00 | AAPL | Stock | 5.4989 | 5.4993 | 5.4968 | 5.4979 | 404320.0 |
| 2007-09-27 09:10:00 | AAPL | Stock | 5.4982 | 5.4989 | 5.4954 | 5.4979 | 583912.0 |
| 2007-09-27 09:15:00 | AAPL | Stock | 5.4979 | 5.4989 | 5.4957 | 5.4979 | 1183588.0 |
| 2007-09-27 09:20:00 | AAPL | Stock | 5.4975 | 5.4975 | 5.4904 | 5.4911 | 169400.0 |
| 2007-09-27 09:25:00 | AAPL | Stock | 5.4893 | 5.4961 | 5.4868 | 5.4954 | 705796.0 |
| 2007-09-27 09:30:00 | AAPL | Stock | 5.4936 | 5.4982 | 5.4607 | 5.4633 | 24452736.0 |
| 2007-09-27 09:35:00 | AAPL | Stock | 5.4629 | 5.4764 | 5.4532 | 5.4621 | 19455408.0 |
| 2007-09-27 09:40:00 | AAPL | Stock | 5.4621 | 5.4643 | 5.44 | 5.4582 | 17079468.0 |
| 2007-09-27 09:45:00 | AAPL | Stock | 5.4571 | 5.4818 | 5.4536 | 5.4807 | 16372720.0 |
| 2007-09-27 09:50:00 | AAPL | Stock | 5.4811 | 5.4821 | 5.4625 | 5.48 | 15985032.0 |
| 2007-09-27 09:55:00 | AAPL | Stock | 5.48 | 5.4893 | 5.4614 | 5.4643 | 18458468.0 |
| 2007-09-27 10:00:00 | AAPL | Stock | 5.4639 | 5.475 | 5.4596 | 5.4625 | 14388248.0 |
| 2007-09-27 10:05:00 | AAPL | Stock | 5.4625 | 5.4661 | 5.4429 | 5.4614 | 16510508.0 |
| 2007-09-27 10:10:00 | AAPL | Stock | 5.4614 | 5.4782 | 5.4536 | 5.47 | 15023148.0 |
| 2007-09-27 10:15:00 | AAPL | Stock | 5.4707 | 5.4768 | 5.4643 | 5.4768 | 8670508.0 |
| 2007-09-27 10:20:00 | AAPL | Stock | 5.4768 | 5.4889 | 5.475 | 5.4804 | 10463040.0 |
| 2007-09-27 10:25:00 | AAPL | Stock | 5.4804 | 5.4871 | 5.4682 | 5.4682 | 8571304.0 |
| 2007-09-27 10:30:00 | AAPL | Stock | 5.4679 | 5.4761 | 5.4654 | 5.4746 | 7376488.0 |
| 2007-09-27 10:35:00 | AAPL | Stock | 5.4746 | 5.4868 | 5.4736 | 5.485 | 10753260.0 |
| 2007-09-27 10:40:00 | AAPL | Stock | 5.485 | 5.4907 | 5.4807 | 5.4893 | 10598616.0 |
| 2007-09-27 10:45:00 | AAPL | Stock | 5.4893 | 5.4946 | 5.4836 | 5.4914 | 10787980.0 |
| 2007-09-27 10:50:00 | AAPL | Stock | 5.4911 | 5.4939 | 5.4804 | 5.4864 | 7549948.0 |
| 2007-09-27 10:55:00 | AAPL | Stock | 5.4868 | 5.5171 | 5.4868 | 5.5114 | 28535024.0 |
| 2007-09-27 11:00:00 | AAPL | Stock | 5.5121 | 5.5146 | 5.5004 | 5.5004 | 12651436.0 |
| 2007-09-27 11:05:00 | AAPL | Stock | 5.5004 | 5.5125 | 5.5 | 5.5064 | 11188352.0 |
| 2007-09-27 11:10:00 | AAPL | Stock | 5.5064 | 5.5175 | 5.5061 | 5.5124 | 11084136.0 |
| 2007-09-27 11:15:00 | AAPL | Stock | 5.5121 | 5.5171 | 5.5043 | 5.5061 | 10355912.0 |
> showing 50 of 299,471 rows — these rows as CSV