PREVIEW / stock_5min / 2007-10-01
file: by_date/stock_5min/2007/2007-10-01.parquet size: 4.3 MB rows: 315,374 symbols: 3,135
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-10-01 07:10:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4536 | 5.4536 | 84000.0 |
| 2007-10-01 07:50:00 | AAPL | Stock | 5.4768 | 5.4768 | 5.4768 | 5.4768 | 28000.0 |
| 2007-10-01 07:55:00 | AAPL | Stock | 5.4664 | 5.475 | 5.4664 | 5.475 | 94640.0 |
| 2007-10-01 08:00:00 | AAPL | Stock | 5.4668 | 5.475 | 5.4668 | 5.4714 | 220360.0 |
| 2007-10-01 08:05:00 | AAPL | Stock | 5.4743 | 5.4825 | 5.4743 | 5.4821 | 212604.0 |
| 2007-10-01 08:10:00 | AAPL | Stock | 5.4825 | 5.4829 | 5.4786 | 5.4807 | 290332.0 |
| 2007-10-01 08:15:00 | AAPL | Stock | 5.4786 | 5.4989 | 5.4754 | 5.4754 | 234976.0 |
| 2007-10-01 08:20:00 | AAPL | Stock | 5.4764 | 5.5136 | 5.4761 | 5.5136 | 540820.0 |
| 2007-10-01 08:25:00 | AAPL | Stock | 5.5136 | 5.5143 | 5.5025 | 5.5107 | 677040.0 |
| 2007-10-01 08:30:00 | AAPL | Stock | 5.51 | 5.5179 | 5.51 | 5.5179 | 960848.0 |
| 2007-10-01 08:35:00 | AAPL | Stock | 5.5179 | 5.5254 | 5.4836 | 5.5214 | 783384.0 |
| 2007-10-01 08:40:00 | AAPL | Stock | 5.5214 | 5.5214 | 5.5121 | 5.5121 | 277200.0 |
| 2007-10-01 08:45:00 | AAPL | Stock | 5.5111 | 5.5121 | 5.5054 | 5.5054 | 222656.0 |
| 2007-10-01 08:50:00 | AAPL | Stock | 5.5039 | 5.5139 | 5.5007 | 5.5011 | 233856.0 |
| 2007-10-01 08:55:00 | AAPL | Stock | 5.5032 | 5.5046 | 5.5004 | 5.5029 | 413112.0 |
| 2007-10-01 09:00:00 | AAPL | Stock | 5.5043 | 5.5075 | 5.5036 | 5.5064 | 179200.0 |
| 2007-10-01 09:05:00 | AAPL | Stock | 5.5039 | 5.5039 | 5.5036 | 5.5036 | 64120.0 |
| 2007-10-01 09:10:00 | AAPL | Stock | 5.5021 | 5.5071 | 5.5 | 5.5018 | 244244.0 |
| 2007-10-01 09:15:00 | AAPL | Stock | 5.5032 | 5.5036 | 5.5018 | 5.5021 | 44800.0 |
| 2007-10-01 09:20:00 | AAPL | Stock | 5.5021 | 5.5036 | 5.5011 | 5.5011 | 94640.0 |
| 2007-10-01 09:25:00 | AAPL | Stock | 5.5011 | 5.5268 | 5.4982 | 5.5214 | 2069788.0 |
| 2007-10-01 09:30:00 | AAPL | Stock | 5.5214 | 5.5311 | 5.4989 | 5.4989 | 27424236.0 |
| 2007-10-01 09:35:00 | AAPL | Stock | 5.4989 | 5.5036 | 5.4861 | 5.4975 | 13851320.0 |
| 2007-10-01 09:40:00 | AAPL | Stock | 5.4975 | 5.5118 | 5.4889 | 5.5086 | 12523896.0 |
| 2007-10-01 09:45:00 | AAPL | Stock | 5.5089 | 5.5179 | 5.4875 | 5.4907 | 15197476.0 |
| 2007-10-01 09:50:00 | AAPL | Stock | 5.4904 | 5.4982 | 5.4879 | 5.4964 | 10072608.0 |
| 2007-10-01 09:55:00 | AAPL | Stock | 5.4964 | 5.4968 | 5.4821 | 5.4889 | 13292860.0 |
| 2007-10-01 10:00:00 | AAPL | Stock | 5.4886 | 5.5036 | 5.4743 | 5.4771 | 18672388.0 |
| 2007-10-01 10:05:00 | AAPL | Stock | 5.4775 | 5.4921 | 5.475 | 5.4818 | 15040228.0 |
| 2007-10-01 10:10:00 | AAPL | Stock | 5.4818 | 5.4825 | 5.4671 | 5.4693 | 15047200.0 |
| 2007-10-01 10:15:00 | AAPL | Stock | 5.4693 | 5.4786 | 5.4618 | 5.4702 | 14154672.0 |
| 2007-10-01 10:20:00 | AAPL | Stock | 5.4704 | 5.4796 | 5.4679 | 5.4759 | 6971412.0 |
| 2007-10-01 10:25:00 | AAPL | Stock | 5.4757 | 5.4843 | 5.47 | 5.4761 | 12427072.0 |
| 2007-10-01 10:30:00 | AAPL | Stock | 5.475 | 5.4907 | 5.4743 | 5.4882 | 7759752.0 |
| 2007-10-01 10:35:00 | AAPL | Stock | 5.4882 | 5.4961 | 5.4882 | 5.4921 | 7918288.0 |
| 2007-10-01 10:40:00 | AAPL | Stock | 5.4918 | 5.5036 | 5.4893 | 5.4983 | 9661400.0 |
| 2007-10-01 10:45:00 | AAPL | Stock | 5.4986 | 5.4993 | 5.4893 | 5.4893 | 7962472.0 |
| 2007-10-01 10:50:00 | AAPL | Stock | 5.4893 | 5.4954 | 5.4871 | 5.4893 | 5988808.0 |
| 2007-10-01 10:55:00 | AAPL | Stock | 5.49 | 5.4943 | 5.4864 | 5.4929 | 4609052.0 |
| 2007-10-01 11:00:00 | AAPL | Stock | 5.4929 | 5.4964 | 5.4904 | 5.4914 | 4484564.0 |
| 2007-10-01 11:05:00 | AAPL | Stock | 5.4907 | 5.495 | 5.4868 | 5.4936 | 5515244.0 |
| 2007-10-01 11:10:00 | AAPL | Stock | 5.4929 | 5.5075 | 5.4925 | 5.5057 | 9016028.0 |
| 2007-10-01 11:15:00 | AAPL | Stock | 5.5064 | 5.5207 | 5.5021 | 5.5164 | 16577876.0 |
| 2007-10-01 11:20:00 | AAPL | Stock | 5.5171 | 5.5186 | 5.5086 | 5.5139 | 8549296.0 |
| 2007-10-01 11:25:00 | AAPL | Stock | 5.5139 | 5.5196 | 5.5089 | 5.5146 | 7922768.0 |
| 2007-10-01 11:30:00 | AAPL | Stock | 5.5146 | 5.5196 | 5.51 | 5.5196 | 11271792.0 |
| 2007-10-01 11:35:00 | AAPL | Stock | 5.5196 | 5.5239 | 5.5139 | 5.5171 | 11157972.0 |
| 2007-10-01 11:40:00 | AAPL | Stock | 5.5171 | 5.5243 | 5.5157 | 5.5189 | 7173516.0 |
| 2007-10-01 11:45:00 | AAPL | Stock | 5.5189 | 5.5493 | 5.5175 | 5.5464 | 32759440.0 |
| 2007-10-01 11:50:00 | AAPL | Stock | 5.5459 | 5.5625 | 5.5404 | 5.5607 | 25900280.0 |
> showing 50 of 315,374 rows — these rows as CSV