PREVIEW / stock_5min / 2006-09-19
file: by_date/stock_5min/2006/2006-09-19.parquet size: 3.1 MB rows: 227,156 symbols: 2,371
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-19 07:00:00 | AAPL | Stock | 2.6261 | 2.6261 | 2.625 | 2.625 | 11200.0 |
| 2006-09-19 07:55:00 | AAPL | Stock | 2.6282 | 2.6282 | 2.6282 | 2.6282 | 2800.0 |
| 2006-09-19 08:00:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6254 | 2.6254 | 11200.0 |
| 2006-09-19 08:05:00 | AAPL | Stock | 2.6289 | 2.6289 | 2.6286 | 2.6289 | 44800.0 |
| 2006-09-19 08:10:00 | AAPL | Stock | 2.6304 | 2.6321 | 2.6286 | 2.6286 | 30800.0 |
| 2006-09-19 08:15:00 | AAPL | Stock | 2.6314 | 2.6325 | 2.6314 | 2.6325 | 33600.0 |
| 2006-09-19 08:20:00 | AAPL | Stock | 2.6339 | 2.6339 | 2.6339 | 2.6339 | 22400.0 |
| 2006-09-19 08:25:00 | AAPL | Stock | 2.6339 | 2.6393 | 2.6339 | 2.6393 | 36400.0 |
| 2006-09-19 08:30:00 | AAPL | Stock | 2.6411 | 2.6464 | 2.6393 | 2.6457 | 372708.0 |
| 2006-09-19 08:35:00 | AAPL | Stock | 2.6457 | 2.6457 | 2.6396 | 2.6396 | 131320.0 |
| 2006-09-19 08:40:00 | AAPL | Stock | 2.6396 | 2.6396 | 2.6375 | 2.6375 | 90720.0 |
| 2006-09-19 08:45:00 | AAPL | Stock | 2.6368 | 2.6375 | 2.6339 | 2.6339 | 279720.0 |
| 2006-09-19 08:50:00 | AAPL | Stock | 2.6339 | 2.6414 | 2.6339 | 2.6414 | 82572.0 |
| 2006-09-19 08:55:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6393 | 2.6393 | 28000.0 |
| 2006-09-19 09:00:00 | AAPL | Stock | 2.6418 | 2.6429 | 2.6418 | 2.6429 | 144200.0 |
| 2006-09-19 09:05:00 | AAPL | Stock | 2.6432 | 2.65 | 2.6432 | 2.6464 | 187600.0 |
| 2006-09-19 09:10:00 | AAPL | Stock | 2.6457 | 2.6471 | 2.6446 | 2.6464 | 199920.0 |
| 2006-09-19 09:15:00 | AAPL | Stock | 2.6464 | 2.6464 | 2.6429 | 2.6429 | 112000.0 |
| 2006-09-19 09:20:00 | AAPL | Stock | 2.6443 | 2.6536 | 2.6443 | 2.6518 | 685020.0 |
| 2006-09-19 09:25:00 | AAPL | Stock | 2.6479 | 2.6514 | 2.6396 | 2.6486 | 820316.0 |
| 2006-09-19 09:30:00 | AAPL | Stock | 2.6486 | 2.65 | 2.6321 | 2.6386 | 19319272.0 |
| 2006-09-19 09:35:00 | AAPL | Stock | 2.6379 | 2.6386 | 2.62 | 2.625 | 22680448.0 |
| 2006-09-19 09:40:00 | AAPL | Stock | 2.6254 | 2.6318 | 2.6196 | 2.6299 | 15574552.0 |
| 2006-09-19 09:45:00 | AAPL | Stock | 2.6282 | 2.6386 | 2.6275 | 2.6361 | 14778260.0 |
| 2006-09-19 09:50:00 | AAPL | Stock | 2.6357 | 2.6529 | 2.6357 | 2.6454 | 21385028.0 |
| 2006-09-19 09:55:00 | AAPL | Stock | 2.6454 | 2.6475 | 2.6375 | 2.6414 | 11468604.0 |
| 2006-09-19 10:00:00 | AAPL | Stock | 2.6418 | 2.6493 | 2.6379 | 2.6475 | 10235540.0 |
| 2006-09-19 10:05:00 | AAPL | Stock | 2.6475 | 2.65 | 2.6411 | 2.6439 | 10477124.0 |
| 2006-09-19 10:10:00 | AAPL | Stock | 2.6439 | 2.645 | 2.6382 | 2.6425 | 9145892.0 |
| 2006-09-19 10:15:00 | AAPL | Stock | 2.6418 | 2.6432 | 2.63 | 2.6329 | 12928188.0 |
| 2006-09-19 10:20:00 | AAPL | Stock | 2.6325 | 2.6356 | 2.6282 | 2.6346 | 8058932.0 |
| 2006-09-19 10:25:00 | AAPL | Stock | 2.635 | 2.6371 | 2.6304 | 2.6364 | 7273280.0 |
| 2006-09-19 10:30:00 | AAPL | Stock | 2.6364 | 2.6371 | 2.6271 | 2.6293 | 7937972.0 |
| 2006-09-19 10:35:00 | AAPL | Stock | 2.6293 | 2.6339 | 2.6268 | 2.6325 | 6910624.0 |
| 2006-09-19 10:40:00 | AAPL | Stock | 2.6321 | 2.6339 | 2.6296 | 2.6318 | 5272988.0 |
| 2006-09-19 10:45:00 | AAPL | Stock | 2.6311 | 2.6364 | 2.6307 | 2.6318 | 5437292.0 |
| 2006-09-19 10:50:00 | AAPL | Stock | 2.6329 | 2.6339 | 2.63 | 2.6321 | 5706008.0 |
| 2006-09-19 10:55:00 | AAPL | Stock | 2.6325 | 2.6429 | 2.6321 | 2.6404 | 9908304.0 |
| 2006-09-19 11:00:00 | AAPL | Stock | 2.64 | 2.6468 | 2.6396 | 2.6468 | 10834432.0 |
| 2006-09-19 11:05:00 | AAPL | Stock | 2.6468 | 2.6479 | 2.6446 | 2.6454 | 7908964.0 |
| 2006-09-19 11:10:00 | AAPL | Stock | 2.6454 | 2.6525 | 2.645 | 2.6496 | 14495516.0 |
| 2006-09-19 11:15:00 | AAPL | Stock | 2.6496 | 2.6557 | 2.6496 | 2.6525 | 17111024.0 |
| 2006-09-19 11:20:00 | AAPL | Stock | 2.6525 | 2.6557 | 2.6493 | 2.6511 | 9981160.0 |
| 2006-09-19 11:25:00 | AAPL | Stock | 2.6511 | 2.6514 | 2.6457 | 2.6468 | 9194080.0 |
| 2006-09-19 11:30:00 | AAPL | Stock | 2.6471 | 2.6475 | 2.6429 | 2.6457 | 10363584.0 |
| 2006-09-19 11:35:00 | AAPL | Stock | 2.6454 | 2.6464 | 2.6314 | 2.6343 | 18025252.0 |
| 2006-09-19 11:40:00 | AAPL | Stock | 2.6346 | 2.6436 | 2.625 | 2.6339 | 17488184.0 |
| 2006-09-19 11:45:00 | AAPL | Stock | 2.6339 | 2.6379 | 2.6236 | 2.6346 | 15336440.0 |
| 2006-09-19 11:50:00 | AAPL | Stock | 2.6346 | 2.635 | 2.6236 | 2.6275 | 13454868.0 |
| 2006-09-19 11:55:00 | AAPL | Stock | 2.6282 | 2.6282 | 2.6132 | 2.6232 | 23494884.0 |
> showing 50 of 227,156 rows — these rows as CSV