PREVIEW / stock_5min / 2004-11-18
file: by_date/stock_5min/2004/2004-11-18.parquet size: 2.5 MB rows: 183,920 symbols: 1,880
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-18 08:00:00 | AAPL | Stock | 0.9784 | 0.9784 | 0.9784 | 0.9784 | 8400.0 |
| 2004-11-18 08:25:00 | AAPL | Stock | 0.9786 | 0.9786 | 0.9777 | 0.9777 | 16800.0 |
| 2004-11-18 08:40:00 | AAPL | Stock | 0.9804 | 0.9804 | 0.9804 | 0.9804 | 43736.0 |
| 2004-11-18 08:50:00 | AAPL | Stock | 0.9768 | 0.9768 | 0.9768 | 0.9768 | 13328.0 |
| 2004-11-18 09:15:00 | AAPL | Stock | 0.9782 | 0.9786 | 0.9782 | 0.9786 | 135352.0 |
| 2004-11-18 09:25:00 | AAPL | Stock | 0.9795 | 0.9795 | 0.9696 | 0.9696 | 1194984.0 |
| 2004-11-18 09:30:00 | AAPL | Stock | 0.9696 | 0.9839 | 0.9695 | 0.9829 | 15761760.0 |
| 2004-11-18 09:35:00 | AAPL | Stock | 0.9832 | 0.9873 | 0.9813 | 0.9841 | 13743856.0 |
| 2004-11-18 09:40:00 | AAPL | Stock | 0.9845 | 0.9855 | 0.9804 | 0.9809 | 10033352.0 |
| 2004-11-18 09:45:00 | AAPL | Stock | 0.9807 | 0.9829 | 0.9773 | 0.9789 | 9026920.0 |
| 2004-11-18 09:50:00 | AAPL | Stock | 0.9793 | 0.9836 | 0.9788 | 0.9814 | 10698072.0 |
| 2004-11-18 09:55:00 | AAPL | Stock | 0.9813 | 0.9827 | 0.9795 | 0.9827 | 9083032.0 |
| 2004-11-18 10:00:00 | AAPL | Stock | 0.9829 | 0.9841 | 0.9811 | 0.9841 | 13747104.0 |
| 2004-11-18 10:05:00 | AAPL | Stock | 0.9839 | 0.9866 | 0.9839 | 0.9859 | 12108432.0 |
| 2004-11-18 10:10:00 | AAPL | Stock | 0.9861 | 0.9884 | 0.985 | 0.988 | 11680144.0 |
| 2004-11-18 10:15:00 | AAPL | Stock | 0.9873 | 0.9886 | 0.9839 | 0.9875 | 11628064.0 |
| 2004-11-18 10:20:00 | AAPL | Stock | 0.9873 | 0.9875 | 0.9848 | 0.9866 | 5642000.0 |
| 2004-11-18 10:25:00 | AAPL | Stock | 0.9864 | 0.9902 | 0.9863 | 0.9895 | 22425032.0 |
| 2004-11-18 10:30:00 | AAPL | Stock | 0.9896 | 0.9896 | 0.9863 | 0.9866 | 7139384.0 |
| 2004-11-18 10:35:00 | AAPL | Stock | 0.9868 | 0.9888 | 0.9864 | 0.9879 | 4556888.0 |
| 2004-11-18 10:40:00 | AAPL | Stock | 0.9879 | 0.9886 | 0.987 | 0.9884 | 5367096.0 |
| 2004-11-18 10:45:00 | AAPL | Stock | 0.9882 | 0.9884 | 0.9873 | 0.9882 | 3987872.0 |
| 2004-11-18 10:50:00 | AAPL | Stock | 0.988 | 0.9898 | 0.9877 | 0.9877 | 10340120.0 |
| 2004-11-18 10:55:00 | AAPL | Stock | 0.9879 | 0.9902 | 0.987 | 0.9875 | 13520584.0 |
| 2004-11-18 11:00:00 | AAPL | Stock | 0.9875 | 0.9888 | 0.9866 | 0.987 | 7151872.0 |
| 2004-11-18 11:05:00 | AAPL | Stock | 0.987 | 0.9884 | 0.9868 | 0.9884 | 4508672.0 |
| 2004-11-18 11:10:00 | AAPL | Stock | 0.9882 | 0.9884 | 0.9871 | 0.988 | 5151888.0 |
| 2004-11-18 11:15:00 | AAPL | Stock | 0.9877 | 0.9882 | 0.9846 | 0.9868 | 4723320.0 |
| 2004-11-18 11:20:00 | AAPL | Stock | 0.9866 | 0.9884 | 0.9866 | 0.9879 | 5081328.0 |
| 2004-11-18 11:25:00 | AAPL | Stock | 0.9879 | 0.9884 | 0.9871 | 0.9877 | 3249400.0 |
| 2004-11-18 11:30:00 | AAPL | Stock | 0.9879 | 0.9884 | 0.9873 | 0.988 | 3747632.0 |
| 2004-11-18 11:35:00 | AAPL | Stock | 0.9882 | 0.9902 | 0.9875 | 0.9882 | 5091912.0 |
| 2004-11-18 11:40:00 | AAPL | Stock | 0.9884 | 0.9898 | 0.9877 | 0.9884 | 16981104.0 |
| 2004-11-18 11:45:00 | AAPL | Stock | 0.988 | 0.9884 | 0.9868 | 0.9873 | 2006928.0 |
| 2004-11-18 11:50:00 | AAPL | Stock | 0.987 | 0.9877 | 0.9866 | 0.9877 | 6101200.0 |
| 2004-11-18 11:55:00 | AAPL | Stock | 0.9875 | 0.9877 | 0.9871 | 0.9875 | 1599192.0 |
| 2004-11-18 12:00:00 | AAPL | Stock | 0.9877 | 0.9877 | 0.9857 | 0.9859 | 6016304.0 |
| 2004-11-18 12:05:00 | AAPL | Stock | 0.9859 | 0.9866 | 0.9848 | 0.9848 | 2943752.0 |
| 2004-11-18 12:10:00 | AAPL | Stock | 0.985 | 0.9864 | 0.9848 | 0.9864 | 1094296.0 |
| 2004-11-18 12:15:00 | AAPL | Stock | 0.9863 | 0.9873 | 0.9859 | 0.9871 | 612248.0 |
| 2004-11-18 12:20:00 | AAPL | Stock | 0.987 | 0.9884 | 0.9868 | 0.9882 | 2522744.0 |
| 2004-11-18 12:25:00 | AAPL | Stock | 0.9879 | 0.9884 | 0.9871 | 0.9873 | 1116752.0 |
| 2004-11-18 12:30:00 | AAPL | Stock | 0.9873 | 0.9884 | 0.9868 | 0.9884 | 2499896.0 |
| 2004-11-18 12:35:00 | AAPL | Stock | 0.9884 | 0.9884 | 0.9875 | 0.9884 | 4315808.0 |
| 2004-11-18 12:40:00 | AAPL | Stock | 0.9884 | 0.9884 | 0.9879 | 0.9882 | 1306368.0 |
| 2004-11-18 12:45:00 | AAPL | Stock | 0.9884 | 0.9886 | 0.9882 | 0.9886 | 2723784.0 |
| 2004-11-18 12:50:00 | AAPL | Stock | 0.9886 | 0.9888 | 0.9879 | 0.9884 | 1478680.0 |
| 2004-11-18 12:55:00 | AAPL | Stock | 0.988 | 0.988 | 0.9863 | 0.9868 | 1466976.0 |
| 2004-11-18 13:00:00 | AAPL | Stock | 0.9866 | 0.9871 | 0.9863 | 0.9868 | 2514792.0 |
| 2004-11-18 13:05:00 | AAPL | Stock | 0.987 | 0.9871 | 0.9836 | 0.9846 | 4910584.0 |
> showing 50 of 183,920 rows — these rows as CSV