PREVIEW / stock_5min / 2006-10-09
file: by_date/stock_5min/2006/2006-10-09.parquet size: 3.1 MB rows: 224,319 symbols: 2,376
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-10-09 07:00:00 | AAPL | Stock | 2.6411 | 2.6411 | 2.6411 | 2.6411 | 2800.0 |
| 2006-10-09 08:00:00 | AAPL | Stock | 2.6411 | 2.6411 | 2.6379 | 2.6379 | 55692.0 |
| 2006-10-09 08:05:00 | AAPL | Stock | 2.6375 | 2.6379 | 2.6375 | 2.6379 | 7420.0 |
| 2006-10-09 08:10:00 | AAPL | Stock | 2.6386 | 2.6386 | 2.6386 | 2.6386 | 8400.0 |
| 2006-10-09 08:15:00 | AAPL | Stock | 2.6379 | 2.6379 | 2.6375 | 2.6375 | 114800.0 |
| 2006-10-09 08:20:00 | AAPL | Stock | 2.6375 | 2.6375 | 2.6375 | 2.6375 | 14000.0 |
| 2006-10-09 08:25:00 | AAPL | Stock | 2.6404 | 2.6425 | 2.6375 | 2.6375 | 53200.0 |
| 2006-10-09 08:30:00 | AAPL | Stock | 2.6375 | 2.6421 | 2.6375 | 2.6393 | 78400.0 |
| 2006-10-09 08:35:00 | AAPL | Stock | 2.6393 | 2.6393 | 2.6393 | 2.6393 | 22232.0 |
| 2006-10-09 08:40:00 | AAPL | Stock | 2.6421 | 2.6421 | 2.6421 | 2.6421 | 9800.0 |
| 2006-10-09 08:50:00 | AAPL | Stock | 2.6407 | 2.6407 | 2.6375 | 2.6375 | 109200.0 |
| 2006-10-09 08:55:00 | AAPL | Stock | 2.6393 | 2.6407 | 2.6393 | 2.6407 | 86800.0 |
| 2006-10-09 09:00:00 | AAPL | Stock | 2.6393 | 2.6407 | 2.6393 | 2.6393 | 157360.0 |
| 2006-10-09 09:05:00 | AAPL | Stock | 2.6382 | 2.64 | 2.6371 | 2.64 | 73276.0 |
| 2006-10-09 09:10:00 | AAPL | Stock | 2.6393 | 2.6425 | 2.6382 | 2.6389 | 82572.0 |
| 2006-10-09 09:15:00 | AAPL | Stock | 2.6375 | 2.6375 | 2.6339 | 2.635 | 82600.0 |
| 2006-10-09 09:20:00 | AAPL | Stock | 2.635 | 2.635 | 2.635 | 2.635 | 47600.0 |
| 2006-10-09 09:25:00 | AAPL | Stock | 2.6364 | 2.6364 | 2.6336 | 2.6336 | 47600.0 |
| 2006-10-09 09:30:00 | AAPL | Stock | 2.6357 | 2.6389 | 2.6296 | 2.6354 | 14010808.0 |
| 2006-10-09 09:35:00 | AAPL | Stock | 2.6357 | 2.6457 | 2.6339 | 2.6429 | 14898884.0 |
| 2006-10-09 09:40:00 | AAPL | Stock | 2.6421 | 2.6425 | 2.6339 | 2.635 | 9009868.0 |
| 2006-10-09 09:45:00 | AAPL | Stock | 2.6354 | 2.6371 | 2.6268 | 2.6336 | 10358068.0 |
| 2006-10-09 09:50:00 | AAPL | Stock | 2.6339 | 2.6368 | 2.6307 | 2.6321 | 5072060.0 |
| 2006-10-09 09:55:00 | AAPL | Stock | 2.6311 | 2.6386 | 2.6261 | 2.6296 | 8552236.0 |
| 2006-10-09 10:00:00 | AAPL | Stock | 2.6289 | 2.6354 | 2.6271 | 2.6304 | 9396744.0 |
| 2006-10-09 10:05:00 | AAPL | Stock | 2.6304 | 2.6343 | 2.6264 | 2.6319 | 5809076.0 |
| 2006-10-09 10:10:00 | AAPL | Stock | 2.6321 | 2.6332 | 2.6289 | 2.6311 | 3994872.0 |
| 2006-10-09 10:15:00 | AAPL | Stock | 2.6311 | 2.6379 | 2.6311 | 2.6354 | 7668976.0 |
| 2006-10-09 10:20:00 | AAPL | Stock | 2.6357 | 2.6436 | 2.6354 | 2.6411 | 10005436.0 |
| 2006-10-09 10:25:00 | AAPL | Stock | 2.6411 | 2.6429 | 2.6339 | 2.6343 | 5339880.0 |
| 2006-10-09 10:30:00 | AAPL | Stock | 2.6346 | 2.6357 | 2.6304 | 2.6346 | 5828116.0 |
| 2006-10-09 10:35:00 | AAPL | Stock | 2.6343 | 2.64 | 2.6336 | 2.6393 | 2870392.0 |
| 2006-10-09 10:40:00 | AAPL | Stock | 2.64 | 2.64 | 2.6336 | 2.6339 | 3419780.0 |
| 2006-10-09 10:45:00 | AAPL | Stock | 2.6339 | 2.6354 | 2.6318 | 2.6339 | 3932404.0 |
| 2006-10-09 10:50:00 | AAPL | Stock | 2.6336 | 2.64 | 2.6332 | 2.64 | 4441136.0 |
| 2006-10-09 10:55:00 | AAPL | Stock | 2.64 | 2.64 | 2.6361 | 2.6364 | 3615836.0 |
| 2006-10-09 11:00:00 | AAPL | Stock | 2.6361 | 2.6371 | 2.635 | 2.6371 | 1656284.0 |
| 2006-10-09 11:05:00 | AAPL | Stock | 2.6371 | 2.6439 | 2.6364 | 2.6425 | 5765676.0 |
| 2006-10-09 11:10:00 | AAPL | Stock | 2.6429 | 2.6429 | 2.6379 | 2.6411 | 2794680.0 |
| 2006-10-09 11:15:00 | AAPL | Stock | 2.6411 | 2.6493 | 2.6407 | 2.6461 | 6307196.0 |
| 2006-10-09 11:20:00 | AAPL | Stock | 2.6461 | 2.6507 | 2.6461 | 2.6499 | 4247936.0 |
| 2006-10-09 11:25:00 | AAPL | Stock | 2.65 | 2.65 | 2.6464 | 2.6475 | 4514776.0 |
| 2006-10-09 11:30:00 | AAPL | Stock | 2.6471 | 2.6525 | 2.6464 | 2.6496 | 8391628.0 |
| 2006-10-09 11:35:00 | AAPL | Stock | 2.65 | 2.6618 | 2.6471 | 2.6604 | 10862544.0 |
| 2006-10-09 11:40:00 | AAPL | Stock | 2.6597 | 2.6611 | 2.6546 | 2.655 | 9061332.0 |
| 2006-10-09 11:45:00 | AAPL | Stock | 2.6546 | 2.6614 | 2.6546 | 2.6607 | 7162876.0 |
| 2006-10-09 11:50:00 | AAPL | Stock | 2.66 | 2.6604 | 2.6529 | 2.6536 | 4154388.0 |
| 2006-10-09 11:55:00 | AAPL | Stock | 2.6532 | 2.6536 | 2.6482 | 2.6482 | 4912376.0 |
| 2006-10-09 12:00:00 | AAPL | Stock | 2.6489 | 2.6518 | 2.6482 | 2.6489 | 1983324.0 |
| 2006-10-09 12:05:00 | AAPL | Stock | 2.6489 | 2.6546 | 2.6486 | 2.6536 | 2550632.0 |
> showing 50 of 224,319 rows — these rows as CSV