PREVIEW / stock_5min / 2005-11-28
file: by_date/stock_5min/2005/2005-11-28.parquet size: 2.9 MB rows: 211,741 symbols: 2,134
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-11-28 07:00:00 | AAPL | Stock | 2.5007 | 2.5196 | 2.5004 | 2.5179 | 75600.0 |
| 2005-11-28 07:05:00 | AAPL | Stock | 2.5179 | 2.5179 | 2.5179 | 2.5179 | 2800.0 |
| 2005-11-28 07:15:00 | AAPL | Stock | 2.5286 | 2.5286 | 2.5179 | 2.5179 | 168000.0 |
| 2005-11-28 07:25:00 | AAPL | Stock | 2.525 | 2.5282 | 2.525 | 2.525 | 39200.0 |
| 2005-11-28 07:45:00 | AAPL | Stock | 2.5179 | 2.5179 | 2.5179 | 2.5179 | 33628.0 |
| 2005-11-28 07:50:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5107 | 2.5107 | 191772.0 |
| 2005-11-28 07:55:00 | AAPL | Stock | 2.5143 | 2.5143 | 2.5143 | 2.5143 | 81200.0 |
| 2005-11-28 08:00:00 | AAPL | Stock | 2.5179 | 2.5307 | 2.5114 | 2.5214 | 3670800.0 |
| 2005-11-28 08:05:00 | AAPL | Stock | 2.5214 | 2.525 | 2.5179 | 2.5207 | 1107960.0 |
| 2005-11-28 08:10:00 | AAPL | Stock | 2.5229 | 2.5246 | 2.52 | 2.5207 | 691348.0 |
| 2005-11-28 08:15:00 | AAPL | Stock | 2.5239 | 2.5268 | 2.52 | 2.5257 | 430080.0 |
| 2005-11-28 08:20:00 | AAPL | Stock | 2.5246 | 2.5275 | 2.5204 | 2.5275 | 791280.0 |
| 2005-11-28 08:25:00 | AAPL | Stock | 2.525 | 2.5268 | 2.525 | 2.5257 | 651980.0 |
| 2005-11-28 08:30:00 | AAPL | Stock | 2.5264 | 2.5275 | 2.5243 | 2.5268 | 945392.0 |
| 2005-11-28 08:35:00 | AAPL | Stock | 2.5275 | 2.5286 | 2.525 | 2.5275 | 645428.0 |
| 2005-11-28 08:40:00 | AAPL | Stock | 2.5275 | 2.535 | 2.5271 | 2.5343 | 906276.0 |
| 2005-11-28 08:45:00 | AAPL | Stock | 2.5343 | 2.5346 | 2.5304 | 2.5321 | 1398516.0 |
| 2005-11-28 08:50:00 | AAPL | Stock | 2.5329 | 2.535 | 2.5307 | 2.5318 | 1367436.0 |
| 2005-11-28 08:55:00 | AAPL | Stock | 2.5314 | 2.5321 | 2.5296 | 2.5296 | 1047760.0 |
| 2005-11-28 09:00:00 | AAPL | Stock | 2.5296 | 2.5318 | 2.5286 | 2.5296 | 871080.0 |
| 2005-11-28 09:05:00 | AAPL | Stock | 2.53 | 2.5321 | 2.5279 | 2.5286 | 999880.0 |
| 2005-11-28 09:10:00 | AAPL | Stock | 2.5296 | 2.5304 | 2.5268 | 2.5293 | 680036.0 |
| 2005-11-28 09:15:00 | AAPL | Stock | 2.5289 | 2.53 | 2.5289 | 2.5289 | 615552.0 |
| 2005-11-28 09:20:00 | AAPL | Stock | 2.5289 | 2.5332 | 2.5232 | 2.5257 | 2373672.0 |
| 2005-11-28 09:25:00 | AAPL | Stock | 2.5254 | 2.5296 | 2.5218 | 2.5264 | 5052656.0 |
| 2005-11-28 09:30:00 | AAPL | Stock | 2.5257 | 2.5382 | 2.5146 | 2.5307 | 78633296.0 |
| 2005-11-28 09:35:00 | AAPL | Stock | 2.5307 | 2.5321 | 2.5139 | 2.5214 | 49777196.0 |
| 2005-11-28 09:40:00 | AAPL | Stock | 2.5214 | 2.5257 | 2.5164 | 2.5236 | 34460608.0 |
| 2005-11-28 09:45:00 | AAPL | Stock | 2.5232 | 2.5261 | 2.5046 | 2.5068 | 40411168.0 |
| 2005-11-28 09:50:00 | AAPL | Stock | 2.5071 | 2.5221 | 2.5036 | 2.5196 | 31218796.0 |
| 2005-11-28 09:55:00 | AAPL | Stock | 2.5196 | 2.5239 | 2.5075 | 2.5093 | 26022248.0 |
| 2005-11-28 10:00:00 | AAPL | Stock | 2.5093 | 2.515 | 2.5018 | 2.5093 | 26459944.0 |
| 2005-11-28 10:05:00 | AAPL | Stock | 2.5089 | 2.5104 | 2.5018 | 2.5054 | 25616556.0 |
| 2005-11-28 10:10:00 | AAPL | Stock | 2.5054 | 2.5114 | 2.4975 | 2.505 | 27068888.0 |
| 2005-11-28 10:15:00 | AAPL | Stock | 2.5046 | 2.5168 | 2.5032 | 2.5136 | 17776864.0 |
| 2005-11-28 10:20:00 | AAPL | Stock | 2.5136 | 2.5175 | 2.5079 | 2.515 | 15668940.0 |
| 2005-11-28 10:25:00 | AAPL | Stock | 2.515 | 2.5154 | 2.5089 | 2.5107 | 12346656.0 |
| 2005-11-28 10:30:00 | AAPL | Stock | 2.5104 | 2.5146 | 2.5075 | 2.5143 | 14005544.0 |
| 2005-11-28 10:35:00 | AAPL | Stock | 2.5143 | 2.5264 | 2.5104 | 2.5104 | 11842796.0 |
| 2005-11-28 10:40:00 | AAPL | Stock | 2.5104 | 2.5118 | 2.5068 | 2.5086 | 11819332.0 |
| 2005-11-28 10:45:00 | AAPL | Stock | 2.5086 | 2.5125 | 2.5057 | 2.5121 | 7651840.0 |
| 2005-11-28 10:50:00 | AAPL | Stock | 2.5118 | 2.5139 | 2.5086 | 2.5089 | 9687580.0 |
| 2005-11-28 10:55:00 | AAPL | Stock | 2.5086 | 2.5086 | 2.4875 | 2.4889 | 30116492.0 |
| 2005-11-28 11:00:00 | AAPL | Stock | 2.4886 | 2.4968 | 2.4832 | 2.4925 | 24442152.0 |
| 2005-11-28 11:05:00 | AAPL | Stock | 2.4924 | 2.495 | 2.4871 | 2.4896 | 13713896.0 |
| 2005-11-28 11:10:00 | AAPL | Stock | 2.4893 | 2.5089 | 2.485 | 2.4907 | 12591628.0 |
| 2005-11-28 11:15:00 | AAPL | Stock | 2.4907 | 2.4943 | 2.4871 | 2.49 | 9035768.0 |
| 2005-11-28 11:20:00 | AAPL | Stock | 2.49 | 2.49 | 2.4721 | 2.4793 | 27189008.0 |
| 2005-11-28 11:25:00 | AAPL | Stock | 2.4793 | 2.4793 | 2.4668 | 2.4711 | 22979152.0 |
| 2005-11-28 11:30:00 | AAPL | Stock | 2.4711 | 2.4807 | 2.4704 | 2.48 | 19152336.0 |
> showing 50 of 211,741 rows — these rows as CSV