PREVIEW / stock_5min / 2004-11-16
file: by_date/stock_5min/2004/2004-11-16.parquet size: 2.5 MB rows: 187,065 symbols: 1,874
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-16 08:00:00 | AAPL | Stock | 0.9868 | 0.9888 | 0.9868 | 0.9888 | 44800.0 |
| 2004-11-16 08:05:00 | AAPL | Stock | 0.9895 | 0.9929 | 0.9895 | 0.9929 | 175672.0 |
| 2004-11-16 08:20:00 | AAPL | Stock | 0.9896 | 0.9896 | 0.9896 | 0.9896 | 69440.0 |
| 2004-11-16 08:30:00 | AAPL | Stock | 0.9896 | 0.9896 | 0.9896 | 0.9896 | 281680.0 |
| 2004-11-16 08:35:00 | AAPL | Stock | 0.9895 | 0.9895 | 0.9895 | 0.9895 | 5600.0 |
| 2004-11-16 08:40:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.9863 | 0.9863 | 84000.0 |
| 2004-11-16 08:55:00 | AAPL | Stock | 1.0536 | 1.0536 | 0.9863 | 0.9863 | 50400.0 |
| 2004-11-16 09:00:00 | AAPL | Stock | 0.9863 | 0.9863 | 0.9857 | 0.9857 | 72800.0 |
| 2004-11-16 09:05:00 | AAPL | Stock | 0.9854 | 0.9863 | 0.9854 | 0.9863 | 89600.0 |
| 2004-11-16 09:10:00 | AAPL | Stock | 0.985 | 0.985 | 0.985 | 0.985 | 11200.0 |
| 2004-11-16 09:15:00 | AAPL | Stock | 0.985 | 0.985 | 0.985 | 0.985 | 16800.0 |
| 2004-11-16 09:20:00 | AAPL | Stock | 0.985 | 0.985 | 0.985 | 0.985 | 10304.0 |
| 2004-11-16 09:25:00 | AAPL | Stock | 0.985 | 0.9859 | 0.9841 | 0.9852 | 439432.0 |
| 2004-11-16 09:30:00 | AAPL | Stock | 0.985 | 0.9857 | 0.975 | 0.9779 | 13060376.0 |
| 2004-11-16 09:35:00 | AAPL | Stock | 0.9779 | 0.982 | 0.9768 | 0.9786 | 4819360.0 |
| 2004-11-16 09:40:00 | AAPL | Stock | 0.9782 | 0.983 | 0.977 | 0.9813 | 10042144.0 |
| 2004-11-16 09:45:00 | AAPL | Stock | 0.9814 | 0.9821 | 0.9777 | 0.98 | 4926152.0 |
| 2004-11-16 09:50:00 | AAPL | Stock | 0.9805 | 0.9811 | 0.9791 | 0.9795 | 4069968.0 |
| 2004-11-16 09:55:00 | AAPL | Stock | 0.9795 | 0.9796 | 0.9775 | 0.9779 | 3740744.0 |
| 2004-11-16 10:00:00 | AAPL | Stock | 0.9782 | 0.9782 | 0.9732 | 0.9745 | 8754368.0 |
| 2004-11-16 10:05:00 | AAPL | Stock | 0.9745 | 0.9775 | 0.9741 | 0.9759 | 7780976.0 |
| 2004-11-16 10:10:00 | AAPL | Stock | 0.9759 | 0.9768 | 0.9739 | 0.975 | 6609904.0 |
| 2004-11-16 10:15:00 | AAPL | Stock | 0.9748 | 0.9755 | 0.9729 | 0.9752 | 6306440.0 |
| 2004-11-16 10:20:00 | AAPL | Stock | 0.9752 | 0.9755 | 0.9739 | 0.9748 | 2613184.0 |
| 2004-11-16 10:25:00 | AAPL | Stock | 0.9748 | 0.9773 | 0.9745 | 0.9768 | 2604448.0 |
| 2004-11-16 10:30:00 | AAPL | Stock | 0.9763 | 0.9786 | 0.9763 | 0.9763 | 3273256.0 |
| 2004-11-16 10:35:00 | AAPL | Stock | 0.9763 | 0.9786 | 0.9759 | 0.977 | 2361464.0 |
| 2004-11-16 10:40:00 | AAPL | Stock | 0.977 | 0.9777 | 0.9736 | 0.9738 | 3645600.0 |
| 2004-11-16 10:45:00 | AAPL | Stock | 0.9736 | 0.9755 | 0.9734 | 0.975 | 3804472.0 |
| 2004-11-16 10:50:00 | AAPL | Stock | 0.9754 | 0.9759 | 0.9746 | 0.9746 | 1164856.0 |
| 2004-11-16 10:55:00 | AAPL | Stock | 0.9746 | 0.9763 | 0.9743 | 0.9752 | 2136736.0 |
| 2004-11-16 11:00:00 | AAPL | Stock | 0.9757 | 0.9779 | 0.9754 | 0.9779 | 2945208.0 |
| 2004-11-16 11:05:00 | AAPL | Stock | 0.9779 | 0.98 | 0.9778 | 0.9795 | 3960712.0 |
| 2004-11-16 11:10:00 | AAPL | Stock | 0.9793 | 0.9813 | 0.9789 | 0.9805 | 5856312.0 |
| 2004-11-16 11:15:00 | AAPL | Stock | 0.9804 | 0.982 | 0.9791 | 0.9813 | 6030864.0 |
| 2004-11-16 11:20:00 | AAPL | Stock | 0.9814 | 0.9827 | 0.9813 | 0.9819 | 10217984.0 |
| 2004-11-16 11:25:00 | AAPL | Stock | 0.9816 | 0.9816 | 0.9804 | 0.9811 | 2026640.0 |
| 2004-11-16 11:30:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9804 | 0.9804 | 2635416.0 |
| 2004-11-16 11:35:00 | AAPL | Stock | 0.9804 | 0.9807 | 0.9804 | 0.9805 | 4290160.0 |
| 2004-11-16 11:40:00 | AAPL | Stock | 0.9805 | 0.9805 | 0.9793 | 0.9793 | 3065104.0 |
| 2004-11-16 11:45:00 | AAPL | Stock | 0.9793 | 0.9798 | 0.9775 | 0.9796 | 2714600.0 |
| 2004-11-16 11:50:00 | AAPL | Stock | 0.9795 | 0.9795 | 0.9786 | 0.9789 | 1146376.0 |
| 2004-11-16 11:55:00 | AAPL | Stock | 0.9789 | 0.9793 | 0.9779 | 0.9779 | 1295168.0 |
| 2004-11-16 12:00:00 | AAPL | Stock | 0.9777 | 0.9777 | 0.9759 | 0.9771 | 3492328.0 |
| 2004-11-16 12:05:00 | AAPL | Stock | 0.9771 | 0.9784 | 0.977 | 0.9779 | 2692144.0 |
| 2004-11-16 12:10:00 | AAPL | Stock | 0.9779 | 0.9779 | 0.977 | 0.9775 | 2008496.0 |
| 2004-11-16 12:15:00 | AAPL | Stock | 0.9773 | 0.9784 | 0.9771 | 0.9771 | 2622536.0 |
| 2004-11-16 12:20:00 | AAPL | Stock | 0.9773 | 0.9775 | 0.975 | 0.9763 | 4385920.0 |
| 2004-11-16 12:25:00 | AAPL | Stock | 0.9763 | 0.9763 | 0.9743 | 0.9763 | 3575992.0 |
| 2004-11-16 12:30:00 | AAPL | Stock | 0.9758 | 0.9766 | 0.9755 | 0.9764 | 978992.0 |
> showing 50 of 187,065 rows — these rows as CSV