PREVIEW / stock_5min / 2007-07-03
file: by_date/stock_5min/2007/2007-07-03.parquet size: 2.4 MB rows: 164,542 symbols: 2,990
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-07-03 09:30:00 | AAPL | Stock | 4.3571 | 4.3575 | 4.3411 | 4.3493 | 20473236.0 |
| 2007-07-03 09:35:00 | AAPL | Stock | 4.3489 | 4.3536 | 4.3393 | 4.3514 | 16182936.0 |
| 2007-07-03 09:40:00 | AAPL | Stock | 4.3518 | 4.355 | 4.3446 | 4.3493 | 17796968.0 |
| 2007-07-03 09:45:00 | AAPL | Stock | 4.3496 | 4.3543 | 4.3439 | 4.3518 | 15727796.0 |
| 2007-07-03 09:50:00 | AAPL | Stock | 4.3521 | 4.3732 | 4.3512 | 4.3714 | 31350816.0 |
| 2007-07-03 09:55:00 | AAPL | Stock | 4.3711 | 4.3746 | 4.365 | 4.3725 | 24887940.0 |
| 2007-07-03 10:00:00 | AAPL | Stock | 4.3721 | 4.3886 | 4.3661 | 4.3875 | 31759364.0 |
| 2007-07-03 10:05:00 | AAPL | Stock | 4.3879 | 4.4275 | 4.3786 | 4.4267 | 43924580.0 |
| 2007-07-03 10:10:00 | AAPL | Stock | 4.4261 | 4.4643 | 4.4146 | 4.4614 | 78290240.0 |
| 2007-07-03 10:15:00 | AAPL | Stock | 4.4625 | 4.4643 | 4.4179 | 4.4607 | 58843568.0 |
| 2007-07-03 10:20:00 | AAPL | Stock | 4.4607 | 4.4821 | 4.4536 | 4.4786 | 61407948.0 |
| 2007-07-03 10:25:00 | AAPL | Stock | 4.4782 | 4.4896 | 4.4661 | 4.4798 | 37380476.0 |
| 2007-07-03 10:30:00 | AAPL | Stock | 4.4789 | 4.4839 | 4.4571 | 4.4621 | 34783028.0 |
| 2007-07-03 10:35:00 | AAPL | Stock | 4.4621 | 4.4771 | 4.4579 | 4.4714 | 27436612.0 |
| 2007-07-03 10:40:00 | AAPL | Stock | 4.4714 | 4.4871 | 4.47 | 4.4836 | 28034216.0 |
| 2007-07-03 10:45:00 | AAPL | Stock | 4.4839 | 4.5171 | 4.4821 | 4.5146 | 47062512.0 |
| 2007-07-03 10:50:00 | AAPL | Stock | 4.515 | 4.5232 | 4.5032 | 4.5154 | 37419088.0 |
| 2007-07-03 10:55:00 | AAPL | Stock | 4.5154 | 4.5443 | 4.5146 | 4.5296 | 54106584.0 |
| 2007-07-03 11:00:00 | AAPL | Stock | 4.5296 | 4.5343 | 4.5111 | 4.5114 | 32667124.0 |
| 2007-07-03 11:05:00 | AAPL | Stock | 4.5114 | 4.5321 | 4.51 | 4.5275 | 30026948.0 |
| 2007-07-03 11:10:00 | AAPL | Stock | 4.5268 | 4.5307 | 4.5196 | 4.522 | 19080180.0 |
| 2007-07-03 11:15:00 | AAPL | Stock | 4.5218 | 4.5314 | 4.5175 | 4.5182 | 16435160.0 |
| 2007-07-03 11:20:00 | AAPL | Stock | 4.5179 | 4.5271 | 4.5161 | 4.5214 | 14144648.0 |
| 2007-07-03 11:25:00 | AAPL | Stock | 4.5207 | 4.5214 | 4.5036 | 4.505 | 21402584.0 |
| 2007-07-03 11:30:00 | AAPL | Stock | 4.5046 | 4.5054 | 4.4946 | 4.5039 | 24121272.0 |
| 2007-07-03 11:35:00 | AAPL | Stock | 4.5014 | 4.5321 | 4.4964 | 4.5032 | 17579828.0 |
| 2007-07-03 11:40:00 | AAPL | Stock | 4.5029 | 4.5143 | 4.5 | 4.5066 | 16314676.0 |
| 2007-07-03 11:45:00 | AAPL | Stock | 4.5068 | 4.5132 | 4.5061 | 4.5118 | 10072132.0 |
| 2007-07-03 11:50:00 | AAPL | Stock | 4.5118 | 4.5268 | 4.5114 | 4.5245 | 15028020.0 |
| 2007-07-03 11:55:00 | AAPL | Stock | 4.5239 | 4.5246 | 4.5171 | 4.5243 | 9218020.0 |
| 2007-07-03 12:00:00 | AAPL | Stock | 4.5239 | 4.5243 | 4.5121 | 4.5168 | 11940824.0 |
| 2007-07-03 12:05:00 | AAPL | Stock | 4.5175 | 4.5175 | 4.5075 | 4.5104 | 11269608.0 |
| 2007-07-03 12:10:00 | AAPL | Stock | 4.5107 | 4.5129 | 4.5054 | 4.5102 | 14971740.0 |
| 2007-07-03 12:15:00 | AAPL | Stock | 4.5104 | 4.5179 | 4.5089 | 4.5143 | 8720796.0 |
| 2007-07-03 12:20:00 | AAPL | Stock | 4.5146 | 4.5271 | 4.5146 | 4.5232 | 15488116.0 |
| 2007-07-03 12:25:00 | AAPL | Stock | 4.5236 | 4.5357 | 4.5146 | 4.5336 | 21367472.0 |
| 2007-07-03 12:30:00 | AAPL | Stock | 4.5336 | 4.5418 | 4.5304 | 4.5314 | 26439812.0 |
| 2007-07-03 12:35:00 | AAPL | Stock | 4.5314 | 4.5475 | 4.5311 | 4.5457 | 25265520.0 |
| 2007-07-03 12:40:00 | AAPL | Stock | 4.5461 | 4.55 | 4.5407 | 4.5461 | 25219796.0 |
| 2007-07-03 12:45:00 | AAPL | Stock | 4.5464 | 4.5479 | 4.5375 | 4.5418 | 17591644.0 |
| 2007-07-03 12:50:00 | AAPL | Stock | 4.5414 | 4.5464 | 4.5339 | 4.5418 | 19369644.0 |
| 2007-07-03 12:55:00 | AAPL | Stock | 4.5418 | 4.5468 | 4.5393 | 4.5407 | 29495592.0 |
| 2007-07-03 13:00:00 | AAPL | Stock | 4.5418 | 4.5421 | 4.5404 | 4.5418 | 7394492.0 |
| 2007-07-03 09:30:00 | MSFT | Stock | 29.785 | 29.96 | 29.78 | 29.96 | 1156801.0 |
| 2007-07-03 09:35:00 | MSFT | Stock | 29.96 | 30.0 | 29.95 | 29.99 | 1633083.0 |
| 2007-07-03 09:40:00 | MSFT | Stock | 29.983 | 30.0 | 29.92 | 29.94 | 1633631.0 |
| 2007-07-03 09:45:00 | MSFT | Stock | 29.94 | 29.95 | 29.84 | 29.89 | 912690.0 |
| 2007-07-03 09:50:00 | MSFT | Stock | 29.89 | 29.93 | 29.89 | 29.92 | 1693675.0 |
| 2007-07-03 09:55:00 | MSFT | Stock | 29.92 | 30.0 | 29.91 | 29.99 | 1816170.0 |
| 2007-07-03 10:00:00 | MSFT | Stock | 29.98 | 30.0 | 29.97 | 29.98 | 846366.0 |
> showing 50 of 164,542 rows — these rows as CSV