PREVIEW / stock_1min / 2011-08-18
file: by_date/stock_1min/2011/2011-08-18.parquet size: 14.6 MB rows: 1,081,547 symbols: 2,869
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-08-18 04:00:00 | AAPL | Stock | 13.5154 | 13.5154 | 13.5154 | 13.5154 | 2800.0 |
| 2011-08-18 04:05:00 | AAPL | Stock | 13.4457 | 13.4457 | 13.4457 | 13.4457 | 2800.0 |
| 2011-08-18 04:54:00 | AAPL | Stock | 13.4114 | 13.4114 | 13.4114 | 13.4114 | 2800.0 |
| 2011-08-18 05:09:00 | AAPL | Stock | 13.3825 | 13.3825 | 13.3746 | 13.3746 | 28000.0 |
| 2011-08-18 05:19:00 | AAPL | Stock | 13.3221 | 13.3221 | 13.3221 | 13.3221 | 8372.0 |
| 2011-08-18 05:21:00 | AAPL | Stock | 13.3536 | 13.3625 | 13.3536 | 13.3625 | 8400.0 |
| 2011-08-18 05:22:00 | AAPL | Stock | 13.3561 | 13.3561 | 13.3561 | 13.3561 | 2800.0 |
| 2011-08-18 05:24:00 | AAPL | Stock | 13.2682 | 13.2682 | 13.2682 | 13.2682 | 8400.0 |
| 2011-08-18 05:29:00 | AAPL | Stock | 13.3664 | 13.3736 | 13.3664 | 13.3736 | 8400.0 |
| 2011-08-18 05:30:00 | AAPL | Stock | 13.3736 | 13.3768 | 13.3721 | 13.3768 | 8400.0 |
| 2011-08-18 05:31:00 | AAPL | Stock | 13.375 | 13.3789 | 13.375 | 13.3789 | 8400.0 |
| 2011-08-18 05:50:00 | AAPL | Stock | 13.3921 | 13.3921 | 13.3921 | 13.3921 | 8400.0 |
| 2011-08-18 06:27:00 | AAPL | Stock | 13.3875 | 13.3875 | 13.3875 | 13.3875 | 5600.0 |
| 2011-08-18 06:29:00 | AAPL | Stock | 13.3918 | 13.3929 | 13.3918 | 13.3929 | 5600.0 |
| 2011-08-18 06:30:00 | AAPL | Stock | 13.3804 | 13.3832 | 13.3804 | 13.3832 | 5600.0 |
| 2011-08-18 06:31:00 | AAPL | Stock | 13.3864 | 13.3868 | 13.3864 | 13.3868 | 5600.0 |
| 2011-08-18 06:38:00 | AAPL | Stock | 13.385 | 13.385 | 13.385 | 13.385 | 2800.0 |
| 2011-08-18 06:45:00 | AAPL | Stock | 13.3846 | 13.3846 | 13.3846 | 13.3846 | 2800.0 |
| 2011-08-18 07:01:00 | AAPL | Stock | 13.4032 | 13.4032 | 13.3936 | 13.3936 | 8400.0 |
| 2011-08-18 07:02:00 | AAPL | Stock | 13.3964 | 13.3964 | 13.3964 | 13.3964 | 11200.0 |
| 2011-08-18 07:04:00 | AAPL | Stock | 13.4071 | 13.4286 | 13.4071 | 13.4286 | 42000.0 |
| 2011-08-18 07:06:00 | AAPL | Stock | 13.4186 | 13.4214 | 13.4179 | 13.4214 | 33180.0 |
| 2011-08-18 07:07:00 | AAPL | Stock | 13.4282 | 13.4282 | 13.4282 | 13.4282 | 2800.0 |
| 2011-08-18 07:08:00 | AAPL | Stock | 13.4354 | 13.4354 | 13.4354 | 13.4354 | 2800.0 |
| 2011-08-18 07:09:00 | AAPL | Stock | 13.4214 | 13.4214 | 13.4204 | 13.4204 | 17668.0 |
| 2011-08-18 07:10:00 | AAPL | Stock | 13.4204 | 13.4204 | 13.4204 | 13.4204 | 3360.0 |
| 2011-08-18 07:12:00 | AAPL | Stock | 13.4125 | 13.4125 | 13.4107 | 13.4107 | 8400.0 |
| 2011-08-18 07:14:00 | AAPL | Stock | 13.4071 | 13.4071 | 13.4036 | 13.4036 | 16240.0 |
| 2011-08-18 07:15:00 | AAPL | Stock | 13.4032 | 13.4032 | 13.4032 | 13.4032 | 30800.0 |
| 2011-08-18 07:16:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3929 | 13.3929 | 7896.0 |
| 2011-08-18 07:17:00 | AAPL | Stock | 13.3932 | 13.3932 | 13.3839 | 13.3839 | 11200.0 |
| 2011-08-18 07:19:00 | AAPL | Stock | 13.3929 | 13.4032 | 13.3857 | 13.4032 | 72324.0 |
| 2011-08-18 07:20:00 | AAPL | Stock | 13.4018 | 13.4018 | 13.4004 | 13.4004 | 8400.0 |
| 2011-08-18 07:22:00 | AAPL | Stock | 13.4129 | 13.4129 | 13.4129 | 13.4129 | 14000.0 |
| 2011-08-18 07:23:00 | AAPL | Stock | 13.4129 | 13.4139 | 13.4121 | 13.4139 | 8400.0 |
| 2011-08-18 07:24:00 | AAPL | Stock | 13.4071 | 13.4071 | 13.3932 | 13.3932 | 64400.0 |
| 2011-08-18 07:27:00 | AAPL | Stock | 13.4014 | 13.4014 | 13.4014 | 13.4014 | 2800.0 |
| 2011-08-18 07:31:00 | AAPL | Stock | 13.4082 | 13.4082 | 13.3846 | 13.3846 | 47460.0 |
| 2011-08-18 07:32:00 | AAPL | Stock | 13.375 | 13.375 | 13.375 | 13.375 | 2800.0 |
| 2011-08-18 07:33:00 | AAPL | Stock | 13.3693 | 13.3693 | 13.3654 | 13.3654 | 5600.0 |
| 2011-08-18 07:34:00 | AAPL | Stock | 13.3732 | 13.3732 | 13.3732 | 13.3732 | 2800.0 |
| 2011-08-18 07:35:00 | AAPL | Stock | 13.3743 | 13.3743 | 13.3743 | 13.3743 | 2800.0 |
| 2011-08-18 07:36:00 | AAPL | Stock | 13.3818 | 13.3818 | 13.3646 | 13.3771 | 83244.0 |
| 2011-08-18 07:38:00 | AAPL | Stock | 13.3771 | 13.3771 | 13.3771 | 13.3771 | 5600.0 |
| 2011-08-18 07:39:00 | AAPL | Stock | 13.3725 | 13.3725 | 13.3725 | 13.3725 | 2800.0 |
| 2011-08-18 07:40:00 | AAPL | Stock | 13.3693 | 13.3693 | 13.3618 | 13.3679 | 37716.0 |
| 2011-08-18 07:43:00 | AAPL | Stock | 13.3571 | 13.3571 | 13.3536 | 13.3571 | 56952.0 |
| 2011-08-18 07:45:00 | AAPL | Stock | 13.3571 | 13.3614 | 13.3571 | 13.3614 | 8400.0 |
| 2011-08-18 07:46:00 | AAPL | Stock | 13.3607 | 13.3646 | 13.3607 | 13.3607 | 29176.0 |
| 2011-08-18 07:50:00 | AAPL | Stock | 13.3618 | 13.3618 | 13.3618 | 13.3618 | 2800.0 |
> showing 50 of 1,081,547 rows — these rows as CSV