PREVIEW / stock_5min / 2004-07-14
file: by_date/stock_5min/2004/2004-07-14.parquet size: 2.4 MB rows: 175,454 symbols: 1,797
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-07-14 08:00:00 | AAPL | Stock | 0.521 | 0.521 | 0.521 | 0.521 | 716800.0 |
| 2004-07-14 08:25:00 | AAPL | Stock | 0.5164 | 0.5179 | 0.5164 | 0.5179 | 39200.0 |
| 2004-07-14 08:45:00 | AAPL | Stock | 0.517 | 0.517 | 0.517 | 0.517 | 5600.0 |
| 2004-07-14 09:15:00 | AAPL | Stock | 0.517 | 0.517 | 0.517 | 0.517 | 50400.0 |
| 2004-07-14 09:20:00 | AAPL | Stock | 0.5179 | 0.5218 | 0.5179 | 0.5179 | 5059600.0 |
| 2004-07-14 09:25:00 | AAPL | Stock | 0.5171 | 0.5173 | 0.5141 | 0.5141 | 448616.0 |
| 2004-07-14 09:30:00 | AAPL | Stock | 0.5171 | 0.5179 | 0.5132 | 0.5177 | 14235704.0 |
| 2004-07-14 09:35:00 | AAPL | Stock | 0.5177 | 0.52 | 0.5161 | 0.52 | 10015320.0 |
| 2004-07-14 09:40:00 | AAPL | Stock | 0.52 | 0.522 | 0.5196 | 0.5205 | 10244360.0 |
| 2004-07-14 09:45:00 | AAPL | Stock | 0.5205 | 0.5214 | 0.5202 | 0.5207 | 9648296.0 |
| 2004-07-14 09:50:00 | AAPL | Stock | 0.5205 | 0.5211 | 0.5202 | 0.5211 | 5913936.0 |
| 2004-07-14 09:55:00 | AAPL | Stock | 0.5211 | 0.5211 | 0.5193 | 0.5202 | 6124104.0 |
| 2004-07-14 10:00:00 | AAPL | Stock | 0.5204 | 0.5209 | 0.5196 | 0.5205 | 5825904.0 |
| 2004-07-14 10:05:00 | AAPL | Stock | 0.5207 | 0.5216 | 0.52 | 0.5216 | 4521496.0 |
| 2004-07-14 10:10:00 | AAPL | Stock | 0.5216 | 0.522 | 0.5211 | 0.5214 | 5201112.0 |
| 2004-07-14 10:15:00 | AAPL | Stock | 0.5214 | 0.5216 | 0.5207 | 0.5211 | 2529800.0 |
| 2004-07-14 10:20:00 | AAPL | Stock | 0.5211 | 0.522 | 0.5209 | 0.5211 | 11491648.0 |
| 2004-07-14 10:25:00 | AAPL | Stock | 0.5211 | 0.5218 | 0.5209 | 0.5216 | 4907112.0 |
| 2004-07-14 10:30:00 | AAPL | Stock | 0.5215 | 0.5232 | 0.5209 | 0.5229 | 5532184.0 |
| 2004-07-14 10:35:00 | AAPL | Stock | 0.523 | 0.5255 | 0.5227 | 0.5248 | 7932624.0 |
| 2004-07-14 10:40:00 | AAPL | Stock | 0.5248 | 0.5266 | 0.5243 | 0.5266 | 6271944.0 |
| 2004-07-14 10:45:00 | AAPL | Stock | 0.5266 | 0.5311 | 0.5264 | 0.5282 | 12557552.0 |
| 2004-07-14 10:50:00 | AAPL | Stock | 0.5286 | 0.5286 | 0.5254 | 0.5254 | 9535680.0 |
| 2004-07-14 10:55:00 | AAPL | Stock | 0.5254 | 0.5273 | 0.525 | 0.5268 | 5997600.0 |
| 2004-07-14 11:00:00 | AAPL | Stock | 0.5271 | 0.5273 | 0.5261 | 0.5263 | 3190880.0 |
| 2004-07-14 11:05:00 | AAPL | Stock | 0.5262 | 0.5266 | 0.5252 | 0.5257 | 4139912.0 |
| 2004-07-14 11:10:00 | AAPL | Stock | 0.5255 | 0.5264 | 0.5252 | 0.5262 | 3289160.0 |
| 2004-07-14 11:15:00 | AAPL | Stock | 0.5263 | 0.5268 | 0.5261 | 0.5266 | 4151280.0 |
| 2004-07-14 11:20:00 | AAPL | Stock | 0.5266 | 0.5271 | 0.5261 | 0.5261 | 5107984.0 |
| 2004-07-14 11:25:00 | AAPL | Stock | 0.5263 | 0.5266 | 0.5263 | 0.5266 | 1834280.0 |
| 2004-07-14 11:30:00 | AAPL | Stock | 0.5266 | 0.5275 | 0.5264 | 0.5275 | 4587912.0 |
| 2004-07-14 11:35:00 | AAPL | Stock | 0.5275 | 0.5288 | 0.527 | 0.5286 | 6098960.0 |
| 2004-07-14 11:40:00 | AAPL | Stock | 0.5284 | 0.5291 | 0.5268 | 0.527 | 14273112.0 |
| 2004-07-14 11:45:00 | AAPL | Stock | 0.5268 | 0.5273 | 0.5264 | 0.5266 | 3789184.0 |
| 2004-07-14 11:50:00 | AAPL | Stock | 0.5264 | 0.5264 | 0.525 | 0.5257 | 3853864.0 |
| 2004-07-14 11:55:00 | AAPL | Stock | 0.5257 | 0.5263 | 0.5254 | 0.5263 | 3381000.0 |
| 2004-07-14 12:00:00 | AAPL | Stock | 0.5263 | 0.5268 | 0.5254 | 0.5264 | 7036120.0 |
| 2004-07-14 12:05:00 | AAPL | Stock | 0.5263 | 0.5271 | 0.5263 | 0.5271 | 7197232.0 |
| 2004-07-14 12:10:00 | AAPL | Stock | 0.5271 | 0.5302 | 0.5264 | 0.527 | 10931368.0 |
| 2004-07-14 12:15:00 | AAPL | Stock | 0.527 | 0.5298 | 0.5268 | 0.5296 | 8864464.0 |
| 2004-07-14 12:20:00 | AAPL | Stock | 0.5296 | 0.533 | 0.5295 | 0.5327 | 13054608.0 |
| 2004-07-14 12:25:00 | AAPL | Stock | 0.5327 | 0.5334 | 0.5289 | 0.5296 | 13098792.0 |
| 2004-07-14 12:30:00 | AAPL | Stock | 0.5296 | 0.5296 | 0.5284 | 0.5286 | 5196800.0 |
| 2004-07-14 12:35:00 | AAPL | Stock | 0.5286 | 0.5286 | 0.5271 | 0.5273 | 10508792.0 |
| 2004-07-14 12:40:00 | AAPL | Stock | 0.5275 | 0.5279 | 0.525 | 0.525 | 21184296.0 |
| 2004-07-14 12:45:00 | AAPL | Stock | 0.525 | 0.5259 | 0.5248 | 0.5248 | 5681256.0 |
| 2004-07-14 12:50:00 | AAPL | Stock | 0.5248 | 0.5255 | 0.5232 | 0.5248 | 10797248.0 |
| 2004-07-14 12:55:00 | AAPL | Stock | 0.525 | 0.5261 | 0.5248 | 0.5257 | 2737000.0 |
| 2004-07-14 13:00:00 | AAPL | Stock | 0.5257 | 0.5263 | 0.5246 | 0.5252 | 2478840.0 |
| 2004-07-14 13:05:00 | AAPL | Stock | 0.525 | 0.5275 | 0.5248 | 0.527 | 5276600.0 |
> showing 50 of 175,454 rows — these rows as CSV