PREVIEW / stock_5min / 2012-02-01
file: by_date/stock_5min/2012/2012-02-01.parquet size: 5.1 MB rows: 340,005 symbols: 3,544
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-01 04:00:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 2800.0 |
| 2012-02-01 04:10:00 | AAPL | Stock | 16.3707 | 16.3707 | 16.3707 | 16.3707 | 2800.0 |
| 2012-02-01 04:30:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3896 | 16.3896 | 14280.0 |
| 2012-02-01 04:35:00 | AAPL | Stock | 16.3896 | 16.3929 | 16.3896 | 16.3929 | 11200.0 |
| 2012-02-01 04:40:00 | AAPL | Stock | 16.3925 | 16.3929 | 16.3925 | 16.3929 | 12600.0 |
| 2012-02-01 04:45:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 5600.0 |
| 2012-02-01 04:55:00 | AAPL | Stock | 16.4075 | 16.4075 | 16.4075 | 16.4075 | 2800.0 |
| 2012-02-01 05:05:00 | AAPL | Stock | 16.4286 | 16.4286 | 16.4057 | 16.4057 | 11200.0 |
| 2012-02-01 05:10:00 | AAPL | Stock | 16.4057 | 16.4057 | 16.4057 | 16.4057 | 16800.0 |
| 2012-02-01 05:15:00 | AAPL | Stock | 16.4057 | 16.4057 | 16.4057 | 16.4057 | 5880.0 |
| 2012-02-01 05:20:00 | AAPL | Stock | 16.4107 | 16.4107 | 16.4 | 16.4 | 16800.0 |
| 2012-02-01 05:30:00 | AAPL | Stock | 16.4 | 16.4 | 16.3982 | 16.3982 | 12600.0 |
| 2012-02-01 05:40:00 | AAPL | Stock | 16.3982 | 16.3982 | 16.3982 | 16.3982 | 5600.0 |
| 2012-02-01 05:45:00 | AAPL | Stock | 16.3982 | 16.3982 | 16.3982 | 16.3982 | 5040.0 |
| 2012-02-01 05:55:00 | AAPL | Stock | 16.3982 | 16.3982 | 16.3982 | 16.3982 | 2800.0 |
| 2012-02-01 06:00:00 | AAPL | Stock | 16.3964 | 16.3964 | 16.3964 | 16.3964 | 3360.0 |
| 2012-02-01 06:10:00 | AAPL | Stock | 16.3964 | 16.3964 | 16.3964 | 16.3964 | 5740.0 |
| 2012-02-01 06:20:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2012-02-01 06:25:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2012-02-01 06:35:00 | AAPL | Stock | 16.3925 | 16.3925 | 16.3925 | 16.3925 | 2800.0 |
| 2012-02-01 06:40:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 8120.0 |
| 2012-02-01 06:45:00 | AAPL | Stock | 16.3964 | 16.3964 | 16.3964 | 16.3964 | 14000.0 |
| 2012-02-01 06:50:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2012-02-01 06:55:00 | AAPL | Stock | 16.3964 | 16.3964 | 16.3914 | 16.3929 | 22400.0 |
| 2012-02-01 07:00:00 | AAPL | Stock | 16.3914 | 16.3914 | 16.3607 | 16.3836 | 51156.0 |
| 2012-02-01 07:05:00 | AAPL | Stock | 16.375 | 16.375 | 16.375 | 16.375 | 27440.0 |
| 2012-02-01 07:10:00 | AAPL | Stock | 16.3707 | 16.3714 | 16.3593 | 16.3714 | 106904.0 |
| 2012-02-01 07:15:00 | AAPL | Stock | 16.3736 | 16.3736 | 16.3679 | 16.3679 | 56588.0 |
| 2012-02-01 07:20:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3614 | 16.3714 | 44240.0 |
| 2012-02-01 07:25:00 | AAPL | Stock | 16.3736 | 16.3804 | 16.3736 | 16.3804 | 64120.0 |
| 2012-02-01 07:30:00 | AAPL | Stock | 16.38 | 16.3843 | 16.3796 | 16.3843 | 98000.0 |
| 2012-02-01 07:35:00 | AAPL | Stock | 16.3843 | 16.3882 | 16.3771 | 16.3771 | 78344.0 |
| 2012-02-01 07:40:00 | AAPL | Stock | 16.3839 | 16.3875 | 16.3818 | 16.3875 | 67200.0 |
| 2012-02-01 07:45:00 | AAPL | Stock | 16.3857 | 16.3857 | 16.3743 | 16.3743 | 47600.0 |
| 2012-02-01 07:50:00 | AAPL | Stock | 16.3836 | 16.3839 | 16.3836 | 16.3839 | 5600.0 |
| 2012-02-01 07:55:00 | AAPL | Stock | 16.3782 | 16.3786 | 16.3782 | 16.3786 | 26600.0 |
| 2012-02-01 08:00:00 | AAPL | Stock | 16.3743 | 16.3768 | 16.3568 | 16.3675 | 259728.0 |
| 2012-02-01 08:05:00 | AAPL | Stock | 16.3696 | 16.3696 | 16.3536 | 16.3614 | 139776.0 |
| 2012-02-01 08:10:00 | AAPL | Stock | 16.3607 | 16.3654 | 16.3564 | 16.3571 | 102200.0 |
| 2012-02-01 08:15:00 | AAPL | Stock | 16.3571 | 16.3704 | 16.35 | 16.3679 | 183400.0 |
| 2012-02-01 08:20:00 | AAPL | Stock | 16.3604 | 16.375 | 16.3589 | 16.375 | 173264.0 |
| 2012-02-01 08:25:00 | AAPL | Stock | 16.3729 | 16.3746 | 16.3711 | 16.3725 | 39340.0 |
| 2012-02-01 08:30:00 | AAPL | Stock | 16.3725 | 16.3779 | 16.3725 | 16.3779 | 88760.0 |
| 2012-02-01 08:35:00 | AAPL | Stock | 16.3729 | 16.3729 | 16.3679 | 16.3725 | 47040.0 |
| 2012-02-01 08:40:00 | AAPL | Stock | 16.3725 | 16.3725 | 16.3604 | 16.3604 | 77812.0 |
| 2012-02-01 08:45:00 | AAPL | Stock | 16.3607 | 16.3714 | 16.3589 | 16.3589 | 72940.0 |
| 2012-02-01 08:50:00 | AAPL | Stock | 16.365 | 16.3711 | 16.3575 | 16.3621 | 311808.0 |
| 2012-02-01 08:55:00 | AAPL | Stock | 16.3643 | 16.3679 | 16.3621 | 16.3675 | 78568.0 |
| 2012-02-01 09:00:00 | AAPL | Stock | 16.3693 | 16.3718 | 16.3661 | 16.3661 | 293692.0 |
| 2012-02-01 09:05:00 | AAPL | Stock | 16.3611 | 16.3689 | 16.3571 | 16.3686 | 364532.0 |
> showing 50 of 340,005 rows — these rows as CSV