PREVIEW / stock_5min / 2003-11-21
file: by_date/stock_5min/2003/2003-11-21.parquet size: 2.2 MB rows: 161,326 symbols: 1,661
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-21 08:05:00 | AAPL | Stock | 0.3639 | 0.3639 | 0.3639 | 0.3639 | 33600.0 |
| 2003-11-21 08:10:00 | AAPL | Stock | 0.3791 | 0.3793 | 0.3636 | 0.3643 | 376936.0 |
| 2003-11-21 08:15:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3643 | 0.3643 | 134400.0 |
| 2003-11-21 08:20:00 | AAPL | Stock | 0.367 | 0.3696 | 0.367 | 0.3696 | 28000.0 |
| 2003-11-21 09:05:00 | AAPL | Stock | 0.3618 | 0.3618 | 0.3618 | 0.3618 | 716800.0 |
| 2003-11-21 09:25:00 | AAPL | Stock | 0.3632 | 0.3679 | 0.3632 | 0.3659 | 1754480.0 |
| 2003-11-21 09:30:00 | AAPL | Stock | 0.3632 | 0.3675 | 0.3632 | 0.3642 | 9548560.0 |
| 2003-11-21 09:35:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3625 | 0.3632 | 2808120.0 |
| 2003-11-21 09:40:00 | AAPL | Stock | 0.363 | 0.363 | 0.3607 | 0.3607 | 2805712.0 |
| 2003-11-21 09:45:00 | AAPL | Stock | 0.3607 | 0.3609 | 0.36 | 0.3607 | 5032552.0 |
| 2003-11-21 09:50:00 | AAPL | Stock | 0.3607 | 0.3621 | 0.3605 | 0.3618 | 2625784.0 |
| 2003-11-21 09:55:00 | AAPL | Stock | 0.3618 | 0.3625 | 0.3616 | 0.3616 | 1358336.0 |
| 2003-11-21 10:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3609 | 0.3609 | 1482432.0 |
| 2003-11-21 10:05:00 | AAPL | Stock | 0.3607 | 0.3613 | 0.3606 | 0.3613 | 1061256.0 |
| 2003-11-21 10:10:00 | AAPL | Stock | 0.3614 | 0.3614 | 0.3596 | 0.3604 | 2037560.0 |
| 2003-11-21 10:15:00 | AAPL | Stock | 0.36 | 0.3604 | 0.3596 | 0.3598 | 935928.0 |
| 2003-11-21 10:20:00 | AAPL | Stock | 0.3598 | 0.3604 | 0.3595 | 0.36 | 1849960.0 |
| 2003-11-21 10:25:00 | AAPL | Stock | 0.36 | 0.3613 | 0.3596 | 0.3609 | 2539880.0 |
| 2003-11-21 10:30:00 | AAPL | Stock | 0.3609 | 0.3611 | 0.3598 | 0.3602 | 1024968.0 |
| 2003-11-21 10:35:00 | AAPL | Stock | 0.3604 | 0.3605 | 0.3566 | 0.3577 | 8918336.0 |
| 2003-11-21 10:40:00 | AAPL | Stock | 0.3573 | 0.3577 | 0.3545 | 0.3564 | 13289080.0 |
| 2003-11-21 10:45:00 | AAPL | Stock | 0.3561 | 0.3564 | 0.3552 | 0.3561 | 5433512.0 |
| 2003-11-21 10:50:00 | AAPL | Stock | 0.3564 | 0.3571 | 0.3555 | 0.3563 | 2696904.0 |
| 2003-11-21 10:55:00 | AAPL | Stock | 0.3563 | 0.3573 | 0.3563 | 0.3571 | 887376.0 |
| 2003-11-21 11:00:00 | AAPL | Stock | 0.3573 | 0.3591 | 0.3571 | 0.3586 | 4577608.0 |
| 2003-11-21 11:05:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3582 | 0.3584 | 1883840.0 |
| 2003-11-21 11:10:00 | AAPL | Stock | 0.3586 | 0.3589 | 0.3584 | 0.3589 | 1700440.0 |
| 2003-11-21 11:15:00 | AAPL | Stock | 0.3589 | 0.3598 | 0.3588 | 0.3596 | 4313736.0 |
| 2003-11-21 11:20:00 | AAPL | Stock | 0.3598 | 0.3604 | 0.3593 | 0.3596 | 6577872.0 |
| 2003-11-21 11:25:00 | AAPL | Stock | 0.3596 | 0.3604 | 0.3593 | 0.3598 | 1402184.0 |
| 2003-11-21 11:30:00 | AAPL | Stock | 0.36 | 0.3616 | 0.3595 | 0.3616 | 4149768.0 |
| 2003-11-21 11:35:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3609 | 0.3616 | 5560296.0 |
| 2003-11-21 11:40:00 | AAPL | Stock | 0.3614 | 0.3623 | 0.3614 | 0.3618 | 8054368.0 |
| 2003-11-21 11:45:00 | AAPL | Stock | 0.362 | 0.3621 | 0.3613 | 0.3614 | 3697064.0 |
| 2003-11-21 11:50:00 | AAPL | Stock | 0.3613 | 0.3614 | 0.3602 | 0.3602 | 2745400.0 |
| 2003-11-21 11:55:00 | AAPL | Stock | 0.3602 | 0.3607 | 0.3595 | 0.36 | 1719256.0 |
| 2003-11-21 12:00:00 | AAPL | Stock | 0.3598 | 0.3601 | 0.3593 | 0.3598 | 1357608.0 |
| 2003-11-21 12:05:00 | AAPL | Stock | 0.3599 | 0.36 | 0.3593 | 0.3595 | 5258400.0 |
| 2003-11-21 12:10:00 | AAPL | Stock | 0.3593 | 0.3596 | 0.3591 | 0.3593 | 1926400.0 |
| 2003-11-21 12:15:00 | AAPL | Stock | 0.3593 | 0.3596 | 0.3593 | 0.3595 | 393120.0 |
| 2003-11-21 12:20:00 | AAPL | Stock | 0.3596 | 0.3596 | 0.3591 | 0.3593 | 2699200.0 |
| 2003-11-21 12:25:00 | AAPL | Stock | 0.3593 | 0.3596 | 0.3588 | 0.3596 | 1925168.0 |
| 2003-11-21 12:30:00 | AAPL | Stock | 0.3595 | 0.36 | 0.3595 | 0.3596 | 575344.0 |
| 2003-11-21 12:35:00 | AAPL | Stock | 0.3595 | 0.3598 | 0.3593 | 0.3595 | 453544.0 |
| 2003-11-21 12:40:00 | AAPL | Stock | 0.3596 | 0.3596 | 0.3588 | 0.3588 | 675920.0 |
| 2003-11-21 12:45:00 | AAPL | Stock | 0.3588 | 0.3596 | 0.3588 | 0.3596 | 1711920.0 |
| 2003-11-21 12:50:00 | AAPL | Stock | 0.3598 | 0.3605 | 0.3595 | 0.3604 | 1471960.0 |
| 2003-11-21 12:55:00 | AAPL | Stock | 0.3602 | 0.3611 | 0.3602 | 0.3611 | 941808.0 |
| 2003-11-21 13:00:00 | AAPL | Stock | 0.3611 | 0.3613 | 0.3604 | 0.3611 | 2322488.0 |
| 2003-11-21 13:05:00 | AAPL | Stock | 0.3611 | 0.3623 | 0.3611 | 0.3621 | 6426112.0 |
> showing 50 of 161,326 rows — these rows as CSV