PREVIEW / stock_5min / 2004-11-11
file: by_date/stock_5min/2004/2004-11-11.parquet size: 2.5 MB rows: 183,460 symbols: 1,862
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-11 08:20:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 9576.0 |
| 2004-11-11 08:25:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 5600.0 |
| 2004-11-11 08:30:00 | AAPL | Stock | 0.98 | 0.98 | 0.98 | 0.98 | 16800.0 |
| 2004-11-11 08:35:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 28000.0 |
| 2004-11-11 08:40:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 56000.0 |
| 2004-11-11 08:45:00 | AAPL | Stock | 0.9839 | 0.9839 | 0.9839 | 0.9839 | 112000.0 |
| 2004-11-11 08:50:00 | AAPL | Stock | 0.9839 | 0.9857 | 0.9839 | 0.9857 | 69440.0 |
| 2004-11-11 08:55:00 | AAPL | Stock | 0.9821 | 0.9823 | 0.9821 | 0.9821 | 117600.0 |
| 2004-11-11 09:10:00 | AAPL | Stock | 0.9821 | 0.9821 | 0.9821 | 0.9821 | 16800.0 |
| 2004-11-11 09:20:00 | AAPL | Stock | 0.9813 | 0.9813 | 0.9813 | 0.9813 | 70616.0 |
| 2004-11-11 09:25:00 | AAPL | Stock | 0.9805 | 0.9821 | 0.98 | 0.9811 | 1366400.0 |
| 2004-11-11 09:30:00 | AAPL | Stock | 0.9809 | 0.982 | 0.9788 | 0.9804 | 2840432.0 |
| 2004-11-11 09:35:00 | AAPL | Stock | 0.9805 | 0.9816 | 0.9782 | 0.9789 | 2098600.0 |
| 2004-11-11 09:40:00 | AAPL | Stock | 0.9793 | 0.9802 | 0.9777 | 0.98 | 1041096.0 |
| 2004-11-11 09:45:00 | AAPL | Stock | 0.9798 | 0.98 | 0.9784 | 0.9789 | 2501856.0 |
| 2004-11-11 09:50:00 | AAPL | Stock | 0.9784 | 0.9795 | 0.9741 | 0.975 | 5336520.0 |
| 2004-11-11 09:55:00 | AAPL | Stock | 0.9755 | 0.9755 | 0.9684 | 0.971 | 12377624.0 |
| 2004-11-11 10:00:00 | AAPL | Stock | 0.9711 | 0.9775 | 0.9702 | 0.9764 | 16572584.0 |
| 2004-11-11 10:05:00 | AAPL | Stock | 0.9761 | 0.9768 | 0.9732 | 0.9741 | 8258488.0 |
| 2004-11-11 10:10:00 | AAPL | Stock | 0.9741 | 0.9745 | 0.9714 | 0.972 | 5075728.0 |
| 2004-11-11 10:15:00 | AAPL | Stock | 0.9716 | 0.9736 | 0.9714 | 0.9721 | 3823288.0 |
| 2004-11-11 10:20:00 | AAPL | Stock | 0.9721 | 0.9773 | 0.9714 | 0.9764 | 11149824.0 |
| 2004-11-11 10:25:00 | AAPL | Stock | 0.9764 | 0.9857 | 0.9745 | 0.9854 | 11006688.0 |
| 2004-11-11 10:30:00 | AAPL | Stock | 0.9859 | 0.9861 | 0.9809 | 0.9811 | 9598736.0 |
| 2004-11-11 10:35:00 | AAPL | Stock | 0.9816 | 0.9838 | 0.9811 | 0.9821 | 8427832.0 |
| 2004-11-11 10:40:00 | AAPL | Stock | 0.9821 | 0.9861 | 0.9821 | 0.9854 | 8469944.0 |
| 2004-11-11 10:45:00 | AAPL | Stock | 0.9852 | 0.9893 | 0.9846 | 0.9891 | 16544864.0 |
| 2004-11-11 10:50:00 | AAPL | Stock | 0.9888 | 0.9891 | 0.9859 | 0.9875 | 5070352.0 |
| 2004-11-11 10:55:00 | AAPL | Stock | 0.9875 | 0.9877 | 0.9841 | 0.9846 | 4194064.0 |
| 2004-11-11 11:00:00 | AAPL | Stock | 0.9845 | 0.9848 | 0.9821 | 0.9834 | 5320448.0 |
| 2004-11-11 11:05:00 | AAPL | Stock | 0.9832 | 0.9846 | 0.9823 | 0.983 | 4881744.0 |
| 2004-11-11 11:10:00 | AAPL | Stock | 0.9825 | 0.9829 | 0.9795 | 0.9811 | 6898024.0 |
| 2004-11-11 11:15:00 | AAPL | Stock | 0.9808 | 0.9813 | 0.9784 | 0.9788 | 7074200.0 |
| 2004-11-11 11:20:00 | AAPL | Stock | 0.9788 | 0.9809 | 0.977 | 0.9809 | 9761024.0 |
| 2004-11-11 11:25:00 | AAPL | Stock | 0.9807 | 0.9811 | 0.98 | 0.9804 | 3077536.0 |
| 2004-11-11 11:30:00 | AAPL | Stock | 0.9804 | 0.9807 | 0.9798 | 0.9807 | 1884456.0 |
| 2004-11-11 11:35:00 | AAPL | Stock | 0.9807 | 0.9843 | 0.9807 | 0.9834 | 3268328.0 |
| 2004-11-11 11:40:00 | AAPL | Stock | 0.9841 | 0.9843 | 0.9827 | 0.9834 | 3136896.0 |
| 2004-11-11 11:45:00 | AAPL | Stock | 0.9836 | 0.9846 | 0.9805 | 0.9846 | 4546024.0 |
| 2004-11-11 11:50:00 | AAPL | Stock | 0.9846 | 0.9857 | 0.9814 | 0.9827 | 2484328.0 |
| 2004-11-11 11:55:00 | AAPL | Stock | 0.982 | 0.9838 | 0.982 | 0.9838 | 2021768.0 |
| 2004-11-11 12:00:00 | AAPL | Stock | 0.9838 | 0.9843 | 0.9829 | 0.9834 | 1698984.0 |
| 2004-11-11 12:05:00 | AAPL | Stock | 0.9834 | 0.9854 | 0.9834 | 0.9852 | 1306648.0 |
| 2004-11-11 12:10:00 | AAPL | Stock | 0.9853 | 0.9854 | 0.9829 | 0.9829 | 2345672.0 |
| 2004-11-11 12:15:00 | AAPL | Stock | 0.9829 | 0.9829 | 0.9807 | 0.9823 | 3150000.0 |
| 2004-11-11 12:20:00 | AAPL | Stock | 0.9818 | 0.983 | 0.9813 | 0.9825 | 2249576.0 |
| 2004-11-11 12:25:00 | AAPL | Stock | 0.983 | 0.9839 | 0.9825 | 0.9839 | 1397984.0 |
| 2004-11-11 12:30:00 | AAPL | Stock | 0.9839 | 0.9843 | 0.9829 | 0.983 | 2885344.0 |
| 2004-11-11 12:35:00 | AAPL | Stock | 0.9827 | 0.983 | 0.9823 | 0.983 | 1189496.0 |
| 2004-11-11 12:40:00 | AAPL | Stock | 0.9829 | 0.9839 | 0.9818 | 0.9818 | 1225784.0 |
> showing 50 of 183,460 rows — these rows as CSV