PREVIEW / stock_5min / 2001-07-23
file: by_date/stock_5min/2001/2001-07-23.parquet size: 1.5 MB rows: 103,951 symbols: 1,320
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-23 08:00:00 | AAPL | Stock | 0.3568 | 0.3568 | 0.3568 | 0.3568 | 672000.0 |
| 2001-07-23 08:05:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 16800.0 |
| 2001-07-23 08:15:00 | AAPL | Stock | 0.3577 | 0.3577 | 0.3577 | 0.3577 | 22400.0 |
| 2001-07-23 08:30:00 | AAPL | Stock | 0.3579 | 0.3589 | 0.3579 | 0.3579 | 67200.0 |
| 2001-07-23 08:35:00 | AAPL | Stock | 0.3607 | 0.3607 | 0.3607 | 0.3607 | 16800.0 |
| 2001-07-23 08:40:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 168000.0 |
| 2001-07-23 08:45:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3589 | 0.3589 | 56000.0 |
| 2001-07-23 08:55:00 | AAPL | Stock | 0.3584 | 0.3584 | 0.3584 | 0.3584 | 16800.0 |
| 2001-07-23 09:00:00 | AAPL | Stock | 0.3588 | 0.3588 | 0.3571 | 0.3571 | 268800.0 |
| 2001-07-23 09:05:00 | AAPL | Stock | 0.3588 | 0.3588 | 0.3586 | 0.3586 | 28000.0 |
| 2001-07-23 09:25:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3584 | 0.3586 | 190400.0 |
| 2001-07-23 09:30:00 | AAPL | Stock | 0.3588 | 0.3589 | 0.3563 | 0.3564 | 9973600.0 |
| 2001-07-23 09:35:00 | AAPL | Stock | 0.3568 | 0.3616 | 0.3566 | 0.3614 | 7644000.0 |
| 2001-07-23 09:40:00 | AAPL | Stock | 0.3614 | 0.3652 | 0.36 | 0.3646 | 5258400.0 |
| 2001-07-23 09:45:00 | AAPL | Stock | 0.3643 | 0.3661 | 0.3643 | 0.3643 | 5566400.0 |
| 2001-07-23 09:50:00 | AAPL | Stock | 0.3643 | 0.3654 | 0.3575 | 0.3586 | 5712000.0 |
| 2001-07-23 09:55:00 | AAPL | Stock | 0.3596 | 0.3618 | 0.3582 | 0.3586 | 2996000.0 |
| 2001-07-23 10:00:00 | AAPL | Stock | 0.3589 | 0.3605 | 0.3586 | 0.3602 | 6193600.0 |
| 2001-07-23 10:05:00 | AAPL | Stock | 0.3602 | 0.3604 | 0.3571 | 0.3573 | 3320800.0 |
| 2001-07-23 10:10:00 | AAPL | Stock | 0.3571 | 0.3586 | 0.357 | 0.3571 | 5964000.0 |
| 2001-07-23 10:15:00 | AAPL | Stock | 0.3573 | 0.3577 | 0.3555 | 0.3555 | 6395200.0 |
| 2001-07-23 10:20:00 | AAPL | Stock | 0.3554 | 0.3559 | 0.3545 | 0.3545 | 3925600.0 |
| 2001-07-23 10:25:00 | AAPL | Stock | 0.3546 | 0.355 | 0.3534 | 0.3536 | 1842400.0 |
| 2001-07-23 10:30:00 | AAPL | Stock | 0.3536 | 0.3546 | 0.3527 | 0.3534 | 3651200.0 |
| 2001-07-23 10:35:00 | AAPL | Stock | 0.3534 | 0.3543 | 0.3529 | 0.3543 | 1680000.0 |
| 2001-07-23 10:40:00 | AAPL | Stock | 0.3538 | 0.3564 | 0.35 | 0.3505 | 6966400.0 |
| 2001-07-23 10:45:00 | AAPL | Stock | 0.3502 | 0.3527 | 0.3496 | 0.3502 | 6025600.0 |
| 2001-07-23 10:50:00 | AAPL | Stock | 0.3502 | 0.3525 | 0.3496 | 0.3513 | 3522400.0 |
| 2001-07-23 10:55:00 | AAPL | Stock | 0.3518 | 0.3527 | 0.3504 | 0.3507 | 1657600.0 |
| 2001-07-23 11:00:00 | AAPL | Stock | 0.3505 | 0.3518 | 0.3498 | 0.3516 | 2105600.0 |
| 2001-07-23 11:05:00 | AAPL | Stock | 0.3516 | 0.3541 | 0.35 | 0.3534 | 3824800.0 |
| 2001-07-23 11:10:00 | AAPL | Stock | 0.3536 | 0.3545 | 0.3521 | 0.3523 | 7145600.0 |
| 2001-07-23 11:15:00 | AAPL | Stock | 0.3529 | 0.3539 | 0.3511 | 0.3516 | 12392800.0 |
| 2001-07-23 11:20:00 | AAPL | Stock | 0.3511 | 0.3527 | 0.3498 | 0.3525 | 3421600.0 |
| 2001-07-23 11:25:00 | AAPL | Stock | 0.3523 | 0.3527 | 0.3513 | 0.3521 | 1551200.0 |
| 2001-07-23 11:30:00 | AAPL | Stock | 0.3525 | 0.3543 | 0.3518 | 0.3525 | 2475200.0 |
| 2001-07-23 11:35:00 | AAPL | Stock | 0.3532 | 0.3536 | 0.3525 | 0.3527 | 1036000.0 |
| 2001-07-23 11:40:00 | AAPL | Stock | 0.3527 | 0.3534 | 0.3525 | 0.3527 | 935200.0 |
| 2001-07-23 11:45:00 | AAPL | Stock | 0.3527 | 0.3539 | 0.3527 | 0.3534 | 1024800.0 |
| 2001-07-23 11:50:00 | AAPL | Stock | 0.3539 | 0.3539 | 0.3529 | 0.3529 | 224000.0 |
| 2001-07-23 11:55:00 | AAPL | Stock | 0.3529 | 0.3539 | 0.3527 | 0.3536 | 543200.0 |
| 2001-07-23 12:00:00 | AAPL | Stock | 0.3536 | 0.3538 | 0.353 | 0.3534 | 582400.0 |
| 2001-07-23 12:05:00 | AAPL | Stock | 0.3538 | 0.3539 | 0.3527 | 0.3538 | 1164800.0 |
| 2001-07-23 12:10:00 | AAPL | Stock | 0.3538 | 0.3541 | 0.3523 | 0.3538 | 1517600.0 |
| 2001-07-23 12:15:00 | AAPL | Stock | 0.3539 | 0.3543 | 0.353 | 0.3543 | 907200.0 |
| 2001-07-23 12:20:00 | AAPL | Stock | 0.3546 | 0.3546 | 0.3538 | 0.3543 | 543200.0 |
| 2001-07-23 12:25:00 | AAPL | Stock | 0.3543 | 0.3545 | 0.3538 | 0.3545 | 756000.0 |
| 2001-07-23 12:30:00 | AAPL | Stock | 0.3538 | 0.3552 | 0.3538 | 0.3541 | 4743200.0 |
| 2001-07-23 12:35:00 | AAPL | Stock | 0.3541 | 0.3554 | 0.3541 | 0.3554 | 2016000.0 |
| 2001-07-23 12:40:00 | AAPL | Stock | 0.3546 | 0.3564 | 0.3546 | 0.3557 | 2178400.0 |
> showing 50 of 103,951 rows — these rows as CSV