PREVIEW / stock_5min / 2003-11-18
file: by_date/stock_5min/2003/2003-11-18.parquet size: 2.3 MB rows: 162,759 symbols: 1,670
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 |
|---|---|---|---|---|---|---|---|
| 2003-11-18 08:55:00 | AAPL | Stock | 0.3866 | 0.3866 | 0.3855 | 0.3857 | 33600.0 |
| 2003-11-18 09:00:00 | AAPL | Stock | 0.3786 | 0.3786 | 0.3786 | 0.3786 | 89600.0 |
| 2003-11-18 09:10:00 | AAPL | Stock | 0.3788 | 0.3788 | 0.3771 | 0.3771 | 516488.0 |
| 2003-11-18 09:15:00 | AAPL | Stock | 0.3771 | 0.3771 | 0.3771 | 0.3771 | 65912.0 |
| 2003-11-18 09:25:00 | AAPL | Stock | 0.3784 | 0.3788 | 0.3777 | 0.3777 | 162400.0 |
| 2003-11-18 09:30:00 | AAPL | Stock | 0.3788 | 0.3804 | 0.3773 | 0.3795 | 4378080.0 |
| 2003-11-18 09:35:00 | AAPL | Stock | 0.3793 | 0.3804 | 0.3777 | 0.3793 | 3080112.0 |
| 2003-11-18 09:40:00 | AAPL | Stock | 0.3793 | 0.3795 | 0.378 | 0.3784 | 2422056.0 |
| 2003-11-18 09:45:00 | AAPL | Stock | 0.3784 | 0.3793 | 0.3784 | 0.3786 | 1969016.0 |
| 2003-11-18 09:50:00 | AAPL | Stock | 0.3789 | 0.3811 | 0.3786 | 0.3809 | 1236592.0 |
| 2003-11-18 09:55:00 | AAPL | Stock | 0.3807 | 0.3811 | 0.3791 | 0.3796 | 1170064.0 |
| 2003-11-18 10:00:00 | AAPL | Stock | 0.3798 | 0.3798 | 0.3768 | 0.3768 | 3790864.0 |
| 2003-11-18 10:05:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3734 | 0.3748 | 4264232.0 |
| 2003-11-18 10:10:00 | AAPL | Stock | 0.375 | 0.375 | 0.3732 | 0.3741 | 2745176.0 |
| 2003-11-18 10:15:00 | AAPL | Stock | 0.3741 | 0.3754 | 0.3734 | 0.3745 | 3277232.0 |
| 2003-11-18 10:20:00 | AAPL | Stock | 0.3754 | 0.3771 | 0.3752 | 0.3771 | 2927344.0 |
| 2003-11-18 10:25:00 | AAPL | Stock | 0.3771 | 0.3784 | 0.3771 | 0.3784 | 1921080.0 |
| 2003-11-18 10:30:00 | AAPL | Stock | 0.3782 | 0.3784 | 0.377 | 0.377 | 1033200.0 |
| 2003-11-18 10:35:00 | AAPL | Stock | 0.3766 | 0.3768 | 0.3739 | 0.3757 | 2724120.0 |
| 2003-11-18 10:40:00 | AAPL | Stock | 0.3755 | 0.3784 | 0.3732 | 0.3752 | 4697952.0 |
| 2003-11-18 10:45:00 | AAPL | Stock | 0.3752 | 0.3757 | 0.375 | 0.3755 | 2011968.0 |
| 2003-11-18 10:50:00 | AAPL | Stock | 0.3755 | 0.3768 | 0.3752 | 0.3763 | 1456280.0 |
| 2003-11-18 10:55:00 | AAPL | Stock | 0.3763 | 0.3766 | 0.3754 | 0.3763 | 1601880.0 |
| 2003-11-18 11:00:00 | AAPL | Stock | 0.3763 | 0.3766 | 0.3752 | 0.3757 | 1130304.0 |
| 2003-11-18 11:05:00 | AAPL | Stock | 0.3757 | 0.3764 | 0.3755 | 0.3764 | 697760.0 |
| 2003-11-18 11:10:00 | AAPL | Stock | 0.3764 | 0.3768 | 0.3761 | 0.3764 | 904904.0 |
| 2003-11-18 11:15:00 | AAPL | Stock | 0.3764 | 0.3775 | 0.3764 | 0.3771 | 2606128.0 |
| 2003-11-18 11:20:00 | AAPL | Stock | 0.3771 | 0.3779 | 0.377 | 0.3778 | 1810760.0 |
| 2003-11-18 11:25:00 | AAPL | Stock | 0.378 | 0.3782 | 0.3775 | 0.3779 | 1727880.0 |
| 2003-11-18 11:30:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.3771 | 0.3782 | 640808.0 |
| 2003-11-18 11:35:00 | AAPL | Stock | 0.3784 | 0.3784 | 0.3779 | 0.378 | 1219232.0 |
| 2003-11-18 11:40:00 | AAPL | Stock | 0.3784 | 0.3793 | 0.3779 | 0.3789 | 2846256.0 |
| 2003-11-18 11:45:00 | AAPL | Stock | 0.3789 | 0.3798 | 0.3788 | 0.3795 | 2447816.0 |
| 2003-11-18 11:50:00 | AAPL | Stock | 0.3791 | 0.3791 | 0.378 | 0.3784 | 2987152.0 |
| 2003-11-18 11:55:00 | AAPL | Stock | 0.3786 | 0.3793 | 0.3777 | 0.3782 | 1990968.0 |
| 2003-11-18 12:00:00 | AAPL | Stock | 0.378 | 0.3786 | 0.3764 | 0.377 | 6755056.0 |
| 2003-11-18 12:05:00 | AAPL | Stock | 0.377 | 0.3779 | 0.377 | 0.3771 | 1311072.0 |
| 2003-11-18 12:10:00 | AAPL | Stock | 0.3775 | 0.3775 | 0.377 | 0.3773 | 737184.0 |
| 2003-11-18 12:15:00 | AAPL | Stock | 0.3773 | 0.378 | 0.377 | 0.3777 | 1124144.0 |
| 2003-11-18 12:20:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.377 | 0.377 | 1976744.0 |
| 2003-11-18 12:25:00 | AAPL | Stock | 0.377 | 0.378 | 0.377 | 0.3771 | 1354976.0 |
| 2003-11-18 12:30:00 | AAPL | Stock | 0.3773 | 0.3773 | 0.3763 | 0.3766 | 2924768.0 |
| 2003-11-18 12:35:00 | AAPL | Stock | 0.3766 | 0.377 | 0.3764 | 0.3764 | 1590568.0 |
| 2003-11-18 12:40:00 | AAPL | Stock | 0.3763 | 0.3763 | 0.3759 | 0.3759 | 1423128.0 |
| 2003-11-18 12:45:00 | AAPL | Stock | 0.3759 | 0.377 | 0.3759 | 0.3769 | 762160.0 |
| 2003-11-18 12:50:00 | AAPL | Stock | 0.3766 | 0.377 | 0.3764 | 0.3764 | 733544.0 |
| 2003-11-18 12:55:00 | AAPL | Stock | 0.3766 | 0.3777 | 0.3766 | 0.3766 | 3311280.0 |
| 2003-11-18 13:00:00 | AAPL | Stock | 0.3771 | 0.3771 | 0.3764 | 0.3764 | 1737960.0 |
| 2003-11-18 13:05:00 | AAPL | Stock | 0.3764 | 0.3768 | 0.3764 | 0.3766 | 927304.0 |
| 2003-11-18 13:10:00 | AAPL | Stock | 0.3764 | 0.377 | 0.3764 | 0.3768 | 1394400.0 |
> showing 50 of 162,759 rows — these rows as CSV