PREVIEW / stock_5min / 2006-09-18
file: by_date/stock_5min/2006/2006-09-18.parquet size: 3.1 MB rows: 225,757 symbols: 2,361
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-18 07:45:00 | AAPL | Stock | 2.6475 | 2.6475 | 2.6446 | 2.6446 | 5600.0 |
| 2006-09-18 08:00:00 | AAPL | Stock | 2.6432 | 2.6464 | 2.6429 | 2.6464 | 307300.0 |
| 2006-09-18 08:05:00 | AAPL | Stock | 2.6389 | 2.6443 | 2.6389 | 2.6443 | 16100.0 |
| 2006-09-18 08:10:00 | AAPL | Stock | 2.6443 | 2.6454 | 2.6354 | 2.6357 | 190120.0 |
| 2006-09-18 08:15:00 | AAPL | Stock | 2.6357 | 2.6393 | 2.6357 | 2.6393 | 122780.0 |
| 2006-09-18 08:20:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6357 | 2.6361 | 22400.0 |
| 2006-09-18 08:25:00 | AAPL | Stock | 2.6407 | 2.6407 | 2.6375 | 2.6375 | 23100.0 |
| 2006-09-18 08:30:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6357 | 2.6357 | 33880.0 |
| 2006-09-18 08:35:00 | AAPL | Stock | 2.6361 | 2.6361 | 2.6343 | 2.6343 | 26488.0 |
| 2006-09-18 08:40:00 | AAPL | Stock | 2.6357 | 2.6357 | 2.6254 | 2.6257 | 354200.0 |
| 2006-09-18 08:45:00 | AAPL | Stock | 2.6286 | 2.6286 | 2.625 | 2.6286 | 411600.0 |
| 2006-09-18 08:50:00 | AAPL | Stock | 2.6286 | 2.6318 | 2.6286 | 2.6304 | 180040.0 |
| 2006-09-18 08:55:00 | AAPL | Stock | 2.6304 | 2.6321 | 2.6293 | 2.6321 | 81900.0 |
| 2006-09-18 09:00:00 | AAPL | Stock | 2.6321 | 2.6325 | 2.6304 | 2.6321 | 146720.0 |
| 2006-09-18 09:05:00 | AAPL | Stock | 2.6321 | 2.6321 | 2.6304 | 2.6321 | 174720.0 |
| 2006-09-18 09:10:00 | AAPL | Stock | 2.6321 | 2.6357 | 2.6321 | 2.6357 | 334152.0 |
| 2006-09-18 09:15:00 | AAPL | Stock | 2.6332 | 2.6332 | 2.63 | 2.6314 | 47600.0 |
| 2006-09-18 09:20:00 | AAPL | Stock | 2.6314 | 2.6329 | 2.6307 | 2.6321 | 103628.0 |
| 2006-09-18 09:25:00 | AAPL | Stock | 2.6329 | 2.6389 | 2.6318 | 2.6357 | 293160.0 |
| 2006-09-18 09:30:00 | AAPL | Stock | 2.6357 | 2.6446 | 2.6311 | 2.6421 | 17784284.0 |
| 2006-09-18 09:35:00 | AAPL | Stock | 2.6429 | 2.6464 | 2.6304 | 2.6339 | 20844348.0 |
| 2006-09-18 09:40:00 | AAPL | Stock | 2.6336 | 2.6411 | 2.6311 | 2.6396 | 13102292.0 |
| 2006-09-18 09:45:00 | AAPL | Stock | 2.6396 | 2.64 | 2.6296 | 2.6307 | 10053820.0 |
| 2006-09-18 09:50:00 | AAPL | Stock | 2.6311 | 2.6375 | 2.6264 | 2.635 | 13253576.0 |
| 2006-09-18 09:55:00 | AAPL | Stock | 2.635 | 2.6421 | 2.6343 | 2.6361 | 12706792.0 |
| 2006-09-18 10:00:00 | AAPL | Stock | 2.6361 | 2.6364 | 2.6179 | 2.6321 | 15646708.0 |
| 2006-09-18 10:05:00 | AAPL | Stock | 2.6321 | 2.6354 | 2.6286 | 2.6346 | 9634772.0 |
| 2006-09-18 10:10:00 | AAPL | Stock | 2.6346 | 2.6368 | 2.6239 | 2.6243 | 15992368.0 |
| 2006-09-18 10:15:00 | AAPL | Stock | 2.6243 | 2.6329 | 2.6232 | 2.6243 | 15116612.0 |
| 2006-09-18 10:20:00 | AAPL | Stock | 2.6243 | 2.6332 | 2.6243 | 2.6314 | 8715504.0 |
| 2006-09-18 10:25:00 | AAPL | Stock | 2.6314 | 2.6321 | 2.6225 | 2.6261 | 7323176.0 |
| 2006-09-18 10:30:00 | AAPL | Stock | 2.6264 | 2.6296 | 2.6229 | 2.6271 | 8912624.0 |
| 2006-09-18 10:35:00 | AAPL | Stock | 2.6271 | 2.6339 | 2.6268 | 2.6318 | 9503340.0 |
| 2006-09-18 10:40:00 | AAPL | Stock | 2.6318 | 2.6375 | 2.6311 | 2.6375 | 10247972.0 |
| 2006-09-18 10:45:00 | AAPL | Stock | 2.6375 | 2.6386 | 2.6268 | 2.6296 | 9896292.0 |
| 2006-09-18 10:50:00 | AAPL | Stock | 2.6296 | 2.6325 | 2.6279 | 2.6279 | 5665688.0 |
| 2006-09-18 10:55:00 | AAPL | Stock | 2.6279 | 2.6307 | 2.625 | 2.6268 | 8066296.0 |
| 2006-09-18 11:00:00 | AAPL | Stock | 2.6268 | 2.6296 | 2.6232 | 2.6289 | 6339340.0 |
| 2006-09-18 11:05:00 | AAPL | Stock | 2.6289 | 2.6332 | 2.6264 | 2.6268 | 3603040.0 |
| 2006-09-18 11:10:00 | AAPL | Stock | 2.6268 | 2.6289 | 2.6218 | 2.6275 | 7635684.0 |
| 2006-09-18 11:15:00 | AAPL | Stock | 2.6279 | 2.6304 | 2.6261 | 2.6282 | 3139864.0 |
| 2006-09-18 11:20:00 | AAPL | Stock | 2.6282 | 2.6329 | 2.625 | 2.6261 | 6936860.0 |
| 2006-09-18 11:25:00 | AAPL | Stock | 2.6257 | 2.6332 | 2.6254 | 2.6307 | 5398316.0 |
| 2006-09-18 11:30:00 | AAPL | Stock | 2.6304 | 2.6332 | 2.6279 | 2.6311 | 6487152.0 |
| 2006-09-18 11:35:00 | AAPL | Stock | 2.631 | 2.6361 | 2.6307 | 2.6321 | 6915020.0 |
| 2006-09-18 11:40:00 | AAPL | Stock | 2.6325 | 2.6375 | 2.6321 | 2.6364 | 8470896.0 |
| 2006-09-18 11:45:00 | AAPL | Stock | 2.6361 | 2.6429 | 2.635 | 2.6407 | 12668320.0 |
| 2006-09-18 11:50:00 | AAPL | Stock | 2.6407 | 2.6468 | 2.6404 | 2.6443 | 15160012.0 |
| 2006-09-18 11:55:00 | AAPL | Stock | 2.6446 | 2.6543 | 2.6429 | 2.6507 | 13535900.0 |
| 2006-09-18 12:00:00 | AAPL | Stock | 2.65 | 2.655 | 2.6479 | 2.6518 | 8955100.0 |
> showing 50 of 225,757 rows — these rows as CSV