PREVIEW / stock_1min / 2012-02-22
file: by_date/stock_1min/2012/2012-02-22.parquet size: 13.1 MB rows: 974,891 symbols: 2,858
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-22 04:00:00 | AAPL | Stock | 18.4239 | 18.4239 | 18.4239 | 18.4239 | 5600.0 |
| 2012-02-22 04:16:00 | AAPL | Stock | 18.3782 | 18.3782 | 18.3782 | 18.3782 | 5600.0 |
| 2012-02-22 04:22:00 | AAPL | Stock | 18.3825 | 18.3825 | 18.3786 | 18.3786 | 14000.0 |
| 2012-02-22 04:50:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 14000.0 |
| 2012-02-22 04:53:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 2800.0 |
| 2012-02-22 05:25:00 | AAPL | Stock | 18.3964 | 18.3964 | 18.3964 | 18.3964 | 2800.0 |
| 2012-02-22 05:36:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 2800.0 |
| 2012-02-22 05:41:00 | AAPL | Stock | 18.3982 | 18.3982 | 18.3982 | 18.3982 | 6020.0 |
| 2012-02-22 06:03:00 | AAPL | Stock | 18.3875 | 18.3875 | 18.3875 | 18.3875 | 5600.0 |
| 2012-02-22 06:17:00 | AAPL | Stock | 18.3518 | 18.3518 | 18.3518 | 18.3518 | 19600.0 |
| 2012-02-22 06:19:00 | AAPL | Stock | 18.3561 | 18.3561 | 18.3561 | 18.3561 | 5600.0 |
| 2012-02-22 06:23:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 2800.0 |
| 2012-02-22 06:25:00 | AAPL | Stock | 18.3714 | 18.3714 | 18.3714 | 18.3714 | 2800.0 |
| 2012-02-22 06:27:00 | AAPL | Stock | 18.3714 | 18.3714 | 18.3714 | 18.3714 | 8652.0 |
| 2012-02-22 06:28:00 | AAPL | Stock | 18.3661 | 18.3661 | 18.3661 | 18.3661 | 2800.0 |
| 2012-02-22 06:40:00 | AAPL | Stock | 18.3693 | 18.3693 | 18.3693 | 18.3693 | 5600.0 |
| 2012-02-22 06:45:00 | AAPL | Stock | 18.3693 | 18.3693 | 18.3693 | 18.3693 | 5544.0 |
| 2012-02-22 06:55:00 | AAPL | Stock | 18.3536 | 18.3536 | 18.3536 | 18.3536 | 5600.0 |
| 2012-02-22 06:56:00 | AAPL | Stock | 18.3536 | 18.3536 | 18.3493 | 18.3493 | 19600.0 |
| 2012-02-22 07:00:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3564 | 18.3564 | 25200.0 |
| 2012-02-22 07:02:00 | AAPL | Stock | 18.3568 | 18.3571 | 18.3568 | 18.3571 | 23044.0 |
| 2012-02-22 07:04:00 | AAPL | Stock | 18.3661 | 18.3661 | 18.3661 | 18.3661 | 8624.0 |
| 2012-02-22 07:05:00 | AAPL | Stock | 18.3661 | 18.3711 | 18.3661 | 18.3711 | 14224.0 |
| 2012-02-22 07:06:00 | AAPL | Stock | 18.3711 | 18.3711 | 18.3693 | 18.3693 | 5600.0 |
| 2012-02-22 07:08:00 | AAPL | Stock | 18.3732 | 18.375 | 18.3679 | 18.3679 | 11200.0 |
| 2012-02-22 07:09:00 | AAPL | Stock | 18.3614 | 18.3614 | 18.3575 | 18.3575 | 11200.0 |
| 2012-02-22 07:10:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3568 | 18.3571 | 39200.0 |
| 2012-02-22 07:12:00 | AAPL | Stock | 18.345 | 18.3571 | 18.345 | 18.3571 | 19600.0 |
| 2012-02-22 07:13:00 | AAPL | Stock | 18.3643 | 18.3643 | 18.3639 | 18.3639 | 8400.0 |
| 2012-02-22 07:14:00 | AAPL | Stock | 18.3639 | 18.3639 | 18.3639 | 18.3639 | 5600.0 |
| 2012-02-22 07:19:00 | AAPL | Stock | 18.3625 | 18.3839 | 18.3625 | 18.3839 | 40404.0 |
| 2012-02-22 07:22:00 | AAPL | Stock | 18.3675 | 18.3775 | 18.3668 | 18.3775 | 8400.0 |
| 2012-02-22 07:23:00 | AAPL | Stock | 18.3786 | 18.3832 | 18.3786 | 18.3832 | 5600.0 |
| 2012-02-22 07:24:00 | AAPL | Stock | 18.3836 | 18.3839 | 18.3786 | 18.3786 | 11200.0 |
| 2012-02-22 07:25:00 | AAPL | Stock | 18.3846 | 18.3846 | 18.3846 | 18.3846 | 2800.0 |
| 2012-02-22 07:26:00 | AAPL | Stock | 18.3839 | 18.3839 | 18.3804 | 18.3804 | 8400.0 |
| 2012-02-22 07:27:00 | AAPL | Stock | 18.3839 | 18.3839 | 18.375 | 18.375 | 68236.0 |
| 2012-02-22 07:28:00 | AAPL | Stock | 18.3782 | 18.3786 | 18.3779 | 18.3786 | 27580.0 |
| 2012-02-22 07:29:00 | AAPL | Stock | 18.3736 | 18.3736 | 18.3714 | 18.3714 | 16800.0 |
| 2012-02-22 07:30:00 | AAPL | Stock | 18.375 | 18.3782 | 18.375 | 18.3782 | 13300.0 |
| 2012-02-22 07:32:00 | AAPL | Stock | 18.3779 | 18.3804 | 18.3779 | 18.3804 | 34160.0 |
| 2012-02-22 07:33:00 | AAPL | Stock | 18.3771 | 18.3843 | 18.3771 | 18.3843 | 14000.0 |
| 2012-02-22 07:34:00 | AAPL | Stock | 18.3843 | 18.3846 | 18.3843 | 18.3846 | 22400.0 |
| 2012-02-22 07:35:00 | AAPL | Stock | 18.3846 | 18.385 | 18.3846 | 18.385 | 18424.0 |
| 2012-02-22 07:36:00 | AAPL | Stock | 18.3718 | 18.3746 | 18.3668 | 18.3668 | 48720.0 |
| 2012-02-22 07:37:00 | AAPL | Stock | 18.3707 | 18.3732 | 18.3682 | 18.3732 | 37380.0 |
| 2012-02-22 07:38:00 | AAPL | Stock | 18.3732 | 18.3743 | 18.3714 | 18.3714 | 39200.0 |
| 2012-02-22 07:39:00 | AAPL | Stock | 18.3682 | 18.3714 | 18.3682 | 18.3714 | 72800.0 |
| 2012-02-22 07:40:00 | AAPL | Stock | 18.3786 | 18.3804 | 18.3771 | 18.3771 | 14280.0 |
| 2012-02-22 07:43:00 | AAPL | Stock | 18.375 | 18.375 | 18.375 | 18.375 | 2800.0 |
> showing 50 of 974,891 rows — these rows as CSV