PREVIEW / stock_5min / 2005-04-06
file: by_date/stock_5min/2005/2005-04-06.parquet size: 2.6 MB rows: 193,706 symbols: 1,952
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-04-06 08:00:00 | AAPL | Stock | 1.49 | 1.4975 | 1.49 | 1.4964 | 136500.0 |
| 2005-04-06 08:05:00 | AAPL | Stock | 1.4964 | 1.4964 | 1.4964 | 1.4964 | 8400.0 |
| 2005-04-06 08:10:00 | AAPL | Stock | 1.4975 | 1.5 | 1.4975 | 1.4975 | 144900.0 |
| 2005-04-06 08:15:00 | AAPL | Stock | 1.4975 | 1.5068 | 1.4961 | 1.5036 | 558600.0 |
| 2005-04-06 08:20:00 | AAPL | Stock | 1.5057 | 1.5071 | 1.5054 | 1.5071 | 136920.0 |
| 2005-04-06 08:25:00 | AAPL | Stock | 1.5089 | 1.5125 | 1.5071 | 1.5071 | 371420.0 |
| 2005-04-06 08:30:00 | AAPL | Stock | 1.5071 | 1.5107 | 1.5036 | 1.51 | 333480.0 |
| 2005-04-06 08:40:00 | AAPL | Stock | 1.5089 | 1.5089 | 1.5071 | 1.5089 | 336000.0 |
| 2005-04-06 08:45:00 | AAPL | Stock | 1.5089 | 1.5089 | 1.5079 | 1.5079 | 98000.0 |
| 2005-04-06 08:50:00 | AAPL | Stock | 1.5075 | 1.5089 | 1.5075 | 1.5086 | 39200.0 |
| 2005-04-06 08:55:00 | AAPL | Stock | 1.5086 | 1.5089 | 1.5075 | 1.5082 | 151200.0 |
| 2005-04-06 09:00:00 | AAPL | Stock | 1.5071 | 1.5086 | 1.5071 | 1.5086 | 199920.0 |
| 2005-04-06 09:05:00 | AAPL | Stock | 1.5089 | 1.5093 | 1.5086 | 1.5093 | 134400.0 |
| 2005-04-06 09:10:00 | AAPL | Stock | 1.5086 | 1.51 | 1.5086 | 1.51 | 190400.0 |
| 2005-04-06 09:15:00 | AAPL | Stock | 1.51 | 1.51 | 1.51 | 1.51 | 5600.0 |
| 2005-04-06 09:20:00 | AAPL | Stock | 1.5104 | 1.5107 | 1.5104 | 1.5107 | 11200.0 |
| 2005-04-06 09:25:00 | AAPL | Stock | 1.5 | 1.5179 | 1.5 | 1.5179 | 1594572.0 |
| 2005-04-06 09:30:00 | AAPL | Stock | 1.5143 | 1.5214 | 1.5107 | 1.5136 | 26918248.0 |
| 2005-04-06 09:35:00 | AAPL | Stock | 1.5139 | 1.5179 | 1.5093 | 1.5125 | 14341404.0 |
| 2005-04-06 09:40:00 | AAPL | Stock | 1.5118 | 1.515 | 1.5096 | 1.5096 | 6654676.0 |
| 2005-04-06 09:45:00 | AAPL | Stock | 1.5093 | 1.5146 | 1.5093 | 1.5136 | 6654116.0 |
| 2005-04-06 09:50:00 | AAPL | Stock | 1.5136 | 1.5179 | 1.5132 | 1.5164 | 7869876.0 |
| 2005-04-06 09:55:00 | AAPL | Stock | 1.5161 | 1.52 | 1.5154 | 1.5171 | 10189060.0 |
| 2005-04-06 10:00:00 | AAPL | Stock | 1.5171 | 1.5232 | 1.5157 | 1.5218 | 11783492.0 |
| 2005-04-06 10:05:00 | AAPL | Stock | 1.5214 | 1.5271 | 1.5214 | 1.5243 | 14322224.0 |
| 2005-04-06 10:10:00 | AAPL | Stock | 1.5243 | 1.5264 | 1.5164 | 1.5232 | 8179416.0 |
| 2005-04-06 10:15:00 | AAPL | Stock | 1.5232 | 1.5279 | 1.5164 | 1.5243 | 9087204.0 |
| 2005-04-06 10:20:00 | AAPL | Stock | 1.5243 | 1.5271 | 1.5179 | 1.5179 | 8945132.0 |
| 2005-04-06 10:25:00 | AAPL | Stock | 1.5179 | 1.5243 | 1.5168 | 1.5211 | 9254196.0 |
| 2005-04-06 10:30:00 | AAPL | Stock | 1.5211 | 1.5268 | 1.5204 | 1.5223 | 8548372.0 |
| 2005-04-06 10:35:00 | AAPL | Stock | 1.5221 | 1.5223 | 1.5154 | 1.5154 | 7779408.0 |
| 2005-04-06 10:40:00 | AAPL | Stock | 1.5154 | 1.5193 | 1.515 | 1.5182 | 7150612.0 |
| 2005-04-06 10:45:00 | AAPL | Stock | 1.5186 | 1.5225 | 1.5164 | 1.5204 | 7345016.0 |
| 2005-04-06 10:50:00 | AAPL | Stock | 1.5204 | 1.5211 | 1.5179 | 1.52 | 2309132.0 |
| 2005-04-06 10:55:00 | AAPL | Stock | 1.5196 | 1.5211 | 1.5179 | 1.52 | 2759764.0 |
| 2005-04-06 11:00:00 | AAPL | Stock | 1.52 | 1.5236 | 1.5186 | 1.5236 | 3981320.0 |
| 2005-04-06 11:05:00 | AAPL | Stock | 1.5236 | 1.5239 | 1.5211 | 1.5236 | 3656492.0 |
| 2005-04-06 11:10:00 | AAPL | Stock | 1.5232 | 1.5254 | 1.5221 | 1.5246 | 3447780.0 |
| 2005-04-06 11:15:00 | AAPL | Stock | 1.5243 | 1.5254 | 1.5214 | 1.5225 | 6430368.0 |
| 2005-04-06 11:20:00 | AAPL | Stock | 1.5229 | 1.5239 | 1.5221 | 1.5232 | 2679040.0 |
| 2005-04-06 11:25:00 | AAPL | Stock | 1.5229 | 1.5286 | 1.5225 | 1.5282 | 7650272.0 |
| 2005-04-06 11:30:00 | AAPL | Stock | 1.5279 | 1.5289 | 1.5239 | 1.5243 | 6190548.0 |
| 2005-04-06 11:35:00 | AAPL | Stock | 1.5243 | 1.5275 | 1.5243 | 1.5268 | 3193008.0 |
| 2005-04-06 11:40:00 | AAPL | Stock | 1.5271 | 1.5271 | 1.5232 | 1.5232 | 4219488.0 |
| 2005-04-06 11:45:00 | AAPL | Stock | 1.5232 | 1.5243 | 1.5232 | 1.5239 | 2390136.0 |
| 2005-04-06 11:50:00 | AAPL | Stock | 1.5236 | 1.5239 | 1.5221 | 1.5229 | 2666496.0 |
| 2005-04-06 11:55:00 | AAPL | Stock | 1.5232 | 1.525 | 1.5232 | 1.525 | 2596160.0 |
| 2005-04-06 12:00:00 | AAPL | Stock | 1.5246 | 1.525 | 1.5232 | 1.5239 | 3851960.0 |
| 2005-04-06 12:05:00 | AAPL | Stock | 1.5243 | 1.5268 | 1.5235 | 1.5264 | 5666276.0 |
| 2005-04-06 12:10:00 | AAPL | Stock | 1.5261 | 1.5268 | 1.525 | 1.5257 | 1920716.0 |
> showing 50 of 193,706 rows — these rows as CSV