PREVIEW / stock_5min / 2004-06-07
file: by_date/stock_5min/2004/2004-06-07.parquet size: 2.4 MB rows: 174,773 symbols: 1,784
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 |
|---|---|---|---|---|---|---|---|
| 2004-06-07 08:00:00 | AAPL | Stock | 0.5179 | 0.5229 | 0.5179 | 0.5229 | 84000.0 |
| 2004-06-07 08:10:00 | AAPL | Stock | 0.5229 | 0.5229 | 0.5229 | 0.5229 | 56000.0 |
| 2004-06-07 08:15:00 | AAPL | Stock | 0.5223 | 0.5229 | 0.5223 | 0.5229 | 22400.0 |
| 2004-06-07 08:25:00 | AAPL | Stock | 0.5227 | 0.5227 | 0.522 | 0.522 | 16800.0 |
| 2004-06-07 08:35:00 | AAPL | Stock | 0.5188 | 0.5214 | 0.5188 | 0.5214 | 56000.0 |
| 2004-06-07 08:40:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5196 | 0.5196 | 11200.0 |
| 2004-06-07 08:45:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5188 | 0.5188 | 168000.0 |
| 2004-06-07 08:55:00 | AAPL | Stock | 0.5193 | 0.5193 | 0.5193 | 0.5193 | 28000.0 |
| 2004-06-07 09:00:00 | AAPL | Stock | 0.5196 | 0.5196 | 0.5179 | 0.5179 | 140000.0 |
| 2004-06-07 09:05:00 | AAPL | Stock | 0.5188 | 0.5193 | 0.5179 | 0.5184 | 190400.0 |
| 2004-06-07 09:25:00 | AAPL | Stock | 0.5173 | 0.5184 | 0.5161 | 0.5173 | 639408.0 |
| 2004-06-07 09:30:00 | AAPL | Stock | 0.5186 | 0.5186 | 0.5145 | 0.5159 | 4254712.0 |
| 2004-06-07 09:35:00 | AAPL | Stock | 0.5155 | 0.5164 | 0.5148 | 0.5156 | 1868160.0 |
| 2004-06-07 09:40:00 | AAPL | Stock | 0.5157 | 0.5166 | 0.5154 | 0.5164 | 2198840.0 |
| 2004-06-07 09:45:00 | AAPL | Stock | 0.5164 | 0.518 | 0.5164 | 0.5179 | 3096128.0 |
| 2004-06-07 09:50:00 | AAPL | Stock | 0.5179 | 0.5205 | 0.5177 | 0.5202 | 3810968.0 |
| 2004-06-07 09:55:00 | AAPL | Stock | 0.5205 | 0.522 | 0.5195 | 0.522 | 5532856.0 |
| 2004-06-07 10:00:00 | AAPL | Stock | 0.5218 | 0.522 | 0.5204 | 0.5216 | 6043296.0 |
| 2004-06-07 10:05:00 | AAPL | Stock | 0.5216 | 0.5245 | 0.5211 | 0.5243 | 8060136.0 |
| 2004-06-07 10:10:00 | AAPL | Stock | 0.5243 | 0.525 | 0.5234 | 0.5234 | 5583648.0 |
| 2004-06-07 10:15:00 | AAPL | Stock | 0.5234 | 0.5245 | 0.5207 | 0.5213 | 3756592.0 |
| 2004-06-07 10:20:00 | AAPL | Stock | 0.5209 | 0.5229 | 0.5207 | 0.5229 | 1887200.0 |
| 2004-06-07 10:25:00 | AAPL | Stock | 0.5229 | 0.5229 | 0.5218 | 0.522 | 2005584.0 |
| 2004-06-07 10:30:00 | AAPL | Stock | 0.522 | 0.5223 | 0.5214 | 0.5214 | 3028312.0 |
| 2004-06-07 10:35:00 | AAPL | Stock | 0.5213 | 0.5221 | 0.5207 | 0.5221 | 3333120.0 |
| 2004-06-07 10:40:00 | AAPL | Stock | 0.5221 | 0.5221 | 0.5213 | 0.5214 | 1929200.0 |
| 2004-06-07 10:45:00 | AAPL | Stock | 0.5214 | 0.5216 | 0.5209 | 0.5214 | 1800400.0 |
| 2004-06-07 10:50:00 | AAPL | Stock | 0.5213 | 0.5214 | 0.5213 | 0.5213 | 704032.0 |
| 2004-06-07 10:55:00 | AAPL | Stock | 0.5213 | 0.5214 | 0.5213 | 0.5214 | 577360.0 |
| 2004-06-07 11:00:00 | AAPL | Stock | 0.5213 | 0.5214 | 0.5205 | 0.5211 | 3367728.0 |
| 2004-06-07 11:05:00 | AAPL | Stock | 0.5211 | 0.5221 | 0.5209 | 0.5216 | 2902760.0 |
| 2004-06-07 11:10:00 | AAPL | Stock | 0.5218 | 0.523 | 0.5218 | 0.5229 | 2597672.0 |
| 2004-06-07 11:15:00 | AAPL | Stock | 0.5229 | 0.5241 | 0.5229 | 0.5232 | 3950296.0 |
| 2004-06-07 11:20:00 | AAPL | Stock | 0.5232 | 0.5236 | 0.5229 | 0.5232 | 2321144.0 |
| 2004-06-07 11:25:00 | AAPL | Stock | 0.5234 | 0.5245 | 0.5234 | 0.5243 | 2816520.0 |
| 2004-06-07 11:30:00 | AAPL | Stock | 0.5243 | 0.5243 | 0.5239 | 0.5239 | 2305352.0 |
| 2004-06-07 11:35:00 | AAPL | Stock | 0.5239 | 0.5246 | 0.5239 | 0.5245 | 2234680.0 |
| 2004-06-07 11:40:00 | AAPL | Stock | 0.5245 | 0.5255 | 0.5241 | 0.5255 | 2891280.0 |
| 2004-06-07 11:45:00 | AAPL | Stock | 0.5255 | 0.527 | 0.525 | 0.5268 | 10740072.0 |
| 2004-06-07 11:50:00 | AAPL | Stock | 0.5268 | 0.527 | 0.5259 | 0.5259 | 1484224.0 |
| 2004-06-07 11:55:00 | AAPL | Stock | 0.5259 | 0.5261 | 0.5252 | 0.5255 | 1145480.0 |
| 2004-06-07 12:00:00 | AAPL | Stock | 0.5254 | 0.5261 | 0.5254 | 0.5257 | 1568504.0 |
| 2004-06-07 12:05:00 | AAPL | Stock | 0.5259 | 0.5268 | 0.5257 | 0.5268 | 1090544.0 |
| 2004-06-07 12:10:00 | AAPL | Stock | 0.5264 | 0.5298 | 0.5264 | 0.5288 | 8110424.0 |
| 2004-06-07 12:15:00 | AAPL | Stock | 0.5288 | 0.5293 | 0.5273 | 0.5277 | 4597880.0 |
| 2004-06-07 12:20:00 | AAPL | Stock | 0.5275 | 0.5289 | 0.5275 | 0.5284 | 1507744.0 |
| 2004-06-07 12:25:00 | AAPL | Stock | 0.5282 | 0.5293 | 0.5282 | 0.5293 | 1735216.0 |
| 2004-06-07 12:30:00 | AAPL | Stock | 0.5289 | 0.5304 | 0.5288 | 0.5298 | 6953296.0 |
| 2004-06-07 12:35:00 | AAPL | Stock | 0.5295 | 0.5298 | 0.5282 | 0.5286 | 2777152.0 |
| 2004-06-07 12:40:00 | AAPL | Stock | 0.5286 | 0.5286 | 0.5273 | 0.5275 | 3412528.0 |
> showing 50 of 174,773 rows — these rows as CSV