PREVIEW / stock_5min / 2007-04-03
file: by_date/stock_5min/2007/2007-04-03.parquet size: 3.6 MB rows: 260,791 symbols: 2,573
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-04-03 07:20:00 | AAPL | Stock | 3.3461 | 3.3461 | 3.3461 | 3.3461 | 2800.0 |
| 2007-04-03 07:25:00 | AAPL | Stock | 3.3468 | 3.3468 | 3.3461 | 3.3461 | 24948.0 |
| 2007-04-03 07:30:00 | AAPL | Stock | 3.3482 | 3.3482 | 3.3482 | 3.3482 | 19600.0 |
| 2007-04-03 07:35:00 | AAPL | Stock | 3.3471 | 3.3471 | 3.3471 | 3.3471 | 5600.0 |
| 2007-04-03 07:40:00 | AAPL | Stock | 3.3554 | 3.3607 | 3.3554 | 3.3607 | 85540.0 |
| 2007-04-03 07:45:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3571 | 3.3571 | 106400.0 |
| 2007-04-03 07:50:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3521 | 3.3521 | 60200.0 |
| 2007-04-03 07:55:00 | AAPL | Stock | 3.3554 | 3.3554 | 3.3554 | 3.3554 | 2800.0 |
| 2007-04-03 08:00:00 | AAPL | Stock | 3.3554 | 3.3571 | 3.35 | 3.3536 | 580692.0 |
| 2007-04-03 08:05:00 | AAPL | Stock | 3.3518 | 3.3536 | 3.3504 | 3.3504 | 72184.0 |
| 2007-04-03 08:10:00 | AAPL | Stock | 3.3504 | 3.3571 | 3.3504 | 3.3536 | 455448.0 |
| 2007-04-03 08:15:00 | AAPL | Stock | 3.3546 | 3.3554 | 3.3536 | 3.3536 | 167300.0 |
| 2007-04-03 08:20:00 | AAPL | Stock | 3.3525 | 3.3536 | 3.3507 | 3.3511 | 75600.0 |
| 2007-04-03 08:25:00 | AAPL | Stock | 3.3532 | 3.3532 | 3.3518 | 3.3532 | 81200.0 |
| 2007-04-03 08:30:00 | AAPL | Stock | 3.3518 | 3.3539 | 3.3514 | 3.3539 | 131180.0 |
| 2007-04-03 08:35:00 | AAPL | Stock | 3.3536 | 3.3561 | 3.3536 | 3.3561 | 148120.0 |
| 2007-04-03 08:45:00 | AAPL | Stock | 3.3554 | 3.3564 | 3.3546 | 3.355 | 46200.0 |
| 2007-04-03 08:50:00 | AAPL | Stock | 3.355 | 3.3564 | 3.355 | 3.3557 | 144816.0 |
| 2007-04-03 08:55:00 | AAPL | Stock | 3.3557 | 3.3557 | 3.3554 | 3.3554 | 33600.0 |
| 2007-04-03 09:00:00 | AAPL | Stock | 3.3554 | 3.3571 | 3.3536 | 3.3536 | 404264.0 |
| 2007-04-03 09:05:00 | AAPL | Stock | 3.3539 | 3.3554 | 3.3536 | 3.3543 | 274400.0 |
| 2007-04-03 09:10:00 | AAPL | Stock | 3.3554 | 3.3579 | 3.355 | 3.355 | 382872.0 |
| 2007-04-03 09:15:00 | AAPL | Stock | 3.355 | 3.3579 | 3.355 | 3.3568 | 64400.0 |
| 2007-04-03 09:20:00 | AAPL | Stock | 3.3568 | 3.3579 | 3.3554 | 3.3571 | 132020.0 |
| 2007-04-03 09:25:00 | AAPL | Stock | 3.3564 | 3.3625 | 3.3564 | 3.3621 | 947800.0 |
| 2007-04-03 09:30:00 | AAPL | Stock | 3.3621 | 3.3625 | 3.3486 | 3.36 | 23643200.0 |
| 2007-04-03 09:35:00 | AAPL | Stock | 3.3596 | 3.36 | 3.3504 | 3.3564 | 16503200.0 |
| 2007-04-03 09:40:00 | AAPL | Stock | 3.3564 | 3.3568 | 3.3514 | 3.3543 | 10493308.0 |
| 2007-04-03 09:45:00 | AAPL | Stock | 3.355 | 3.375 | 3.3532 | 3.3729 | 29556380.0 |
| 2007-04-03 09:50:00 | AAPL | Stock | 3.3729 | 3.3771 | 3.3696 | 3.3743 | 18671772.0 |
| 2007-04-03 09:55:00 | AAPL | Stock | 3.3743 | 3.3793 | 3.3736 | 3.3741 | 17655288.0 |
| 2007-04-03 10:00:00 | AAPL | Stock | 3.3739 | 3.3839 | 3.3718 | 3.3779 | 25987164.0 |
| 2007-04-03 10:05:00 | AAPL | Stock | 3.3775 | 3.3829 | 3.3664 | 3.3693 | 18986408.0 |
| 2007-04-03 10:10:00 | AAPL | Stock | 3.3693 | 3.3832 | 3.3679 | 3.3696 | 5957868.0 |
| 2007-04-03 10:15:00 | AAPL | Stock | 3.3696 | 3.3782 | 3.3693 | 3.3714 | 8167852.0 |
| 2007-04-03 10:20:00 | AAPL | Stock | 3.3711 | 3.3743 | 3.3704 | 3.3721 | 6071856.0 |
| 2007-04-03 10:25:00 | AAPL | Stock | 3.3718 | 3.3746 | 3.3664 | 3.3671 | 7447356.0 |
| 2007-04-03 10:30:00 | AAPL | Stock | 3.3671 | 3.3739 | 3.3664 | 3.3693 | 4710972.0 |
| 2007-04-03 10:35:00 | AAPL | Stock | 3.3693 | 3.3732 | 3.3686 | 3.3732 | 5172020.0 |
| 2007-04-03 10:40:00 | AAPL | Stock | 3.3729 | 3.38 | 3.3729 | 3.3793 | 13275920.0 |
| 2007-04-03 10:45:00 | AAPL | Stock | 3.3796 | 3.3839 | 3.3775 | 3.3836 | 12674060.0 |
| 2007-04-03 10:50:00 | AAPL | Stock | 3.3836 | 3.3918 | 3.3829 | 3.3889 | 18635484.0 |
| 2007-04-03 10:55:00 | AAPL | Stock | 3.3889 | 3.3929 | 3.3879 | 3.3918 | 10942092.0 |
| 2007-04-03 11:00:00 | AAPL | Stock | 3.3918 | 3.3925 | 3.3889 | 3.3911 | 5729864.0 |
| 2007-04-03 11:05:00 | AAPL | Stock | 3.3911 | 3.3954 | 3.3907 | 3.3921 | 11284000.0 |
| 2007-04-03 11:10:00 | AAPL | Stock | 3.3925 | 3.3932 | 3.3879 | 3.3882 | 6232156.0 |
| 2007-04-03 11:15:00 | AAPL | Stock | 3.3882 | 3.39 | 3.3857 | 3.3861 | 6021680.0 |
| 2007-04-03 11:20:00 | AAPL | Stock | 3.3857 | 3.3864 | 3.3818 | 3.3839 | 9245404.0 |
| 2007-04-03 11:25:00 | AAPL | Stock | 3.3839 | 3.385 | 3.3821 | 3.3825 | 4531212.0 |
| 2007-04-03 11:30:00 | AAPL | Stock | 3.3825 | 3.3879 | 3.3821 | 3.3868 | 3412388.0 |
> showing 50 of 260,791 rows — these rows as CSV