PREVIEW / stock_5min / 2007-06-05
file: by_date/stock_5min/2007/2007-06-05.parquet size: 4.0 MB rows: 295,284 symbols: 3,001
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-05 09:30:00 | AAPL | Stock | 4.3361 | 4.3532 | 4.3179 | 4.3254 | 39464936.0 |
| 2007-06-05 09:35:00 | AAPL | Stock | 4.3264 | 4.3268 | 4.3036 | 4.3246 | 27176520.0 |
| 2007-06-05 09:40:00 | AAPL | Stock | 4.3246 | 4.3554 | 4.32 | 4.3546 | 28781536.0 |
| 2007-06-05 09:45:00 | AAPL | Stock | 4.3546 | 4.3679 | 4.3161 | 4.3571 | 33669804.0 |
| 2007-06-05 09:50:00 | AAPL | Stock | 4.3568 | 4.3643 | 4.3396 | 4.3464 | 28880152.0 |
| 2007-06-05 09:55:00 | AAPL | Stock | 4.3454 | 4.3532 | 4.3393 | 4.3475 | 14352800.0 |
| 2007-06-05 10:00:00 | AAPL | Stock | 4.3471 | 4.3561 | 4.3339 | 4.3421 | 20349168.0 |
| 2007-06-05 10:05:00 | AAPL | Stock | 4.3425 | 4.3629 | 4.3396 | 4.3582 | 15142344.0 |
| 2007-06-05 10:10:00 | AAPL | Stock | 4.3575 | 4.3614 | 4.3543 | 4.3596 | 13112960.0 |
| 2007-06-05 10:15:00 | AAPL | Stock | 4.3596 | 4.3639 | 4.3482 | 4.3521 | 15457848.0 |
| 2007-06-05 10:20:00 | AAPL | Stock | 4.3514 | 4.3532 | 4.3411 | 4.3457 | 12721324.0 |
| 2007-06-05 10:25:00 | AAPL | Stock | 4.345 | 4.3607 | 4.345 | 4.3607 | 12800620.0 |
| 2007-06-05 10:30:00 | AAPL | Stock | 4.3607 | 4.3696 | 4.3579 | 4.3593 | 18686920.0 |
| 2007-06-05 10:35:00 | AAPL | Stock | 4.3593 | 4.3614 | 4.3482 | 4.3525 | 12663308.0 |
| 2007-06-05 10:40:00 | AAPL | Stock | 4.3518 | 4.3564 | 4.3414 | 4.3521 | 12339152.0 |
| 2007-06-05 10:45:00 | AAPL | Stock | 4.3521 | 4.3625 | 4.3521 | 4.3543 | 11717748.0 |
| 2007-06-05 10:50:00 | AAPL | Stock | 4.3543 | 4.3732 | 4.3539 | 4.3686 | 19907972.0 |
| 2007-06-05 10:55:00 | AAPL | Stock | 4.3693 | 4.3696 | 4.3593 | 4.3636 | 10599736.0 |
| 2007-06-05 11:00:00 | AAPL | Stock | 4.3639 | 4.3679 | 4.3614 | 4.3625 | 9213372.0 |
| 2007-06-05 11:05:00 | AAPL | Stock | 4.3632 | 4.3632 | 4.3514 | 4.3579 | 12149228.0 |
| 2007-06-05 11:10:00 | AAPL | Stock | 4.3582 | 4.3696 | 4.3557 | 4.3657 | 9919532.0 |
| 2007-06-05 11:15:00 | AAPL | Stock | 4.3657 | 4.3661 | 4.3575 | 4.3621 | 6418496.0 |
| 2007-06-05 11:20:00 | AAPL | Stock | 4.3621 | 4.3654 | 4.3571 | 4.3646 | 8508108.0 |
| 2007-06-05 11:25:00 | AAPL | Stock | 4.3646 | 4.3736 | 4.3636 | 4.37 | 12958148.0 |
| 2007-06-05 11:30:00 | AAPL | Stock | 4.37 | 4.3729 | 4.3543 | 4.3714 | 9398004.0 |
| 2007-06-05 11:35:00 | AAPL | Stock | 4.3718 | 4.3814 | 4.3693 | 4.3757 | 19121284.0 |
| 2007-06-05 11:40:00 | AAPL | Stock | 4.3754 | 4.3754 | 4.3696 | 4.3736 | 11885048.0 |
| 2007-06-05 11:45:00 | AAPL | Stock | 4.3732 | 4.3757 | 4.3596 | 4.3661 | 18196500.0 |
| 2007-06-05 11:50:00 | AAPL | Stock | 4.3654 | 4.3704 | 4.3607 | 4.3682 | 9692956.0 |
| 2007-06-05 11:55:00 | AAPL | Stock | 4.368 | 4.3714 | 4.3607 | 4.3618 | 8645868.0 |
| 2007-06-05 12:00:00 | AAPL | Stock | 4.3614 | 4.3632 | 4.3521 | 4.3607 | 15426488.0 |
| 2007-06-05 12:05:00 | AAPL | Stock | 4.3607 | 4.3736 | 4.3604 | 4.3682 | 20673940.0 |
| 2007-06-05 12:10:00 | AAPL | Stock | 4.3686 | 4.3711 | 4.3614 | 4.3682 | 10941056.0 |
| 2007-06-05 12:15:00 | AAPL | Stock | 4.3682 | 4.3732 | 4.3536 | 4.3579 | 10979360.0 |
| 2007-06-05 12:20:00 | AAPL | Stock | 4.3579 | 4.3643 | 4.3554 | 4.3586 | 9831220.0 |
| 2007-06-05 12:25:00 | AAPL | Stock | 4.3582 | 4.3636 | 4.3482 | 4.3618 | 14635880.0 |
| 2007-06-05 12:30:00 | AAPL | Stock | 4.3618 | 4.3668 | 4.3607 | 4.365 | 7327152.0 |
| 2007-06-05 12:35:00 | AAPL | Stock | 4.3646 | 4.3661 | 4.3589 | 4.3654 | 5838504.0 |
| 2007-06-05 12:40:00 | AAPL | Stock | 4.3646 | 4.3689 | 4.3639 | 4.365 | 6642552.0 |
| 2007-06-05 12:45:00 | AAPL | Stock | 4.3646 | 4.37 | 4.3643 | 4.3664 | 5142620.0 |
| 2007-06-05 12:50:00 | AAPL | Stock | 4.3664 | 4.3714 | 4.3657 | 4.3711 | 4170320.0 |
| 2007-06-05 12:55:00 | AAPL | Stock | 4.3714 | 4.375 | 4.3689 | 4.3714 | 7394352.0 |
| 2007-06-05 13:00:00 | AAPL | Stock | 4.3718 | 4.3721 | 4.3646 | 4.3675 | 6280820.0 |
| 2007-06-05 13:05:00 | AAPL | Stock | 4.3679 | 4.3754 | 4.3679 | 4.3743 | 7410704.0 |
| 2007-06-05 13:10:00 | AAPL | Stock | 4.3743 | 4.38 | 4.3732 | 4.3761 | 8660484.0 |
| 2007-06-05 13:15:00 | AAPL | Stock | 4.3768 | 4.3782 | 4.3725 | 4.3757 | 6103524.0 |
| 2007-06-05 13:20:00 | AAPL | Stock | 4.3761 | 4.3764 | 4.3696 | 4.3725 | 8167264.0 |
| 2007-06-05 13:25:00 | AAPL | Stock | 4.3725 | 4.3754 | 4.3654 | 4.3675 | 7091056.0 |
| 2007-06-05 13:30:00 | AAPL | Stock | 4.3675 | 4.3693 | 4.3636 | 4.3671 | 6798260.0 |
| 2007-06-05 13:35:00 | AAPL | Stock | 4.3671 | 4.375 | 4.3671 | 4.3729 | 8238580.0 |
> showing 50 of 295,284 rows — these rows as CSV