PREVIEW / stock_5min / 2010-11-05
file: by_date/stock_5min/2010/2010-11-05.parquet size: 4.9 MB rows: 338,944 symbols: 3,511
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-11-05 04:25:00 | AAPL | Stock | 11.3393 | 11.3393 | 11.3393 | 11.3393 | 11200.0 |
| 2010-11-05 05:50:00 | AAPL | Stock | 11.3136 | 11.3136 | 11.3136 | 11.3136 | 2800.0 |
| 2010-11-05 06:05:00 | AAPL | Stock | 11.2932 | 11.2932 | 11.2932 | 11.2932 | 2800.0 |
| 2010-11-05 06:20:00 | AAPL | Stock | 11.3043 | 11.3043 | 11.3043 | 11.3043 | 2800.0 |
| 2010-11-05 06:40:00 | AAPL | Stock | 11.2946 | 11.2946 | 11.2929 | 11.2929 | 22120.0 |
| 2010-11-05 06:55:00 | AAPL | Stock | 11.2911 | 11.2911 | 11.29 | 11.29 | 8400.0 |
| 2010-11-05 07:00:00 | AAPL | Stock | 11.29 | 11.2946 | 11.29 | 11.2946 | 8400.0 |
| 2010-11-05 07:05:00 | AAPL | Stock | 11.2907 | 11.2954 | 11.29 | 11.2954 | 21840.0 |
| 2010-11-05 07:10:00 | AAPL | Stock | 11.3054 | 11.3107 | 11.3018 | 11.3071 | 35000.0 |
| 2010-11-05 07:15:00 | AAPL | Stock | 11.305 | 11.305 | 11.3043 | 11.3043 | 5600.0 |
| 2010-11-05 07:25:00 | AAPL | Stock | 11.3104 | 11.3168 | 11.3104 | 11.3168 | 21000.0 |
| 2010-11-05 07:30:00 | AAPL | Stock | 11.3168 | 11.3175 | 11.3168 | 11.3168 | 11760.0 |
| 2010-11-05 07:35:00 | AAPL | Stock | 11.325 | 11.3314 | 11.325 | 11.3279 | 16800.0 |
| 2010-11-05 07:40:00 | AAPL | Stock | 11.3279 | 11.3279 | 11.325 | 11.325 | 22400.0 |
| 2010-11-05 07:45:00 | AAPL | Stock | 11.3268 | 11.3268 | 11.3218 | 11.3218 | 14000.0 |
| 2010-11-05 07:50:00 | AAPL | Stock | 11.3264 | 11.3279 | 11.3264 | 11.3279 | 5600.0 |
| 2010-11-05 07:55:00 | AAPL | Stock | 11.3264 | 11.3275 | 11.3264 | 11.3275 | 8960.0 |
| 2010-11-05 08:00:00 | AAPL | Stock | 11.3221 | 11.3371 | 11.3214 | 11.3321 | 323708.0 |
| 2010-11-05 08:05:00 | AAPL | Stock | 11.3307 | 11.3321 | 11.3254 | 11.3286 | 234920.0 |
| 2010-11-05 08:10:00 | AAPL | Stock | 11.3307 | 11.3336 | 11.3279 | 11.3321 | 138572.0 |
| 2010-11-05 08:15:00 | AAPL | Stock | 11.3321 | 11.3336 | 11.3279 | 11.3279 | 132132.0 |
| 2010-11-05 08:20:00 | AAPL | Stock | 11.3279 | 11.3289 | 11.3254 | 11.3286 | 98476.0 |
| 2010-11-05 08:25:00 | AAPL | Stock | 11.3307 | 11.3307 | 11.3225 | 11.325 | 218596.0 |
| 2010-11-05 08:30:00 | AAPL | Stock | 11.3321 | 11.3804 | 11.3225 | 11.3661 | 4336416.0 |
| 2010-11-05 08:35:00 | AAPL | Stock | 11.3671 | 11.3925 | 11.3661 | 11.3829 | 803236.0 |
| 2010-11-05 08:40:00 | AAPL | Stock | 11.3832 | 11.3893 | 11.3739 | 11.3782 | 484456.0 |
| 2010-11-05 08:45:00 | AAPL | Stock | 11.3782 | 11.38 | 11.3529 | 11.3607 | 708204.0 |
| 2010-11-05 08:50:00 | AAPL | Stock | 11.3611 | 11.3643 | 11.3546 | 11.3571 | 246680.0 |
| 2010-11-05 08:55:00 | AAPL | Stock | 11.3579 | 11.3643 | 11.3489 | 11.3489 | 332528.0 |
| 2010-11-05 09:00:00 | AAPL | Stock | 11.3489 | 11.3568 | 11.3489 | 11.3568 | 168364.0 |
| 2010-11-05 09:05:00 | AAPL | Stock | 11.3571 | 11.3604 | 11.3554 | 11.3554 | 108640.0 |
| 2010-11-05 09:10:00 | AAPL | Stock | 11.3554 | 11.3571 | 11.3511 | 11.355 | 150052.0 |
| 2010-11-05 09:15:00 | AAPL | Stock | 11.3536 | 11.3539 | 11.3429 | 11.3511 | 77560.0 |
| 2010-11-05 09:20:00 | AAPL | Stock | 11.3436 | 11.3557 | 11.3436 | 11.3514 | 57400.0 |
| 2010-11-05 09:25:00 | AAPL | Stock | 11.3468 | 11.3632 | 11.3468 | 11.3582 | 205688.0 |
| 2010-11-05 09:30:00 | AAPL | Stock | 11.3532 | 11.3879 | 11.3393 | 11.3871 | 19936924.0 |
| 2010-11-05 09:35:00 | AAPL | Stock | 11.3864 | 11.4132 | 11.3611 | 11.3871 | 20415360.0 |
| 2010-11-05 09:40:00 | AAPL | Stock | 11.3871 | 11.3889 | 11.3412 | 11.3418 | 11120116.0 |
| 2010-11-05 09:45:00 | AAPL | Stock | 11.3432 | 11.3671 | 11.3357 | 11.3507 | 9601088.0 |
| 2010-11-05 09:50:00 | AAPL | Stock | 11.3517 | 11.375 | 11.3321 | 11.3746 | 9031652.0 |
| 2010-11-05 09:55:00 | AAPL | Stock | 11.375 | 11.3918 | 11.3607 | 11.3639 | 8956248.0 |
| 2010-11-05 10:00:00 | AAPL | Stock | 11.3639 | 11.375 | 11.3536 | 11.355 | 4716292.0 |
| 2010-11-05 10:05:00 | AAPL | Stock | 11.3561 | 11.3732 | 11.3511 | 11.3654 | 5523868.0 |
| 2010-11-05 10:10:00 | AAPL | Stock | 11.3661 | 11.3814 | 11.3564 | 11.3704 | 8045408.0 |
| 2010-11-05 10:15:00 | AAPL | Stock | 11.3732 | 11.3732 | 11.3571 | 11.3596 | 4194064.0 |
| 2010-11-05 10:20:00 | AAPL | Stock | 11.3597 | 11.3714 | 11.3575 | 11.3639 | 2678480.0 |
| 2010-11-05 10:25:00 | AAPL | Stock | 11.3614 | 11.3679 | 11.3536 | 11.36 | 4063584.0 |
| 2010-11-05 10:30:00 | AAPL | Stock | 11.3593 | 11.3657 | 11.3557 | 11.3589 | 3353280.0 |
| 2010-11-05 10:35:00 | AAPL | Stock | 11.3598 | 11.3732 | 11.3589 | 11.3679 | 4912180.0 |
| 2010-11-05 10:40:00 | AAPL | Stock | 11.3664 | 11.3764 | 11.3607 | 11.375 | 4272576.0 |
> showing 50 of 338,944 rows — these rows as CSV