PREVIEW / stock_5min / 2007-04-09
file: by_date/stock_5min/2007/2007-04-09.parquet size: 3.5 MB rows: 253,927 symbols: 2,582
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-09 07:55:00 | AAPL | Stock | 3.3836 | 3.3925 | 3.3836 | 3.3925 | 16800.0 |
| 2007-04-09 08:00:00 | AAPL | Stock | 3.3836 | 3.3921 | 3.3829 | 3.3911 | 238000.0 |
| 2007-04-09 08:05:00 | AAPL | Stock | 3.3904 | 3.4007 | 3.3893 | 3.3996 | 416108.0 |
| 2007-04-09 08:10:00 | AAPL | Stock | 3.4 | 3.4 | 3.3971 | 3.3989 | 137116.0 |
| 2007-04-09 08:15:00 | AAPL | Stock | 3.3971 | 3.4007 | 3.3929 | 3.4006 | 532476.0 |
| 2007-04-09 08:20:00 | AAPL | Stock | 3.3971 | 3.4 | 3.3971 | 3.3996 | 68600.0 |
| 2007-04-09 08:25:00 | AAPL | Stock | 3.3996 | 3.4 | 3.3971 | 3.3971 | 33600.0 |
| 2007-04-09 08:30:00 | AAPL | Stock | 3.3964 | 3.4 | 3.3946 | 3.3982 | 112952.0 |
| 2007-04-09 08:35:00 | AAPL | Stock | 3.3961 | 3.4018 | 3.3961 | 3.4 | 230076.0 |
| 2007-04-09 08:40:00 | AAPL | Stock | 3.4011 | 3.4089 | 3.4011 | 3.4082 | 373240.0 |
| 2007-04-09 08:45:00 | AAPL | Stock | 3.4071 | 3.41 | 3.4071 | 3.4071 | 484932.0 |
| 2007-04-09 08:50:00 | AAPL | Stock | 3.4071 | 3.4079 | 3.4061 | 3.4064 | 235620.0 |
| 2007-04-09 08:55:00 | AAPL | Stock | 3.4057 | 3.4075 | 3.4057 | 3.4071 | 348600.0 |
| 2007-04-09 09:00:00 | AAPL | Stock | 3.4071 | 3.4089 | 3.4061 | 3.4061 | 256452.0 |
| 2007-04-09 09:05:00 | AAPL | Stock | 3.4057 | 3.4061 | 3.4046 | 3.4054 | 252700.0 |
| 2007-04-09 09:10:00 | AAPL | Stock | 3.4039 | 3.4064 | 3.4032 | 3.4036 | 53200.0 |
| 2007-04-09 09:15:00 | AAPL | Stock | 3.405 | 3.405 | 3.4 | 3.4036 | 121520.0 |
| 2007-04-09 09:20:00 | AAPL | Stock | 3.4039 | 3.4068 | 3.4036 | 3.4036 | 55160.0 |
| 2007-04-09 09:25:00 | AAPL | Stock | 3.4029 | 3.4054 | 3.3993 | 3.4007 | 1181600.0 |
| 2007-04-09 09:30:00 | AAPL | Stock | 3.4004 | 3.4036 | 3.3857 | 3.3875 | 17966676.0 |
| 2007-04-09 09:35:00 | AAPL | Stock | 3.3879 | 3.3893 | 3.3789 | 3.3821 | 19233312.0 |
| 2007-04-09 09:40:00 | AAPL | Stock | 3.3821 | 3.3846 | 3.3682 | 3.3714 | 14871752.0 |
| 2007-04-09 09:45:00 | AAPL | Stock | 3.3711 | 3.3839 | 3.3661 | 3.3736 | 10791872.0 |
| 2007-04-09 09:50:00 | AAPL | Stock | 3.3736 | 3.3775 | 3.3729 | 3.375 | 11741212.0 |
| 2007-04-09 09:55:00 | AAPL | Stock | 3.375 | 3.375 | 3.3696 | 3.3721 | 6955788.0 |
| 2007-04-09 10:00:00 | AAPL | Stock | 3.3721 | 3.3754 | 3.3543 | 3.3579 | 17435600.0 |
| 2007-04-09 10:05:00 | AAPL | Stock | 3.3579 | 3.3607 | 3.3457 | 3.35 | 19252352.0 |
| 2007-04-09 10:10:00 | AAPL | Stock | 3.35 | 3.3539 | 3.3482 | 3.3521 | 7644168.0 |
| 2007-04-09 10:15:00 | AAPL | Stock | 3.3521 | 3.3596 | 3.3496 | 3.3587 | 8561700.0 |
| 2007-04-09 10:20:00 | AAPL | Stock | 3.3586 | 3.3639 | 3.3539 | 3.3614 | 9911356.0 |
| 2007-04-09 10:25:00 | AAPL | Stock | 3.3614 | 3.3629 | 3.3579 | 3.3621 | 3874108.0 |
| 2007-04-09 10:30:00 | AAPL | Stock | 3.3618 | 3.3661 | 3.3571 | 3.3579 | 6868904.0 |
| 2007-04-09 10:35:00 | AAPL | Stock | 3.3582 | 3.3596 | 3.3536 | 3.3589 | 5047112.0 |
| 2007-04-09 10:40:00 | AAPL | Stock | 3.3589 | 3.3643 | 3.3554 | 3.3571 | 5329436.0 |
| 2007-04-09 10:45:00 | AAPL | Stock | 3.3554 | 3.3607 | 3.3546 | 3.3596 | 4528776.0 |
| 2007-04-09 10:50:00 | AAPL | Stock | 3.36 | 3.3621 | 3.3586 | 3.3618 | 3515260.0 |
| 2007-04-09 10:55:00 | AAPL | Stock | 3.3618 | 3.3629 | 3.3607 | 3.3614 | 2687748.0 |
| 2007-04-09 11:00:00 | AAPL | Stock | 3.3618 | 3.3686 | 3.3618 | 3.3679 | 9101316.0 |
| 2007-04-09 11:05:00 | AAPL | Stock | 3.3679 | 3.3682 | 3.3643 | 3.3646 | 3424680.0 |
| 2007-04-09 11:10:00 | AAPL | Stock | 3.3646 | 3.3686 | 3.3639 | 3.3672 | 3441844.0 |
| 2007-04-09 11:15:00 | AAPL | Stock | 3.3671 | 3.3682 | 3.3653 | 3.3657 | 2438660.0 |
| 2007-04-09 11:20:00 | AAPL | Stock | 3.3661 | 3.3675 | 3.3661 | 3.3668 | 1471596.0 |
| 2007-04-09 11:25:00 | AAPL | Stock | 3.3668 | 3.3689 | 3.3664 | 3.3675 | 2035320.0 |
| 2007-04-09 11:30:00 | AAPL | Stock | 3.3675 | 3.3727 | 3.3675 | 3.37 | 4432344.0 |
| 2007-04-09 11:35:00 | AAPL | Stock | 3.37 | 3.3711 | 3.3686 | 3.3694 | 2380812.0 |
| 2007-04-09 11:40:00 | AAPL | Stock | 3.3693 | 3.3714 | 3.3693 | 3.3696 | 1725472.0 |
| 2007-04-09 11:45:00 | AAPL | Stock | 3.3696 | 3.37 | 3.3643 | 3.3643 | 5146540.0 |
| 2007-04-09 11:50:00 | AAPL | Stock | 3.3646 | 3.3668 | 3.3639 | 3.3646 | 5237260.0 |
| 2007-04-09 11:55:00 | AAPL | Stock | 3.3646 | 3.3664 | 3.3643 | 3.3664 | 3858400.0 |
| 2007-04-09 12:00:00 | AAPL | Stock | 3.3664 | 3.3679 | 3.3643 | 3.3654 | 1613388.0 |
> showing 50 of 253,927 rows — these rows as CSV