PREVIEW / stock_1min / 2005-05-04
file: by_date/stock_1min/2005/2005-05-04.parquet size: 7.0 MB rows: 578,848 symbols: 1,620
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-04 08:00:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 5600.0 |
| 2005-05-04 08:02:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2957 | 1.2957 | 403200.0 |
| 2005-05-04 08:06:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 14000.0 |
| 2005-05-04 08:11:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.2929 | 1.2929 | 14000.0 |
| 2005-05-04 08:12:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 28000.0 |
| 2005-05-04 08:20:00 | AAPL | Stock | 1.2979 | 1.2979 | 1.2979 | 1.2979 | 6720.0 |
| 2005-05-04 08:22:00 | AAPL | Stock | 1.2929 | 1.2946 | 1.2929 | 1.2946 | 5600.0 |
| 2005-05-04 08:29:00 | AAPL | Stock | 1.2929 | 1.2946 | 1.2929 | 1.2946 | 33740.0 |
| 2005-05-04 08:31:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 5740.0 |
| 2005-05-04 08:33:00 | AAPL | Stock | 1.2936 | 1.2936 | 1.2936 | 1.2936 | 14000.0 |
| 2005-05-04 08:36:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 19460.0 |
| 2005-05-04 08:41:00 | AAPL | Stock | 1.2946 | 1.295 | 1.2921 | 1.2921 | 159180.0 |
| 2005-05-04 08:42:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 148400.0 |
| 2005-05-04 08:43:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 152516.0 |
| 2005-05-04 08:44:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 2800.0 |
| 2005-05-04 08:45:00 | AAPL | Stock | 1.2918 | 1.2918 | 1.2918 | 1.2918 | 28000.0 |
| 2005-05-04 08:48:00 | AAPL | Stock | 1.2918 | 1.2918 | 1.2918 | 1.2918 | 56000.0 |
| 2005-05-04 08:49:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 28000.0 |
| 2005-05-04 08:50:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 5600.0 |
| 2005-05-04 08:51:00 | AAPL | Stock | 1.2918 | 1.2918 | 1.2911 | 1.2918 | 64400.0 |
| 2005-05-04 08:54:00 | AAPL | Stock | 1.2914 | 1.2914 | 1.2914 | 1.2914 | 84000.0 |
| 2005-05-04 08:55:00 | AAPL | Stock | 1.2918 | 1.2929 | 1.2918 | 1.2929 | 11200.0 |
| 2005-05-04 08:59:00 | AAPL | Stock | 1.2929 | 1.2943 | 1.2929 | 1.2943 | 39816.0 |
| 2005-05-04 09:05:00 | AAPL | Stock | 1.2936 | 1.2943 | 1.2936 | 1.2943 | 25312.0 |
| 2005-05-04 09:06:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 72800.0 |
| 2005-05-04 09:07:00 | AAPL | Stock | 1.2943 | 1.2943 | 1.2943 | 1.2943 | 14000.0 |
| 2005-05-04 09:08:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 11200.0 |
| 2005-05-04 09:11:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 5600.0 |
| 2005-05-04 09:12:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2946 | 1.2946 | 8400.0 |
| 2005-05-04 09:14:00 | AAPL | Stock | 1.2939 | 1.2939 | 1.2936 | 1.2936 | 27384.0 |
| 2005-05-04 09:18:00 | AAPL | Stock | 1.2939 | 1.2943 | 1.2939 | 1.2943 | 11340.0 |
| 2005-05-04 09:22:00 | AAPL | Stock | 1.2939 | 1.2939 | 1.2936 | 1.2939 | 16800.0 |
| 2005-05-04 09:25:00 | AAPL | Stock | 1.2946 | 1.2975 | 1.2929 | 1.2929 | 111888.0 |
| 2005-05-04 09:26:00 | AAPL | Stock | 1.2921 | 1.2921 | 1.2914 | 1.2914 | 11200.0 |
| 2005-05-04 09:27:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2911 | 1.2911 | 27300.0 |
| 2005-05-04 09:28:00 | AAPL | Stock | 1.2904 | 1.2904 | 1.2904 | 1.2904 | 5600.0 |
| 2005-05-04 09:29:00 | AAPL | Stock | 1.2911 | 1.2968 | 1.2889 | 1.2964 | 255696.0 |
| 2005-05-04 09:30:00 | AAPL | Stock | 1.2896 | 1.2982 | 1.2893 | 1.2982 | 4000192.0 |
| 2005-05-04 09:31:00 | AAPL | Stock | 1.2975 | 1.2982 | 1.2896 | 1.2968 | 1712424.0 |
| 2005-05-04 09:32:00 | AAPL | Stock | 1.2971 | 1.3 | 1.2964 | 1.2993 | 2929164.0 |
| 2005-05-04 09:33:00 | AAPL | Stock | 1.2993 | 1.3018 | 1.2982 | 1.3007 | 3036628.0 |
| 2005-05-04 09:34:00 | AAPL | Stock | 1.3007 | 1.3011 | 1.2975 | 1.2986 | 2057860.0 |
| 2005-05-04 09:35:00 | AAPL | Stock | 1.2986 | 1.3 | 1.2957 | 1.2979 | 1752324.0 |
| 2005-05-04 09:36:00 | AAPL | Stock | 1.2982 | 1.3011 | 1.2982 | 1.3004 | 1725108.0 |
| 2005-05-04 09:37:00 | AAPL | Stock | 1.3004 | 1.3036 | 1.2996 | 1.3018 | 2736496.0 |
| 2005-05-04 09:38:00 | AAPL | Stock | 1.3018 | 1.305 | 1.3014 | 1.3047 | 3642632.0 |
| 2005-05-04 09:39:00 | AAPL | Stock | 1.305 | 1.3114 | 1.3032 | 1.3114 | 4855256.0 |
| 2005-05-04 09:40:00 | AAPL | Stock | 1.3107 | 1.3125 | 1.3029 | 1.3082 | 6429080.0 |
| 2005-05-04 09:41:00 | AAPL | Stock | 1.3082 | 1.3118 | 1.3071 | 1.3104 | 3983588.0 |
| 2005-05-04 09:42:00 | AAPL | Stock | 1.31 | 1.3107 | 1.3086 | 1.3096 | 1990408.0 |
> showing 50 of 578,848 rows — these rows as CSV