PREVIEW / stock_5min / 2005-06-22
file: by_date/stock_5min/2005/2005-06-22.parquet size: 2.7 MB rows: 198,612 symbols: 1,993
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-06-22 08:00:00 | AAPL | Stock | 1.3661 | 1.3675 | 1.3643 | 1.3643 | 313936.0 |
| 2005-06-22 08:05:00 | AAPL | Stock | 1.3632 | 1.3643 | 1.3632 | 1.3643 | 51800.0 |
| 2005-06-22 08:10:00 | AAPL | Stock | 1.3639 | 1.3639 | 1.3625 | 1.3625 | 29400.0 |
| 2005-06-22 08:15:00 | AAPL | Stock | 1.3625 | 1.3625 | 1.3625 | 1.3625 | 60200.0 |
| 2005-06-22 08:20:00 | AAPL | Stock | 1.3632 | 1.3636 | 1.3625 | 1.3636 | 29400.0 |
| 2005-06-22 08:25:00 | AAPL | Stock | 1.3629 | 1.3629 | 1.3629 | 1.3629 | 2800.0 |
| 2005-06-22 08:30:00 | AAPL | Stock | 1.3636 | 1.3664 | 1.3636 | 1.3661 | 209020.0 |
| 2005-06-22 08:35:00 | AAPL | Stock | 1.3679 | 1.3743 | 1.3675 | 1.3732 | 518868.0 |
| 2005-06-22 08:40:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3714 | 1.3714 | 319200.0 |
| 2005-06-22 08:45:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3696 | 1.3714 | 239400.0 |
| 2005-06-22 08:50:00 | AAPL | Stock | 1.3714 | 1.3732 | 1.3714 | 1.3729 | 285600.0 |
| 2005-06-22 08:55:00 | AAPL | Stock | 1.3732 | 1.375 | 1.3729 | 1.3743 | 289632.0 |
| 2005-06-22 09:00:00 | AAPL | Stock | 1.375 | 1.3757 | 1.3743 | 1.3746 | 219296.0 |
| 2005-06-22 09:05:00 | AAPL | Stock | 1.3746 | 1.3764 | 1.3743 | 1.375 | 397096.0 |
| 2005-06-22 09:10:00 | AAPL | Stock | 1.3743 | 1.3754 | 1.3725 | 1.3725 | 137200.0 |
| 2005-06-22 09:15:00 | AAPL | Stock | 1.3729 | 1.3754 | 1.352 | 1.3736 | 290304.0 |
| 2005-06-22 09:20:00 | AAPL | Stock | 1.3746 | 1.3746 | 1.3732 | 1.3732 | 2876188.0 |
| 2005-06-22 09:25:00 | AAPL | Stock | 1.3704 | 1.3746 | 1.3668 | 1.3679 | 1303120.0 |
| 2005-06-22 09:30:00 | AAPL | Stock | 1.3664 | 1.3739 | 1.365 | 1.3736 | 17310160.0 |
| 2005-06-22 09:35:00 | AAPL | Stock | 1.3736 | 1.3746 | 1.3668 | 1.3672 | 14239176.0 |
| 2005-06-22 09:40:00 | AAPL | Stock | 1.3671 | 1.3718 | 1.3668 | 1.3696 | 8725276.0 |
| 2005-06-22 09:45:00 | AAPL | Stock | 1.3696 | 1.3714 | 1.3679 | 1.369 | 9357964.0 |
| 2005-06-22 09:50:00 | AAPL | Stock | 1.3693 | 1.3704 | 1.3654 | 1.37 | 13137600.0 |
| 2005-06-22 09:55:00 | AAPL | Stock | 1.3704 | 1.3725 | 1.3675 | 1.3689 | 8545824.0 |
| 2005-06-22 10:00:00 | AAPL | Stock | 1.3682 | 1.3696 | 1.3675 | 1.3682 | 7331940.0 |
| 2005-06-22 10:05:00 | AAPL | Stock | 1.3682 | 1.3689 | 1.3661 | 1.3679 | 8192464.0 |
| 2005-06-22 10:10:00 | AAPL | Stock | 1.3675 | 1.3721 | 1.3661 | 1.3711 | 10731112.0 |
| 2005-06-22 10:15:00 | AAPL | Stock | 1.3711 | 1.3732 | 1.3689 | 1.3732 | 5702228.0 |
| 2005-06-22 10:20:00 | AAPL | Stock | 1.3732 | 1.375 | 1.3718 | 1.3736 | 11195184.0 |
| 2005-06-22 10:25:00 | AAPL | Stock | 1.3736 | 1.3736 | 1.3707 | 1.3711 | 4663120.0 |
| 2005-06-22 10:30:00 | AAPL | Stock | 1.3707 | 1.375 | 1.3696 | 1.375 | 8592444.0 |
| 2005-06-22 10:35:00 | AAPL | Stock | 1.3746 | 1.3786 | 1.3746 | 1.3782 | 13380836.0 |
| 2005-06-22 10:40:00 | AAPL | Stock | 1.3782 | 1.3782 | 1.375 | 1.375 | 6786528.0 |
| 2005-06-22 10:45:00 | AAPL | Stock | 1.375 | 1.3757 | 1.3711 | 1.3714 | 7864108.0 |
| 2005-06-22 10:50:00 | AAPL | Stock | 1.3714 | 1.3718 | 1.3668 | 1.3704 | 10106544.0 |
| 2005-06-22 10:55:00 | AAPL | Stock | 1.3704 | 1.3707 | 1.3664 | 1.3696 | 7618156.0 |
| 2005-06-22 11:00:00 | AAPL | Stock | 1.3696 | 1.3704 | 1.3675 | 1.3682 | 6753012.0 |
| 2005-06-22 11:05:00 | AAPL | Stock | 1.3675 | 1.3682 | 1.3643 | 1.3668 | 10452988.0 |
| 2005-06-22 11:10:00 | AAPL | Stock | 1.3671 | 1.3693 | 1.365 | 1.3657 | 3830344.0 |
| 2005-06-22 11:15:00 | AAPL | Stock | 1.3654 | 1.3668 | 1.3621 | 1.3646 | 6766536.0 |
| 2005-06-22 11:20:00 | AAPL | Stock | 1.3643 | 1.3654 | 1.3636 | 1.3643 | 4644136.0 |
| 2005-06-22 11:25:00 | AAPL | Stock | 1.3646 | 1.3667 | 1.3636 | 1.3646 | 4613672.0 |
| 2005-06-22 11:30:00 | AAPL | Stock | 1.3646 | 1.3654 | 1.3632 | 1.365 | 3877020.0 |
| 2005-06-22 11:35:00 | AAPL | Stock | 1.365 | 1.3675 | 1.3636 | 1.3664 | 3912132.0 |
| 2005-06-22 11:40:00 | AAPL | Stock | 1.3664 | 1.3686 | 1.3654 | 1.3679 | 3497844.0 |
| 2005-06-22 11:45:00 | AAPL | Stock | 1.3679 | 1.3686 | 1.3657 | 1.3661 | 2070236.0 |
| 2005-06-22 11:50:00 | AAPL | Stock | 1.3664 | 1.3675 | 1.3657 | 1.3664 | 3756900.0 |
| 2005-06-22 11:55:00 | AAPL | Stock | 1.3668 | 1.3668 | 1.3639 | 1.3643 | 2758952.0 |
| 2005-06-22 12:00:00 | AAPL | Stock | 1.3646 | 1.3664 | 1.3636 | 1.3639 | 2082500.0 |
| 2005-06-22 12:05:00 | AAPL | Stock | 1.364 | 1.3646 | 1.3636 | 1.3636 | 1312920.0 |
> showing 50 of 198,612 rows — these rows as CSV