PREVIEW / stock_5min / 2010-08-04
file: by_date/stock_5min/2010/2010-08-04.parquet size: 4.7 MB rows: 321,989 symbols: 3,491
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-04 05:50:00 | AAPL | Stock | 9.3214 | 9.3214 | 9.3214 | 9.3214 | 3948.0 |
| 2010-08-04 07:00:00 | AAPL | Stock | 9.3632 | 9.3632 | 9.3632 | 9.3632 | 5600.0 |
| 2010-08-04 07:05:00 | AAPL | Stock | 9.3625 | 9.3625 | 9.3625 | 9.3625 | 2800.0 |
| 2010-08-04 07:15:00 | AAPL | Stock | 9.3568 | 9.3607 | 9.3564 | 9.3607 | 14000.0 |
| 2010-08-04 07:25:00 | AAPL | Stock | 9.3614 | 9.3614 | 9.3614 | 9.3614 | 28000.0 |
| 2010-08-04 07:40:00 | AAPL | Stock | 9.3486 | 9.3554 | 9.3486 | 9.3554 | 8400.0 |
| 2010-08-04 07:45:00 | AAPL | Stock | 9.3486 | 9.3486 | 9.3446 | 9.3446 | 8400.0 |
| 2010-08-04 07:50:00 | AAPL | Stock | 9.3414 | 9.3414 | 9.3343 | 9.3393 | 19180.0 |
| 2010-08-04 08:00:00 | AAPL | Stock | 9.335 | 9.3375 | 9.3232 | 9.3243 | 150080.0 |
| 2010-08-04 08:05:00 | AAPL | Stock | 9.325 | 9.3271 | 9.3214 | 9.3271 | 57960.0 |
| 2010-08-04 08:10:00 | AAPL | Stock | 9.3214 | 9.3282 | 9.3214 | 9.3282 | 14000.0 |
| 2010-08-04 08:15:00 | AAPL | Stock | 9.3325 | 9.3632 | 9.3325 | 9.3571 | 353696.0 |
| 2010-08-04 08:20:00 | AAPL | Stock | 9.3539 | 9.3714 | 9.3539 | 9.3643 | 236936.0 |
| 2010-08-04 08:25:00 | AAPL | Stock | 9.3668 | 9.3786 | 9.3668 | 9.3786 | 224280.0 |
| 2010-08-04 08:30:00 | AAPL | Stock | 9.3786 | 9.3814 | 9.3675 | 9.3679 | 434840.0 |
| 2010-08-04 08:35:00 | AAPL | Stock | 9.3714 | 9.3714 | 9.3568 | 9.3639 | 122920.0 |
| 2010-08-04 08:40:00 | AAPL | Stock | 9.3621 | 9.3654 | 9.3621 | 9.3621 | 110684.0 |
| 2010-08-04 08:45:00 | AAPL | Stock | 9.3657 | 9.3739 | 9.3657 | 9.3711 | 144200.0 |
| 2010-08-04 08:50:00 | AAPL | Stock | 9.3679 | 9.3721 | 9.3632 | 9.3671 | 105448.0 |
| 2010-08-04 08:55:00 | AAPL | Stock | 9.3611 | 9.3639 | 9.3607 | 9.3625 | 56840.0 |
| 2010-08-04 09:00:00 | AAPL | Stock | 9.3625 | 9.3664 | 9.3625 | 9.3664 | 81592.0 |
| 2010-08-04 09:05:00 | AAPL | Stock | 9.3704 | 9.3732 | 9.3696 | 9.3711 | 68600.0 |
| 2010-08-04 09:10:00 | AAPL | Stock | 9.3704 | 9.3721 | 9.3632 | 9.3714 | 123480.0 |
| 2010-08-04 09:15:00 | AAPL | Stock | 9.3696 | 9.3739 | 9.3696 | 9.3739 | 323120.0 |
| 2010-08-04 09:20:00 | AAPL | Stock | 9.3786 | 9.3996 | 9.3786 | 9.3964 | 563220.0 |
| 2010-08-04 09:25:00 | AAPL | Stock | 9.3964 | 9.3971 | 9.3861 | 9.3861 | 283612.0 |
| 2010-08-04 09:30:00 | AAPL | Stock | 9.3871 | 9.4236 | 9.3682 | 9.4004 | 16633904.0 |
| 2010-08-04 09:35:00 | AAPL | Stock | 9.399 | 9.4179 | 9.3936 | 9.4171 | 9855524.0 |
| 2010-08-04 09:40:00 | AAPL | Stock | 9.4161 | 9.4279 | 9.4029 | 9.4264 | 9110332.0 |
| 2010-08-04 09:45:00 | AAPL | Stock | 9.4254 | 9.4321 | 9.4143 | 9.4282 | 11720996.0 |
| 2010-08-04 09:50:00 | AAPL | Stock | 9.4279 | 9.4318 | 9.4186 | 9.4236 | 6110496.0 |
| 2010-08-04 09:55:00 | AAPL | Stock | 9.4234 | 9.4282 | 9.4061 | 9.4146 | 7119084.0 |
| 2010-08-04 10:00:00 | AAPL | Stock | 9.4146 | 9.4386 | 9.3432 | 9.3496 | 27432384.0 |
| 2010-08-04 10:05:00 | AAPL | Stock | 9.3511 | 9.3804 | 9.3432 | 9.375 | 18474036.0 |
| 2010-08-04 10:10:00 | AAPL | Stock | 9.3736 | 9.375 | 9.3093 | 9.3318 | 22957676.0 |
| 2010-08-04 10:15:00 | AAPL | Stock | 9.3336 | 9.3343 | 9.2968 | 9.3039 | 15338008.0 |
| 2010-08-04 10:20:00 | AAPL | Stock | 9.3043 | 9.3439 | 9.3036 | 9.333 | 10332980.0 |
| 2010-08-04 10:25:00 | AAPL | Stock | 9.3329 | 9.3661 | 9.3311 | 9.3533 | 10857000.0 |
| 2010-08-04 10:30:00 | AAPL | Stock | 9.3554 | 9.36 | 9.3393 | 9.3439 | 4801664.0 |
| 2010-08-04 10:35:00 | AAPL | Stock | 9.3443 | 9.345 | 9.3196 | 9.3279 | 5440204.0 |
| 2010-08-04 10:40:00 | AAPL | Stock | 9.3279 | 9.3432 | 9.3214 | 9.3393 | 4276440.0 |
| 2010-08-04 10:45:00 | AAPL | Stock | 9.3404 | 9.3575 | 9.3357 | 9.3407 | 4138484.0 |
| 2010-08-04 10:50:00 | AAPL | Stock | 9.3418 | 9.3529 | 9.3304 | 9.3392 | 3041332.0 |
| 2010-08-04 10:55:00 | AAPL | Stock | 9.3375 | 9.3421 | 9.3321 | 9.3354 | 2465008.0 |
| 2010-08-04 11:00:00 | AAPL | Stock | 9.3357 | 9.3489 | 9.3339 | 9.3414 | 3455620.0 |
| 2010-08-04 11:05:00 | AAPL | Stock | 9.3423 | 9.3711 | 9.3423 | 9.3679 | 5640936.0 |
| 2010-08-04 11:10:00 | AAPL | Stock | 9.3682 | 9.375 | 9.3618 | 9.3714 | 3970372.0 |
| 2010-08-04 11:15:00 | AAPL | Stock | 9.3718 | 9.3796 | 9.3679 | 9.3729 | 6245988.0 |
| 2010-08-04 11:20:00 | AAPL | Stock | 9.3721 | 9.3807 | 9.3686 | 9.3793 | 3310720.0 |
| 2010-08-04 11:25:00 | AAPL | Stock | 9.3793 | 9.3918 | 9.3793 | 9.3859 | 5657120.0 |
> showing 50 of 321,989 rows — these rows as CSV