PREVIEW / stock_1min / 2011-06-02
file: by_date/stock_1min/2011/2011-06-02.parquet size: 13.5 MB rows: 1,020,466 symbols: 2,876
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:31:00 | AAPL | Stock | 12.3718 | 12.3718 | 12.3718 | 12.3718 | 5600.0 |
| 2011-06-02 04:33:00 | AAPL | Stock | 12.3743 | 12.3743 | 12.3743 | 12.3743 | 5600.0 |
| 2011-06-02 04:41:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3907 | 12.3907 | 19600.0 |
| 2011-06-02 04:56:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 11200.0 |
| 2011-06-02 05:06:00 | AAPL | Stock | 12.3729 | 12.3729 | 12.3729 | 12.3729 | 14000.0 |
| 2011-06-02 05:07:00 | AAPL | Stock | 12.3718 | 12.3718 | 12.3718 | 12.3718 | 2800.0 |
| 2011-06-02 05:20:00 | AAPL | Stock | 12.3957 | 12.3957 | 12.3957 | 12.3957 | 2800.0 |
| 2011-06-02 05:39:00 | AAPL | Stock | 12.3821 | 12.3821 | 12.3821 | 12.3821 | 2800.0 |
| 2011-06-02 05:46: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:13: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:37:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 8400.0 |
| 2011-06-02 07:01:00 | AAPL | Stock | 12.3757 | 12.3757 | 12.375 | 12.375 | 19600.0 |
| 2011-06-02 07:02:00 | AAPL | Stock | 12.375 | 12.3754 | 12.375 | 12.3754 | 17080.0 |
| 2011-06-02 07:05:00 | AAPL | Stock | 12.3754 | 12.3754 | 12.3754 | 12.3754 | 10920.0 |
| 2011-06-02 07:06:00 | AAPL | Stock | 12.3729 | 12.3729 | 12.3729 | 12.3729 | 4200.0 |
| 2011-06-02 07:10:00 | AAPL | Stock | 12.3589 | 12.3589 | 12.3589 | 12.3589 | 2800.0 |
| 2011-06-02 07:18:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3589 | 12.3589 | 5600.0 |
| 2011-06-02 07:22:00 | AAPL | Stock | 12.3671 | 12.3671 | 12.3671 | 12.3671 | 2800.0 |
| 2011-06-02 07:28:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 2800.0 |
| 2011-06-02 07:31:00 | AAPL | Stock | 12.3682 | 12.3682 | 12.3682 | 12.3682 | 2800.0 |
| 2011-06-02 07:32:00 | AAPL | Stock | 12.3682 | 12.3682 | 12.3679 | 12.3679 | 21000.0 |
| 2011-06-02 07:34:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 11200.0 |
| 2011-06-02 07:35:00 | AAPL | Stock | 12.3804 | 12.3804 | 12.3804 | 12.3804 | 33600.0 |
| 2011-06-02 07:37:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3679 | 12.3679 | 22400.0 |
| 2011-06-02 07:44:00 | AAPL | Stock | 12.3786 | 12.3818 | 12.3786 | 12.3818 | 19600.0 |
| 2011-06-02 07:46:00 | AAPL | Stock | 12.3811 | 12.3818 | 12.3811 | 12.3811 | 25200.0 |
| 2011-06-02 07:47:00 | AAPL | Stock | 12.3811 | 12.3811 | 12.3811 | 12.3811 | 8400.0 |
| 2011-06-02 07:48:00 | AAPL | Stock | 12.3821 | 12.3821 | 12.3821 | 12.3821 | 2800.0 |
| 2011-06-02 07:54:00 | AAPL | Stock | 12.3811 | 12.3811 | 12.3811 | 12.3811 | 2800.0 |
| 2011-06-02 07:55:00 | AAPL | Stock | 12.37 | 12.37 | 12.37 | 12.37 | 2800.0 |
| 2011-06-02 07:57:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3714 | 12.3714 | 2800.0 |
| 2011-06-02 08:00:00 | AAPL | Stock | 12.375 | 12.3814 | 12.3661 | 12.3661 | 83300.0 |
| 2011-06-02 08:01:00 | AAPL | Stock | 12.3661 | 12.3661 | 12.3661 | 12.3661 | 2800.0 |
| 2011-06-02 08:02:00 | AAPL | Stock | 12.3668 | 12.3675 | 12.3668 | 12.3675 | 11200.0 |
| 2011-06-02 08:03:00 | AAPL | Stock | 12.3661 | 12.3718 | 12.3661 | 12.3718 | 44352.0 |
| 2011-06-02 08:04:00 | AAPL | Stock | 12.3714 | 12.3718 | 12.3714 | 12.3714 | 37240.0 |
| 2011-06-02 08:06:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3714 | 12.3714 | 30800.0 |
| 2011-06-02 08:08:00 | AAPL | Stock | 12.37 | 12.37 | 12.3664 | 12.3664 | 21840.0 |
| 2011-06-02 08:09:00 | AAPL | Stock | 12.37 | 12.37 | 12.3646 | 12.3646 | 11200.0 |
| 2011-06-02 08:10:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 2800.0 |
| 2011-06-02 08:13:00 | AAPL | Stock | 12.3661 | 12.3661 | 12.3614 | 12.3661 | 28560.0 |
| 2011-06-02 08:14:00 | AAPL | Stock | 12.3661 | 12.3696 | 12.3661 | 12.3696 | 18760.0 |
| 2011-06-02 08:15:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 5600.0 |
| 2011-06-02 08:16:00 | AAPL | Stock | 12.3714 | 12.3718 | 12.3696 | 12.3718 | 28000.0 |
| 2011-06-02 08:17:00 | AAPL | Stock | 12.3714 | 12.3714 | 12.3661 | 12.3661 | 113876.0 |
| 2011-06-02 08:18:00 | AAPL | Stock | 12.3643 | 12.3679 | 12.3643 | 12.3661 | 10024.0 |
| 2011-06-02 08:19:00 | AAPL | Stock | 12.3675 | 12.3696 | 12.3675 | 12.3696 | 8400.0 |
| 2011-06-02 08:20:00 | AAPL | Stock | 12.3696 | 12.3696 | 12.3696 | 12.3696 | 2800.0 |
> showing 50 of 1,020,466 rows — these rows as CSV