PREVIEW / stock_5min / 2004-10-13
file: by_date/stock_5min/2004/2004-10-13.parquet size: 2.5 MB rows: 178,382 symbols: 1,831
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-13 08:00:00 | AAPL | Stock | 0.6893 | 0.6893 | 0.6893 | 0.6893 | 56000.0 |
| 2004-10-13 08:15:00 | AAPL | Stock | 0.6918 | 0.6929 | 0.6918 | 0.6929 | 285600.0 |
| 2004-10-13 08:20:00 | AAPL | Stock | 0.6925 | 0.6925 | 0.6925 | 0.6925 | 16240.0 |
| 2004-10-13 08:25:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6929 | 0.6929 | 140000.0 |
| 2004-10-13 08:30:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.6911 | 0.6911 | 258160.0 |
| 2004-10-13 08:40:00 | AAPL | Stock | 0.6911 | 0.6929 | 0.6907 | 0.6929 | 246400.0 |
| 2004-10-13 08:45:00 | AAPL | Stock | 0.6927 | 0.6929 | 0.6911 | 0.6911 | 49840.0 |
| 2004-10-13 08:50:00 | AAPL | Stock | 0.692 | 0.692 | 0.692 | 0.692 | 22400.0 |
| 2004-10-13 09:00:00 | AAPL | Stock | 0.6923 | 0.6929 | 0.692 | 0.692 | 63168.0 |
| 2004-10-13 09:05:00 | AAPL | Stock | 0.6918 | 0.6929 | 0.6918 | 0.6929 | 71568.0 |
| 2004-10-13 09:10:00 | AAPL | Stock | 0.6929 | 0.6938 | 0.6929 | 0.6938 | 176400.0 |
| 2004-10-13 09:15:00 | AAPL | Stock | 0.6929 | 0.6929 | 0.692 | 0.692 | 1061200.0 |
| 2004-10-13 09:20:00 | AAPL | Stock | 0.6938 | 0.6938 | 0.6918 | 0.6921 | 1379168.0 |
| 2004-10-13 09:25:00 | AAPL | Stock | 0.6929 | 0.6939 | 0.692 | 0.6939 | 3410400.0 |
| 2004-10-13 09:30:00 | AAPL | Stock | 0.6939 | 0.6982 | 0.6921 | 0.6982 | 39957904.0 |
| 2004-10-13 09:35:00 | AAPL | Stock | 0.6982 | 0.7002 | 0.6963 | 0.7002 | 26593616.0 |
| 2004-10-13 09:40:00 | AAPL | Stock | 0.7002 | 0.7071 | 0.6993 | 0.7059 | 27178144.0 |
| 2004-10-13 09:45:00 | AAPL | Stock | 0.7059 | 0.7066 | 0.6977 | 0.7 | 21408296.0 |
| 2004-10-13 09:50:00 | AAPL | Stock | 0.7 | 0.7014 | 0.6989 | 0.7011 | 13607104.0 |
| 2004-10-13 09:55:00 | AAPL | Stock | 0.7009 | 0.7041 | 0.6996 | 0.7032 | 9600976.0 |
| 2004-10-13 10:00:00 | AAPL | Stock | 0.7036 | 0.7036 | 0.7004 | 0.7005 | 11122384.0 |
| 2004-10-13 10:05:00 | AAPL | Stock | 0.7007 | 0.7009 | 0.6971 | 0.6982 | 17625608.0 |
| 2004-10-13 10:10:00 | AAPL | Stock | 0.6984 | 0.6989 | 0.6966 | 0.6966 | 16470104.0 |
| 2004-10-13 10:15:00 | AAPL | Stock | 0.6966 | 0.6979 | 0.6945 | 0.6977 | 8837248.0 |
| 2004-10-13 10:20:00 | AAPL | Stock | 0.6979 | 0.7 | 0.697 | 0.7 | 6279952.0 |
| 2004-10-13 10:25:00 | AAPL | Stock | 0.7 | 0.7 | 0.6971 | 0.6971 | 15945216.0 |
| 2004-10-13 10:30:00 | AAPL | Stock | 0.6971 | 0.6982 | 0.6955 | 0.6963 | 20378904.0 |
| 2004-10-13 10:35:00 | AAPL | Stock | 0.6964 | 0.6977 | 0.6963 | 0.6963 | 8534736.0 |
| 2004-10-13 10:40:00 | AAPL | Stock | 0.6963 | 0.6975 | 0.6963 | 0.6971 | 2556568.0 |
| 2004-10-13 10:45:00 | AAPL | Stock | 0.6971 | 0.6984 | 0.6963 | 0.697 | 5002592.0 |
| 2004-10-13 10:50:00 | AAPL | Stock | 0.697 | 0.6991 | 0.697 | 0.6982 | 4638368.0 |
| 2004-10-13 10:55:00 | AAPL | Stock | 0.6986 | 0.6986 | 0.6968 | 0.6968 | 2936752.0 |
| 2004-10-13 11:00:00 | AAPL | Stock | 0.6968 | 0.6973 | 0.6927 | 0.6929 | 9352616.0 |
| 2004-10-13 11:05:00 | AAPL | Stock | 0.6932 | 0.6954 | 0.6927 | 0.6929 | 10978464.0 |
| 2004-10-13 11:10:00 | AAPL | Stock | 0.6929 | 0.6938 | 0.6927 | 0.6938 | 7132832.0 |
| 2004-10-13 11:15:00 | AAPL | Stock | 0.6938 | 0.6938 | 0.6929 | 0.6938 | 3972248.0 |
| 2004-10-13 11:20:00 | AAPL | Stock | 0.6934 | 0.6938 | 0.692 | 0.6934 | 5118624.0 |
| 2004-10-13 11:25:00 | AAPL | Stock | 0.6936 | 0.6961 | 0.6929 | 0.6954 | 7272104.0 |
| 2004-10-13 11:30:00 | AAPL | Stock | 0.6954 | 0.6964 | 0.6954 | 0.6955 | 4810400.0 |
| 2004-10-13 11:35:00 | AAPL | Stock | 0.6959 | 0.6982 | 0.6952 | 0.6959 | 14098896.0 |
| 2004-10-13 11:40:00 | AAPL | Stock | 0.6957 | 0.6966 | 0.6955 | 0.6963 | 5210576.0 |
| 2004-10-13 11:45:00 | AAPL | Stock | 0.6964 | 0.6964 | 0.6961 | 0.6964 | 3501848.0 |
| 2004-10-13 11:50:00 | AAPL | Stock | 0.6964 | 0.6968 | 0.6946 | 0.6954 | 2464448.0 |
| 2004-10-13 11:55:00 | AAPL | Stock | 0.6954 | 0.6961 | 0.6954 | 0.6959 | 2248792.0 |
| 2004-10-13 12:00:00 | AAPL | Stock | 0.6961 | 0.6964 | 0.6954 | 0.6957 | 1414952.0 |
| 2004-10-13 12:05:00 | AAPL | Stock | 0.6957 | 0.6964 | 0.6957 | 0.6964 | 2569448.0 |
| 2004-10-13 12:10:00 | AAPL | Stock | 0.6964 | 0.697 | 0.6959 | 0.697 | 2157400.0 |
| 2004-10-13 12:15:00 | AAPL | Stock | 0.697 | 0.6971 | 0.6963 | 0.6963 | 3306688.0 |
| 2004-10-13 12:20:00 | AAPL | Stock | 0.6968 | 0.6968 | 0.6964 | 0.6966 | 1706320.0 |
| 2004-10-13 12:25:00 | AAPL | Stock | 0.6964 | 0.697 | 0.6963 | 0.6964 | 2288328.0 |
> showing 50 of 178,382 rows — these rows as CSV