PREVIEW / stock_5min / 2001-09-24
file: by_date/stock_5min/2001/2001-09-24.parquet size: 1.7 MB rows: 116,406 symbols: 1,346
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 |
|---|---|---|---|---|---|---|---|
| 2001-09-24 08:15:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 28000.0 |
| 2001-09-24 08:20:00 | AAPL | Stock | 0.2893 | 0.2911 | 0.2893 | 0.2911 | 140000.0 |
| 2001-09-24 08:25:00 | AAPL | Stock | 0.2914 | 0.2914 | 0.2911 | 0.2911 | 100800.0 |
| 2001-09-24 08:30:00 | AAPL | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 84000.0 |
| 2001-09-24 08:40:00 | AAPL | Stock | 0.2911 | 0.2914 | 0.2911 | 0.2914 | 67200.0 |
| 2001-09-24 08:45:00 | AAPL | Stock | 0.2925 | 0.2925 | 0.2914 | 0.2914 | 11200.0 |
| 2001-09-24 09:05:00 | AAPL | Stock | 0.2902 | 0.2907 | 0.2902 | 0.2902 | 128800.0 |
| 2001-09-24 09:10:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2902 | 0.2902 | 106400.0 |
| 2001-09-24 09:15:00 | AAPL | Stock | 0.2891 | 0.2893 | 0.2891 | 0.2893 | 22400.0 |
| 2001-09-24 09:20:00 | AAPL | Stock | 0.2891 | 0.2891 | 0.2864 | 0.2875 | 156800.0 |
| 2001-09-24 09:25:00 | AAPL | Stock | 0.2891 | 0.29 | 0.2875 | 0.2884 | 1209600.0 |
| 2001-09-24 09:30:00 | AAPL | Stock | 0.2877 | 0.29 | 0.2848 | 0.2879 | 10813600.0 |
| 2001-09-24 09:35:00 | AAPL | Stock | 0.288 | 0.2911 | 0.2866 | 0.2909 | 5280800.0 |
| 2001-09-24 09:40:00 | AAPL | Stock | 0.2911 | 0.2939 | 0.2898 | 0.2939 | 11032000.0 |
| 2001-09-24 09:45:00 | AAPL | Stock | 0.2939 | 0.2946 | 0.292 | 0.2921 | 6703200.0 |
| 2001-09-24 09:50:00 | AAPL | Stock | 0.2929 | 0.2946 | 0.292 | 0.2941 | 6238400.0 |
| 2001-09-24 09:55:00 | AAPL | Stock | 0.2943 | 0.2943 | 0.2914 | 0.2914 | 3124800.0 |
| 2001-09-24 10:00:00 | AAPL | Stock | 0.2915 | 0.2939 | 0.2915 | 0.293 | 3203200.0 |
| 2001-09-24 10:05:00 | AAPL | Stock | 0.2929 | 0.2954 | 0.2921 | 0.2954 | 5219200.0 |
| 2001-09-24 10:10:00 | AAPL | Stock | 0.2954 | 0.2954 | 0.2918 | 0.2929 | 3040800.0 |
| 2001-09-24 10:15:00 | AAPL | Stock | 0.292 | 0.2939 | 0.2911 | 0.2936 | 5135200.0 |
| 2001-09-24 10:20:00 | AAPL | Stock | 0.2936 | 0.2957 | 0.2936 | 0.2953 | 4631200.0 |
| 2001-09-24 10:25:00 | AAPL | Stock | 0.2948 | 0.2973 | 0.2936 | 0.2936 | 3074400.0 |
| 2001-09-24 10:30:00 | AAPL | Stock | 0.2936 | 0.2973 | 0.2929 | 0.2973 | 11032000.0 |
| 2001-09-24 10:35:00 | AAPL | Stock | 0.2973 | 0.2973 | 0.2934 | 0.2954 | 2329600.0 |
| 2001-09-24 10:40:00 | AAPL | Stock | 0.2957 | 0.2982 | 0.295 | 0.2982 | 9940000.0 |
| 2001-09-24 10:45:00 | AAPL | Stock | 0.2982 | 0.3 | 0.2966 | 0.2966 | 4972800.0 |
| 2001-09-24 10:50:00 | AAPL | Stock | 0.2971 | 0.2975 | 0.295 | 0.2955 | 3332000.0 |
| 2001-09-24 10:55:00 | AAPL | Stock | 0.2957 | 0.2963 | 0.2946 | 0.2963 | 2811200.0 |
| 2001-09-24 11:00:00 | AAPL | Stock | 0.2961 | 0.2977 | 0.2955 | 0.2971 | 1220800.0 |
| 2001-09-24 11:05:00 | AAPL | Stock | 0.2966 | 0.2971 | 0.2955 | 0.2961 | 890400.0 |
| 2001-09-24 11:10:00 | AAPL | Stock | 0.2961 | 0.2982 | 0.2955 | 0.2966 | 1982400.0 |
| 2001-09-24 11:15:00 | AAPL | Stock | 0.297 | 0.298 | 0.2963 | 0.2963 | 1495200.0 |
| 2001-09-24 11:20:00 | AAPL | Stock | 0.2966 | 0.2993 | 0.2955 | 0.2993 | 11015200.0 |
| 2001-09-24 11:25:00 | AAPL | Stock | 0.2993 | 0.3 | 0.2966 | 0.2966 | 3085600.0 |
| 2001-09-24 11:30:00 | AAPL | Stock | 0.2966 | 0.2989 | 0.2964 | 0.2971 | 2150400.0 |
| 2001-09-24 11:35:00 | AAPL | Stock | 0.2973 | 0.298 | 0.2971 | 0.298 | 772800.0 |
| 2001-09-24 11:40:00 | AAPL | Stock | 0.298 | 0.298 | 0.2963 | 0.2968 | 1293600.0 |
| 2001-09-24 11:45:00 | AAPL | Stock | 0.2963 | 0.298 | 0.2963 | 0.298 | 1590400.0 |
| 2001-09-24 11:50:00 | AAPL | Stock | 0.298 | 0.2989 | 0.2964 | 0.297 | 1562400.0 |
| 2001-09-24 11:55:00 | AAPL | Stock | 0.2973 | 0.2979 | 0.2966 | 0.2971 | 1562400.0 |
| 2001-09-24 12:00:00 | AAPL | Stock | 0.2968 | 0.2991 | 0.2966 | 0.2973 | 1372000.0 |
| 2001-09-24 12:05:00 | AAPL | Stock | 0.2979 | 0.2979 | 0.297 | 0.2973 | 1024800.0 |
| 2001-09-24 12:10:00 | AAPL | Stock | 0.2975 | 0.2977 | 0.2966 | 0.2973 | 666400.0 |
| 2001-09-24 12:15:00 | AAPL | Stock | 0.2975 | 0.2989 | 0.2975 | 0.2988 | 2245600.0 |
| 2001-09-24 12:20:00 | AAPL | Stock | 0.2988 | 0.2989 | 0.2973 | 0.2977 | 2581600.0 |
| 2001-09-24 12:25:00 | AAPL | Stock | 0.2975 | 0.2982 | 0.2975 | 0.2979 | 1601600.0 |
| 2001-09-24 12:30:00 | AAPL | Stock | 0.2979 | 0.2982 | 0.2973 | 0.2982 | 784000.0 |
| 2001-09-24 12:35:00 | AAPL | Stock | 0.298 | 0.2982 | 0.2977 | 0.298 | 151200.0 |
| 2001-09-24 12:40:00 | AAPL | Stock | 0.2975 | 0.2991 | 0.2975 | 0.2987 | 677600.0 |
> showing 50 of 116,406 rows — these rows as CSV