PREVIEW / stock_1min / 2012-02-06
file: by_date/stock_1min/2012/2012-02-06.parquet size: 12.9 MB rows: 956,407 symbols: 2,882
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-06 06:03:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3607 | 16.3607 | 5600.0 |
| 2012-02-06 06:26:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 9520.0 |
| 2012-02-06 06:50:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3571 | 16.3571 | 8400.0 |
| 2012-02-06 07:01:00 | AAPL | Stock | 16.3654 | 16.3654 | 16.3654 | 16.3654 | 5600.0 |
| 2012-02-06 07:02:00 | AAPL | Stock | 16.3654 | 16.3654 | 16.3654 | 16.3654 | 2800.0 |
| 2012-02-06 07:08:00 | AAPL | Stock | 16.3804 | 16.3804 | 16.3804 | 16.3804 | 5600.0 |
| 2012-02-06 07:12:00 | AAPL | Stock | 16.3643 | 16.3643 | 16.3643 | 16.3643 | 5600.0 |
| 2012-02-06 07:18:00 | AAPL | Stock | 16.3632 | 16.3632 | 16.3632 | 16.3632 | 4200.0 |
| 2012-02-06 07:19:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 2800.0 |
| 2012-02-06 07:21:00 | AAPL | Stock | 16.3768 | 16.3768 | 16.3768 | 16.3768 | 8400.0 |
| 2012-02-06 07:23:00 | AAPL | Stock | 16.3825 | 16.3829 | 16.3825 | 16.3829 | 10108.0 |
| 2012-02-06 07:42:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 2800.0 |
| 2012-02-06 07:58:00 | AAPL | Stock | 16.3593 | 16.3593 | 16.3582 | 16.3589 | 11200.0 |
| 2012-02-06 08:00:00 | AAPL | Stock | 16.3711 | 16.375 | 16.3711 | 16.375 | 24668.0 |
| 2012-02-06 08:02:00 | AAPL | Stock | 16.375 | 16.375 | 16.3714 | 16.3714 | 28000.0 |
| 2012-02-06 08:04:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3714 | 16.3714 | 2800.0 |
| 2012-02-06 08:05:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3714 | 16.3714 | 2800.0 |
| 2012-02-06 08:06:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3611 | 16.3611 | 9968.0 |
| 2012-02-06 08:07:00 | AAPL | Stock | 16.3614 | 16.3679 | 16.3614 | 16.3679 | 14000.0 |
| 2012-02-06 08:08:00 | AAPL | Stock | 16.3618 | 16.3679 | 16.3618 | 16.3679 | 8400.0 |
| 2012-02-06 08:09:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 13692.0 |
| 2012-02-06 08:10:00 | AAPL | Stock | 16.3846 | 16.3846 | 16.3846 | 16.3846 | 16800.0 |
| 2012-02-06 08:11:00 | AAPL | Stock | 16.3714 | 16.3714 | 16.3714 | 16.3714 | 3500.0 |
| 2012-02-06 08:12:00 | AAPL | Stock | 16.3679 | 16.3679 | 16.3679 | 16.3679 | 2800.0 |
| 2012-02-06 08:14:00 | AAPL | Stock | 16.3682 | 16.3682 | 16.3682 | 16.3682 | 5600.0 |
| 2012-02-06 08:15:00 | AAPL | Stock | 16.3682 | 16.3711 | 16.3682 | 16.3711 | 5600.0 |
| 2012-02-06 08:16:00 | AAPL | Stock | 16.3704 | 16.3714 | 16.3682 | 16.3682 | 11200.0 |
| 2012-02-06 08:20:00 | AAPL | Stock | 16.3689 | 16.3689 | 16.3689 | 16.3689 | 2800.0 |
| 2012-02-06 08:22:00 | AAPL | Stock | 16.37 | 16.37 | 16.3661 | 16.3661 | 33908.0 |
| 2012-02-06 08:25:00 | AAPL | Stock | 16.3671 | 16.3675 | 16.3671 | 16.3675 | 7252.0 |
| 2012-02-06 08:29:00 | AAPL | Stock | 16.3661 | 16.3661 | 16.3643 | 16.3643 | 32760.0 |
| 2012-02-06 08:35:00 | AAPL | Stock | 16.3618 | 16.3618 | 16.3618 | 16.3618 | 2800.0 |
| 2012-02-06 08:38:00 | AAPL | Stock | 16.3607 | 16.3607 | 16.3607 | 16.3607 | 2800.0 |
| 2012-02-06 08:39:00 | AAPL | Stock | 16.3596 | 16.3596 | 16.3518 | 16.3571 | 142268.0 |
| 2012-02-06 08:42:00 | AAPL | Stock | 16.3518 | 16.3518 | 16.3464 | 16.3464 | 39900.0 |
| 2012-02-06 08:43:00 | AAPL | Stock | 16.3443 | 16.3514 | 16.3443 | 16.3514 | 5600.0 |
| 2012-02-06 08:45:00 | AAPL | Stock | 16.35 | 16.35 | 16.35 | 16.35 | 46732.0 |
| 2012-02-06 08:51:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 8400.0 |
| 2012-02-06 08:52:00 | AAPL | Stock | 16.3632 | 16.3632 | 16.3632 | 16.3632 | 5180.0 |
| 2012-02-06 08:53:00 | AAPL | Stock | 16.3629 | 16.3643 | 16.3579 | 16.3579 | 13132.0 |
| 2012-02-06 08:54:00 | AAPL | Stock | 16.3571 | 16.3571 | 16.3571 | 16.3571 | 4200.0 |
| 2012-02-06 08:56:00 | AAPL | Stock | 16.3536 | 16.3536 | 16.3536 | 16.3536 | 2800.0 |
| 2012-02-06 08:59:00 | AAPL | Stock | 16.3539 | 16.3539 | 16.3539 | 16.3539 | 2800.0 |
| 2012-02-06 09:02:00 | AAPL | Stock | 16.3496 | 16.3496 | 16.3482 | 16.3482 | 16800.0 |
| 2012-02-06 09:03:00 | AAPL | Stock | 16.3479 | 16.3543 | 16.3479 | 16.3543 | 11200.0 |
| 2012-02-06 09:05:00 | AAPL | Stock | 16.3536 | 16.3557 | 16.3532 | 16.355 | 58632.0 |
| 2012-02-06 09:06:00 | AAPL | Stock | 16.3557 | 16.3607 | 16.3557 | 16.36 | 50568.0 |
| 2012-02-06 09:07:00 | AAPL | Stock | 16.3554 | 16.3554 | 16.3554 | 16.3554 | 5600.0 |
| 2012-02-06 09:08:00 | AAPL | Stock | 16.3518 | 16.3518 | 16.3504 | 16.3504 | 30800.0 |
| 2012-02-06 09:09:00 | AAPL | Stock | 16.3504 | 16.3504 | 16.3504 | 16.3504 | 2800.0 |
> showing 50 of 956,407 rows — these rows as CSV