PREVIEW / stock_5min / 2004-11-08
file: by_date/stock_5min/2004/2004-11-08.parquet size: 2.5 MB rows: 185,016 symbols: 1,863
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-08 08:00:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.975 | 0.975 | 50400.0 |
| 2004-11-08 08:10:00 | AAPL | Stock | 0.9752 | 0.9752 | 0.9752 | 0.9752 | 16800.0 |
| 2004-11-08 08:35:00 | AAPL | Stock | 0.9746 | 0.9746 | 0.9746 | 0.9746 | 11200.0 |
| 2004-11-08 08:45:00 | AAPL | Stock | 0.9741 | 0.9755 | 0.9741 | 0.9755 | 11200.0 |
| 2004-11-08 08:50:00 | AAPL | Stock | 0.9755 | 0.9755 | 0.9755 | 0.9755 | 5600.0 |
| 2004-11-08 09:00:00 | AAPL | Stock | 0.975 | 0.975 | 0.975 | 0.975 | 5600.0 |
| 2004-11-08 09:05:00 | AAPL | Stock | 0.9741 | 0.9741 | 0.9716 | 0.9716 | 33600.0 |
| 2004-11-08 09:10:00 | AAPL | Stock | 0.9714 | 0.9771 | 0.9714 | 0.973 | 379792.0 |
| 2004-11-08 09:15:00 | AAPL | Stock | 0.972 | 0.972 | 0.9716 | 0.9718 | 207200.0 |
| 2004-11-08 09:20:00 | AAPL | Stock | 0.9732 | 0.9738 | 0.9718 | 0.9718 | 140000.0 |
| 2004-11-08 09:25:00 | AAPL | Stock | 0.9743 | 0.9743 | 0.972 | 0.9725 | 1607200.0 |
| 2004-11-08 09:30:00 | AAPL | Stock | 0.9727 | 0.9795 | 0.9716 | 0.9777 | 7257656.0 |
| 2004-11-08 09:35:00 | AAPL | Stock | 0.9775 | 0.9868 | 0.9773 | 0.9848 | 16412536.0 |
| 2004-11-08 09:40:00 | AAPL | Stock | 0.985 | 0.9889 | 0.9821 | 0.9884 | 14407512.0 |
| 2004-11-08 09:45:00 | AAPL | Stock | 0.9884 | 0.9902 | 0.987 | 0.9879 | 13671952.0 |
| 2004-11-08 09:50:00 | AAPL | Stock | 0.988 | 0.988 | 0.9836 | 0.9841 | 13305712.0 |
| 2004-11-08 09:55:00 | AAPL | Stock | 0.9841 | 0.9848 | 0.9793 | 0.9798 | 9310616.0 |
| 2004-11-08 10:00:00 | AAPL | Stock | 0.98 | 0.9845 | 0.9791 | 0.9821 | 8206296.0 |
| 2004-11-08 10:05:00 | AAPL | Stock | 0.982 | 0.9843 | 0.9796 | 0.9827 | 14007896.0 |
| 2004-11-08 10:10:00 | AAPL | Stock | 0.9829 | 0.9838 | 0.9766 | 0.9798 | 10234000.0 |
| 2004-11-08 10:15:00 | AAPL | Stock | 0.9798 | 0.9816 | 0.9782 | 0.9793 | 4926096.0 |
| 2004-11-08 10:20:00 | AAPL | Stock | 0.9791 | 0.9795 | 0.978 | 0.9786 | 3596096.0 |
| 2004-11-08 10:25:00 | AAPL | Stock | 0.9784 | 0.9789 | 0.9729 | 0.9738 | 8300992.0 |
| 2004-11-08 10:30:00 | AAPL | Stock | 0.9738 | 0.9782 | 0.9732 | 0.9763 | 8290016.0 |
| 2004-11-08 10:35:00 | AAPL | Stock | 0.9763 | 0.9796 | 0.9761 | 0.978 | 3430000.0 |
| 2004-11-08 10:40:00 | AAPL | Stock | 0.978 | 0.9821 | 0.9757 | 0.982 | 5380648.0 |
| 2004-11-08 10:45:00 | AAPL | Stock | 0.9816 | 0.9821 | 0.9788 | 0.982 | 6572720.0 |
| 2004-11-08 10:50:00 | AAPL | Stock | 0.982 | 0.9827 | 0.9804 | 0.9807 | 4364080.0 |
| 2004-11-08 10:55:00 | AAPL | Stock | 0.9811 | 0.9825 | 0.9805 | 0.9821 | 3679480.0 |
| 2004-11-08 11:00:00 | AAPL | Stock | 0.9823 | 0.9846 | 0.9811 | 0.983 | 5608064.0 |
| 2004-11-08 11:05:00 | AAPL | Stock | 0.983 | 0.9846 | 0.9816 | 0.9816 | 5057528.0 |
| 2004-11-08 11:10:00 | AAPL | Stock | 0.9814 | 0.982 | 0.9805 | 0.9805 | 3617600.0 |
| 2004-11-08 11:15:00 | AAPL | Stock | 0.9807 | 0.982 | 0.9796 | 0.9802 | 3727696.0 |
| 2004-11-08 11:20:00 | AAPL | Stock | 0.9798 | 0.9832 | 0.9798 | 0.9829 | 5314624.0 |
| 2004-11-08 11:25:00 | AAPL | Stock | 0.9832 | 0.9839 | 0.9827 | 0.9839 | 2339848.0 |
| 2004-11-08 11:30:00 | AAPL | Stock | 0.9839 | 0.9839 | 0.9789 | 0.9789 | 2583616.0 |
| 2004-11-08 11:35:00 | AAPL | Stock | 0.9789 | 0.9796 | 0.978 | 0.9788 | 4369344.0 |
| 2004-11-08 11:40:00 | AAPL | Stock | 0.9791 | 0.9807 | 0.9786 | 0.9804 | 2477776.0 |
| 2004-11-08 11:45:00 | AAPL | Stock | 0.9802 | 0.9863 | 0.9796 | 0.9855 | 14202160.0 |
| 2004-11-08 11:50:00 | AAPL | Stock | 0.9855 | 0.9877 | 0.9832 | 0.9836 | 14765968.0 |
| 2004-11-08 11:55:00 | AAPL | Stock | 0.9838 | 0.9861 | 0.9829 | 0.9854 | 4498984.0 |
| 2004-11-08 12:00:00 | AAPL | Stock | 0.9855 | 0.9886 | 0.9843 | 0.9886 | 6389152.0 |
| 2004-11-08 12:05:00 | AAPL | Stock | 0.9886 | 0.9893 | 0.9848 | 0.9863 | 7836528.0 |
| 2004-11-08 12:10:00 | AAPL | Stock | 0.9861 | 0.9863 | 0.9841 | 0.9845 | 3637648.0 |
| 2004-11-08 12:15:00 | AAPL | Stock | 0.9843 | 0.9854 | 0.9834 | 0.9838 | 1888824.0 |
| 2004-11-08 12:20:00 | AAPL | Stock | 0.9836 | 0.9836 | 0.9816 | 0.9832 | 4514384.0 |
| 2004-11-08 12:25:00 | AAPL | Stock | 0.9834 | 0.9875 | 0.9829 | 0.9871 | 3805424.0 |
| 2004-11-08 12:30:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.9846 | 0.9846 | 3477880.0 |
| 2004-11-08 12:35:00 | AAPL | Stock | 0.9852 | 0.9875 | 0.9852 | 0.9864 | 2239832.0 |
| 2004-11-08 12:40:00 | AAPL | Stock | 0.9866 | 0.9868 | 0.9843 | 0.9857 | 1484728.0 |
> showing 50 of 185,016 rows — these rows as CSV