PREVIEW / stock_5min / 2004-10-05
file: by_date/stock_5min/2004/2004-10-05.parquet size: 2.4 MB rows: 178,654 symbols: 1,839
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-10-05 08:00:00 | AAPL | Stock | 0.6889 | 0.6918 | 0.6859 | 0.6918 | 67200.0 |
| 2004-10-05 08:05:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 24640.0 |
| 2004-10-05 08:10:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 56000.0 |
| 2004-10-05 08:25:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 11200.0 |
| 2004-10-05 08:55:00 | AAPL | Stock | 0.6877 | 0.6877 | 0.6877 | 0.6877 | 22400.0 |
| 2004-10-05 09:00:00 | AAPL | Stock | 0.6877 | 0.6877 | 0.6875 | 0.6875 | 89600.0 |
| 2004-10-05 09:05:00 | AAPL | Stock | 0.6882 | 0.6886 | 0.6882 | 0.6886 | 89600.0 |
| 2004-10-05 09:10:00 | AAPL | Stock | 0.6886 | 0.6886 | 0.6886 | 0.6886 | 28000.0 |
| 2004-10-05 09:15:00 | AAPL | Stock | 0.69 | 0.69 | 0.6893 | 0.6893 | 52416.0 |
| 2004-10-05 09:25:00 | AAPL | Stock | 0.6909 | 0.6909 | 0.6884 | 0.6886 | 565040.0 |
| 2004-10-05 09:30:00 | AAPL | Stock | 0.6886 | 0.6918 | 0.6857 | 0.6905 | 8648696.0 |
| 2004-10-05 09:35:00 | AAPL | Stock | 0.6905 | 0.6911 | 0.6896 | 0.6911 | 4627840.0 |
| 2004-10-05 09:40:00 | AAPL | Stock | 0.6911 | 0.6918 | 0.6902 | 0.6916 | 5436928.0 |
| 2004-10-05 09:45:00 | AAPL | Stock | 0.6916 | 0.6929 | 0.6911 | 0.6923 | 6490960.0 |
| 2004-10-05 09:50:00 | AAPL | Stock | 0.6923 | 0.695 | 0.6911 | 0.6943 | 6021568.0 |
| 2004-10-05 09:55:00 | AAPL | Stock | 0.6943 | 0.695 | 0.693 | 0.6936 | 4605384.0 |
| 2004-10-05 10:00:00 | AAPL | Stock | 0.6934 | 0.6936 | 0.6914 | 0.6921 | 5442584.0 |
| 2004-10-05 10:05:00 | AAPL | Stock | 0.6916 | 0.6945 | 0.6916 | 0.6934 | 7418040.0 |
| 2004-10-05 10:10:00 | AAPL | Stock | 0.6936 | 0.6939 | 0.6914 | 0.6923 | 3071712.0 |
| 2004-10-05 10:15:00 | AAPL | Stock | 0.6921 | 0.695 | 0.692 | 0.6948 | 4743144.0 |
| 2004-10-05 10:20:00 | AAPL | Stock | 0.6948 | 0.6964 | 0.6945 | 0.6948 | 2860256.0 |
| 2004-10-05 10:25:00 | AAPL | Stock | 0.6945 | 0.6991 | 0.6945 | 0.6977 | 5939472.0 |
| 2004-10-05 10:30:00 | AAPL | Stock | 0.6977 | 0.6982 | 0.6957 | 0.6963 | 8703184.0 |
| 2004-10-05 10:35:00 | AAPL | Stock | 0.6963 | 0.6968 | 0.695 | 0.6959 | 4451888.0 |
| 2004-10-05 10:40:00 | AAPL | Stock | 0.6959 | 0.6982 | 0.6954 | 0.6979 | 4835432.0 |
| 2004-10-05 10:45:00 | AAPL | Stock | 0.698 | 0.698 | 0.695 | 0.6952 | 3905216.0 |
| 2004-10-05 10:50:00 | AAPL | Stock | 0.6952 | 0.6952 | 0.6939 | 0.6943 | 3759056.0 |
| 2004-10-05 10:55:00 | AAPL | Stock | 0.6943 | 0.695 | 0.6943 | 0.6946 | 3093664.0 |
| 2004-10-05 11:00:00 | AAPL | Stock | 0.6945 | 0.6961 | 0.6938 | 0.6961 | 4121040.0 |
| 2004-10-05 11:05:00 | AAPL | Stock | 0.6961 | 0.6968 | 0.6943 | 0.6943 | 3098536.0 |
| 2004-10-05 11:10:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.6929 | 0.6946 | 3694992.0 |
| 2004-10-05 11:15:00 | AAPL | Stock | 0.6943 | 0.695 | 0.6941 | 0.6943 | 3316936.0 |
| 2004-10-05 11:20:00 | AAPL | Stock | 0.6943 | 0.6946 | 0.6927 | 0.693 | 3586912.0 |
| 2004-10-05 11:25:00 | AAPL | Stock | 0.693 | 0.6936 | 0.6923 | 0.693 | 3840984.0 |
| 2004-10-05 11:30:00 | AAPL | Stock | 0.693 | 0.6932 | 0.6929 | 0.6932 | 2993368.0 |
| 2004-10-05 11:35:00 | AAPL | Stock | 0.6932 | 0.6932 | 0.693 | 0.6932 | 434448.0 |
| 2004-10-05 11:40:00 | AAPL | Stock | 0.6932 | 0.6934 | 0.693 | 0.6932 | 1344560.0 |
| 2004-10-05 11:45:00 | AAPL | Stock | 0.693 | 0.6936 | 0.6925 | 0.6932 | 2630432.0 |
| 2004-10-05 11:50:00 | AAPL | Stock | 0.6932 | 0.6945 | 0.693 | 0.6939 | 2728544.0 |
| 2004-10-05 11:55:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.6938 | 0.6943 | 1771448.0 |
| 2004-10-05 12:00:00 | AAPL | Stock | 0.6943 | 0.6948 | 0.6941 | 0.6946 | 803880.0 |
| 2004-10-05 12:05:00 | AAPL | Stock | 0.6946 | 0.6955 | 0.6943 | 0.6955 | 1257760.0 |
| 2004-10-05 12:10:00 | AAPL | Stock | 0.6954 | 0.6964 | 0.6945 | 0.6964 | 3713080.0 |
| 2004-10-05 12:15:00 | AAPL | Stock | 0.6964 | 0.6968 | 0.6959 | 0.6968 | 3785824.0 |
| 2004-10-05 12:20:00 | AAPL | Stock | 0.6968 | 0.6968 | 0.6959 | 0.6964 | 1407504.0 |
| 2004-10-05 12:25:00 | AAPL | Stock | 0.6966 | 0.6968 | 0.6964 | 0.6964 | 1543976.0 |
| 2004-10-05 12:30:00 | AAPL | Stock | 0.6964 | 0.6971 | 0.6963 | 0.6968 | 1887872.0 |
| 2004-10-05 12:35:00 | AAPL | Stock | 0.6968 | 0.698 | 0.6966 | 0.6979 | 6148968.0 |
| 2004-10-05 12:40:00 | AAPL | Stock | 0.6966 | 0.6979 | 0.6966 | 0.6975 | 1703240.0 |
| 2004-10-05 12:45:00 | AAPL | Stock | 0.6975 | 0.6982 | 0.6973 | 0.698 | 1815632.0 |
> showing 50 of 178,654 rows — these rows as CSV