PREVIEW / stock_1min / 2004-10-01
file: by_date/stock_1min/2004/2004-10-01.parquet size: 6.4 MB rows: 533,186 symbols: 1,514
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:01:00 | AAPL | Stock | 0.6925 | 0.6925 | 0.6925 | 0.6925 | 5600.0 |
| 2004-10-01 08:27:00 | AAPL | Stock | 0.6964 | 0.6964 | 0.6964 | 0.6964 | 123200.0 |
| 2004-10-01 08:29:00 | AAPL | Stock | 0.6971 | 0.7009 | 0.6971 | 0.6971 | 39200.0 |
| 2004-10-01 08:31:00 | AAPL | Stock | 0.6973 | 0.6973 | 0.6971 | 0.6971 | 22400.0 |
| 2004-10-01 08:36:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 39200.0 |
| 2004-10-01 08:43:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 11200.0 |
| 2004-10-01 08:51:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 11200.0 |
| 2004-10-01 08:53:00 | AAPL | Stock | 0.6971 | 0.6971 | 0.6971 | 0.6971 | 11200.0 |
| 2004-10-01 08:54:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 22400.0 |
| 2004-10-01 08:58:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 89600.0 |
| 2004-10-01 09:01:00 | AAPL | Stock | 0.6991 | 0.6991 | 0.692 | 0.692 | 285600.0 |
| 2004-10-01 09:08:00 | AAPL | Stock | 0.6991 | 0.6991 | 0.6991 | 0.6991 | 560000.0 |
| 2004-10-01 09:09:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 50400.0 |
| 2004-10-01 09:14:00 | AAPL | Stock | 0.7005 | 0.7007 | 0.7005 | 0.7007 | 240800.0 |
| 2004-10-01 09:16:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 5600.0 |
| 2004-10-01 09:18:00 | AAPL | Stock | 0.7 | 0.7 | 0.7 | 0.7 | 84000.0 |
| 2004-10-01 09:20:00 | AAPL | Stock | 0.6991 | 0.6991 | 0.6991 | 0.6991 | 44800.0 |
| 2004-10-01 09:21:00 | AAPL | Stock | 0.6989 | 0.6989 | 0.6989 | 0.6989 | 89600.0 |
| 2004-10-01 09:22:00 | AAPL | Stock | 0.6993 | 0.6993 | 0.6989 | 0.6993 | 985600.0 |
| 2004-10-01 09:24:00 | AAPL | Stock | 0.6993 | 0.6993 | 0.6993 | 0.6993 | 5600.0 |
| 2004-10-01 09:27:00 | AAPL | Stock | 0.6996 | 0.6998 | 0.6996 | 0.6998 | 520800.0 |
| 2004-10-01 09:29:00 | AAPL | Stock | 0.6996 | 0.7 | 0.6996 | 0.6996 | 115808.0 |
| 2004-10-01 09:30:00 | AAPL | Stock | 0.6986 | 0.6998 | 0.6946 | 0.695 | 5594288.0 |
| 2004-10-01 09:31:00 | AAPL | Stock | 0.6946 | 0.6993 | 0.6941 | 0.6966 | 918400.0 |
| 2004-10-01 09:32:00 | AAPL | Stock | 0.697 | 0.6973 | 0.6941 | 0.6946 | 2894640.0 |
| 2004-10-01 09:33:00 | AAPL | Stock | 0.6946 | 0.6973 | 0.6929 | 0.6939 | 2919056.0 |
| 2004-10-01 09:34:00 | AAPL | Stock | 0.6941 | 0.6946 | 0.693 | 0.6946 | 817544.0 |
| 2004-10-01 09:35:00 | AAPL | Stock | 0.6946 | 0.6959 | 0.6946 | 0.6959 | 1207640.0 |
| 2004-10-01 09:36:00 | AAPL | Stock | 0.6957 | 0.6959 | 0.6943 | 0.6948 | 1935192.0 |
| 2004-10-01 09:37:00 | AAPL | Stock | 0.6945 | 0.6946 | 0.6934 | 0.6945 | 1467928.0 |
| 2004-10-01 09:38:00 | AAPL | Stock | 0.6941 | 0.695 | 0.6938 | 0.6945 | 1860768.0 |
| 2004-10-01 09:39:00 | AAPL | Stock | 0.6948 | 0.6955 | 0.6945 | 0.6948 | 1121680.0 |
| 2004-10-01 09:40:00 | AAPL | Stock | 0.6948 | 0.6948 | 0.6945 | 0.6945 | 1265600.0 |
| 2004-10-01 09:41:00 | AAPL | Stock | 0.6946 | 0.6946 | 0.6943 | 0.6945 | 473872.0 |
| 2004-10-01 09:42:00 | AAPL | Stock | 0.6945 | 0.6946 | 0.6943 | 0.6945 | 1059296.0 |
| 2004-10-01 09:43:00 | AAPL | Stock | 0.6946 | 0.6946 | 0.6934 | 0.6934 | 1215424.0 |
| 2004-10-01 09:44:00 | AAPL | Stock | 0.6934 | 0.6936 | 0.6925 | 0.6929 | 1393896.0 |
| 2004-10-01 09:45:00 | AAPL | Stock | 0.6929 | 0.6932 | 0.6927 | 0.6932 | 1397480.0 |
| 2004-10-01 09:46:00 | AAPL | Stock | 0.693 | 0.693 | 0.6914 | 0.6914 | 1205624.0 |
| 2004-10-01 09:47:00 | AAPL | Stock | 0.692 | 0.6927 | 0.6904 | 0.6911 | 2930816.0 |
| 2004-10-01 09:48:00 | AAPL | Stock | 0.6911 | 0.692 | 0.6902 | 0.6916 | 2449216.0 |
| 2004-10-01 09:49:00 | AAPL | Stock | 0.6916 | 0.6923 | 0.6914 | 0.6921 | 883904.0 |
| 2004-10-01 09:50:00 | AAPL | Stock | 0.692 | 0.6921 | 0.6911 | 0.692 | 605920.0 |
| 2004-10-01 09:51:00 | AAPL | Stock | 0.6916 | 0.692 | 0.6916 | 0.6918 | 273000.0 |
| 2004-10-01 09:52:00 | AAPL | Stock | 0.6916 | 0.6918 | 0.6911 | 0.6911 | 1035160.0 |
| 2004-10-01 09:53:00 | AAPL | Stock | 0.6907 | 0.6914 | 0.6896 | 0.6898 | 3084536.0 |
| 2004-10-01 09:54:00 | AAPL | Stock | 0.6904 | 0.6938 | 0.6893 | 0.6896 | 2699200.0 |
| 2004-10-01 09:55:00 | AAPL | Stock | 0.6893 | 0.6905 | 0.6889 | 0.6905 | 1172248.0 |
| 2004-10-01 09:56:00 | AAPL | Stock | 0.6905 | 0.6907 | 0.6905 | 0.6907 | 945672.0 |
| 2004-10-01 09:57:00 | AAPL | Stock | 0.6905 | 0.6905 | 0.6898 | 0.6898 | 487312.0 |
> showing 50 of 533,186 rows — these rows as CSV