PREVIEW / stock_5min / 2004-11-17
file: by_date/stock_5min/2004/2004-11-17.parquet size: 2.6 MB rows: 187,480 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-17 08:15:00 | AAPL | Stock | 0.9864 | 0.9864 | 0.9857 | 0.9857 | 36960.0 |
| 2004-11-17 08:30:00 | AAPL | Stock | 0.9821 | 0.9882 | 0.9821 | 0.9882 | 230720.0 |
| 2004-11-17 08:40:00 | AAPL | Stock | 0.9884 | 0.9884 | 0.9884 | 0.9884 | 5600.0 |
| 2004-11-17 08:45:00 | AAPL | Stock | 0.9884 | 0.9893 | 0.9884 | 0.9893 | 95200.0 |
| 2004-11-17 08:50:00 | AAPL | Stock | 0.9893 | 0.9893 | 0.9893 | 0.9893 | 67200.0 |
| 2004-11-17 09:00:00 | AAPL | Stock | 0.9893 | 0.9911 | 0.9893 | 0.9911 | 39200.0 |
| 2004-11-17 09:05:00 | AAPL | Stock | 0.9893 | 0.9893 | 0.9866 | 0.9866 | 56000.0 |
| 2004-11-17 09:20:00 | AAPL | Stock | 0.9875 | 0.9877 | 0.9875 | 0.9875 | 117600.0 |
| 2004-11-17 09:25:00 | AAPL | Stock | 0.9829 | 0.9877 | 0.9829 | 0.9863 | 738080.0 |
| 2004-11-17 09:30:00 | AAPL | Stock | 0.9855 | 0.9902 | 0.9839 | 0.9889 | 17456040.0 |
| 2004-11-17 09:35:00 | AAPL | Stock | 0.9884 | 0.99 | 0.9864 | 0.9877 | 7378000.0 |
| 2004-11-17 09:40:00 | AAPL | Stock | 0.9875 | 0.9886 | 0.9846 | 0.9855 | 5552400.0 |
| 2004-11-17 09:45:00 | AAPL | Stock | 0.9854 | 0.9866 | 0.9821 | 0.9841 | 6434176.0 |
| 2004-11-17 09:50:00 | AAPL | Stock | 0.9841 | 0.9864 | 0.9839 | 0.9845 | 3698072.0 |
| 2004-11-17 09:55:00 | AAPL | Stock | 0.9846 | 0.9857 | 0.9796 | 0.9814 | 7326144.0 |
| 2004-11-17 10:00:00 | AAPL | Stock | 0.9814 | 0.9825 | 0.9804 | 0.9823 | 5050304.0 |
| 2004-11-17 10:05:00 | AAPL | Stock | 0.9825 | 0.985 | 0.9809 | 0.982 | 7916720.0 |
| 2004-11-17 10:10:00 | AAPL | Stock | 0.9816 | 0.9846 | 0.9814 | 0.9839 | 5700576.0 |
| 2004-11-17 10:15:00 | AAPL | Stock | 0.9836 | 0.9896 | 0.9834 | 0.988 | 14171024.0 |
| 2004-11-17 10:20:00 | AAPL | Stock | 0.988 | 0.9893 | 0.9861 | 0.9875 | 7973336.0 |
| 2004-11-17 10:25:00 | AAPL | Stock | 0.9873 | 0.9882 | 0.9863 | 0.9875 | 5529048.0 |
| 2004-11-17 10:30:00 | AAPL | Stock | 0.9873 | 0.988 | 0.9829 | 0.9855 | 9347016.0 |
| 2004-11-17 10:35:00 | AAPL | Stock | 0.9854 | 0.9866 | 0.9839 | 0.9861 | 4924024.0 |
| 2004-11-17 10:40:00 | AAPL | Stock | 0.9863 | 0.9875 | 0.9857 | 0.9871 | 5492088.0 |
| 2004-11-17 10:45:00 | AAPL | Stock | 0.9871 | 0.9893 | 0.9854 | 0.9866 | 6627152.0 |
| 2004-11-17 10:50:00 | AAPL | Stock | 0.9868 | 0.9873 | 0.9848 | 0.9848 | 5908280.0 |
| 2004-11-17 10:55:00 | AAPL | Stock | 0.985 | 0.9868 | 0.9848 | 0.9857 | 2523192.0 |
| 2004-11-17 11:00:00 | AAPL | Stock | 0.9861 | 0.9866 | 0.9855 | 0.9864 | 1895320.0 |
| 2004-11-17 11:05:00 | AAPL | Stock | 0.9866 | 0.9868 | 0.9855 | 0.9864 | 3635128.0 |
| 2004-11-17 11:10:00 | AAPL | Stock | 0.9866 | 0.9868 | 0.985 | 0.9859 | 3081904.0 |
| 2004-11-17 11:15:00 | AAPL | Stock | 0.9861 | 0.9866 | 0.9852 | 0.9861 | 2436504.0 |
| 2004-11-17 11:20:00 | AAPL | Stock | 0.9864 | 0.987 | 0.9861 | 0.9866 | 1587992.0 |
| 2004-11-17 11:25:00 | AAPL | Stock | 0.9866 | 0.9884 | 0.9864 | 0.9882 | 8512840.0 |
| 2004-11-17 11:30:00 | AAPL | Stock | 0.9884 | 0.9902 | 0.988 | 0.9895 | 8627304.0 |
| 2004-11-17 11:35:00 | AAPL | Stock | 0.9895 | 0.9896 | 0.9864 | 0.9877 | 10388448.0 |
| 2004-11-17 11:40:00 | AAPL | Stock | 0.9879 | 0.9882 | 0.9857 | 0.9866 | 1987440.0 |
| 2004-11-17 11:45:00 | AAPL | Stock | 0.987 | 0.9893 | 0.9869 | 0.9893 | 2843904.0 |
| 2004-11-17 11:50:00 | AAPL | Stock | 0.9891 | 0.9891 | 0.9866 | 0.9886 | 2269512.0 |
| 2004-11-17 11:55:00 | AAPL | Stock | 0.9888 | 0.9888 | 0.9877 | 0.9886 | 674912.0 |
| 2004-11-17 12:00:00 | AAPL | Stock | 0.9886 | 0.9898 | 0.9886 | 0.9896 | 3482248.0 |
| 2004-11-17 12:05:00 | AAPL | Stock | 0.9896 | 0.99 | 0.9888 | 0.9889 | 2804592.0 |
| 2004-11-17 12:10:00 | AAPL | Stock | 0.9893 | 0.9896 | 0.9889 | 0.9891 | 2636480.0 |
| 2004-11-17 12:15:00 | AAPL | Stock | 0.9891 | 0.9895 | 0.9873 | 0.9884 | 3428656.0 |
| 2004-11-17 12:20:00 | AAPL | Stock | 0.9884 | 0.9884 | 0.987 | 0.9873 | 2451736.0 |
| 2004-11-17 12:25:00 | AAPL | Stock | 0.9871 | 0.9873 | 0.9866 | 0.9871 | 3901016.0 |
| 2004-11-17 12:30:00 | AAPL | Stock | 0.9875 | 0.9877 | 0.9866 | 0.9871 | 2965256.0 |
| 2004-11-17 12:35:00 | AAPL | Stock | 0.9873 | 0.9877 | 0.9861 | 0.9868 | 2420712.0 |
| 2004-11-17 12:40:00 | AAPL | Stock | 0.987 | 0.9875 | 0.9863 | 0.9871 | 2165240.0 |
| 2004-11-17 12:45:00 | AAPL | Stock | 0.9871 | 0.988 | 0.9863 | 0.9868 | 3690008.0 |
| 2004-11-17 12:50:00 | AAPL | Stock | 0.9871 | 0.9875 | 0.9868 | 0.987 | 1195040.0 |
> showing 50 of 187,480 rows — these rows as CSV