PREVIEW / stock_5min / 2005-02-01
file: by_date/stock_5min/2005/2005-02-01.parquet size: 2.7 MB rows: 197,701 symbols: 1,925
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-02-01 08:00:00 | AAPL | Stock | 1.3761 | 1.3761 | 1.3732 | 1.3732 | 421736.0 |
| 2005-02-01 08:05:00 | AAPL | Stock | 1.3714 | 1.3738 | 1.3698 | 1.3698 | 200200.0 |
| 2005-02-01 08:10:00 | AAPL | Stock | 1.3698 | 1.3714 | 1.3698 | 1.3705 | 117600.0 |
| 2005-02-01 08:15:00 | AAPL | Stock | 1.3705 | 1.3711 | 1.3688 | 1.3696 | 345576.0 |
| 2005-02-01 08:20:00 | AAPL | Stock | 1.3696 | 1.3732 | 1.3696 | 1.3702 | 60816.0 |
| 2005-02-01 08:25:00 | AAPL | Stock | 1.3696 | 1.3718 | 1.3696 | 1.3714 | 272440.0 |
| 2005-02-01 08:30:00 | AAPL | Stock | 1.3714 | 1.3714 | 1.3714 | 1.3714 | 144704.0 |
| 2005-02-01 08:35:00 | AAPL | Stock | 1.3729 | 1.3729 | 1.372 | 1.372 | 436800.0 |
| 2005-02-01 08:40:00 | AAPL | Stock | 1.372 | 1.3729 | 1.3714 | 1.3729 | 198800.0 |
| 2005-02-01 08:45:00 | AAPL | Stock | 1.3721 | 1.3721 | 1.3721 | 1.3721 | 11200.0 |
| 2005-02-01 08:50:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3721 | 1.3721 | 157248.0 |
| 2005-02-01 08:55:00 | AAPL | Stock | 1.3732 | 1.3732 | 1.3716 | 1.3716 | 79184.0 |
| 2005-02-01 09:00:00 | AAPL | Stock | 1.3732 | 1.375 | 1.3732 | 1.375 | 414232.0 |
| 2005-02-01 09:05:00 | AAPL | Stock | 1.375 | 1.3759 | 1.375 | 1.3759 | 214592.0 |
| 2005-02-01 09:10:00 | AAPL | Stock | 1.3763 | 1.3771 | 1.375 | 1.3754 | 192640.0 |
| 2005-02-01 09:15:00 | AAPL | Stock | 1.3746 | 1.3761 | 1.3741 | 1.3741 | 359408.0 |
| 2005-02-01 09:20:00 | AAPL | Stock | 1.3741 | 1.3746 | 1.3741 | 1.3741 | 133840.0 |
| 2005-02-01 09:25:00 | AAPL | Stock | 1.3741 | 1.3768 | 1.3721 | 1.3759 | 4878664.0 |
| 2005-02-01 09:30:00 | AAPL | Stock | 1.3759 | 1.3852 | 1.375 | 1.3816 | 52575712.0 |
| 2005-02-01 09:35:00 | AAPL | Stock | 1.3816 | 1.3846 | 1.3771 | 1.3846 | 27885256.0 |
| 2005-02-01 09:40:00 | AAPL | Stock | 1.3845 | 1.3888 | 1.3796 | 1.3823 | 39008760.0 |
| 2005-02-01 09:45:00 | AAPL | Stock | 1.383 | 1.383 | 1.377 | 1.3784 | 23651320.0 |
| 2005-02-01 09:50:00 | AAPL | Stock | 1.3786 | 1.3802 | 1.3707 | 1.3707 | 22370376.0 |
| 2005-02-01 09:55:00 | AAPL | Stock | 1.3711 | 1.3763 | 1.3707 | 1.3746 | 21711032.0 |
| 2005-02-01 10:00:00 | AAPL | Stock | 1.3745 | 1.375 | 1.3675 | 1.3725 | 19842592.0 |
| 2005-02-01 10:05:00 | AAPL | Stock | 1.3725 | 1.3771 | 1.3705 | 1.3771 | 21596792.0 |
| 2005-02-01 10:10:00 | AAPL | Stock | 1.3771 | 1.3821 | 1.375 | 1.3773 | 16955792.0 |
| 2005-02-01 10:15:00 | AAPL | Stock | 1.3775 | 1.3798 | 1.3754 | 1.3754 | 13047496.0 |
| 2005-02-01 10:20:00 | AAPL | Stock | 1.3754 | 1.3791 | 1.3711 | 1.3768 | 13055672.0 |
| 2005-02-01 10:25:00 | AAPL | Stock | 1.3768 | 1.3811 | 1.3764 | 1.3796 | 12253248.0 |
| 2005-02-01 10:30:00 | AAPL | Stock | 1.38 | 1.3836 | 1.3771 | 1.3827 | 8596168.0 |
| 2005-02-01 10:35:00 | AAPL | Stock | 1.3827 | 1.3839 | 1.3805 | 1.3829 | 11287528.0 |
| 2005-02-01 10:40:00 | AAPL | Stock | 1.3834 | 1.3836 | 1.3805 | 1.3813 | 9751448.0 |
| 2005-02-01 10:45:00 | AAPL | Stock | 1.3813 | 1.3838 | 1.38 | 1.3804 | 7508648.0 |
| 2005-02-01 10:50:00 | AAPL | Stock | 1.3804 | 1.3805 | 1.3775 | 1.3784 | 7256984.0 |
| 2005-02-01 10:55:00 | AAPL | Stock | 1.3786 | 1.3805 | 1.3779 | 1.3786 | 5376280.0 |
| 2005-02-01 11:00:00 | AAPL | Stock | 1.3788 | 1.3795 | 1.378 | 1.3788 | 4822384.0 |
| 2005-02-01 11:05:00 | AAPL | Stock | 1.3788 | 1.3789 | 1.3764 | 1.3777 | 7459256.0 |
| 2005-02-01 11:10:00 | AAPL | Stock | 1.3777 | 1.3784 | 1.3757 | 1.3771 | 12868352.0 |
| 2005-02-01 11:15:00 | AAPL | Stock | 1.3777 | 1.3784 | 1.3761 | 1.3763 | 7554960.0 |
| 2005-02-01 11:20:00 | AAPL | Stock | 1.3761 | 1.3777 | 1.3754 | 1.3768 | 6764520.0 |
| 2005-02-01 11:25:00 | AAPL | Stock | 1.3767 | 1.3782 | 1.3743 | 1.3745 | 6019944.0 |
| 2005-02-01 11:30:00 | AAPL | Stock | 1.3745 | 1.3775 | 1.3736 | 1.3771 | 6568968.0 |
| 2005-02-01 11:35:00 | AAPL | Stock | 1.3771 | 1.3782 | 1.3755 | 1.3764 | 4825408.0 |
| 2005-02-01 11:40:00 | AAPL | Stock | 1.3768 | 1.3779 | 1.3759 | 1.3764 | 3901800.0 |
| 2005-02-01 11:45:00 | AAPL | Stock | 1.3764 | 1.3793 | 1.3764 | 1.3773 | 6438040.0 |
| 2005-02-01 11:50:00 | AAPL | Stock | 1.3773 | 1.378 | 1.3763 | 1.3779 | 3666712.0 |
| 2005-02-01 11:55:00 | AAPL | Stock | 1.3777 | 1.3813 | 1.3777 | 1.3788 | 8314376.0 |
| 2005-02-01 12:00:00 | AAPL | Stock | 1.3784 | 1.3818 | 1.3782 | 1.3811 | 7183008.0 |
| 2005-02-01 12:05:00 | AAPL | Stock | 1.3811 | 1.3816 | 1.3795 | 1.3813 | 6355216.0 |
> showing 50 of 197,701 rows — these rows as CSV