PREVIEW / stock_5min / 2004-11-04
file: by_date/stock_5min/2004/2004-11-04.parquet size: 2.6 MB rows: 184,397 symbols: 1,865
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-04 08:00:00 | AAPL | Stock | 0.9839 | 0.9875 | 0.9839 | 0.9875 | 64960.0 |
| 2004-11-04 08:20:00 | AAPL | Stock | 0.9857 | 0.9857 | 0.9841 | 0.9841 | 49560.0 |
| 2004-11-04 08:25:00 | AAPL | Stock | 0.9857 | 0.9871 | 0.9857 | 0.9871 | 55440.0 |
| 2004-11-04 08:30:00 | AAPL | Stock | 0.9871 | 0.9871 | 0.9871 | 0.9871 | 16800.0 |
| 2004-11-04 08:35:00 | AAPL | Stock | 0.9875 | 0.9875 | 0.9875 | 0.9875 | 28000.0 |
| 2004-11-04 08:40:00 | AAPL | Stock | 0.9839 | 0.9839 | 0.9823 | 0.9823 | 11200.0 |
| 2004-11-04 08:45:00 | AAPL | Stock | 0.9868 | 0.9868 | 0.9868 | 0.9868 | 50400.0 |
| 2004-11-04 08:55:00 | AAPL | Stock | 0.987 | 0.987 | 0.987 | 0.987 | 5600.0 |
| 2004-11-04 09:00:00 | AAPL | Stock | 0.9866 | 0.9866 | 0.9866 | 0.9866 | 16800.0 |
| 2004-11-04 09:10:00 | AAPL | Stock | 0.9848 | 0.9848 | 0.9848 | 0.9848 | 54600.0 |
| 2004-11-04 09:15:00 | AAPL | Stock | 0.9848 | 0.9848 | 0.983 | 0.983 | 141400.0 |
| 2004-11-04 09:20:00 | AAPL | Stock | 0.9839 | 0.9839 | 0.983 | 0.983 | 72800.0 |
| 2004-11-04 09:25:00 | AAPL | Stock | 0.9868 | 0.9868 | 0.9813 | 0.9832 | 1767696.0 |
| 2004-11-04 09:30:00 | AAPL | Stock | 0.9827 | 0.9886 | 0.9813 | 0.9883 | 22592752.0 |
| 2004-11-04 09:35:00 | AAPL | Stock | 0.9884 | 0.9905 | 0.9798 | 0.9818 | 22920856.0 |
| 2004-11-04 09:40:00 | AAPL | Stock | 0.9836 | 0.9864 | 0.9821 | 0.9864 | 15932112.0 |
| 2004-11-04 09:45:00 | AAPL | Stock | 0.9864 | 0.9893 | 0.985 | 0.988 | 20296696.0 |
| 2004-11-04 09:50:00 | AAPL | Stock | 0.988 | 0.992 | 0.9875 | 0.9902 | 33883640.0 |
| 2004-11-04 09:55:00 | AAPL | Stock | 0.9902 | 0.9904 | 0.9859 | 0.9882 | 13357848.0 |
| 2004-11-04 10:00:00 | AAPL | Stock | 0.9882 | 0.9907 | 0.988 | 0.9888 | 13037136.0 |
| 2004-11-04 10:05:00 | AAPL | Stock | 0.9884 | 0.9889 | 0.982 | 0.983 | 20801704.0 |
| 2004-11-04 10:10:00 | AAPL | Stock | 0.983 | 0.9848 | 0.9777 | 0.9777 | 36676472.0 |
| 2004-11-04 10:15:00 | AAPL | Stock | 0.9777 | 0.9814 | 0.977 | 0.9786 | 12697888.0 |
| 2004-11-04 10:20:00 | AAPL | Stock | 0.9786 | 0.9866 | 0.9784 | 0.9813 | 12180392.0 |
| 2004-11-04 10:25:00 | AAPL | Stock | 0.9813 | 0.9827 | 0.9795 | 0.9802 | 16251200.0 |
| 2004-11-04 10:30:00 | AAPL | Stock | 0.9805 | 0.9832 | 0.9782 | 0.9811 | 16450504.0 |
| 2004-11-04 10:35:00 | AAPL | Stock | 0.9809 | 0.9817 | 0.975 | 0.9771 | 18502176.0 |
| 2004-11-04 10:40:00 | AAPL | Stock | 0.9772 | 0.9789 | 0.9732 | 0.9734 | 10773616.0 |
| 2004-11-04 10:45:00 | AAPL | Stock | 0.9734 | 0.9746 | 0.9709 | 0.9739 | 15230768.0 |
| 2004-11-04 10:50:00 | AAPL | Stock | 0.9736 | 0.9743 | 0.9721 | 0.9738 | 10511032.0 |
| 2004-11-04 10:55:00 | AAPL | Stock | 0.9736 | 0.9782 | 0.9734 | 0.9775 | 10926272.0 |
| 2004-11-04 11:00:00 | AAPL | Stock | 0.9772 | 0.9796 | 0.9755 | 0.9796 | 16856952.0 |
| 2004-11-04 11:05:00 | AAPL | Stock | 0.9795 | 0.9809 | 0.9777 | 0.9804 | 14364952.0 |
| 2004-11-04 11:10:00 | AAPL | Stock | 0.98 | 0.9846 | 0.9798 | 0.9836 | 12633096.0 |
| 2004-11-04 11:15:00 | AAPL | Stock | 0.9836 | 0.9866 | 0.9816 | 0.983 | 18238920.0 |
| 2004-11-04 11:20:00 | AAPL | Stock | 0.983 | 0.9866 | 0.982 | 0.9848 | 14738024.0 |
| 2004-11-04 11:25:00 | AAPL | Stock | 0.9848 | 0.9871 | 0.9839 | 0.9868 | 10981824.0 |
| 2004-11-04 11:30:00 | AAPL | Stock | 0.9868 | 0.9891 | 0.9861 | 0.9877 | 18329640.0 |
| 2004-11-04 11:35:00 | AAPL | Stock | 0.9873 | 0.9875 | 0.9834 | 0.985 | 7360192.0 |
| 2004-11-04 11:40:00 | AAPL | Stock | 0.9846 | 0.9861 | 0.9823 | 0.983 | 4618824.0 |
| 2004-11-04 11:45:00 | AAPL | Stock | 0.983 | 0.9846 | 0.9827 | 0.9836 | 4087496.0 |
| 2004-11-04 11:50:00 | AAPL | Stock | 0.9832 | 0.9836 | 0.9805 | 0.9811 | 4698904.0 |
| 2004-11-04 11:55:00 | AAPL | Stock | 0.9807 | 0.9821 | 0.9805 | 0.982 | 3077648.0 |
| 2004-11-04 12:00:00 | AAPL | Stock | 0.9818 | 0.982 | 0.9813 | 0.9813 | 1826328.0 |
| 2004-11-04 12:05:00 | AAPL | Stock | 0.9813 | 0.982 | 0.9804 | 0.9818 | 1869616.0 |
| 2004-11-04 12:10:00 | AAPL | Stock | 0.9813 | 0.9821 | 0.9813 | 0.9818 | 4036928.0 |
| 2004-11-04 12:15:00 | AAPL | Stock | 0.982 | 0.9848 | 0.9814 | 0.9843 | 16320808.0 |
| 2004-11-04 12:20:00 | AAPL | Stock | 0.9843 | 0.9855 | 0.9821 | 0.9837 | 6827016.0 |
| 2004-11-04 12:25:00 | AAPL | Stock | 0.9834 | 0.9845 | 0.9821 | 0.9841 | 5170872.0 |
| 2004-11-04 12:30:00 | AAPL | Stock | 0.9841 | 0.9861 | 0.9836 | 0.9861 | 4296208.0 |
> showing 50 of 184,397 rows — these rows as CSV