PREVIEW / stock_5min / 2013-11-08
file: by_date/stock_5min/2013/2013-11-08.parquet size: 5.4 MB rows: 353,197 symbols: 3,547
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-11-08 04:25:00 | AAPL | Stock | 18.3496 | 18.3496 | 18.3496 | 18.3496 | 2800.0 |
| 2013-11-08 05:45:00 | AAPL | Stock | 18.3393 | 18.3393 | 18.3393 | 18.3393 | 2800.0 |
| 2013-11-08 06:05:00 | AAPL | Stock | 18.35 | 18.35 | 18.35 | 18.35 | 2800.0 |
| 2013-11-08 06:25:00 | AAPL | Stock | 18.3618 | 18.3618 | 18.3618 | 18.3618 | 2800.0 |
| 2013-11-08 06:30:00 | AAPL | Stock | 18.3596 | 18.3746 | 18.3596 | 18.3743 | 26824.0 |
| 2013-11-08 06:40:00 | AAPL | Stock | 18.3714 | 18.375 | 18.3714 | 18.375 | 8400.0 |
| 2013-11-08 06:45:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 5600.0 |
| 2013-11-08 07:00:00 | AAPL | Stock | 18.3571 | 18.3571 | 18.3571 | 18.3571 | 2800.0 |
| 2013-11-08 07:05:00 | AAPL | Stock | 18.3654 | 18.3679 | 18.3654 | 18.3679 | 8400.0 |
| 2013-11-08 07:10:00 | AAPL | Stock | 18.37 | 18.3807 | 18.3571 | 18.3571 | 54460.0 |
| 2013-11-08 07:20:00 | AAPL | Stock | 18.3564 | 18.3607 | 18.3536 | 18.3568 | 36596.0 |
| 2013-11-08 07:35:00 | AAPL | Stock | 18.3561 | 18.3561 | 18.345 | 18.345 | 13300.0 |
| 2013-11-08 07:40:00 | AAPL | Stock | 18.3404 | 18.3404 | 18.3304 | 18.3304 | 28196.0 |
| 2013-11-08 07:45:00 | AAPL | Stock | 18.3389 | 18.3432 | 18.3221 | 18.3304 | 16800.0 |
| 2013-11-08 07:50:00 | AAPL | Stock | 18.3314 | 18.3314 | 18.3304 | 18.3304 | 11200.0 |
| 2013-11-08 07:55:00 | AAPL | Stock | 18.3304 | 18.3336 | 18.3232 | 18.3336 | 30800.0 |
| 2013-11-08 08:00:00 | AAPL | Stock | 18.3325 | 18.3654 | 18.3033 | 18.3232 | 257180.0 |
| 2013-11-08 08:05:00 | AAPL | Stock | 18.3354 | 18.3357 | 18.3268 | 18.3357 | 60088.0 |
| 2013-11-08 08:10:00 | AAPL | Stock | 18.3429 | 18.3507 | 18.3361 | 18.3464 | 53340.0 |
| 2013-11-08 08:15:00 | AAPL | Stock | 18.3482 | 18.3711 | 18.3482 | 18.3711 | 65380.0 |
| 2013-11-08 08:20:00 | AAPL | Stock | 18.3554 | 18.3675 | 18.3554 | 18.3564 | 46368.0 |
| 2013-11-08 08:25:00 | AAPL | Stock | 18.3564 | 18.3564 | 18.3425 | 18.3489 | 137144.0 |
| 2013-11-08 08:30:00 | AAPL | Stock | 18.3443 | 18.3482 | 18.27 | 18.3043 | 1013852.0 |
| 2013-11-08 08:35:00 | AAPL | Stock | 18.3207 | 18.3496 | 18.3154 | 18.3461 | 234276.0 |
| 2013-11-08 08:40:00 | AAPL | Stock | 18.3539 | 18.37 | 18.3039 | 18.3625 | 3393936.0 |
| 2013-11-08 08:45:00 | AAPL | Stock | 18.3732 | 18.3732 | 18.3364 | 18.3439 | 245504.0 |
| 2013-11-08 08:50:00 | AAPL | Stock | 18.3393 | 18.3571 | 18.3393 | 18.3571 | 77756.0 |
| 2013-11-08 08:55:00 | AAPL | Stock | 18.3661 | 18.3732 | 18.36 | 18.3732 | 129220.0 |
| 2013-11-08 09:00:00 | AAPL | Stock | 18.3679 | 18.3854 | 18.3571 | 18.3804 | 419524.0 |
| 2013-11-08 09:05:00 | AAPL | Stock | 18.3857 | 18.4071 | 18.3764 | 18.4029 | 542668.0 |
| 2013-11-08 09:10:00 | AAPL | Stock | 18.4 | 18.4 | 18.3696 | 18.3921 | 527240.0 |
| 2013-11-08 09:15:00 | AAPL | Stock | 18.3868 | 18.4018 | 18.38 | 18.4018 | 102620.0 |
| 2013-11-08 09:20:00 | AAPL | Stock | 18.4036 | 18.4229 | 18.3814 | 18.4229 | 157052.0 |
| 2013-11-08 09:25:00 | AAPL | Stock | 18.3861 | 18.3921 | 18.3571 | 18.3807 | 107072.0 |
| 2013-11-08 09:30:00 | AAPL | Stock | 18.3779 | 18.4154 | 18.3361 | 18.3645 | 12348336.0 |
| 2013-11-08 09:35:00 | AAPL | Stock | 18.3671 | 18.3877 | 18.3125 | 18.3432 | 6504764.0 |
| 2013-11-08 09:40:00 | AAPL | Stock | 18.34 | 18.4054 | 18.3068 | 18.3986 | 6394584.0 |
| 2013-11-08 09:45:00 | AAPL | Stock | 18.4036 | 18.4043 | 18.3646 | 18.3789 | 3650164.0 |
| 2013-11-08 09:50:00 | AAPL | Stock | 18.3825 | 18.3941 | 18.3396 | 18.3596 | 2796388.0 |
| 2013-11-08 09:55:00 | AAPL | Stock | 18.3546 | 18.3671 | 18.3214 | 18.3357 | 4184404.0 |
| 2013-11-08 10:00:00 | AAPL | Stock | 18.3336 | 18.3875 | 18.3304 | 18.3757 | 5458180.0 |
| 2013-11-08 10:05:00 | AAPL | Stock | 18.3739 | 18.4046 | 18.372 | 18.3879 | 4002600.0 |
| 2013-11-08 10:10:00 | AAPL | Stock | 18.3884 | 18.4546 | 18.3829 | 18.4275 | 5663700.0 |
| 2013-11-08 10:15:00 | AAPL | Stock | 18.4271 | 18.4721 | 18.4271 | 18.4668 | 7015568.0 |
| 2013-11-08 10:20:00 | AAPL | Stock | 18.4705 | 18.4939 | 18.4607 | 18.4868 | 5219648.0 |
| 2013-11-08 10:25:00 | AAPL | Stock | 18.4843 | 18.4878 | 18.4657 | 18.4796 | 2900240.0 |
| 2013-11-08 10:30:00 | AAPL | Stock | 18.4804 | 18.5071 | 18.4779 | 18.5036 | 4978344.0 |
| 2013-11-08 10:35:00 | AAPL | Stock | 18.5036 | 18.5125 | 18.4946 | 18.4993 | 3813292.0 |
| 2013-11-08 10:40:00 | AAPL | Stock | 18.5011 | 18.5032 | 18.4654 | 18.4707 | 4318804.0 |
| 2013-11-08 10:45:00 | AAPL | Stock | 18.4668 | 18.5015 | 18.4668 | 18.4929 | 5748932.0 |
> showing 50 of 353,197 rows — these rows as CSV