PREVIEW / stock_5min / 2001-09-19
file: by_date/stock_5min/2001/2001-09-19.parquet size: 1.8 MB rows: 121,217 symbols: 1,350
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-19 08:50:00 | AAPL | Stock | 0.2913 | 0.2916 | 0.2911 | 0.2911 | 89600.0 |
| 2001-09-19 08:55:00 | AAPL | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 61600.0 |
| 2001-09-19 09:00:00 | AAPL | Stock | 0.2916 | 0.2916 | 0.2916 | 0.2916 | 56000.0 |
| 2001-09-19 09:05:00 | AAPL | Stock | 0.2916 | 0.2916 | 0.2916 | 0.2916 | 112000.0 |
| 2001-09-19 09:10:00 | AAPL | Stock | 0.2911 | 0.2913 | 0.2911 | 0.2911 | 341600.0 |
| 2001-09-19 09:20:00 | AAPL | Stock | 0.2929 | 0.2943 | 0.2929 | 0.2943 | 140000.0 |
| 2001-09-19 09:25:00 | AAPL | Stock | 0.2945 | 0.2945 | 0.2944 | 0.2945 | 1926400.0 |
| 2001-09-19 09:30:00 | AAPL | Stock | 0.2946 | 0.3009 | 0.2944 | 0.2991 | 11205600.0 |
| 2001-09-19 09:35:00 | AAPL | Stock | 0.2991 | 0.2995 | 0.2961 | 0.2971 | 6490400.0 |
| 2001-09-19 09:40:00 | AAPL | Stock | 0.2975 | 0.2975 | 0.295 | 0.2955 | 3292800.0 |
| 2001-09-19 09:45:00 | AAPL | Stock | 0.2955 | 0.2964 | 0.293 | 0.2938 | 6204800.0 |
| 2001-09-19 09:50:00 | AAPL | Stock | 0.2939 | 0.298 | 0.293 | 0.2971 | 4452000.0 |
| 2001-09-19 09:55:00 | AAPL | Stock | 0.2973 | 0.2993 | 0.297 | 0.2982 | 4093600.0 |
| 2001-09-19 10:00:00 | AAPL | Stock | 0.2982 | 0.2996 | 0.2973 | 0.2995 | 5275200.0 |
| 2001-09-19 10:05:00 | AAPL | Stock | 0.2996 | 0.2996 | 0.2977 | 0.2977 | 3012800.0 |
| 2001-09-19 10:10:00 | AAPL | Stock | 0.2975 | 0.2984 | 0.2971 | 0.2971 | 2480800.0 |
| 2001-09-19 10:15:00 | AAPL | Stock | 0.2971 | 0.2971 | 0.2938 | 0.2938 | 3136000.0 |
| 2001-09-19 10:20:00 | AAPL | Stock | 0.2941 | 0.2973 | 0.2929 | 0.2966 | 1372000.0 |
| 2001-09-19 10:25:00 | AAPL | Stock | 0.2968 | 0.297 | 0.2938 | 0.2952 | 2156000.0 |
| 2001-09-19 10:30:00 | AAPL | Stock | 0.2955 | 0.2955 | 0.2923 | 0.2938 | 3791200.0 |
| 2001-09-19 10:35:00 | AAPL | Stock | 0.2938 | 0.2959 | 0.2927 | 0.2948 | 2340800.0 |
| 2001-09-19 10:40:00 | AAPL | Stock | 0.2948 | 0.295 | 0.2913 | 0.2916 | 6501600.0 |
| 2001-09-19 10:45:00 | AAPL | Stock | 0.2916 | 0.2927 | 0.2914 | 0.2923 | 2077600.0 |
| 2001-09-19 10:50:00 | AAPL | Stock | 0.2921 | 0.2927 | 0.2902 | 0.2904 | 4636800.0 |
| 2001-09-19 10:55:00 | AAPL | Stock | 0.2903 | 0.292 | 0.2898 | 0.2914 | 4496800.0 |
| 2001-09-19 11:00:00 | AAPL | Stock | 0.2918 | 0.292 | 0.2893 | 0.2893 | 3847200.0 |
| 2001-09-19 11:05:00 | AAPL | Stock | 0.2893 | 0.2902 | 0.2857 | 0.2861 | 4328800.0 |
| 2001-09-19 11:10:00 | AAPL | Stock | 0.2861 | 0.2866 | 0.2843 | 0.2848 | 6904800.0 |
| 2001-09-19 11:15:00 | AAPL | Stock | 0.2839 | 0.2884 | 0.2839 | 0.2884 | 5952800.0 |
| 2001-09-19 11:20:00 | AAPL | Stock | 0.2884 | 0.2902 | 0.2875 | 0.2902 | 3007200.0 |
| 2001-09-19 11:25:00 | AAPL | Stock | 0.2902 | 0.2913 | 0.2893 | 0.2902 | 4648000.0 |
| 2001-09-19 11:30:00 | AAPL | Stock | 0.2907 | 0.2909 | 0.2895 | 0.2895 | 2049600.0 |
| 2001-09-19 11:35:00 | AAPL | Stock | 0.2896 | 0.2896 | 0.288 | 0.288 | 3444000.0 |
| 2001-09-19 11:40:00 | AAPL | Stock | 0.288 | 0.2882 | 0.2866 | 0.2866 | 6132000.0 |
| 2001-09-19 11:45:00 | AAPL | Stock | 0.2861 | 0.2879 | 0.2857 | 0.2866 | 7515200.0 |
| 2001-09-19 11:50:00 | AAPL | Stock | 0.2866 | 0.2875 | 0.2854 | 0.2857 | 6731200.0 |
| 2001-09-19 11:55:00 | AAPL | Stock | 0.2854 | 0.2857 | 0.285 | 0.285 | 4379200.0 |
| 2001-09-19 12:00:00 | AAPL | Stock | 0.2848 | 0.2852 | 0.2832 | 0.2839 | 2749600.0 |
| 2001-09-19 12:05:00 | AAPL | Stock | 0.2841 | 0.2854 | 0.2839 | 0.2841 | 2839200.0 |
| 2001-09-19 12:10:00 | AAPL | Stock | 0.2841 | 0.2857 | 0.2841 | 0.2848 | 2564800.0 |
| 2001-09-19 12:15:00 | AAPL | Stock | 0.285 | 0.2859 | 0.2839 | 0.2839 | 5616800.0 |
| 2001-09-19 12:20:00 | AAPL | Stock | 0.2852 | 0.2859 | 0.2843 | 0.2843 | 3869600.0 |
| 2001-09-19 12:25:00 | AAPL | Stock | 0.2841 | 0.2846 | 0.2841 | 0.2843 | 1069600.0 |
| 2001-09-19 12:30:00 | AAPL | Stock | 0.2839 | 0.2841 | 0.2818 | 0.2818 | 3259200.0 |
| 2001-09-19 12:35:00 | AAPL | Stock | 0.2816 | 0.2839 | 0.2813 | 0.2839 | 6445600.0 |
| 2001-09-19 12:40:00 | AAPL | Stock | 0.2839 | 0.2841 | 0.2829 | 0.2839 | 5751200.0 |
| 2001-09-19 12:45:00 | AAPL | Stock | 0.2839 | 0.2848 | 0.2825 | 0.2841 | 2755200.0 |
| 2001-09-19 12:50:00 | AAPL | Stock | 0.2841 | 0.285 | 0.2841 | 0.2848 | 2408000.0 |
| 2001-09-19 12:55:00 | AAPL | Stock | 0.2848 | 0.2871 | 0.2841 | 0.2866 | 3242400.0 |
| 2001-09-19 13:00:00 | AAPL | Stock | 0.2866 | 0.2871 | 0.2843 | 0.2845 | 3802400.0 |
> showing 50 of 121,217 rows — these rows as CSV