PREVIEW / stock_1min / 2013-02-01
file: by_date/stock_1min/2013/2013-02-01.parquet size: 13.6 MB rows: 1,010,175 symbols: 2,808
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-01 04:00:00 | AAPL | Stock | 16.3886 | 16.3929 | 16.3886 | 16.3929 | 14000.0 |
| 2013-02-01 04:57:00 | AAPL | Stock | 16.3907 | 16.3907 | 16.3907 | 16.3907 | 2800.0 |
| 2013-02-01 06:07:00 | AAPL | Stock | 16.3525 | 16.3525 | 16.3525 | 16.3525 | 2800.0 |
| 2013-02-01 06:11:00 | AAPL | Stock | 16.3525 | 16.3525 | 16.3525 | 16.3525 | 2800.0 |
| 2013-02-01 06:27:00 | AAPL | Stock | 16.3564 | 16.3564 | 16.3564 | 16.3564 | 5600.0 |
| 2013-02-01 06:38:00 | AAPL | Stock | 16.3429 | 16.3429 | 16.3429 | 16.3429 | 2800.0 |
| 2013-02-01 06:46:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 2800.0 |
| 2013-02-01 07:00:00 | AAPL | Stock | 16.3214 | 16.3214 | 16.3214 | 16.3214 | 4200.0 |
| 2013-02-01 07:01:00 | AAPL | Stock | 16.3479 | 16.3489 | 16.3479 | 16.3486 | 14000.0 |
| 2013-02-01 07:02:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 8400.0 |
| 2013-02-01 07:08:00 | AAPL | Stock | 16.3521 | 16.3521 | 16.3511 | 16.3511 | 8400.0 |
| 2013-02-01 07:10:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 2800.0 |
| 2013-02-01 07:12:00 | AAPL | Stock | 16.3746 | 16.375 | 16.3746 | 16.375 | 6440.0 |
| 2013-02-01 07:13:00 | AAPL | Stock | 16.3857 | 16.3929 | 16.3857 | 16.3864 | 11200.0 |
| 2013-02-01 07:14:00 | AAPL | Stock | 16.3864 | 16.3864 | 16.3836 | 16.3836 | 5600.0 |
| 2013-02-01 07:18:00 | AAPL | Stock | 16.3854 | 16.3854 | 16.385 | 16.385 | 11200.0 |
| 2013-02-01 07:20:00 | AAPL | Stock | 16.375 | 16.3864 | 16.3571 | 16.3839 | 98140.0 |
| 2013-02-01 07:21:00 | AAPL | Stock | 16.3854 | 16.3854 | 16.3854 | 16.3854 | 5600.0 |
| 2013-02-01 07:24:00 | AAPL | Stock | 16.3818 | 16.3929 | 16.3818 | 16.3929 | 25200.0 |
| 2013-02-01 07:31:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 2800.0 |
| 2013-02-01 07:33:00 | AAPL | Stock | 16.3929 | 16.3975 | 16.3929 | 16.3975 | 38640.0 |
| 2013-02-01 07:35:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 3360.0 |
| 2013-02-01 07:36:00 | AAPL | Stock | 16.3804 | 16.3804 | 16.3804 | 16.3804 | 5600.0 |
| 2013-02-01 07:37:00 | AAPL | Stock | 16.3807 | 16.3807 | 16.3804 | 16.3804 | 5600.0 |
| 2013-02-01 07:38:00 | AAPL | Stock | 16.3839 | 16.3925 | 16.3839 | 16.3925 | 33600.0 |
| 2013-02-01 07:39:00 | AAPL | Stock | 16.4 | 16.4007 | 16.3925 | 16.3925 | 27692.0 |
| 2013-02-01 07:43:00 | AAPL | Stock | 16.4018 | 16.4018 | 16.3929 | 16.3929 | 7700.0 |
| 2013-02-01 07:46:00 | AAPL | Stock | 16.3929 | 16.3929 | 16.3929 | 16.3929 | 5600.0 |
| 2013-02-01 07:49:00 | AAPL | Stock | 16.3893 | 16.3893 | 16.3893 | 16.3893 | 16800.0 |
| 2013-02-01 07:50:00 | AAPL | Stock | 16.3886 | 16.3886 | 16.3821 | 16.3821 | 8400.0 |
| 2013-02-01 07:51:00 | AAPL | Stock | 16.3821 | 16.3821 | 16.3786 | 16.3786 | 8400.0 |
| 2013-02-01 07:54:00 | AAPL | Stock | 16.365 | 16.365 | 16.365 | 16.365 | 2800.0 |
| 2013-02-01 07:57:00 | AAPL | Stock | 16.37 | 16.37 | 16.3679 | 16.3679 | 11200.0 |
| 2013-02-01 08:00:00 | AAPL | Stock | 16.3661 | 16.3864 | 16.3571 | 16.3571 | 89852.0 |
| 2013-02-01 08:02:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 5208.0 |
| 2013-02-01 08:03:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3643 | 16.3643 | 2800.0 |
| 2013-02-01 08:05:00 | AAPL | Stock | 16.3571 | 16.3643 | 16.3571 | 16.3643 | 14000.0 |
| 2013-02-01 08:06:00 | AAPL | Stock | 16.3643 | 16.3671 | 16.3643 | 16.3671 | 12936.0 |
| 2013-02-01 08:07:00 | AAPL | Stock | 16.3732 | 16.3732 | 16.3732 | 16.3732 | 4200.0 |
| 2013-02-01 08:08:00 | AAPL | Stock | 16.3843 | 16.3879 | 16.3718 | 16.3718 | 13860.0 |
| 2013-02-01 08:09:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3714 | 16.3714 | 5600.0 |
| 2013-02-01 08:11:00 | AAPL | Stock | 16.3714 | 16.3786 | 16.3689 | 16.3786 | 26768.0 |
| 2013-02-01 08:12:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 3500.0 |
| 2013-02-01 08:13:00 | AAPL | Stock | 16.3618 | 16.3618 | 16.3618 | 16.3618 | 2800.0 |
| 2013-02-01 08:14:00 | AAPL | Stock | 16.3689 | 16.3689 | 16.3571 | 16.3571 | 127400.0 |
| 2013-02-01 08:15:00 | AAPL | Stock | 16.3571 | 16.3625 | 16.3571 | 16.3625 | 57400.0 |
| 2013-02-01 08:16:00 | AAPL | Stock | 16.3607 | 16.3689 | 16.3607 | 16.3686 | 43792.0 |
| 2013-02-01 08:17:00 | AAPL | Stock | 16.3689 | 16.3689 | 16.3689 | 16.3689 | 2800.0 |
| 2013-02-01 08:19:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3596 | 16.3596 | 19600.0 |
| 2013-02-01 08:20:00 | AAPL | Stock | 16.36 | 16.36 | 16.3596 | 16.36 | 22400.0 |
> showing 50 of 1,010,175 rows — these rows as CSV