PREVIEW / stock_5min / 2005-03-04
file: by_date/stock_5min/2005/2005-03-04.parquet size: 2.7 MB rows: 194,286 symbols: 1,936
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-03-04 08:00:00 | AAPL | Stock | 1.4932 | 1.4993 | 1.4821 | 1.4993 | 1111264.0 |
| 2005-03-04 08:05:00 | AAPL | Stock | 1.4993 | 1.5071 | 1.4993 | 1.5054 | 1947792.0 |
| 2005-03-04 08:10:00 | AAPL | Stock | 1.5057 | 1.5111 | 1.5046 | 1.5111 | 826672.0 |
| 2005-03-04 08:15:00 | AAPL | Stock | 1.5111 | 1.5136 | 1.5079 | 1.5114 | 1036504.0 |
| 2005-03-04 08:20:00 | AAPL | Stock | 1.5111 | 1.5118 | 1.5071 | 1.5071 | 608160.0 |
| 2005-03-04 08:25:00 | AAPL | Stock | 1.5075 | 1.5079 | 1.5046 | 1.5079 | 534408.0 |
| 2005-03-04 08:30:00 | AAPL | Stock | 1.5089 | 1.5214 | 1.5089 | 1.5196 | 2419256.0 |
| 2005-03-04 08:35:00 | AAPL | Stock | 1.5193 | 1.5225 | 1.5186 | 1.5225 | 1858920.0 |
| 2005-03-04 08:40:00 | AAPL | Stock | 1.5214 | 1.5221 | 1.5179 | 1.5193 | 1453032.0 |
| 2005-03-04 08:45:00 | AAPL | Stock | 1.5193 | 1.5218 | 1.5179 | 1.5196 | 800072.0 |
| 2005-03-04 08:50:00 | AAPL | Stock | 1.5196 | 1.5218 | 1.5182 | 1.5207 | 572992.0 |
| 2005-03-04 08:55:00 | AAPL | Stock | 1.5214 | 1.5243 | 1.5193 | 1.5243 | 1284864.0 |
| 2005-03-04 09:00:00 | AAPL | Stock | 1.5232 | 1.5232 | 1.5189 | 1.5229 | 1073968.0 |
| 2005-03-04 09:05:00 | AAPL | Stock | 1.5218 | 1.5293 | 1.5218 | 1.5268 | 1217076.0 |
| 2005-03-04 09:10:00 | AAPL | Stock | 1.5268 | 1.5318 | 1.5246 | 1.5246 | 1654604.0 |
| 2005-03-04 09:15:00 | AAPL | Stock | 1.5239 | 1.5304 | 1.5239 | 1.5304 | 201936.0 |
| 2005-03-04 09:20:00 | AAPL | Stock | 1.5304 | 1.5318 | 1.5271 | 1.5296 | 1506092.0 |
| 2005-03-04 09:25:00 | AAPL | Stock | 1.5036 | 1.5354 | 1.5 | 1.5275 | 3373244.0 |
| 2005-03-04 09:30:00 | AAPL | Stock | 1.5271 | 1.5296 | 1.5139 | 1.5154 | 49438620.0 |
| 2005-03-04 09:35:00 | AAPL | Stock | 1.5154 | 1.5211 | 1.5054 | 1.5107 | 27969116.0 |
| 2005-03-04 09:40:00 | AAPL | Stock | 1.5111 | 1.5112 | 1.5 | 1.5011 | 25854892.0 |
| 2005-03-04 09:45:00 | AAPL | Stock | 1.5007 | 1.5057 | 1.4946 | 1.5011 | 29231468.0 |
| 2005-03-04 09:50:00 | AAPL | Stock | 1.5014 | 1.515 | 1.4989 | 1.5143 | 25368532.0 |
| 2005-03-04 09:55:00 | AAPL | Stock | 1.5143 | 1.52 | 1.5121 | 1.5157 | 24490816.0 |
| 2005-03-04 10:00:00 | AAPL | Stock | 1.5161 | 1.5193 | 1.5125 | 1.515 | 15032640.0 |
| 2005-03-04 10:05:00 | AAPL | Stock | 1.515 | 1.5168 | 1.5054 | 1.5054 | 17888528.0 |
| 2005-03-04 10:10:00 | AAPL | Stock | 1.5054 | 1.5139 | 1.5043 | 1.5104 | 11911704.0 |
| 2005-03-04 10:15:00 | AAPL | Stock | 1.5104 | 1.5157 | 1.5086 | 1.515 | 8286124.0 |
| 2005-03-04 10:20:00 | AAPL | Stock | 1.5154 | 1.5214 | 1.515 | 1.5168 | 17731168.0 |
| 2005-03-04 10:25:00 | AAPL | Stock | 1.5168 | 1.5179 | 1.5139 | 1.5146 | 9221912.0 |
| 2005-03-04 10:30:00 | AAPL | Stock | 1.5146 | 1.5164 | 1.5093 | 1.5132 | 6898640.0 |
| 2005-03-04 10:35:00 | AAPL | Stock | 1.5132 | 1.5139 | 1.5096 | 1.5139 | 5576004.0 |
| 2005-03-04 10:40:00 | AAPL | Stock | 1.5139 | 1.5143 | 1.5121 | 1.5136 | 6987400.0 |
| 2005-03-04 10:45:00 | AAPL | Stock | 1.5136 | 1.5189 | 1.5136 | 1.5164 | 9410632.0 |
| 2005-03-04 10:50:00 | AAPL | Stock | 1.5164 | 1.5164 | 1.5107 | 1.515 | 8261680.0 |
| 2005-03-04 10:55:00 | AAPL | Stock | 1.515 | 1.5154 | 1.5129 | 1.515 | 4814684.0 |
| 2005-03-04 11:00:00 | AAPL | Stock | 1.515 | 1.5182 | 1.515 | 1.5164 | 6529768.0 |
| 2005-03-04 11:05:00 | AAPL | Stock | 1.5164 | 1.5204 | 1.5143 | 1.5164 | 8832348.0 |
| 2005-03-04 11:10:00 | AAPL | Stock | 1.5168 | 1.5189 | 1.5164 | 1.5171 | 4873064.0 |
| 2005-03-04 11:15:00 | AAPL | Stock | 1.5175 | 1.5211 | 1.5171 | 1.5193 | 6962984.0 |
| 2005-03-04 11:20:00 | AAPL | Stock | 1.5193 | 1.5264 | 1.5175 | 1.5243 | 12216792.0 |
| 2005-03-04 11:25:00 | AAPL | Stock | 1.5246 | 1.5271 | 1.5229 | 1.5264 | 8834672.0 |
| 2005-03-04 11:30:00 | AAPL | Stock | 1.5264 | 1.5293 | 1.525 | 1.5268 | 8528996.0 |
| 2005-03-04 11:35:00 | AAPL | Stock | 1.5271 | 1.5293 | 1.5243 | 1.5268 | 7058772.0 |
| 2005-03-04 11:40:00 | AAPL | Stock | 1.5261 | 1.5279 | 1.5221 | 1.5254 | 5586952.0 |
| 2005-03-04 11:45:00 | AAPL | Stock | 1.5257 | 1.5279 | 1.5243 | 1.5261 | 3685752.0 |
| 2005-03-04 11:50:00 | AAPL | Stock | 1.5261 | 1.5282 | 1.5232 | 1.5264 | 3307836.0 |
| 2005-03-04 11:55:00 | AAPL | Stock | 1.5264 | 1.5271 | 1.5179 | 1.52 | 7533036.0 |
| 2005-03-04 12:00:00 | AAPL | Stock | 1.5207 | 1.5214 | 1.5189 | 1.5207 | 4461772.0 |
| 2005-03-04 12:05:00 | AAPL | Stock | 1.5204 | 1.5268 | 1.52 | 1.5211 | 3430980.0 |
> showing 50 of 194,286 rows — these rows as CSV