PREVIEW / stock_5min / 2005-07-11
file: by_date/stock_5min/2005/2005-07-11.parquet size: 2.8 MB rows: 205,715 symbols: 2,028
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-11 08:00:00 | AAPL | Stock | 1.375 | 1.3857 | 1.3721 | 1.3857 | 333060.0 |
| 2005-07-11 08:05:00 | AAPL | Stock | 1.3768 | 1.3854 | 1.3768 | 1.3854 | 103600.0 |
| 2005-07-11 08:10:00 | AAPL | Stock | 1.3821 | 1.3854 | 1.3821 | 1.3829 | 290080.0 |
| 2005-07-11 08:15:00 | AAPL | Stock | 1.3836 | 1.3836 | 1.3818 | 1.3818 | 170800.0 |
| 2005-07-11 08:20:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3821 | 1.3821 | 14000.0 |
| 2005-07-11 08:25:00 | AAPL | Stock | 1.3821 | 1.3821 | 1.3796 | 1.3796 | 14000.0 |
| 2005-07-11 08:30:00 | AAPL | Stock | 1.3796 | 1.3814 | 1.3796 | 1.3814 | 5600.0 |
| 2005-07-11 08:35:00 | AAPL | Stock | 1.3814 | 1.3821 | 1.3796 | 1.3796 | 103600.0 |
| 2005-07-11 08:40:00 | AAPL | Stock | 1.3796 | 1.3804 | 1.3789 | 1.3804 | 162400.0 |
| 2005-07-11 08:45:00 | AAPL | Stock | 1.3775 | 1.3775 | 1.3768 | 1.3768 | 13300.0 |
| 2005-07-11 08:50:00 | AAPL | Stock | 1.3782 | 1.3786 | 1.3754 | 1.3754 | 92736.0 |
| 2005-07-11 08:55:00 | AAPL | Stock | 1.3757 | 1.3757 | 1.3757 | 1.3757 | 21028.0 |
| 2005-07-11 09:00:00 | AAPL | Stock | 1.3754 | 1.3754 | 1.3746 | 1.375 | 198800.0 |
| 2005-07-11 09:05:00 | AAPL | Stock | 1.3746 | 1.375 | 1.3743 | 1.3743 | 48048.0 |
| 2005-07-11 09:10:00 | AAPL | Stock | 1.3732 | 1.3768 | 1.3732 | 1.3746 | 623000.0 |
| 2005-07-11 09:15:00 | AAPL | Stock | 1.3768 | 1.3768 | 1.3754 | 1.3754 | 13524.0 |
| 2005-07-11 09:20:00 | AAPL | Stock | 1.3764 | 1.3786 | 1.3764 | 1.3786 | 106260.0 |
| 2005-07-11 09:25:00 | AAPL | Stock | 1.3786 | 1.3814 | 1.37 | 1.3704 | 1854440.0 |
| 2005-07-11 09:30:00 | AAPL | Stock | 1.3704 | 1.3804 | 1.3696 | 1.3764 | 24392508.0 |
| 2005-07-11 09:35:00 | AAPL | Stock | 1.3768 | 1.3789 | 1.3729 | 1.3729 | 14407148.0 |
| 2005-07-11 09:40:00 | AAPL | Stock | 1.3729 | 1.375 | 1.3729 | 1.3739 | 9088464.0 |
| 2005-07-11 09:45:00 | AAPL | Stock | 1.3739 | 1.3768 | 1.3732 | 1.3743 | 9837408.0 |
| 2005-07-11 09:50:00 | AAPL | Stock | 1.3743 | 1.3743 | 1.3725 | 1.3732 | 5552540.0 |
| 2005-07-11 09:55:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3643 | 1.3654 | 9979088.0 |
| 2005-07-11 10:00:00 | AAPL | Stock | 1.365 | 1.3661 | 1.3607 | 1.3621 | 12150208.0 |
| 2005-07-11 10:05:00 | AAPL | Stock | 1.3621 | 1.3636 | 1.3579 | 1.3586 | 12675656.0 |
| 2005-07-11 10:10:00 | AAPL | Stock | 1.3582 | 1.3611 | 1.35 | 1.3529 | 19041484.0 |
| 2005-07-11 10:15:00 | AAPL | Stock | 1.3532 | 1.3554 | 1.3493 | 1.3543 | 12920152.0 |
| 2005-07-11 10:20:00 | AAPL | Stock | 1.3539 | 1.3539 | 1.3507 | 1.3514 | 6952540.0 |
| 2005-07-11 10:25:00 | AAPL | Stock | 1.3525 | 1.3746 | 1.3511 | 1.3564 | 8443064.0 |
| 2005-07-11 10:30:00 | AAPL | Stock | 1.3568 | 1.3586 | 1.3539 | 1.3546 | 6416620.0 |
| 2005-07-11 10:35:00 | AAPL | Stock | 1.3546 | 1.3568 | 1.3536 | 1.3564 | 3372320.0 |
| 2005-07-11 10:40:00 | AAPL | Stock | 1.3561 | 1.3575 | 1.3536 | 1.3571 | 6987008.0 |
| 2005-07-11 10:45:00 | AAPL | Stock | 1.3575 | 1.3593 | 1.3554 | 1.3568 | 6808424.0 |
| 2005-07-11 10:50:00 | AAPL | Stock | 1.3564 | 1.3571 | 1.3539 | 1.3564 | 5914160.0 |
| 2005-07-11 10:55:00 | AAPL | Stock | 1.3561 | 1.3575 | 1.3557 | 1.3571 | 5062148.0 |
| 2005-07-11 11:00:00 | AAPL | Stock | 1.3571 | 1.3575 | 1.3557 | 1.3561 | 2511488.0 |
| 2005-07-11 11:05:00 | AAPL | Stock | 1.3564 | 1.3607 | 1.3564 | 1.3586 | 8714076.0 |
| 2005-07-11 11:10:00 | AAPL | Stock | 1.3586 | 1.3632 | 1.3586 | 1.3632 | 8403136.0 |
| 2005-07-11 11:15:00 | AAPL | Stock | 1.3632 | 1.3646 | 1.3618 | 1.3636 | 5244652.0 |
| 2005-07-11 11:20:00 | AAPL | Stock | 1.3636 | 1.3646 | 1.3625 | 1.3639 | 5191340.0 |
| 2005-07-11 11:25:00 | AAPL | Stock | 1.3639 | 1.3661 | 1.3636 | 1.3657 | 4696944.0 |
| 2005-07-11 11:30:00 | AAPL | Stock | 1.3661 | 1.3664 | 1.365 | 1.3657 | 4073468.0 |
| 2005-07-11 11:35:00 | AAPL | Stock | 1.3661 | 1.3664 | 1.3614 | 1.3625 | 3928624.0 |
| 2005-07-11 11:40:00 | AAPL | Stock | 1.3629 | 1.3661 | 1.3618 | 1.3629 | 3347736.0 |
| 2005-07-11 11:45:00 | AAPL | Stock | 1.3629 | 1.3643 | 1.3618 | 1.3633 | 2564324.0 |
| 2005-07-11 11:50:00 | AAPL | Stock | 1.3632 | 1.3646 | 1.3632 | 1.3646 | 1176700.0 |
| 2005-07-11 11:55:00 | AAPL | Stock | 1.3639 | 1.3643 | 1.3614 | 1.3625 | 2242016.0 |
| 2005-07-11 12:00:00 | AAPL | Stock | 1.3629 | 1.3679 | 1.3604 | 1.3607 | 3459036.0 |
| 2005-07-11 12:05:00 | AAPL | Stock | 1.3607 | 1.3611 | 1.3582 | 1.3589 | 2391844.0 |
> showing 50 of 205,715 rows — these rows as CSV