PREVIEW / stock_5min / 2011-06-02
file: by_date/stock_5min/2011/2011-06-02.parquet size: 4.9 MB rows: 331,623 symbols: 3,547
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-02 04:30:00 | AAPL | Stock | 12.3718 | 12.3743 | 12.3718 | 12.3743 | 11200.0 |
| 2011-06-02 04:40:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3907 | 12.3907 | 19600.0 |
| 2011-06-02 04:55:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 11200.0 |
| 2011-06-02 05:05:00 | AAPL | Stock | 12.3729 | 12.3729 | 12.3718 | 12.3718 | 16800.0 |
| 2011-06-02 05:20:00 | AAPL | Stock | 12.3957 | 12.3957 | 12.3957 | 12.3957 | 2800.0 |
| 2011-06-02 05:35:00 | AAPL | Stock | 12.3821 | 12.3821 | 12.3821 | 12.3821 | 2800.0 |
| 2011-06-02 05:45:00 | AAPL | Stock | 12.3857 | 12.3857 | 12.3857 | 12.3857 | 2800.0 |
| 2011-06-02 06:05:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 5600.0 |
| 2011-06-02 06:10:00 | AAPL | Stock | 12.4107 | 12.4107 | 12.4107 | 12.4107 | 11200.0 |
| 2011-06-02 06:30:00 | AAPL | Stock | 12.3875 | 12.3875 | 12.3875 | 12.3875 | 2800.0 |
| 2011-06-02 06:35:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 8400.0 |
| 2011-06-02 07:00:00 | AAPL | Stock | 12.3757 | 12.3757 | 12.375 | 12.3754 | 36680.0 |
| 2011-06-02 07:05:00 | AAPL | Stock | 12.3754 | 12.3754 | 12.3729 | 12.3729 | 15120.0 |
| 2011-06-02 07:10:00 | AAPL | Stock | 12.3589 | 12.3589 | 12.3589 | 12.3589 | 2800.0 |
| 2011-06-02 07:15:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3589 | 12.3589 | 5600.0 |
| 2011-06-02 07:20:00 | AAPL | Stock | 12.3671 | 12.3671 | 12.3671 | 12.3671 | 2800.0 |
| 2011-06-02 07:25:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 2800.0 |
| 2011-06-02 07:30:00 | AAPL | Stock | 12.3682 | 12.3696 | 12.3679 | 12.3696 | 35000.0 |
| 2011-06-02 07:35:00 | AAPL | Stock | 12.3804 | 12.3804 | 12.3679 | 12.3679 | 56000.0 |
| 2011-06-02 07:40:00 | AAPL | Stock | 12.3786 | 12.3818 | 12.3786 | 12.3818 | 19600.0 |
| 2011-06-02 07:45:00 | AAPL | Stock | 12.3811 | 12.3821 | 12.3811 | 12.3821 | 36400.0 |
| 2011-06-02 07:50:00 | AAPL | Stock | 12.3811 | 12.3811 | 12.3811 | 12.3811 | 2800.0 |
| 2011-06-02 07:55:00 | AAPL | Stock | 12.37 | 12.3714 | 12.37 | 12.3714 | 5600.0 |
| 2011-06-02 08:00:00 | AAPL | Stock | 12.375 | 12.3814 | 12.3661 | 12.3714 | 178892.0 |
| 2011-06-02 08:05:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3646 | 12.3646 | 63840.0 |
| 2011-06-02 08:10:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3614 | 12.3696 | 50120.0 |
| 2011-06-02 08:15:00 | AAPL | Stock | 12.3696 | 12.3718 | 12.3643 | 12.3696 | 165900.0 |
| 2011-06-02 08:20:00 | AAPL | Stock | 12.3696 | 12.3732 | 12.3679 | 12.3679 | 131152.0 |
| 2011-06-02 08:25:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3643 | 12.3643 | 58240.0 |
| 2011-06-02 08:30:00 | AAPL | Stock | 12.365 | 12.4 | 12.365 | 12.3925 | 350476.0 |
| 2011-06-02 08:35:00 | AAPL | Stock | 12.3886 | 12.4064 | 12.3857 | 12.4036 | 405636.0 |
| 2011-06-02 08:40:00 | AAPL | Stock | 12.4039 | 12.4129 | 12.3989 | 12.3993 | 604072.0 |
| 2011-06-02 08:45:00 | AAPL | Stock | 12.3989 | 12.4018 | 12.3875 | 12.4011 | 288512.0 |
| 2011-06-02 08:50:00 | AAPL | Stock | 12.3993 | 12.4061 | 12.3993 | 12.4039 | 72240.0 |
| 2011-06-02 08:55:00 | AAPL | Stock | 12.4039 | 12.4039 | 12.3932 | 12.4004 | 70000.0 |
| 2011-06-02 09:00:00 | AAPL | Stock | 12.4018 | 12.4036 | 12.4018 | 12.4018 | 36400.0 |
| 2011-06-02 09:05:00 | AAPL | Stock | 12.4018 | 12.4018 | 12.3929 | 12.3929 | 70140.0 |
| 2011-06-02 09:10:00 | AAPL | Stock | 12.3929 | 12.4 | 12.3893 | 12.4 | 91476.0 |
| 2011-06-02 09:15:00 | AAPL | Stock | 12.3946 | 12.3961 | 12.3829 | 12.3832 | 113400.0 |
| 2011-06-02 09:20:00 | AAPL | Stock | 12.3893 | 12.3979 | 12.3893 | 12.3979 | 33600.0 |
| 2011-06-02 09:25:00 | AAPL | Stock | 12.3975 | 12.3982 | 12.375 | 12.3768 | 210056.0 |
| 2011-06-02 09:30:00 | AAPL | Stock | 12.375 | 12.4125 | 12.3729 | 12.3896 | 13140260.0 |
| 2011-06-02 09:35:00 | AAPL | Stock | 12.3914 | 12.3996 | 12.3571 | 12.3671 | 11122580.0 |
| 2011-06-02 09:40:00 | AAPL | Stock | 12.3696 | 12.3768 | 12.3396 | 12.3482 | 10227784.0 |
| 2011-06-02 09:45:00 | AAPL | Stock | 12.3482 | 12.3836 | 12.3339 | 12.3729 | 11288228.0 |
| 2011-06-02 09:50:00 | AAPL | Stock | 12.3739 | 12.4018 | 12.37 | 12.3884 | 8434356.0 |
| 2011-06-02 09:55:00 | AAPL | Stock | 12.39 | 12.4054 | 12.3786 | 12.3821 | 5499620.0 |
| 2011-06-02 10:00:00 | AAPL | Stock | 12.3836 | 12.3957 | 12.3589 | 12.3882 | 7110180.0 |
| 2011-06-02 10:05:00 | AAPL | Stock | 12.3875 | 12.3971 | 12.3714 | 12.3732 | 6184192.0 |
| 2011-06-02 10:10:00 | AAPL | Stock | 12.375 | 12.3975 | 12.3732 | 12.3779 | 5605656.0 |
> showing 50 of 331,623 rows — these rows as CSV