PREVIEW / stock_5min / 2005-07-12
file: by_date/stock_5min/2005/2005-07-12.parquet size: 2.7 MB rows: 200,824 symbols: 2,019
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-12 07:20:00 | AAPL | Stock | 1.3682 | 1.3682 | 1.3682 | 1.3682 | 53200.0 |
| 2005-07-12 07:45:00 | AAPL | Stock | 1.3682 | 1.3682 | 1.3682 | 1.3682 | 28000.0 |
| 2005-07-12 07:50:00 | AAPL | Stock | 1.3718 | 1.3718 | 1.3718 | 1.3718 | 140000.0 |
| 2005-07-12 07:55:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 4200.0 |
| 2005-07-12 08:00:00 | AAPL | Stock | 1.375 | 1.3786 | 1.3707 | 1.3736 | 718200.0 |
| 2005-07-12 08:05:00 | AAPL | Stock | 1.3768 | 1.3768 | 1.3714 | 1.3757 | 246400.0 |
| 2005-07-12 08:10:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3732 | 1.3732 | 28000.0 |
| 2005-07-12 08:20:00 | AAPL | Stock | 1.3725 | 1.3732 | 1.3718 | 1.3718 | 70000.0 |
| 2005-07-12 08:25:00 | AAPL | Stock | 1.3714 | 1.3729 | 1.3707 | 1.3707 | 16800.0 |
| 2005-07-12 08:30:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3689 | 1.3689 | 30800.0 |
| 2005-07-12 08:35:00 | AAPL | Stock | 1.3707 | 1.3725 | 1.3689 | 1.3704 | 137200.0 |
| 2005-07-12 08:40:00 | AAPL | Stock | 1.3704 | 1.3714 | 1.3704 | 1.3704 | 85400.0 |
| 2005-07-12 08:45:00 | AAPL | Stock | 1.3686 | 1.3686 | 1.3686 | 1.3686 | 2800.0 |
| 2005-07-12 08:50:00 | AAPL | Stock | 1.3696 | 1.3696 | 1.3679 | 1.3679 | 33600.0 |
| 2005-07-12 08:55:00 | AAPL | Stock | 1.3675 | 1.3679 | 1.3654 | 1.3675 | 131908.0 |
| 2005-07-12 09:00:00 | AAPL | Stock | 1.3679 | 1.3707 | 1.3679 | 1.3707 | 78400.0 |
| 2005-07-12 09:05:00 | AAPL | Stock | 1.3704 | 1.3704 | 1.3682 | 1.3682 | 22400.0 |
| 2005-07-12 09:10:00 | AAPL | Stock | 1.3682 | 1.3693 | 1.3679 | 1.3679 | 168000.0 |
| 2005-07-12 09:15:00 | AAPL | Stock | 1.3679 | 1.3679 | 1.3679 | 1.3679 | 14000.0 |
| 2005-07-12 09:20:00 | AAPL | Stock | 1.3671 | 1.3675 | 1.3671 | 1.3675 | 15960.0 |
| 2005-07-12 09:25:00 | AAPL | Stock | 1.3679 | 1.3679 | 1.3654 | 1.3654 | 487956.0 |
| 2005-07-12 09:30:00 | AAPL | Stock | 1.3654 | 1.3679 | 1.3621 | 1.3625 | 9486204.0 |
| 2005-07-12 09:35:00 | AAPL | Stock | 1.3625 | 1.3646 | 1.3611 | 1.3625 | 5487468.0 |
| 2005-07-12 09:40:00 | AAPL | Stock | 1.3625 | 1.3679 | 1.3625 | 1.3675 | 7698348.0 |
| 2005-07-12 09:45:00 | AAPL | Stock | 1.3675 | 1.3714 | 1.365 | 1.3664 | 8200276.0 |
| 2005-07-12 09:50:00 | AAPL | Stock | 1.3664 | 1.3693 | 1.3661 | 1.3689 | 3384556.0 |
| 2005-07-12 09:55:00 | AAPL | Stock | 1.3689 | 1.37 | 1.3686 | 1.3693 | 5513116.0 |
| 2005-07-12 10:00:00 | AAPL | Stock | 1.3696 | 1.37 | 1.3618 | 1.3621 | 6936468.0 |
| 2005-07-12 10:05:00 | AAPL | Stock | 1.3621 | 1.3696 | 1.3596 | 1.3596 | 10175256.0 |
| 2005-07-12 10:10:00 | AAPL | Stock | 1.3596 | 1.3614 | 1.3571 | 1.3593 | 3851148.0 |
| 2005-07-12 10:15:00 | AAPL | Stock | 1.3593 | 1.3611 | 1.3579 | 1.3607 | 5751732.0 |
| 2005-07-12 10:20:00 | AAPL | Stock | 1.3611 | 1.3625 | 1.3607 | 1.3611 | 4730656.0 |
| 2005-07-12 10:25:00 | AAPL | Stock | 1.3607 | 1.3657 | 1.3586 | 1.3594 | 6973624.0 |
| 2005-07-12 10:30:00 | AAPL | Stock | 1.3596 | 1.3618 | 1.3589 | 1.3607 | 6209616.0 |
| 2005-07-12 10:35:00 | AAPL | Stock | 1.3606 | 1.3618 | 1.3596 | 1.3611 | 6848296.0 |
| 2005-07-12 10:40:00 | AAPL | Stock | 1.3611 | 1.3621 | 1.36 | 1.3621 | 4873484.0 |
| 2005-07-12 10:45:00 | AAPL | Stock | 1.3618 | 1.3629 | 1.3589 | 1.3607 | 11874268.0 |
| 2005-07-12 10:50:00 | AAPL | Stock | 1.3611 | 1.3611 | 1.3593 | 1.3603 | 5012336.0 |
| 2005-07-12 10:55:00 | AAPL | Stock | 1.3604 | 1.3618 | 1.36 | 1.3614 | 2973264.0 |
| 2005-07-12 11:00:00 | AAPL | Stock | 1.3614 | 1.3621 | 1.36 | 1.36 | 2602068.0 |
| 2005-07-12 11:05:00 | AAPL | Stock | 1.36 | 1.3607 | 1.3589 | 1.3596 | 3001600.0 |
| 2005-07-12 11:10:00 | AAPL | Stock | 1.3596 | 1.3596 | 1.3571 | 1.3579 | 3479952.0 |
| 2005-07-12 11:15:00 | AAPL | Stock | 1.3579 | 1.3596 | 1.3575 | 1.3596 | 3043516.0 |
| 2005-07-12 11:20:00 | AAPL | Stock | 1.3596 | 1.3604 | 1.3586 | 1.36 | 2355696.0 |
| 2005-07-12 11:25:00 | AAPL | Stock | 1.36 | 1.3604 | 1.3564 | 1.3582 | 7863996.0 |
| 2005-07-12 11:30:00 | AAPL | Stock | 1.3582 | 1.3589 | 1.3571 | 1.3589 | 2497040.0 |
| 2005-07-12 11:35:00 | AAPL | Stock | 1.3586 | 1.3607 | 1.3571 | 1.3575 | 4806648.0 |
| 2005-07-12 11:40:00 | AAPL | Stock | 1.3575 | 1.3575 | 1.355 | 1.3571 | 5996396.0 |
| 2005-07-12 11:45:00 | AAPL | Stock | 1.3571 | 1.3571 | 1.3554 | 1.356 | 3583496.0 |
| 2005-07-12 11:50:00 | AAPL | Stock | 1.3557 | 1.3593 | 1.3557 | 1.3576 | 5527312.0 |
> showing 50 of 200,824 rows — these rows as CSV