PREVIEW / stock_5min / 2003-10-01
file: by_date/stock_5min/2003/2003-10-01.parquet size: 2.2 MB rows: 161,413 symbols: 1,632
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-10-01 08:35:00 | AAPL | Stock | 0.3695 | 0.3695 | 0.3695 | 0.3695 | 5600.0 |
| 2003-10-01 08:50:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3702 | 0.3702 | 5600.0 |
| 2003-10-01 08:55:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3702 | 0.3702 | 22400.0 |
| 2003-10-01 09:00:00 | AAPL | Stock | 0.3702 | 0.3702 | 0.3702 | 0.3702 | 106400.0 |
| 2003-10-01 09:25:00 | AAPL | Stock | 0.3695 | 0.3705 | 0.3695 | 0.3705 | 22400.0 |
| 2003-10-01 09:30:00 | AAPL | Stock | 0.3698 | 0.3768 | 0.3698 | 0.3763 | 4683616.0 |
| 2003-10-01 09:35:00 | AAPL | Stock | 0.3759 | 0.3763 | 0.3721 | 0.3721 | 1912008.0 |
| 2003-10-01 09:40:00 | AAPL | Stock | 0.3718 | 0.3734 | 0.3707 | 0.3723 | 3880184.0 |
| 2003-10-01 09:45:00 | AAPL | Stock | 0.3725 | 0.3727 | 0.3709 | 0.3714 | 2533160.0 |
| 2003-10-01 09:50:00 | AAPL | Stock | 0.3714 | 0.3736 | 0.3714 | 0.372 | 2472680.0 |
| 2003-10-01 09:55:00 | AAPL | Stock | 0.372 | 0.3725 | 0.3714 | 0.3714 | 3444000.0 |
| 2003-10-01 10:00:00 | AAPL | Stock | 0.3714 | 0.3734 | 0.3709 | 0.3725 | 11359600.0 |
| 2003-10-01 10:05:00 | AAPL | Stock | 0.3728 | 0.3729 | 0.3716 | 0.3718 | 1430464.0 |
| 2003-10-01 10:10:00 | AAPL | Stock | 0.3718 | 0.372 | 0.37 | 0.3714 | 3142328.0 |
| 2003-10-01 10:15:00 | AAPL | Stock | 0.3713 | 0.372 | 0.3707 | 0.3713 | 3691688.0 |
| 2003-10-01 10:20:00 | AAPL | Stock | 0.3714 | 0.3714 | 0.37 | 0.3702 | 4564000.0 |
| 2003-10-01 10:25:00 | AAPL | Stock | 0.37 | 0.3707 | 0.3686 | 0.3693 | 2891000.0 |
| 2003-10-01 10:30:00 | AAPL | Stock | 0.3696 | 0.3696 | 0.3691 | 0.3693 | 2245544.0 |
| 2003-10-01 10:35:00 | AAPL | Stock | 0.3693 | 0.3698 | 0.3675 | 0.3677 | 3647840.0 |
| 2003-10-01 10:40:00 | AAPL | Stock | 0.3673 | 0.3688 | 0.367 | 0.3677 | 5125120.0 |
| 2003-10-01 10:45:00 | AAPL | Stock | 0.3677 | 0.3677 | 0.3632 | 0.3652 | 5574688.0 |
| 2003-10-01 10:50:00 | AAPL | Stock | 0.3652 | 0.3675 | 0.3652 | 0.3675 | 2304008.0 |
| 2003-10-01 10:55:00 | AAPL | Stock | 0.367 | 0.3675 | 0.3625 | 0.3625 | 4195016.0 |
| 2003-10-01 11:00:00 | AAPL | Stock | 0.3629 | 0.3639 | 0.3605 | 0.3639 | 13361096.0 |
| 2003-10-01 11:05:00 | AAPL | Stock | 0.3638 | 0.3648 | 0.3634 | 0.3643 | 4649176.0 |
| 2003-10-01 11:10:00 | AAPL | Stock | 0.3645 | 0.3646 | 0.3641 | 0.3643 | 795200.0 |
| 2003-10-01 11:15:00 | AAPL | Stock | 0.3643 | 0.3643 | 0.3641 | 0.3643 | 2329600.0 |
| 2003-10-01 11:20:00 | AAPL | Stock | 0.3641 | 0.3643 | 0.3639 | 0.3639 | 785568.0 |
| 2003-10-01 11:25:00 | AAPL | Stock | 0.3638 | 0.3659 | 0.3638 | 0.3659 | 4508000.0 |
| 2003-10-01 11:30:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3657 | 0.3661 | 1142008.0 |
| 2003-10-01 11:35:00 | AAPL | Stock | 0.3663 | 0.3673 | 0.3661 | 0.367 | 2268840.0 |
| 2003-10-01 11:40:00 | AAPL | Stock | 0.367 | 0.367 | 0.3657 | 0.3657 | 912464.0 |
| 2003-10-01 11:45:00 | AAPL | Stock | 0.3657 | 0.3661 | 0.3657 | 0.3661 | 1514464.0 |
| 2003-10-01 11:50:00 | AAPL | Stock | 0.3668 | 0.3668 | 0.3654 | 0.3654 | 526400.0 |
| 2003-10-01 11:55:00 | AAPL | Stock | 0.3654 | 0.367 | 0.3654 | 0.3668 | 3252032.0 |
| 2003-10-01 12:00:00 | AAPL | Stock | 0.367 | 0.367 | 0.3657 | 0.3657 | 257600.0 |
| 2003-10-01 12:05:00 | AAPL | Stock | 0.3661 | 0.367 | 0.3659 | 0.3666 | 319816.0 |
| 2003-10-01 12:10:00 | AAPL | Stock | 0.3664 | 0.3679 | 0.3664 | 0.3679 | 2382576.0 |
| 2003-10-01 12:15:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3671 | 0.3679 | 1573768.0 |
| 2003-10-01 12:20:00 | AAPL | Stock | 0.3679 | 0.368 | 0.3672 | 0.3679 | 1484000.0 |
| 2003-10-01 12:25:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3675 | 0.3679 | 588000.0 |
| 2003-10-01 12:30:00 | AAPL | Stock | 0.3679 | 0.3684 | 0.3679 | 0.3682 | 1691200.0 |
| 2003-10-01 12:35:00 | AAPL | Stock | 0.3682 | 0.3684 | 0.368 | 0.3684 | 1684256.0 |
| 2003-10-01 12:40:00 | AAPL | Stock | 0.3684 | 0.3686 | 0.3675 | 0.3677 | 1786400.0 |
| 2003-10-01 12:45:00 | AAPL | Stock | 0.3677 | 0.3679 | 0.3677 | 0.3679 | 296800.0 |
| 2003-10-01 12:50:00 | AAPL | Stock | 0.3679 | 0.3679 | 0.3677 | 0.3677 | 443408.0 |
| 2003-10-01 12:55:00 | AAPL | Stock | 0.3678 | 0.3679 | 0.3677 | 0.3677 | 2009896.0 |
| 2003-10-01 13:00:00 | AAPL | Stock | 0.3677 | 0.3682 | 0.3675 | 0.3681 | 3718400.0 |
| 2003-10-01 13:05:00 | AAPL | Stock | 0.368 | 0.3684 | 0.3679 | 0.3684 | 855064.0 |
| 2003-10-01 13:10:00 | AAPL | Stock | 0.3684 | 0.3686 | 0.3679 | 0.3679 | 1186752.0 |
> showing 50 of 161,413 rows — these rows as CSV