PREVIEW / stock_1min / 2004-10-28
file: by_date/stock_1min/2004/2004-10-28.parquet size: 6.3 MB rows: 515,078 symbols: 1,522
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-28 08:01:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8955 | 0.8955 | 50344.0 |
| 2004-10-28 08:15:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8955 | 0.8955 | 5600.0 |
| 2004-10-28 08:16:00 | AAPL | Stock | 0.8946 | 0.8946 | 0.8936 | 0.8936 | 28000.0 |
| 2004-10-28 08:20:00 | AAPL | Stock | 0.8939 | 0.8939 | 0.8939 | 0.8939 | 11200.0 |
| 2004-10-28 08:23:00 | AAPL | Stock | 0.8939 | 0.8939 | 0.8939 | 0.8939 | 5600.0 |
| 2004-10-28 08:24:00 | AAPL | Stock | 0.8939 | 0.8939 | 0.8939 | 0.8939 | 28000.0 |
| 2004-10-28 08:26:00 | AAPL | Stock | 0.8938 | 0.8946 | 0.8938 | 0.8946 | 22344.0 |
| 2004-10-28 08:35:00 | AAPL | Stock | 0.8945 | 0.8945 | 0.8945 | 0.8945 | 44800.0 |
| 2004-10-28 08:37:00 | AAPL | Stock | 0.8945 | 0.8946 | 0.8945 | 0.8946 | 44800.0 |
| 2004-10-28 08:39:00 | AAPL | Stock | 0.8957 | 0.8957 | 0.8957 | 0.8957 | 11200.0 |
| 2004-10-28 08:40:00 | AAPL | Stock | 0.8941 | 0.8941 | 0.8938 | 0.8938 | 11200.0 |
| 2004-10-28 08:48:00 | AAPL | Stock | 0.8957 | 0.8957 | 0.8938 | 0.8938 | 44800.0 |
| 2004-10-28 08:51:00 | AAPL | Stock | 0.8939 | 0.8939 | 0.8939 | 0.8939 | 28000.0 |
| 2004-10-28 08:54:00 | AAPL | Stock | 0.8941 | 0.8946 | 0.8941 | 0.8946 | 50400.0 |
| 2004-10-28 08:56:00 | AAPL | Stock | 0.8946 | 0.8946 | 0.8946 | 0.8946 | 11200.0 |
| 2004-10-28 08:57:00 | AAPL | Stock | 0.8955 | 0.8955 | 0.8955 | 0.8955 | 5600.0 |
| 2004-10-28 08:58:00 | AAPL | Stock | 0.895 | 0.895 | 0.895 | 0.895 | 5600.0 |
| 2004-10-28 09:00:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 5600.0 |
| 2004-10-28 09:06:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 5600.0 |
| 2004-10-28 09:07:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 33600.0 |
| 2004-10-28 09:11:00 | AAPL | Stock | 0.8946 | 0.8946 | 0.8946 | 0.8946 | 28000.0 |
| 2004-10-28 09:14:00 | AAPL | Stock | 0.8961 | 0.8961 | 0.8961 | 0.8961 | 22400.0 |
| 2004-10-28 09:23:00 | AAPL | Stock | 0.8946 | 0.8946 | 0.8946 | 0.8946 | 28000.0 |
| 2004-10-28 09:25:00 | AAPL | Stock | 0.8977 | 0.898 | 0.8959 | 0.8963 | 232288.0 |
| 2004-10-28 09:26:00 | AAPL | Stock | 0.8963 | 0.8963 | 0.8941 | 0.8945 | 55440.0 |
| 2004-10-28 09:27:00 | AAPL | Stock | 0.8938 | 0.8939 | 0.892 | 0.892 | 856800.0 |
| 2004-10-28 09:28:00 | AAPL | Stock | 0.8929 | 0.8938 | 0.8929 | 0.8929 | 492800.0 |
| 2004-10-28 09:29:00 | AAPL | Stock | 0.8938 | 0.8938 | 0.8905 | 0.8916 | 800800.0 |
| 2004-10-28 09:30:00 | AAPL | Stock | 0.8925 | 0.8927 | 0.8839 | 0.8895 | 11842152.0 |
| 2004-10-28 09:31:00 | AAPL | Stock | 0.8896 | 0.8929 | 0.888 | 0.8925 | 4843384.0 |
| 2004-10-28 09:32:00 | AAPL | Stock | 0.8927 | 0.8927 | 0.8914 | 0.892 | 1995672.0 |
| 2004-10-28 09:33:00 | AAPL | Stock | 0.8918 | 0.8925 | 0.8914 | 0.8923 | 1533952.0 |
| 2004-10-28 09:34:00 | AAPL | Stock | 0.8925 | 0.8927 | 0.8918 | 0.8923 | 1662192.0 |
| 2004-10-28 09:35:00 | AAPL | Stock | 0.8923 | 0.8925 | 0.8914 | 0.8916 | 2354856.0 |
| 2004-10-28 09:36:00 | AAPL | Stock | 0.8916 | 0.8918 | 0.8884 | 0.8893 | 3579072.0 |
| 2004-10-28 09:37:00 | AAPL | Stock | 0.8889 | 0.8902 | 0.8884 | 0.89 | 2496368.0 |
| 2004-10-28 09:38:00 | AAPL | Stock | 0.89 | 0.89 | 0.8884 | 0.8895 | 3028256.0 |
| 2004-10-28 09:39:00 | AAPL | Stock | 0.8895 | 0.8895 | 0.8888 | 0.8888 | 2418248.0 |
| 2004-10-28 09:40:00 | AAPL | Stock | 0.8888 | 0.8889 | 0.8884 | 0.8884 | 1376312.0 |
| 2004-10-28 09:41:00 | AAPL | Stock | 0.8884 | 0.8886 | 0.887 | 0.887 | 3350256.0 |
| 2004-10-28 09:42:00 | AAPL | Stock | 0.8868 | 0.8877 | 0.8866 | 0.8875 | 2392824.0 |
| 2004-10-28 09:43:00 | AAPL | Stock | 0.8875 | 0.8891 | 0.887 | 0.8889 | 3254832.0 |
| 2004-10-28 09:44:00 | AAPL | Stock | 0.8889 | 0.89 | 0.8886 | 0.8898 | 1690752.0 |
| 2004-10-28 09:45:00 | AAPL | Stock | 0.89 | 0.8904 | 0.8898 | 0.89 | 1984360.0 |
| 2004-10-28 09:46:00 | AAPL | Stock | 0.89 | 0.8902 | 0.8893 | 0.8893 | 1997240.0 |
| 2004-10-28 09:47:00 | AAPL | Stock | 0.8895 | 0.8896 | 0.8891 | 0.8895 | 2581488.0 |
| 2004-10-28 09:48:00 | AAPL | Stock | 0.8895 | 0.8916 | 0.8891 | 0.8911 | 3054464.0 |
| 2004-10-28 09:49:00 | AAPL | Stock | 0.8911 | 0.8921 | 0.8911 | 0.8916 | 1309840.0 |
| 2004-10-28 09:50:00 | AAPL | Stock | 0.8914 | 0.8921 | 0.8911 | 0.8914 | 1110816.0 |
| 2004-10-28 09:51:00 | AAPL | Stock | 0.8914 | 0.8921 | 0.8913 | 0.8916 | 1779344.0 |
> showing 50 of 515,078 rows — these rows as CSV