PREVIEW / stock_5min / 2007-06-07
file: by_date/stock_5min/2007/2007-06-07.parquet size: 4.1 MB rows: 297,969 symbols: 3,019
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-06-07 09:30:00 | AAPL | Stock | 4.4639 | 4.4904 | 4.4157 | 4.4775 | 64721748.0 |
| 2007-06-07 09:35:00 | AAPL | Stock | 4.4775 | 4.5 | 4.4643 | 4.5 | 48634012.0 |
| 2007-06-07 09:40:00 | AAPL | Stock | 4.4993 | 4.5129 | 4.4914 | 4.5104 | 45759560.0 |
| 2007-06-07 09:45:00 | AAPL | Stock | 4.5104 | 4.5336 | 4.4643 | 4.5325 | 48847988.0 |
| 2007-06-07 09:50:00 | AAPL | Stock | 4.5318 | 4.5411 | 4.5154 | 4.5239 | 48242376.0 |
| 2007-06-07 09:55:00 | AAPL | Stock | 4.5239 | 4.5339 | 4.5232 | 4.5339 | 26379388.0 |
| 2007-06-07 10:00:00 | AAPL | Stock | 4.5339 | 4.5571 | 4.5293 | 4.5514 | 50362732.0 |
| 2007-06-07 10:05:00 | AAPL | Stock | 4.5511 | 4.5575 | 4.5257 | 4.5307 | 45145576.0 |
| 2007-06-07 10:10:00 | AAPL | Stock | 4.5314 | 4.5393 | 4.5257 | 4.5386 | 26906040.0 |
| 2007-06-07 10:15:00 | AAPL | Stock | 4.5386 | 4.5446 | 4.5232 | 4.5268 | 25307604.0 |
| 2007-06-07 10:20:00 | AAPL | Stock | 4.5264 | 4.5314 | 4.5204 | 4.5279 | 24029432.0 |
| 2007-06-07 10:25:00 | AAPL | Stock | 4.5275 | 4.5346 | 4.5232 | 4.5275 | 16662548.0 |
| 2007-06-07 10:30:00 | AAPL | Stock | 4.5271 | 4.5382 | 4.5271 | 4.5307 | 18764508.0 |
| 2007-06-07 10:35:00 | AAPL | Stock | 4.5307 | 4.5307 | 4.515 | 4.5207 | 24339308.0 |
| 2007-06-07 10:40:00 | AAPL | Stock | 4.5207 | 4.5346 | 4.5186 | 4.53 | 18041100.0 |
| 2007-06-07 10:45:00 | AAPL | Stock | 4.5296 | 4.5443 | 4.5282 | 4.5411 | 24128020.0 |
| 2007-06-07 10:50:00 | AAPL | Stock | 4.5414 | 4.5493 | 4.5339 | 4.5454 | 25819752.0 |
| 2007-06-07 10:55:00 | AAPL | Stock | 4.5454 | 4.5557 | 4.5411 | 4.5514 | 21455728.0 |
| 2007-06-07 11:00:00 | AAPL | Stock | 4.5514 | 4.5536 | 4.5418 | 4.5443 | 20824860.0 |
| 2007-06-07 11:05:00 | AAPL | Stock | 4.5443 | 4.5461 | 4.5271 | 4.5275 | 24007424.0 |
| 2007-06-07 11:10:00 | AAPL | Stock | 4.5286 | 4.5286 | 4.5 | 4.5029 | 47770324.0 |
| 2007-06-07 11:15:00 | AAPL | Stock | 4.5029 | 4.5143 | 4.5 | 4.5143 | 34673884.0 |
| 2007-06-07 11:20:00 | AAPL | Stock | 4.5139 | 4.5218 | 4.5104 | 4.5193 | 26484612.0 |
| 2007-06-07 11:25:00 | AAPL | Stock | 4.5193 | 4.5229 | 4.5082 | 4.5139 | 16381092.0 |
| 2007-06-07 11:30:00 | AAPL | Stock | 4.5139 | 4.515 | 4.5036 | 4.5061 | 12441240.0 |
| 2007-06-07 11:35:00 | AAPL | Stock | 4.5061 | 4.5189 | 4.5039 | 4.5157 | 16544080.0 |
| 2007-06-07 11:40:00 | AAPL | Stock | 4.5164 | 4.5164 | 4.5046 | 4.5093 | 12985588.0 |
| 2007-06-07 11:45:00 | AAPL | Stock | 4.5096 | 4.5164 | 4.5089 | 4.5089 | 14319788.0 |
| 2007-06-07 11:50:00 | AAPL | Stock | 4.5089 | 4.5136 | 4.5079 | 4.5125 | 12036472.0 |
| 2007-06-07 11:55:00 | AAPL | Stock | 4.5125 | 4.5157 | 4.4993 | 4.5086 | 22342572.0 |
| 2007-06-07 12:00:00 | AAPL | Stock | 4.5082 | 4.5168 | 4.505 | 4.5146 | 15396500.0 |
| 2007-06-07 12:05:00 | AAPL | Stock | 4.5136 | 4.5186 | 4.5064 | 4.5068 | 14564284.0 |
| 2007-06-07 12:10:00 | AAPL | Stock | 4.5071 | 4.5164 | 4.5064 | 4.5164 | 12705784.0 |
| 2007-06-07 12:15:00 | AAPL | Stock | 4.5168 | 4.5229 | 4.5136 | 4.5157 | 19420184.0 |
| 2007-06-07 12:20:00 | AAPL | Stock | 4.5157 | 4.5179 | 4.5104 | 4.5118 | 8466276.0 |
| 2007-06-07 12:25:00 | AAPL | Stock | 4.5118 | 4.5171 | 4.5089 | 4.5164 | 8530452.0 |
| 2007-06-07 12:30:00 | AAPL | Stock | 4.5164 | 4.5168 | 4.5111 | 4.5114 | 9828784.0 |
| 2007-06-07 12:35:00 | AAPL | Stock | 4.5118 | 4.5157 | 4.5046 | 4.5066 | 12279120.0 |
| 2007-06-07 12:40:00 | AAPL | Stock | 4.5061 | 4.5068 | 4.5004 | 4.5021 | 13570620.0 |
| 2007-06-07 12:45:00 | AAPL | Stock | 4.5018 | 4.505 | 4.4829 | 4.4836 | 33273268.0 |
| 2007-06-07 12:50:00 | AAPL | Stock | 4.4836 | 4.4943 | 4.4804 | 4.4914 | 19809580.0 |
| 2007-06-07 12:55:00 | AAPL | Stock | 4.4911 | 4.4986 | 4.4907 | 4.4975 | 8861188.0 |
| 2007-06-07 13:00:00 | AAPL | Stock | 4.4979 | 4.5046 | 4.4946 | 4.4989 | 10073140.0 |
| 2007-06-07 13:05:00 | AAPL | Stock | 4.4982 | 4.5007 | 4.4946 | 4.5 | 7881972.0 |
| 2007-06-07 13:10:00 | AAPL | Stock | 4.5 | 4.5004 | 4.4911 | 4.4914 | 10403344.0 |
| 2007-06-07 13:15:00 | AAPL | Stock | 4.4911 | 4.4911 | 4.4643 | 4.466 | 35073528.0 |
| 2007-06-07 13:20:00 | AAPL | Stock | 4.4657 | 4.4796 | 4.4636 | 4.4786 | 23014236.0 |
| 2007-06-07 13:25:00 | AAPL | Stock | 4.4786 | 4.4882 | 4.4746 | 4.4854 | 14446992.0 |
| 2007-06-07 13:30:00 | AAPL | Stock | 4.4854 | 4.5318 | 4.4643 | 4.4721 | 17086048.0 |
| 2007-06-07 13:35:00 | AAPL | Stock | 4.4725 | 4.4725 | 4.4589 | 4.4621 | 23918776.0 |
> showing 50 of 297,969 rows — these rows as CSV