PREVIEW / stock_5min / 2003-07-25
file: by_date/stock_5min/2003/2003-07-25.parquet size: 2.1 MB rows: 148,693 symbols: 1,583
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-07-25 09:15:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3661 | 0.3661 | 11200.0 |
| 2003-07-25 09:25:00 | AAPL | Stock | 0.365 | 0.365 | 0.3648 | 0.3648 | 22400.0 |
| 2003-07-25 09:30:00 | AAPL | Stock | 0.3645 | 0.3732 | 0.3643 | 0.3698 | 5301632.0 |
| 2003-07-25 09:35:00 | AAPL | Stock | 0.3698 | 0.3721 | 0.3693 | 0.37 | 1483440.0 |
| 2003-07-25 09:40:00 | AAPL | Stock | 0.3702 | 0.3729 | 0.3691 | 0.3695 | 4144000.0 |
| 2003-07-25 09:45:00 | AAPL | Stock | 0.3695 | 0.3723 | 0.3695 | 0.3711 | 3338104.0 |
| 2003-07-25 09:50:00 | AAPL | Stock | 0.3711 | 0.3714 | 0.3696 | 0.3714 | 1825600.0 |
| 2003-07-25 09:55:00 | AAPL | Stock | 0.3714 | 0.3721 | 0.3707 | 0.3718 | 469896.0 |
| 2003-07-25 10:00:00 | AAPL | Stock | 0.3723 | 0.3723 | 0.3661 | 0.3689 | 3275216.0 |
| 2003-07-25 10:05:00 | AAPL | Stock | 0.3689 | 0.3691 | 0.367 | 0.3675 | 2325176.0 |
| 2003-07-25 10:10:00 | AAPL | Stock | 0.3679 | 0.368 | 0.3661 | 0.3664 | 1646232.0 |
| 2003-07-25 10:15:00 | AAPL | Stock | 0.3664 | 0.3682 | 0.3662 | 0.3682 | 2031232.0 |
| 2003-07-25 10:20:00 | AAPL | Stock | 0.368 | 0.3682 | 0.3675 | 0.368 | 1408400.0 |
| 2003-07-25 10:25:00 | AAPL | Stock | 0.3684 | 0.3684 | 0.3664 | 0.3666 | 1002400.0 |
| 2003-07-25 10:30:00 | AAPL | Stock | 0.3668 | 0.3671 | 0.3657 | 0.3661 | 2027200.0 |
| 2003-07-25 10:35:00 | AAPL | Stock | 0.3661 | 0.3668 | 0.3659 | 0.3664 | 3662848.0 |
| 2003-07-25 10:40:00 | AAPL | Stock | 0.3663 | 0.3668 | 0.3655 | 0.3663 | 2032800.0 |
| 2003-07-25 10:45:00 | AAPL | Stock | 0.3661 | 0.3663 | 0.3652 | 0.3655 | 846216.0 |
| 2003-07-25 10:50:00 | AAPL | Stock | 0.3654 | 0.3665 | 0.3653 | 0.3664 | 1400000.0 |
| 2003-07-25 10:55:00 | AAPL | Stock | 0.3663 | 0.3675 | 0.3663 | 0.3673 | 694400.0 |
| 2003-07-25 11:00:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3668 | 0.3671 | 246400.0 |
| 2003-07-25 11:05:00 | AAPL | Stock | 0.3671 | 0.3673 | 0.3668 | 0.367 | 856800.0 |
| 2003-07-25 11:10:00 | AAPL | Stock | 0.367 | 0.3695 | 0.3663 | 0.3691 | 2583672.0 |
| 2003-07-25 11:15:00 | AAPL | Stock | 0.3691 | 0.3693 | 0.3686 | 0.3691 | 711200.0 |
| 2003-07-25 11:20:00 | AAPL | Stock | 0.3689 | 0.3696 | 0.3686 | 0.3689 | 1993600.0 |
| 2003-07-25 11:25:00 | AAPL | Stock | 0.3689 | 0.3704 | 0.3688 | 0.3704 | 1596000.0 |
| 2003-07-25 11:30:00 | AAPL | Stock | 0.3704 | 0.3704 | 0.3698 | 0.3704 | 850864.0 |
| 2003-07-25 11:35:00 | AAPL | Stock | 0.3702 | 0.3707 | 0.3694 | 0.3705 | 1982904.0 |
| 2003-07-25 11:40:00 | AAPL | Stock | 0.3705 | 0.3716 | 0.3704 | 0.3713 | 1341760.0 |
| 2003-07-25 11:45:00 | AAPL | Stock | 0.3713 | 0.3713 | 0.3705 | 0.3713 | 2710400.0 |
| 2003-07-25 11:50:00 | AAPL | Stock | 0.3711 | 0.372 | 0.3711 | 0.3713 | 1276800.0 |
| 2003-07-25 11:55:00 | AAPL | Stock | 0.3713 | 0.3718 | 0.3709 | 0.3716 | 848288.0 |
| 2003-07-25 12:00:00 | AAPL | Stock | 0.3716 | 0.3725 | 0.3716 | 0.3723 | 615384.0 |
| 2003-07-25 12:05:00 | AAPL | Stock | 0.3723 | 0.3723 | 0.3713 | 0.3714 | 571536.0 |
| 2003-07-25 12:10:00 | AAPL | Stock | 0.3714 | 0.3727 | 0.3714 | 0.3727 | 414400.0 |
| 2003-07-25 12:15:00 | AAPL | Stock | 0.3727 | 0.3727 | 0.3714 | 0.3727 | 1713600.0 |
| 2003-07-25 12:20:00 | AAPL | Stock | 0.3727 | 0.3732 | 0.3727 | 0.3732 | 1632680.0 |
| 2003-07-25 12:25:00 | AAPL | Stock | 0.3732 | 0.3734 | 0.3728 | 0.3729 | 1708000.0 |
| 2003-07-25 12:30:00 | AAPL | Stock | 0.3729 | 0.373 | 0.3723 | 0.3723 | 1177456.0 |
| 2003-07-25 12:35:00 | AAPL | Stock | 0.3723 | 0.3729 | 0.3723 | 0.3725 | 646968.0 |
| 2003-07-25 12:40:00 | AAPL | Stock | 0.3725 | 0.3725 | 0.3718 | 0.372 | 240800.0 |
| 2003-07-25 12:45:00 | AAPL | Stock | 0.372 | 0.3723 | 0.372 | 0.3723 | 694400.0 |
| 2003-07-25 12:50:00 | AAPL | Stock | 0.3723 | 0.3723 | 0.3721 | 0.3722 | 610848.0 |
| 2003-07-25 12:55:00 | AAPL | Stock | 0.3723 | 0.3741 | 0.372 | 0.3739 | 1937376.0 |
| 2003-07-25 13:00:00 | AAPL | Stock | 0.3738 | 0.3746 | 0.3738 | 0.3743 | 1331232.0 |
| 2003-07-25 13:05:00 | AAPL | Stock | 0.3741 | 0.3745 | 0.3741 | 0.3745 | 224000.0 |
| 2003-07-25 13:10:00 | AAPL | Stock | 0.3741 | 0.3748 | 0.3738 | 0.3746 | 941472.0 |
| 2003-07-25 13:15:00 | AAPL | Stock | 0.3746 | 0.375 | 0.3745 | 0.3746 | 649656.0 |
| 2003-07-25 13:20:00 | AAPL | Stock | 0.3744 | 0.3748 | 0.3741 | 0.3748 | 739200.0 |
| 2003-07-25 13:25:00 | AAPL | Stock | 0.3748 | 0.3748 | 0.3746 | 0.3748 | 285600.0 |
> showing 50 of 148,693 rows — these rows as CSV