PREVIEW / stock_5min / 2001-12-13
file: by_date/stock_5min/2001/2001-12-13.parquet size: 1.7 MB rows: 114,086 symbols: 1,363
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 |
|---|---|---|---|---|---|---|---|
| 2001-12-13 08:00:00 | AAPL | Stock | 0.3837 | 0.3837 | 0.3837 | 0.3837 | 22400.0 |
| 2001-12-13 08:20:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.382 | 0.382 | 28000.0 |
| 2001-12-13 08:45:00 | AAPL | Stock | 0.3809 | 0.3809 | 0.3809 | 0.3809 | 11200.0 |
| 2001-12-13 09:15:00 | AAPL | Stock | 0.3832 | 0.3832 | 0.3832 | 0.3832 | 117600.0 |
| 2001-12-13 09:20:00 | AAPL | Stock | 0.3834 | 0.3834 | 0.3834 | 0.3834 | 5600.0 |
| 2001-12-13 09:25:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3834 | 0.3839 | 459200.0 |
| 2001-12-13 09:30:00 | AAPL | Stock | 0.3838 | 0.3845 | 0.3796 | 0.3814 | 5426400.0 |
| 2001-12-13 09:35:00 | AAPL | Stock | 0.3818 | 0.3821 | 0.3789 | 0.3821 | 3561600.0 |
| 2001-12-13 09:40:00 | AAPL | Stock | 0.3827 | 0.3848 | 0.3813 | 0.3845 | 2889600.0 |
| 2001-12-13 09:45:00 | AAPL | Stock | 0.3846 | 0.3846 | 0.38 | 0.3802 | 4692800.0 |
| 2001-12-13 09:50:00 | AAPL | Stock | 0.3811 | 0.3811 | 0.3766 | 0.3784 | 8019200.0 |
| 2001-12-13 09:55:00 | AAPL | Stock | 0.3784 | 0.3786 | 0.3773 | 0.3786 | 2195200.0 |
| 2001-12-13 10:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3759 | 0.3759 | 3197600.0 |
| 2001-12-13 10:05:00 | AAPL | Stock | 0.3761 | 0.3784 | 0.3709 | 0.3711 | 11575200.0 |
| 2001-12-13 10:10:00 | AAPL | Stock | 0.3713 | 0.3739 | 0.3707 | 0.3725 | 4020800.0 |
| 2001-12-13 10:15:00 | AAPL | Stock | 0.373 | 0.3739 | 0.3713 | 0.3718 | 5286400.0 |
| 2001-12-13 10:20:00 | AAPL | Stock | 0.372 | 0.3723 | 0.37 | 0.3714 | 2856000.0 |
| 2001-12-13 10:25:00 | AAPL | Stock | 0.3714 | 0.3721 | 0.3705 | 0.3714 | 1293600.0 |
| 2001-12-13 10:30:00 | AAPL | Stock | 0.3713 | 0.372 | 0.3705 | 0.3711 | 1461600.0 |
| 2001-12-13 10:35:00 | AAPL | Stock | 0.3713 | 0.3754 | 0.3711 | 0.3754 | 2217600.0 |
| 2001-12-13 10:40:00 | AAPL | Stock | 0.3752 | 0.3764 | 0.3743 | 0.3743 | 1730400.0 |
| 2001-12-13 10:45:00 | AAPL | Stock | 0.3743 | 0.375 | 0.3736 | 0.3745 | 1450400.0 |
| 2001-12-13 10:50:00 | AAPL | Stock | 0.3752 | 0.3764 | 0.3745 | 0.3755 | 1131200.0 |
| 2001-12-13 10:55:00 | AAPL | Stock | 0.3763 | 0.3795 | 0.3763 | 0.3795 | 1747200.0 |
| 2001-12-13 11:00:00 | AAPL | Stock | 0.3795 | 0.3804 | 0.3786 | 0.3796 | 2027200.0 |
| 2001-12-13 11:05:00 | AAPL | Stock | 0.3789 | 0.3791 | 0.3761 | 0.3784 | 1719200.0 |
| 2001-12-13 11:10:00 | AAPL | Stock | 0.3773 | 0.3795 | 0.3773 | 0.3793 | 492800.0 |
| 2001-12-13 11:15:00 | AAPL | Stock | 0.3793 | 0.3804 | 0.3793 | 0.3802 | 1691200.0 |
| 2001-12-13 11:20:00 | AAPL | Stock | 0.3804 | 0.3804 | 0.3761 | 0.3773 | 1500800.0 |
| 2001-12-13 11:25:00 | AAPL | Stock | 0.3775 | 0.3775 | 0.3736 | 0.3764 | 1327200.0 |
| 2001-12-13 11:30:00 | AAPL | Stock | 0.3764 | 0.3764 | 0.3743 | 0.3748 | 879200.0 |
| 2001-12-13 11:35:00 | AAPL | Stock | 0.3752 | 0.3764 | 0.3746 | 0.3752 | 1282400.0 |
| 2001-12-13 11:40:00 | AAPL | Stock | 0.3752 | 0.3752 | 0.3725 | 0.3732 | 1730400.0 |
| 2001-12-13 11:45:00 | AAPL | Stock | 0.3732 | 0.3768 | 0.3732 | 0.3766 | 2038400.0 |
| 2001-12-13 11:50:00 | AAPL | Stock | 0.3761 | 0.3768 | 0.3748 | 0.3748 | 464800.0 |
| 2001-12-13 11:55:00 | AAPL | Stock | 0.3748 | 0.3757 | 0.3746 | 0.375 | 207200.0 |
| 2001-12-13 12:00:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.3736 | 0.3757 | 1181600.0 |
| 2001-12-13 12:05:00 | AAPL | Stock | 0.3757 | 0.3759 | 0.3741 | 0.3741 | 336000.0 |
| 2001-12-13 12:10:00 | AAPL | Stock | 0.3739 | 0.3775 | 0.3739 | 0.3771 | 907200.0 |
| 2001-12-13 12:15:00 | AAPL | Stock | 0.3771 | 0.3793 | 0.3764 | 0.3791 | 2458400.0 |
| 2001-12-13 12:20:00 | AAPL | Stock | 0.3789 | 0.38 | 0.3789 | 0.3793 | 716800.0 |
| 2001-12-13 12:25:00 | AAPL | Stock | 0.3793 | 0.3793 | 0.3782 | 0.3782 | 593600.0 |
| 2001-12-13 12:30:00 | AAPL | Stock | 0.3786 | 0.3796 | 0.3784 | 0.3789 | 1607200.0 |
| 2001-12-13 12:35:00 | AAPL | Stock | 0.3791 | 0.3795 | 0.3782 | 0.3782 | 616000.0 |
| 2001-12-13 12:40:00 | AAPL | Stock | 0.3782 | 0.3782 | 0.3761 | 0.3761 | 963200.0 |
| 2001-12-13 12:45:00 | AAPL | Stock | 0.3766 | 0.3768 | 0.3761 | 0.3764 | 240800.0 |
| 2001-12-13 12:50:00 | AAPL | Stock | 0.3764 | 0.3764 | 0.3738 | 0.3739 | 2598400.0 |
| 2001-12-13 12:55:00 | AAPL | Stock | 0.3741 | 0.3748 | 0.372 | 0.3723 | 1450400.0 |
| 2001-12-13 13:00:00 | AAPL | Stock | 0.3721 | 0.373 | 0.3716 | 0.3723 | 840000.0 |
| 2001-12-13 13:05:00 | AAPL | Stock | 0.3727 | 0.3739 | 0.3716 | 0.3736 | 1831200.0 |
> showing 50 of 114,086 rows — these rows as CSV