PREVIEW / stock_5min / 2004-10-01
file: by_date/stock_5min/2004/2004-10-01.parquet size: 2.5 MB rows: 186,099 symbols: 1,840
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-01 08:00:00 | AAPL | Stock | 0.6925 | 0.6925 | 0.6925 | 0.6925 | 5600.0 |
| 2004-10-01 08:25:00 | AAPL | Stock | 0.6964 | 0.7009 | 0.6964 | 0.6971 | 162400.0 |
| 2004-10-01 08:30:00 | AAPL | Stock | 0.6973 | 0.6973 | 0.6971 | 0.6971 | 22400.0 |
| 2004-10-01 08:35:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 39200.0 |
| 2004-10-01 08:40:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 11200.0 |
| 2004-10-01 08:50:00 | AAPL | Stock | 0.6971 | 0.7 | 0.6971 | 0.7 | 44800.0 |
| 2004-10-01 08:55:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 89600.0 |
| 2004-10-01 09:00:00 | AAPL | Stock | 0.6991 | 0.6991 | 0.692 | 0.692 | 285600.0 |
| 2004-10-01 09:05:00 | AAPL | Stock | 0.6991 | 0.7 | 0.6991 | 0.7 | 610400.0 |
| 2004-10-01 09:10:00 | AAPL | Stock | 0.7005 | 0.7007 | 0.7005 | 0.7007 | 240800.0 |
| 2004-10-01 09:15:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 89600.0 |
| 2004-10-01 09:20:00 | AAPL | Stock | 0.6991 | 0.6993 | 0.6989 | 0.6993 | 1125600.0 |
| 2004-10-01 09:25:00 | AAPL | Stock | 0.6996 | 0.7 | 0.6996 | 0.6996 | 636608.0 |
| 2004-10-01 09:30:00 | AAPL | Stock | 0.6986 | 0.6998 | 0.6929 | 0.6946 | 13143928.0 |
| 2004-10-01 09:35:00 | AAPL | Stock | 0.6946 | 0.6959 | 0.6934 | 0.6948 | 7593208.0 |
| 2004-10-01 09:40:00 | AAPL | Stock | 0.6948 | 0.6948 | 0.6925 | 0.6929 | 5408088.0 |
| 2004-10-01 09:45:00 | AAPL | Stock | 0.6929 | 0.6932 | 0.6902 | 0.6921 | 8867040.0 |
| 2004-10-01 09:50:00 | AAPL | Stock | 0.692 | 0.6938 | 0.6893 | 0.6896 | 7697816.0 |
| 2004-10-01 09:55:00 | AAPL | Stock | 0.6893 | 0.6907 | 0.6889 | 0.6896 | 5315464.0 |
| 2004-10-01 10:00:00 | AAPL | Stock | 0.69 | 0.6929 | 0.6895 | 0.6929 | 7270256.0 |
| 2004-10-01 10:05:00 | AAPL | Stock | 0.6929 | 0.6946 | 0.692 | 0.6946 | 5922000.0 |
| 2004-10-01 10:10:00 | AAPL | Stock | 0.6945 | 0.6946 | 0.6936 | 0.6946 | 4617760.0 |
| 2004-10-01 10:15:00 | AAPL | Stock | 0.6948 | 0.6957 | 0.6939 | 0.6943 | 6425496.0 |
| 2004-10-01 10:20:00 | AAPL | Stock | 0.6943 | 0.6948 | 0.6934 | 0.6945 | 4461632.0 |
| 2004-10-01 10:25:00 | AAPL | Stock | 0.6946 | 0.6948 | 0.6932 | 0.6938 | 2887640.0 |
| 2004-10-01 10:30:00 | AAPL | Stock | 0.6941 | 0.6959 | 0.6939 | 0.6957 | 3296216.0 |
| 2004-10-01 10:35:00 | AAPL | Stock | 0.6955 | 0.6955 | 0.6918 | 0.692 | 4641728.0 |
| 2004-10-01 10:40:00 | AAPL | Stock | 0.6918 | 0.6943 | 0.6918 | 0.6936 | 4616528.0 |
| 2004-10-01 10:45:00 | AAPL | Stock | 0.6936 | 0.6943 | 0.6934 | 0.6941 | 1254064.0 |
| 2004-10-01 10:50:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.6938 | 0.6946 | 7223104.0 |
| 2004-10-01 10:55:00 | AAPL | Stock | 0.6946 | 0.6946 | 0.6925 | 0.6941 | 9791208.0 |
| 2004-10-01 11:00:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.6932 | 0.6938 | 9531872.0 |
| 2004-10-01 11:05:00 | AAPL | Stock | 0.6938 | 0.6943 | 0.6932 | 0.6932 | 4175528.0 |
| 2004-10-01 11:10:00 | AAPL | Stock | 0.6932 | 0.6939 | 0.6918 | 0.6929 | 6723360.0 |
| 2004-10-01 11:15:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6911 | 0.6927 | 3271296.0 |
| 2004-10-01 11:20:00 | AAPL | Stock | 0.6929 | 0.6936 | 0.6927 | 0.693 | 3964352.0 |
| 2004-10-01 11:25:00 | AAPL | Stock | 0.693 | 0.693 | 0.6925 | 0.6927 | 1276016.0 |
| 2004-10-01 11:30:00 | AAPL | Stock | 0.6929 | 0.6941 | 0.6927 | 0.6941 | 3732064.0 |
| 2004-10-01 11:35:00 | AAPL | Stock | 0.6941 | 0.695 | 0.6932 | 0.6939 | 4248216.0 |
| 2004-10-01 11:40:00 | AAPL | Stock | 0.6941 | 0.6961 | 0.6936 | 0.6957 | 3031336.0 |
| 2004-10-01 11:45:00 | AAPL | Stock | 0.6957 | 0.6964 | 0.6946 | 0.6952 | 3281376.0 |
| 2004-10-01 11:50:00 | AAPL | Stock | 0.6954 | 0.6954 | 0.6948 | 0.6948 | 2253160.0 |
| 2004-10-01 11:55:00 | AAPL | Stock | 0.6948 | 0.6948 | 0.693 | 0.6932 | 1927856.0 |
| 2004-10-01 12:00:00 | AAPL | Stock | 0.6932 | 0.6936 | 0.6927 | 0.693 | 1485904.0 |
| 2004-10-01 12:05:00 | AAPL | Stock | 0.693 | 0.6932 | 0.6927 | 0.6929 | 2151016.0 |
| 2004-10-01 12:10:00 | AAPL | Stock | 0.6927 | 0.6929 | 0.6921 | 0.6929 | 1750952.0 |
| 2004-10-01 12:15:00 | AAPL | Stock | 0.693 | 0.6934 | 0.6927 | 0.6929 | 1473080.0 |
| 2004-10-01 12:20:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.692 | 0.6925 | 5321008.0 |
| 2004-10-01 12:25:00 | AAPL | Stock | 0.6925 | 0.6934 | 0.6925 | 0.693 | 3377360.0 |
| 2004-10-01 12:30:00 | AAPL | Stock | 0.6932 | 0.695 | 0.693 | 0.6946 | 3252928.0 |
> showing 50 of 186,099 rows — these rows as CSV