PREVIEW / stock_5min / 2005-02-23
file: by_date/stock_5min/2005/2005-02-23.parquet size: 2.7 MB rows: 194,291 symbols: 1,939
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 |
|---|---|---|---|---|---|---|---|
| 2005-02-23 08:00:00 | AAPL | Stock | 1.5241 | 1.5268 | 1.5241 | 1.525 | 510104.0 |
| 2005-02-23 08:05:00 | AAPL | Stock | 1.525 | 1.525 | 1.5243 | 1.525 | 317016.0 |
| 2005-02-23 08:10:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5243 | 1.5243 | 187600.0 |
| 2005-02-23 08:15:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.525 | 1.5268 | 140000.0 |
| 2005-02-23 08:20:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5259 | 1.5259 | 169848.0 |
| 2005-02-23 08:25:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5255 | 1.5255 | 35840.0 |
| 2005-02-23 08:30:00 | AAPL | Stock | 1.5268 | 1.5429 | 1.5255 | 1.5411 | 3567200.0 |
| 2005-02-23 08:35:00 | AAPL | Stock | 1.5411 | 1.5443 | 1.5386 | 1.5411 | 2801400.0 |
| 2005-02-23 08:40:00 | AAPL | Stock | 1.5418 | 1.5425 | 1.5386 | 1.5393 | 741048.0 |
| 2005-02-23 08:45:00 | AAPL | Stock | 1.5386 | 1.5411 | 1.5384 | 1.5398 | 300720.0 |
| 2005-02-23 08:50:00 | AAPL | Stock | 1.5402 | 1.5411 | 1.5375 | 1.5411 | 956928.0 |
| 2005-02-23 08:55:00 | AAPL | Stock | 1.5405 | 1.5418 | 1.5393 | 1.5409 | 418656.0 |
| 2005-02-23 09:00:00 | AAPL | Stock | 1.5393 | 1.5418 | 1.523 | 1.5404 | 429184.0 |
| 2005-02-23 09:05:00 | AAPL | Stock | 1.5411 | 1.5464 | 1.5411 | 1.5452 | 2273600.0 |
| 2005-02-23 09:10:00 | AAPL | Stock | 1.5459 | 1.5488 | 1.5438 | 1.5488 | 2140880.0 |
| 2005-02-23 09:15:00 | AAPL | Stock | 1.5493 | 1.5496 | 1.5475 | 1.5482 | 1484000.0 |
| 2005-02-23 09:20:00 | AAPL | Stock | 1.548 | 1.5488 | 1.5457 | 1.547 | 882280.0 |
| 2005-02-23 09:25:00 | AAPL | Stock | 1.5364 | 1.5496 | 1.5286 | 1.5484 | 1897952.0 |
| 2005-02-23 09:30:00 | AAPL | Stock | 1.5486 | 1.5536 | 1.5429 | 1.5464 | 46462360.0 |
| 2005-02-23 09:35:00 | AAPL | Stock | 1.5466 | 1.548 | 1.5364 | 1.5395 | 35251664.0 |
| 2005-02-23 09:40:00 | AAPL | Stock | 1.5393 | 1.548 | 1.5391 | 1.5471 | 20277936.0 |
| 2005-02-23 09:45:00 | AAPL | Stock | 1.5468 | 1.5493 | 1.5366 | 1.5371 | 20842808.0 |
| 2005-02-23 09:50:00 | AAPL | Stock | 1.5379 | 1.5414 | 1.5348 | 1.5355 | 22564136.0 |
| 2005-02-23 09:55:00 | AAPL | Stock | 1.5352 | 1.5375 | 1.5277 | 1.5336 | 31847312.0 |
| 2005-02-23 10:00:00 | AAPL | Stock | 1.5336 | 1.5396 | 1.5327 | 1.533 | 20233976.0 |
| 2005-02-23 10:05:00 | AAPL | Stock | 1.5336 | 1.5384 | 1.5327 | 1.5355 | 16498216.0 |
| 2005-02-23 10:10:00 | AAPL | Stock | 1.5357 | 1.5461 | 1.5343 | 1.545 | 24798368.0 |
| 2005-02-23 10:15:00 | AAPL | Stock | 1.545 | 1.5466 | 1.5375 | 1.545 | 24660608.0 |
| 2005-02-23 10:20:00 | AAPL | Stock | 1.545 | 1.5554 | 1.5438 | 1.5507 | 38908520.0 |
| 2005-02-23 10:25:00 | AAPL | Stock | 1.5505 | 1.5541 | 1.5491 | 1.5507 | 23282896.0 |
| 2005-02-23 10:30:00 | AAPL | Stock | 1.5507 | 1.5575 | 1.5497 | 1.5548 | 31089128.0 |
| 2005-02-23 10:35:00 | AAPL | Stock | 1.5548 | 1.5554 | 1.5518 | 1.5554 | 20954136.0 |
| 2005-02-23 10:40:00 | AAPL | Stock | 1.5555 | 1.5561 | 1.5505 | 1.5513 | 20582576.0 |
| 2005-02-23 10:45:00 | AAPL | Stock | 1.5511 | 1.5546 | 1.5505 | 1.5532 | 13918464.0 |
| 2005-02-23 10:50:00 | AAPL | Stock | 1.5525 | 1.5525 | 1.545 | 1.545 | 21561904.0 |
| 2005-02-23 10:55:00 | AAPL | Stock | 1.545 | 1.5527 | 1.5446 | 1.5514 | 18829384.0 |
| 2005-02-23 11:00:00 | AAPL | Stock | 1.5514 | 1.5575 | 1.5509 | 1.5564 | 24791368.0 |
| 2005-02-23 11:05:00 | AAPL | Stock | 1.5564 | 1.567 | 1.5554 | 1.5628 | 42977648.0 |
| 2005-02-23 11:10:00 | AAPL | Stock | 1.563 | 1.5652 | 1.56 | 1.5602 | 24950800.0 |
| 2005-02-23 11:15:00 | AAPL | Stock | 1.5602 | 1.5673 | 1.5598 | 1.5657 | 29147104.0 |
| 2005-02-23 11:20:00 | AAPL | Stock | 1.5657 | 1.5695 | 1.5638 | 1.5686 | 18589368.0 |
| 2005-02-23 11:25:00 | AAPL | Stock | 1.5682 | 1.5696 | 1.5655 | 1.5664 | 18360608.0 |
| 2005-02-23 11:30:00 | AAPL | Stock | 1.5664 | 1.5705 | 1.565 | 1.5695 | 24759896.0 |
| 2005-02-23 11:35:00 | AAPL | Stock | 1.5695 | 1.5723 | 1.568 | 1.5711 | 22545768.0 |
| 2005-02-23 11:40:00 | AAPL | Stock | 1.5711 | 1.5745 | 1.5707 | 1.573 | 20882680.0 |
| 2005-02-23 11:45:00 | AAPL | Stock | 1.573 | 1.573 | 1.5671 | 1.5688 | 16708216.0 |
| 2005-02-23 11:50:00 | AAPL | Stock | 1.5688 | 1.5704 | 1.5659 | 1.57 | 19231296.0 |
| 2005-02-23 11:55:00 | AAPL | Stock | 1.57 | 1.5743 | 1.5679 | 1.5734 | 13991320.0 |
| 2005-02-23 12:00:00 | AAPL | Stock | 1.5734 | 1.5734 | 1.5684 | 1.5684 | 9231936.0 |
| 2005-02-23 12:05:00 | AAPL | Stock | 1.5689 | 1.5714 | 1.5686 | 1.5707 | 7292768.0 |
> showing 50 of 194,291 rows — these rows as CSV