PREVIEW / stock_5min / 2004-11-15
file: by_date/stock_5min/2004/2004-11-15.parquet size: 2.6 MB rows: 187,173 symbols: 1,875
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-15 08:10:00 | AAPL | Stock | 0.9911 | 0.9911 | 0.9911 | 0.9911 | 5600.0 |
| 2004-11-15 08:15:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.9875 | 0.9875 | 5600.0 |
| 2004-11-15 08:20:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.9875 | 0.9875 | 11200.0 |
| 2004-11-15 08:25:00 | AAPL | Stock | 0.9875 | 0.9884 | 0.9875 | 0.9884 | 105000.0 |
| 2004-11-15 08:55:00 | AAPL | Stock | 0.9913 | 0.9913 | 0.9868 | 0.9868 | 5115152.0 |
| 2004-11-15 09:00:00 | AAPL | Stock | 0.9866 | 0.9866 | 0.9866 | 0.9866 | 5656.0 |
| 2004-11-15 09:20:00 | AAPL | Stock | 0.9911 | 0.9911 | 0.987 | 0.987 | 169120.0 |
| 2004-11-15 09:25:00 | AAPL | Stock | 0.9902 | 0.9902 | 0.983 | 0.9834 | 591136.0 |
| 2004-11-15 09:30:00 | AAPL | Stock | 0.9836 | 0.9861 | 0.9821 | 0.9855 | 12541312.0 |
| 2004-11-15 09:35:00 | AAPL | Stock | 0.9857 | 0.9857 | 0.9821 | 0.9832 | 4752384.0 |
| 2004-11-15 09:40:00 | AAPL | Stock | 0.983 | 0.983 | 0.9779 | 0.9791 | 13012776.0 |
| 2004-11-15 09:45:00 | AAPL | Stock | 0.9791 | 0.9839 | 0.9791 | 0.9839 | 11047232.0 |
| 2004-11-15 09:50:00 | AAPL | Stock | 0.9838 | 0.9904 | 0.9836 | 0.9886 | 12550328.0 |
| 2004-11-15 09:55:00 | AAPL | Stock | 0.9888 | 0.9891 | 0.9864 | 0.9882 | 5463920.0 |
| 2004-11-15 10:00:00 | AAPL | Stock | 0.9884 | 0.9891 | 0.9875 | 0.9891 | 5696712.0 |
| 2004-11-15 10:05:00 | AAPL | Stock | 0.9882 | 0.9889 | 0.9845 | 0.985 | 11685800.0 |
| 2004-11-15 10:10:00 | AAPL | Stock | 0.9846 | 0.9863 | 0.9804 | 0.9843 | 15595944.0 |
| 2004-11-15 10:15:00 | AAPL | Stock | 0.9843 | 0.985 | 0.9832 | 0.9836 | 7159152.0 |
| 2004-11-15 10:20:00 | AAPL | Stock | 0.9838 | 0.9843 | 0.9805 | 0.9811 | 3592792.0 |
| 2004-11-15 10:25:00 | AAPL | Stock | 0.9811 | 0.9825 | 0.9798 | 0.9804 | 5108936.0 |
| 2004-11-15 10:30:00 | AAPL | Stock | 0.9804 | 0.9827 | 0.9804 | 0.982 | 7767704.0 |
| 2004-11-15 10:35:00 | AAPL | Stock | 0.9821 | 0.9832 | 0.9804 | 0.9814 | 3981880.0 |
| 2004-11-15 10:40:00 | AAPL | Stock | 0.9816 | 0.9821 | 0.9795 | 0.9804 | 5094096.0 |
| 2004-11-15 10:45:00 | AAPL | Stock | 0.9804 | 0.9813 | 0.9795 | 0.9813 | 10699696.0 |
| 2004-11-15 10:50:00 | AAPL | Stock | 0.9813 | 0.9841 | 0.9805 | 0.9823 | 8890168.0 |
| 2004-11-15 10:55:00 | AAPL | Stock | 0.9821 | 0.9834 | 0.9813 | 0.9818 | 6453440.0 |
| 2004-11-15 11:00:00 | AAPL | Stock | 0.9816 | 0.9818 | 0.9779 | 0.9786 | 7337680.0 |
| 2004-11-15 11:05:00 | AAPL | Stock | 0.9789 | 0.9795 | 0.975 | 0.9754 | 14518840.0 |
| 2004-11-15 11:10:00 | AAPL | Stock | 0.9754 | 0.9754 | 0.9704 | 0.9738 | 11975768.0 |
| 2004-11-15 11:15:00 | AAPL | Stock | 0.9736 | 0.9784 | 0.9736 | 0.9784 | 7076440.0 |
| 2004-11-15 11:20:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.9768 | 0.9771 | 3480176.0 |
| 2004-11-15 11:25:00 | AAPL | Stock | 0.9771 | 0.9775 | 0.9761 | 0.9764 | 2053632.0 |
| 2004-11-15 11:30:00 | AAPL | Stock | 0.9764 | 0.9768 | 0.9761 | 0.9768 | 2589608.0 |
| 2004-11-15 11:35:00 | AAPL | Stock | 0.9764 | 0.9779 | 0.9764 | 0.9777 | 3702776.0 |
| 2004-11-15 11:40:00 | AAPL | Stock | 0.9777 | 0.978 | 0.9775 | 0.9777 | 1421896.0 |
| 2004-11-15 11:45:00 | AAPL | Stock | 0.9779 | 0.9784 | 0.9771 | 0.9775 | 3084480.0 |
| 2004-11-15 11:50:00 | AAPL | Stock | 0.9777 | 0.9777 | 0.9748 | 0.9761 | 3793216.0 |
| 2004-11-15 11:55:00 | AAPL | Stock | 0.9761 | 0.9779 | 0.9757 | 0.9773 | 4796008.0 |
| 2004-11-15 12:00:00 | AAPL | Stock | 0.9773 | 0.9779 | 0.9754 | 0.9764 | 4286408.0 |
| 2004-11-15 12:05:00 | AAPL | Stock | 0.9764 | 0.9766 | 0.9759 | 0.9764 | 2483040.0 |
| 2004-11-15 12:10:00 | AAPL | Stock | 0.9764 | 0.9777 | 0.9763 | 0.9766 | 4598272.0 |
| 2004-11-15 12:15:00 | AAPL | Stock | 0.9766 | 0.9777 | 0.9757 | 0.9763 | 2014544.0 |
| 2004-11-15 12:20:00 | AAPL | Stock | 0.9768 | 0.9777 | 0.9759 | 0.9768 | 1135456.0 |
| 2004-11-15 12:25:00 | AAPL | Stock | 0.9764 | 0.9777 | 0.9764 | 0.9771 | 1043896.0 |
| 2004-11-15 12:30:00 | AAPL | Stock | 0.9771 | 0.9784 | 0.9771 | 0.9784 | 2470160.0 |
| 2004-11-15 12:35:00 | AAPL | Stock | 0.9784 | 0.9795 | 0.9782 | 0.9791 | 2196992.0 |
| 2004-11-15 12:40:00 | AAPL | Stock | 0.9789 | 0.9821 | 0.9786 | 0.9809 | 3796632.0 |
| 2004-11-15 12:45:00 | AAPL | Stock | 0.9813 | 0.9834 | 0.9805 | 0.9816 | 10036040.0 |
| 2004-11-15 12:50:00 | AAPL | Stock | 0.9811 | 0.983 | 0.9809 | 0.982 | 3095120.0 |
| 2004-11-15 12:55:00 | AAPL | Stock | 0.9818 | 0.983 | 0.9813 | 0.9829 | 1070384.0 |
> showing 50 of 187,173 rows — these rows as CSV