PREVIEW / stock_5min / 2014-05-29
file: by_date/stock_5min/2014/2014-05-29.parquet size: 5.3 MB rows: 356,384 symbols: 3,550
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-29 04:50:00 | AAPL | Stock | 22.3789 | 22.3789 | 22.3789 | 22.3789 | 2800.0 |
| 2014-05-29 04:55:00 | AAPL | Stock | 22.3789 | 22.3789 | 22.3789 | 22.3789 | 2800.0 |
| 2014-05-29 05:15:00 | AAPL | Stock | 22.3821 | 22.3821 | 22.3821 | 22.3821 | 5600.0 |
| 2014-05-29 05:35:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 19600.0 |
| 2014-05-29 05:40:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 2800.0 |
| 2014-05-29 05:55:00 | AAPL | Stock | 22.3643 | 22.3643 | 22.3643 | 22.3643 | 11200.0 |
| 2014-05-29 06:00:00 | AAPL | Stock | 22.3311 | 22.3311 | 22.3311 | 22.3311 | 2800.0 |
| 2014-05-29 06:05:00 | AAPL | Stock | 22.3636 | 22.3689 | 22.3636 | 22.3689 | 5600.0 |
| 2014-05-29 06:20:00 | AAPL | Stock | 22.3686 | 22.4071 | 22.3686 | 22.405 | 30632.0 |
| 2014-05-29 06:30:00 | AAPL | Stock | 22.3661 | 22.3661 | 22.3661 | 22.3661 | 5600.0 |
| 2014-05-29 06:45:00 | AAPL | Stock | 22.3571 | 22.3571 | 22.3571 | 22.3571 | 5600.0 |
| 2014-05-29 07:00:00 | AAPL | Stock | 22.3686 | 22.3686 | 22.34 | 22.34 | 33908.0 |
| 2014-05-29 07:05:00 | AAPL | Stock | 22.355 | 22.355 | 22.355 | 22.355 | 2800.0 |
| 2014-05-29 07:15:00 | AAPL | Stock | 22.35 | 22.35 | 22.35 | 22.35 | 2800.0 |
| 2014-05-29 07:20:00 | AAPL | Stock | 22.3525 | 22.3529 | 22.3525 | 22.3529 | 14000.0 |
| 2014-05-29 07:25:00 | AAPL | Stock | 22.3529 | 22.3529 | 22.3496 | 22.3496 | 5600.0 |
| 2014-05-29 07:30:00 | AAPL | Stock | 22.3525 | 22.3529 | 22.3514 | 22.3514 | 26600.0 |
| 2014-05-29 07:40:00 | AAPL | Stock | 22.3571 | 22.3661 | 22.3571 | 22.3661 | 69804.0 |
| 2014-05-29 07:55:00 | AAPL | Stock | 22.3811 | 22.3811 | 22.3696 | 22.3696 | 14140.0 |
| 2014-05-29 08:00:00 | AAPL | Stock | 22.3804 | 22.3839 | 22.3464 | 22.3625 | 168784.0 |
| 2014-05-29 08:05:00 | AAPL | Stock | 22.3679 | 22.3821 | 22.3571 | 22.3671 | 79688.0 |
| 2014-05-29 08:10:00 | AAPL | Stock | 22.3779 | 22.3779 | 22.3607 | 22.3671 | 56056.0 |
| 2014-05-29 08:15:00 | AAPL | Stock | 22.3657 | 22.3729 | 22.3571 | 22.3661 | 54460.0 |
| 2014-05-29 08:20:00 | AAPL | Stock | 22.3689 | 22.3689 | 22.3593 | 22.3593 | 25200.0 |
| 2014-05-29 08:25:00 | AAPL | Stock | 22.3679 | 22.3732 | 22.3679 | 22.3732 | 42000.0 |
| 2014-05-29 08:30:00 | AAPL | Stock | 22.3586 | 22.37 | 22.3429 | 22.37 | 140364.0 |
| 2014-05-29 08:35:00 | AAPL | Stock | 22.37 | 22.37 | 22.3618 | 22.3643 | 20160.0 |
| 2014-05-29 08:40:00 | AAPL | Stock | 22.3679 | 22.3929 | 22.3679 | 22.3843 | 214424.0 |
| 2014-05-29 08:45:00 | AAPL | Stock | 22.3868 | 22.3918 | 22.3714 | 22.3757 | 209272.0 |
| 2014-05-29 08:50:00 | AAPL | Stock | 22.3786 | 22.3875 | 22.3754 | 22.3875 | 84168.0 |
| 2014-05-29 08:55:00 | AAPL | Stock | 22.3786 | 22.3875 | 22.3786 | 22.3821 | 79408.0 |
| 2014-05-29 09:00:00 | AAPL | Stock | 22.3839 | 22.3857 | 22.3796 | 22.3814 | 44800.0 |
| 2014-05-29 09:05:00 | AAPL | Stock | 22.3839 | 22.3975 | 22.3818 | 22.3932 | 346836.0 |
| 2014-05-29 09:10:00 | AAPL | Stock | 22.3929 | 22.3982 | 22.3929 | 22.3946 | 62272.0 |
| 2014-05-29 09:15:00 | AAPL | Stock | 22.395 | 22.4 | 22.3929 | 22.4 | 173292.0 |
| 2014-05-29 09:20:00 | AAPL | Stock | 22.3982 | 22.4254 | 22.3982 | 22.4254 | 330456.0 |
| 2014-05-29 09:25:00 | AAPL | Stock | 22.42 | 22.4343 | 22.4039 | 22.4232 | 667128.0 |
| 2014-05-29 09:30:00 | AAPL | Stock | 22.4232 | 22.5218 | 22.4204 | 22.4925 | 17938536.0 |
| 2014-05-29 09:35:00 | AAPL | Stock | 22.4939 | 22.4939 | 22.4368 | 22.4611 | 10051692.0 |
| 2014-05-29 09:40:00 | AAPL | Stock | 22.46 | 22.5 | 22.4411 | 22.4964 | 5888652.0 |
| 2014-05-29 09:45:00 | AAPL | Stock | 22.4929 | 22.5011 | 22.4532 | 22.46 | 5712392.0 |
| 2014-05-29 09:50:00 | AAPL | Stock | 22.458 | 22.4711 | 22.4464 | 22.4679 | 5593812.0 |
| 2014-05-29 09:55:00 | AAPL | Stock | 22.4679 | 22.5157 | 22.4661 | 22.5011 | 5674284.0 |
| 2014-05-29 10:00:00 | AAPL | Stock | 22.4964 | 22.5179 | 22.4786 | 22.4868 | 4952752.0 |
| 2014-05-29 10:05:00 | AAPL | Stock | 22.4902 | 22.4968 | 22.4507 | 22.4879 | 4246060.0 |
| 2014-05-29 10:10:00 | AAPL | Stock | 22.4896 | 22.4964 | 22.4632 | 22.4764 | 3610712.0 |
| 2014-05-29 10:15:00 | AAPL | Stock | 22.4814 | 22.4929 | 22.4611 | 22.4829 | 3866296.0 |
| 2014-05-29 10:20:00 | AAPL | Stock | 22.4829 | 22.5125 | 22.4729 | 22.4968 | 4764508.0 |
| 2014-05-29 10:25:00 | AAPL | Stock | 22.4968 | 22.5125 | 22.4879 | 22.503 | 2628976.0 |
| 2014-05-29 10:30:00 | AAPL | Stock | 22.4968 | 22.5046 | 22.49 | 22.5032 | 2062536.0 |
> showing 50 of 356,384 rows — these rows as CSV