PREVIEW / stock_5min / 2011-10-04
file: by_date/stock_5min/2011/2011-10-04.parquet size: 5.3 MB rows: 355,606 symbols: 3,517
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-10-04 04:10:00 | AAPL | Stock | 13.3504 | 13.3504 | 13.3504 | 13.3504 | 2800.0 |
| 2011-10-04 04:15:00 | AAPL | Stock | 13.3504 | 13.3504 | 13.3504 | 13.3504 | 2800.0 |
| 2011-10-04 06:15:00 | AAPL | Stock | 13.3932 | 13.3932 | 13.3932 | 13.3932 | 2800.0 |
| 2011-10-04 06:35:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3929 | 13.3929 | 2800.0 |
| 2011-10-04 06:45:00 | AAPL | Stock | 13.3964 | 13.3964 | 13.3943 | 13.3943 | 5600.0 |
| 2011-10-04 06:50:00 | AAPL | Stock | 13.3964 | 13.3964 | 13.3964 | 13.3964 | 5600.0 |
| 2011-10-04 06:55:00 | AAPL | Stock | 13.3964 | 13.3964 | 13.3793 | 13.3821 | 56000.0 |
| 2011-10-04 07:00:00 | AAPL | Stock | 13.3725 | 13.375 | 13.3325 | 13.3421 | 246316.0 |
| 2011-10-04 07:05:00 | AAPL | Stock | 13.3332 | 13.3929 | 13.3286 | 13.3929 | 64260.0 |
| 2011-10-04 07:10:00 | AAPL | Stock | 13.3746 | 13.3779 | 13.3746 | 13.3779 | 21420.0 |
| 2011-10-04 07:15:00 | AAPL | Stock | 13.375 | 13.3929 | 13.3654 | 13.3886 | 91700.0 |
| 2011-10-04 07:20:00 | AAPL | Stock | 13.3929 | 13.3929 | 13.3661 | 13.3661 | 63644.0 |
| 2011-10-04 07:25:00 | AAPL | Stock | 13.3857 | 13.4214 | 13.3857 | 13.3857 | 50624.0 |
| 2011-10-04 07:30:00 | AAPL | Stock | 13.3843 | 13.3843 | 13.3843 | 13.3843 | 8400.0 |
| 2011-10-04 07:35:00 | AAPL | Stock | 13.3689 | 13.3843 | 13.3686 | 13.3693 | 70448.0 |
| 2011-10-04 07:40:00 | AAPL | Stock | 13.3714 | 13.375 | 13.3661 | 13.375 | 50344.0 |
| 2011-10-04 07:50:00 | AAPL | Stock | 13.3643 | 13.3679 | 13.3429 | 13.3564 | 60200.0 |
| 2011-10-04 07:55:00 | AAPL | Stock | 13.3464 | 13.3493 | 13.3429 | 13.3446 | 57428.0 |
| 2011-10-04 08:00:00 | AAPL | Stock | 13.3636 | 13.375 | 13.325 | 13.325 | 428260.0 |
| 2011-10-04 08:05:00 | AAPL | Stock | 13.3125 | 13.3311 | 13.2943 | 13.3036 | 265328.0 |
| 2011-10-04 08:10:00 | AAPL | Stock | 13.3029 | 13.3311 | 13.2982 | 13.3175 | 163912.0 |
| 2011-10-04 08:15:00 | AAPL | Stock | 13.3232 | 13.3711 | 13.3232 | 13.3293 | 173628.0 |
| 2011-10-04 08:20:00 | AAPL | Stock | 13.3232 | 13.3268 | 13.3179 | 13.3214 | 71344.0 |
| 2011-10-04 08:25:00 | AAPL | Stock | 13.3214 | 13.3411 | 13.3179 | 13.3411 | 33600.0 |
| 2011-10-04 08:30:00 | AAPL | Stock | 13.3407 | 13.3679 | 13.3407 | 13.3654 | 153524.0 |
| 2011-10-04 08:35:00 | AAPL | Stock | 13.3707 | 13.3893 | 13.3643 | 13.3789 | 347760.0 |
| 2011-10-04 08:40:00 | AAPL | Stock | 13.3854 | 13.3875 | 13.3486 | 13.3607 | 280868.0 |
| 2011-10-04 08:45:00 | AAPL | Stock | 13.3632 | 13.3971 | 13.3632 | 13.3704 | 604072.0 |
| 2011-10-04 08:50:00 | AAPL | Stock | 13.3821 | 13.3929 | 13.3743 | 13.3911 | 346724.0 |
| 2011-10-04 08:55:00 | AAPL | Stock | 13.3936 | 13.4125 | 13.3929 | 13.4107 | 786352.0 |
| 2011-10-04 09:00:00 | AAPL | Stock | 13.4146 | 13.4275 | 13.4114 | 13.4268 | 929628.0 |
| 2011-10-04 09:05:00 | AAPL | Stock | 13.4261 | 13.4357 | 13.3989 | 13.4039 | 1045912.0 |
| 2011-10-04 09:10:00 | AAPL | Stock | 13.4043 | 13.4107 | 13.3957 | 13.4029 | 399224.0 |
| 2011-10-04 09:15:00 | AAPL | Stock | 13.4032 | 13.4032 | 13.3811 | 13.3811 | 315952.0 |
| 2011-10-04 09:20:00 | AAPL | Stock | 13.3789 | 13.3929 | 13.3711 | 13.3929 | 160132.0 |
| 2011-10-04 09:25:00 | AAPL | Stock | 13.3921 | 13.3929 | 13.3564 | 13.3829 | 462532.0 |
| 2011-10-04 09:30:00 | AAPL | Stock | 13.3889 | 13.5179 | 13.3775 | 13.4457 | 24641232.0 |
| 2011-10-04 09:35:00 | AAPL | Stock | 13.4457 | 13.4814 | 13.4057 | 13.42 | 13863836.0 |
| 2011-10-04 09:40:00 | AAPL | Stock | 13.4125 | 13.4371 | 13.3071 | 13.3361 | 17287536.0 |
| 2011-10-04 09:45:00 | AAPL | Stock | 13.3377 | 13.3643 | 13.3218 | 13.3507 | 12991720.0 |
| 2011-10-04 09:50:00 | AAPL | Stock | 13.3518 | 13.3929 | 13.3318 | 13.35 | 11878244.0 |
| 2011-10-04 09:55:00 | AAPL | Stock | 13.35 | 13.37 | 13.2689 | 13.3321 | 15504860.0 |
| 2011-10-04 10:00:00 | AAPL | Stock | 13.3254 | 13.3636 | 13.2539 | 13.2604 | 14719628.0 |
| 2011-10-04 10:05:00 | AAPL | Stock | 13.2662 | 13.3568 | 13.225 | 13.3357 | 14026124.0 |
| 2011-10-04 10:10:00 | AAPL | Stock | 13.3364 | 13.3571 | 13.3004 | 13.3329 | 8006376.0 |
| 2011-10-04 10:15:00 | AAPL | Stock | 13.3236 | 13.3839 | 13.3146 | 13.3538 | 10853276.0 |
| 2011-10-04 10:20:00 | AAPL | Stock | 13.3517 | 13.3629 | 13.2857 | 13.2943 | 8123108.0 |
| 2011-10-04 10:25:00 | AAPL | Stock | 13.2941 | 13.3168 | 13.2718 | 13.3143 | 6770596.0 |
| 2011-10-04 10:30:00 | AAPL | Stock | 13.3143 | 13.355 | 13.2907 | 13.3114 | 6957972.0 |
| 2011-10-04 10:35:00 | AAPL | Stock | 13.3114 | 13.3693 | 13.3014 | 13.3664 | 7604632.0 |
> showing 50 of 355,606 rows — these rows as CSV