PREVIEW / stock_5min / 2007-08-14
file: by_date/stock_5min/2007/2007-08-14.parquet size: 4.2 MB rows: 302,598 symbols: 3,124
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-08-14 09:30:00 | AAPL | Stock | 4.5818 | 4.5821 | 4.5536 | 4.5554 | 22412516.0 |
| 2007-08-14 09:35:00 | AAPL | Stock | 4.555 | 4.5643 | 4.5446 | 4.5564 | 13834632.0 |
| 2007-08-14 09:40:00 | AAPL | Stock | 4.5571 | 4.5704 | 4.5521 | 4.5568 | 13038956.0 |
| 2007-08-14 09:45:00 | AAPL | Stock | 4.5569 | 4.5607 | 4.5304 | 4.5399 | 18982656.0 |
| 2007-08-14 09:50:00 | AAPL | Stock | 4.5404 | 4.5521 | 4.5268 | 4.5396 | 10409672.0 |
| 2007-08-14 09:55:00 | AAPL | Stock | 4.5393 | 4.5536 | 4.5318 | 4.5354 | 8169308.0 |
| 2007-08-14 10:00:00 | AAPL | Stock | 4.5357 | 4.54 | 4.5289 | 4.5321 | 7963732.0 |
| 2007-08-14 10:05:00 | AAPL | Stock | 4.5321 | 4.5368 | 4.5121 | 4.5243 | 17831772.0 |
| 2007-08-14 10:10:00 | AAPL | Stock | 4.5246 | 4.5268 | 4.5061 | 4.5071 | 8928388.0 |
| 2007-08-14 10:15:00 | AAPL | Stock | 4.5071 | 4.52 | 4.5054 | 4.5169 | 10101644.0 |
| 2007-08-14 10:20:00 | AAPL | Stock | 4.5164 | 4.5196 | 4.4946 | 4.4982 | 11271820.0 |
| 2007-08-14 10:25:00 | AAPL | Stock | 4.4982 | 4.4986 | 4.4718 | 4.4811 | 15993600.0 |
| 2007-08-14 10:30:00 | AAPL | Stock | 4.4807 | 4.4986 | 4.4807 | 4.4893 | 10208156.0 |
| 2007-08-14 10:35:00 | AAPL | Stock | 4.4911 | 4.4996 | 4.4886 | 4.4964 | 8241044.0 |
| 2007-08-14 10:40:00 | AAPL | Stock | 4.4957 | 4.4975 | 4.4768 | 4.4768 | 8244516.0 |
| 2007-08-14 10:45:00 | AAPL | Stock | 4.4779 | 4.4839 | 4.4768 | 4.4775 | 6369412.0 |
| 2007-08-14 10:50:00 | AAPL | Stock | 4.4779 | 4.4811 | 4.4639 | 4.4675 | 14605780.0 |
| 2007-08-14 10:55:00 | AAPL | Stock | 4.4679 | 4.4796 | 4.4604 | 4.4732 | 12767636.0 |
| 2007-08-14 11:00:00 | AAPL | Stock | 4.4732 | 4.4743 | 4.4507 | 4.4636 | 13030164.0 |
| 2007-08-14 11:05:00 | AAPL | Stock | 4.4636 | 4.4743 | 4.4454 | 4.4568 | 12636344.0 |
| 2007-08-14 11:10:00 | AAPL | Stock | 4.4571 | 4.4746 | 4.4561 | 4.4704 | 11329360.0 |
| 2007-08-14 11:15:00 | AAPL | Stock | 4.4704 | 4.4864 | 4.4704 | 4.4854 | 11465468.0 |
| 2007-08-14 11:20:00 | AAPL | Stock | 4.4856 | 4.4918 | 4.4786 | 4.4829 | 8134140.0 |
| 2007-08-14 11:25:00 | AAPL | Stock | 4.4829 | 4.4836 | 4.4654 | 4.4825 | 7749504.0 |
| 2007-08-14 11:30:00 | AAPL | Stock | 4.4825 | 4.5 | 4.4775 | 4.4954 | 9025772.0 |
| 2007-08-14 11:35:00 | AAPL | Stock | 4.4954 | 4.5054 | 4.4804 | 4.4886 | 12104708.0 |
| 2007-08-14 11:40:00 | AAPL | Stock | 4.4896 | 4.4964 | 4.4804 | 4.4893 | 5548060.0 |
| 2007-08-14 11:45:00 | AAPL | Stock | 4.4904 | 4.5029 | 4.4868 | 4.495 | 4908792.0 |
| 2007-08-14 11:50:00 | AAPL | Stock | 4.495 | 4.51 | 4.495 | 4.5096 | 7360892.0 |
| 2007-08-14 11:55:00 | AAPL | Stock | 4.5093 | 4.5264 | 4.5042 | 4.5196 | 11968992.0 |
| 2007-08-14 12:00:00 | AAPL | Stock | 4.5196 | 4.52 | 4.4989 | 4.5007 | 8983436.0 |
| 2007-08-14 12:05:00 | AAPL | Stock | 4.5007 | 4.5125 | 4.5004 | 4.5046 | 6973484.0 |
| 2007-08-14 12:10:00 | AAPL | Stock | 4.5046 | 4.5046 | 4.4964 | 4.4982 | 4267284.0 |
| 2007-08-14 12:15:00 | AAPL | Stock | 4.4986 | 4.5168 | 4.4982 | 4.5146 | 5628392.0 |
| 2007-08-14 12:20:00 | AAPL | Stock | 4.5136 | 4.5161 | 4.5064 | 4.5068 | 4199132.0 |
| 2007-08-14 12:25:00 | AAPL | Stock | 4.5064 | 4.5075 | 4.4864 | 4.4929 | 7780388.0 |
| 2007-08-14 12:30:00 | AAPL | Stock | 4.4929 | 4.4979 | 4.4879 | 4.4882 | 3964688.0 |
| 2007-08-14 12:35:00 | AAPL | Stock | 4.4882 | 4.5 | 4.4864 | 4.4954 | 4348484.0 |
| 2007-08-14 12:40:00 | AAPL | Stock | 4.4954 | 4.5 | 4.4832 | 4.4954 | 4765572.0 |
| 2007-08-14 12:45:00 | AAPL | Stock | 4.495 | 4.5079 | 4.4929 | 4.4939 | 4160688.0 |
| 2007-08-14 12:50:00 | AAPL | Stock | 4.4943 | 4.5018 | 4.4943 | 4.5018 | 2545984.0 |
| 2007-08-14 12:55:00 | AAPL | Stock | 4.5021 | 4.5125 | 4.4957 | 4.505 | 3286556.0 |
| 2007-08-14 13:00:00 | AAPL | Stock | 4.505 | 4.5086 | 4.4943 | 4.4982 | 3784368.0 |
| 2007-08-14 13:05:00 | AAPL | Stock | 4.4982 | 4.5046 | 4.4979 | 4.4986 | 2023364.0 |
| 2007-08-14 13:10:00 | AAPL | Stock | 4.4989 | 4.5025 | 4.4914 | 4.4968 | 2315628.0 |
| 2007-08-14 13:15:00 | AAPL | Stock | 4.4968 | 4.4993 | 4.4839 | 4.4975 | 5361020.0 |
| 2007-08-14 13:20:00 | AAPL | Stock | 4.4986 | 4.4986 | 4.4893 | 4.4933 | 2313276.0 |
| 2007-08-14 13:25:00 | AAPL | Stock | 4.4929 | 4.4964 | 4.4825 | 4.4857 | 5124168.0 |
| 2007-08-14 13:30:00 | AAPL | Stock | 4.4857 | 4.5025 | 4.4821 | 4.4946 | 4527292.0 |
| 2007-08-14 13:35:00 | AAPL | Stock | 4.4946 | 4.5107 | 4.4946 | 4.5025 | 5256300.0 |
> showing 50 of 302,598 rows — these rows as CSV