PREVIEW / stock_5min / 2005-04-05
file: by_date/stock_5min/2005/2005-04-05.parquet size: 2.6 MB rows: 194,319 symbols: 1,954
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-05 08:00:00 | AAPL | Stock | 1.4661 | 1.4821 | 1.4661 | 1.4786 | 261968.0 |
| 2005-04-05 08:05:00 | AAPL | Stock | 1.4764 | 1.4796 | 1.4764 | 1.4796 | 111160.0 |
| 2005-04-05 08:10:00 | AAPL | Stock | 1.4786 | 1.4814 | 1.4786 | 1.4804 | 153020.0 |
| 2005-04-05 08:15:00 | AAPL | Stock | 1.4786 | 1.4789 | 1.4786 | 1.4789 | 70000.0 |
| 2005-04-05 08:20:00 | AAPL | Stock | 1.4771 | 1.4771 | 1.4714 | 1.4771 | 174300.0 |
| 2005-04-05 08:25:00 | AAPL | Stock | 1.4771 | 1.4771 | 1.4768 | 1.4768 | 30800.0 |
| 2005-04-05 08:30:00 | AAPL | Stock | 1.4757 | 1.4782 | 1.4757 | 1.4782 | 56000.0 |
| 2005-04-05 08:35:00 | AAPL | Stock | 1.4725 | 1.4768 | 1.4714 | 1.4764 | 39200.0 |
| 2005-04-05 08:40:00 | AAPL | Stock | 1.4768 | 1.4779 | 1.4768 | 1.4779 | 36596.0 |
| 2005-04-05 08:45:00 | AAPL | Stock | 1.4779 | 1.4786 | 1.4775 | 1.4779 | 50400.0 |
| 2005-04-05 08:55:00 | AAPL | Stock | 1.4768 | 1.4768 | 1.4732 | 1.4732 | 79520.0 |
| 2005-04-05 09:00:00 | AAPL | Stock | 1.4736 | 1.4736 | 1.4725 | 1.4729 | 117600.0 |
| 2005-04-05 09:05:00 | AAPL | Stock | 1.4729 | 1.4729 | 1.4718 | 1.4725 | 42000.0 |
| 2005-04-05 09:10:00 | AAPL | Stock | 1.4729 | 1.475 | 1.4729 | 1.4732 | 95200.0 |
| 2005-04-05 09:15:00 | AAPL | Stock | 1.4746 | 1.4746 | 1.4729 | 1.4739 | 232400.0 |
| 2005-04-05 09:20:00 | AAPL | Stock | 1.4739 | 1.4757 | 1.4739 | 1.4757 | 148400.0 |
| 2005-04-05 09:25:00 | AAPL | Stock | 1.4732 | 1.4754 | 1.4689 | 1.4711 | 2340352.0 |
| 2005-04-05 09:30:00 | AAPL | Stock | 1.4721 | 1.4768 | 1.4675 | 1.4768 | 23448880.0 |
| 2005-04-05 09:35:00 | AAPL | Stock | 1.4768 | 1.4857 | 1.4761 | 1.4857 | 20666128.0 |
| 2005-04-05 09:40:00 | AAPL | Stock | 1.4857 | 1.4886 | 1.4829 | 1.4882 | 15250452.0 |
| 2005-04-05 09:45:00 | AAPL | Stock | 1.4882 | 1.4914 | 1.4839 | 1.4914 | 12818680.0 |
| 2005-04-05 09:50:00 | AAPL | Stock | 1.4914 | 1.5004 | 1.4914 | 1.4996 | 19206516.0 |
| 2005-04-05 09:55:00 | AAPL | Stock | 1.4996 | 1.5079 | 1.4979 | 1.5054 | 19785556.0 |
| 2005-04-05 10:00:00 | AAPL | Stock | 1.505 | 1.5054 | 1.4996 | 1.5004 | 15215536.0 |
| 2005-04-05 10:05:00 | AAPL | Stock | 1.5 | 1.5004 | 1.495 | 1.4971 | 14890596.0 |
| 2005-04-05 10:10:00 | AAPL | Stock | 1.4972 | 1.4975 | 1.4936 | 1.4954 | 8292928.0 |
| 2005-04-05 10:15:00 | AAPL | Stock | 1.4946 | 1.4968 | 1.4929 | 1.4943 | 11075876.0 |
| 2005-04-05 10:20:00 | AAPL | Stock | 1.4943 | 1.4993 | 1.4936 | 1.497 | 8243480.0 |
| 2005-04-05 10:25:00 | AAPL | Stock | 1.4971 | 1.4989 | 1.4946 | 1.4964 | 9654036.0 |
| 2005-04-05 10:30:00 | AAPL | Stock | 1.4961 | 1.5036 | 1.4961 | 1.5032 | 10854004.0 |
| 2005-04-05 10:35:00 | AAPL | Stock | 1.5032 | 1.5036 | 1.4996 | 1.5011 | 5921860.0 |
| 2005-04-05 10:40:00 | AAPL | Stock | 1.5011 | 1.5029 | 1.5 | 1.5 | 3586800.0 |
| 2005-04-05 10:45:00 | AAPL | Stock | 1.4993 | 1.5 | 1.495 | 1.4989 | 7647444.0 |
| 2005-04-05 10:50:00 | AAPL | Stock | 1.4989 | 1.5004 | 1.4968 | 1.4975 | 6860140.0 |
| 2005-04-05 10:55:00 | AAPL | Stock | 1.4975 | 1.505 | 1.4975 | 1.5043 | 10772048.0 |
| 2005-04-05 11:00:00 | AAPL | Stock | 1.5046 | 1.505 | 1.4954 | 1.4989 | 12225052.0 |
| 2005-04-05 11:05:00 | AAPL | Stock | 1.4993 | 1.5 | 1.4964 | 1.4986 | 5278532.0 |
| 2005-04-05 11:10:00 | AAPL | Stock | 1.4982 | 1.5 | 1.4961 | 1.4971 | 5094852.0 |
| 2005-04-05 11:15:00 | AAPL | Stock | 1.4971 | 1.4986 | 1.4954 | 1.4954 | 3026716.0 |
| 2005-04-05 11:20:00 | AAPL | Stock | 1.4954 | 1.4971 | 1.4936 | 1.4965 | 7202496.0 |
| 2005-04-05 11:25:00 | AAPL | Stock | 1.4968 | 1.4979 | 1.495 | 1.4967 | 5231212.0 |
| 2005-04-05 11:30:00 | AAPL | Stock | 1.4967 | 1.5 | 1.4954 | 1.4996 | 4156180.0 |
| 2005-04-05 11:35:00 | AAPL | Stock | 1.5 | 1.5071 | 1.4996 | 1.505 | 12719784.0 |
| 2005-04-05 11:40:00 | AAPL | Stock | 1.505 | 1.5086 | 1.5039 | 1.5064 | 10968496.0 |
| 2005-04-05 11:45:00 | AAPL | Stock | 1.5068 | 1.5068 | 1.5025 | 1.5039 | 3915576.0 |
| 2005-04-05 11:50:00 | AAPL | Stock | 1.5039 | 1.5046 | 1.5029 | 1.5039 | 4293604.0 |
| 2005-04-05 11:55:00 | AAPL | Stock | 1.5043 | 1.5046 | 1.5 | 1.5014 | 4986128.0 |
| 2005-04-05 12:00:00 | AAPL | Stock | 1.5018 | 1.5029 | 1.5004 | 1.5025 | 3096912.0 |
| 2005-04-05 12:05:00 | AAPL | Stock | 1.5021 | 1.5061 | 1.5018 | 1.5025 | 4677232.0 |
| 2005-04-05 12:10:00 | AAPL | Stock | 1.5025 | 1.5036 | 1.5004 | 1.5025 | 4435816.0 |
> showing 50 of 194,319 rows — these rows as CSV