PREVIEW / stock_5min / 2003-11-17
file: by_date/stock_5min/2003/2003-11-17.parquet size: 2.4 MB rows: 168,691 symbols: 1,674
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-17 08:00:00 | AAPL | Stock | 0.3821 | 0.3821 | 0.3821 | 0.3821 | 11200.0 |
| 2003-11-17 08:35:00 | AAPL | Stock | 0.3795 | 0.3795 | 0.3795 | 0.3795 | 5600.0 |
| 2003-11-17 09:05:00 | AAPL | Stock | 0.3832 | 0.3832 | 0.3832 | 0.3832 | 89600.0 |
| 2003-11-17 09:25:00 | AAPL | Stock | 0.3804 | 0.3825 | 0.3795 | 0.3816 | 604800.0 |
| 2003-11-17 09:30:00 | AAPL | Stock | 0.3813 | 0.3816 | 0.3768 | 0.3795 | 10769360.0 |
| 2003-11-17 09:35:00 | AAPL | Stock | 0.3794 | 0.3795 | 0.3761 | 0.3761 | 8762992.0 |
| 2003-11-17 09:40:00 | AAPL | Stock | 0.377 | 0.377 | 0.3752 | 0.3759 | 9508912.0 |
| 2003-11-17 09:45:00 | AAPL | Stock | 0.3759 | 0.3779 | 0.3757 | 0.3777 | 3462592.0 |
| 2003-11-17 09:50:00 | AAPL | Stock | 0.3777 | 0.3782 | 0.3775 | 0.3779 | 1888264.0 |
| 2003-11-17 09:55:00 | AAPL | Stock | 0.3779 | 0.3779 | 0.3766 | 0.3766 | 2297568.0 |
| 2003-11-17 10:00:00 | AAPL | Stock | 0.3764 | 0.3766 | 0.3752 | 0.3757 | 2323664.0 |
| 2003-11-17 10:05:00 | AAPL | Stock | 0.3757 | 0.3764 | 0.3752 | 0.3754 | 2710512.0 |
| 2003-11-17 10:10:00 | AAPL | Stock | 0.3752 | 0.3759 | 0.3752 | 0.3757 | 1519392.0 |
| 2003-11-17 10:15:00 | AAPL | Stock | 0.3756 | 0.3757 | 0.375 | 0.3754 | 3879736.0 |
| 2003-11-17 10:20:00 | AAPL | Stock | 0.3754 | 0.3757 | 0.3752 | 0.3757 | 2194360.0 |
| 2003-11-17 10:25:00 | AAPL | Stock | 0.3757 | 0.3763 | 0.375 | 0.3755 | 2997960.0 |
| 2003-11-17 10:30:00 | AAPL | Stock | 0.3755 | 0.3763 | 0.3755 | 0.3757 | 866208.0 |
| 2003-11-17 10:35:00 | AAPL | Stock | 0.3755 | 0.3757 | 0.3745 | 0.3746 | 5234432.0 |
| 2003-11-17 10:40:00 | AAPL | Stock | 0.3745 | 0.3766 | 0.3745 | 0.3759 | 2565416.0 |
| 2003-11-17 10:45:00 | AAPL | Stock | 0.3761 | 0.377 | 0.3761 | 0.3764 | 3367168.0 |
| 2003-11-17 10:50:00 | AAPL | Stock | 0.3764 | 0.3771 | 0.3752 | 0.3752 | 3789240.0 |
| 2003-11-17 10:55:00 | AAPL | Stock | 0.3751 | 0.3773 | 0.375 | 0.3773 | 1717688.0 |
| 2003-11-17 11:00:00 | AAPL | Stock | 0.3775 | 0.3779 | 0.3759 | 0.3761 | 1317680.0 |
| 2003-11-17 11:05:00 | AAPL | Stock | 0.3763 | 0.3773 | 0.3759 | 0.3759 | 1965208.0 |
| 2003-11-17 11:10:00 | AAPL | Stock | 0.3764 | 0.3766 | 0.375 | 0.375 | 2219504.0 |
| 2003-11-17 11:15:00 | AAPL | Stock | 0.3752 | 0.3755 | 0.3741 | 0.3745 | 2772504.0 |
| 2003-11-17 11:20:00 | AAPL | Stock | 0.3745 | 0.3754 | 0.3745 | 0.3746 | 1060360.0 |
| 2003-11-17 11:25:00 | AAPL | Stock | 0.375 | 0.3755 | 0.3748 | 0.3755 | 1602552.0 |
| 2003-11-17 11:30:00 | AAPL | Stock | 0.3755 | 0.3755 | 0.3752 | 0.3754 | 1087520.0 |
| 2003-11-17 11:35:00 | AAPL | Stock | 0.3752 | 0.3759 | 0.3752 | 0.3759 | 1332744.0 |
| 2003-11-17 11:40:00 | AAPL | Stock | 0.3759 | 0.3759 | 0.375 | 0.375 | 2276848.0 |
| 2003-11-17 11:45:00 | AAPL | Stock | 0.375 | 0.3755 | 0.375 | 0.375 | 1961848.0 |
| 2003-11-17 11:50:00 | AAPL | Stock | 0.375 | 0.3757 | 0.3748 | 0.3757 | 3775576.0 |
| 2003-11-17 11:55:00 | AAPL | Stock | 0.3757 | 0.3771 | 0.3755 | 0.3771 | 1692880.0 |
| 2003-11-17 12:00:00 | AAPL | Stock | 0.3771 | 0.3771 | 0.3763 | 0.3766 | 826952.0 |
| 2003-11-17 12:05:00 | AAPL | Stock | 0.3766 | 0.3766 | 0.3763 | 0.3763 | 3175424.0 |
| 2003-11-17 12:10:00 | AAPL | Stock | 0.3763 | 0.3764 | 0.3763 | 0.3763 | 239120.0 |
| 2003-11-17 12:15:00 | AAPL | Stock | 0.3764 | 0.3764 | 0.3761 | 0.3763 | 3899616.0 |
| 2003-11-17 12:20:00 | AAPL | Stock | 0.3763 | 0.3775 | 0.3763 | 0.3775 | 1299200.0 |
| 2003-11-17 12:25:00 | AAPL | Stock | 0.3775 | 0.3782 | 0.3775 | 0.3782 | 1460704.0 |
| 2003-11-17 12:30:00 | AAPL | Stock | 0.3782 | 0.3786 | 0.3779 | 0.378 | 1644496.0 |
| 2003-11-17 12:35:00 | AAPL | Stock | 0.378 | 0.378 | 0.3775 | 0.3777 | 511000.0 |
| 2003-11-17 12:40:00 | AAPL | Stock | 0.3777 | 0.3777 | 0.3761 | 0.3763 | 1615040.0 |
| 2003-11-17 12:45:00 | AAPL | Stock | 0.3763 | 0.3777 | 0.3763 | 0.3777 | 1430800.0 |
| 2003-11-17 12:50:00 | AAPL | Stock | 0.3775 | 0.3782 | 0.3771 | 0.3782 | 1519560.0 |
| 2003-11-17 12:55:00 | AAPL | Stock | 0.378 | 0.378 | 0.377 | 0.378 | 1017800.0 |
| 2003-11-17 13:00:00 | AAPL | Stock | 0.378 | 0.3786 | 0.378 | 0.3784 | 1624840.0 |
| 2003-11-17 13:05:00 | AAPL | Stock | 0.3786 | 0.3791 | 0.3775 | 0.3775 | 1781192.0 |
| 2003-11-17 13:10:00 | AAPL | Stock | 0.3775 | 0.3777 | 0.375 | 0.3752 | 1890672.0 |
| 2003-11-17 13:15:00 | AAPL | Stock | 0.3752 | 0.3761 | 0.375 | 0.3761 | 1245832.0 |
> showing 50 of 168,691 rows — these rows as CSV