PREVIEW / stock_5min / 2001-09-20
file: by_date/stock_5min/2001/2001-09-20.parquet size: 1.7 MB rows: 117,536 symbols: 1,345
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-20 08:00:00 | AAPL | Stock | 0.3 | 0.3 | 0.3 | 0.3 | 33600.0 |
| 2001-09-20 08:20:00 | AAPL | Stock | 0.2988 | 0.2988 | 0.2982 | 0.2988 | 408800.0 |
| 2001-09-20 08:35:00 | AAPL | Stock | 0.2964 | 0.2964 | 0.2964 | 0.2964 | 33600.0 |
| 2001-09-20 09:00:00 | AAPL | Stock | 0.3039 | 0.3039 | 0.2964 | 0.2964 | 907200.0 |
| 2001-09-20 09:05:00 | AAPL | Stock | 0.2955 | 0.2956 | 0.2955 | 0.2955 | 28000.0 |
| 2001-09-20 09:10:00 | AAPL | Stock | 0.2973 | 0.2973 | 0.2973 | 0.2973 | 84000.0 |
| 2001-09-20 09:15:00 | AAPL | Stock | 0.2971 | 0.2991 | 0.2971 | 0.2991 | 128800.0 |
| 2001-09-20 09:20:00 | AAPL | Stock | 0.3 | 0.3 | 0.2955 | 0.2955 | 16800.0 |
| 2001-09-20 09:25:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2902 | 0.2907 | 1248800.0 |
| 2001-09-20 09:30:00 | AAPL | Stock | 0.2909 | 0.2929 | 0.2877 | 0.2888 | 9716000.0 |
| 2001-09-20 09:35:00 | AAPL | Stock | 0.2889 | 0.2932 | 0.2879 | 0.2932 | 9867200.0 |
| 2001-09-20 09:40:00 | AAPL | Stock | 0.2934 | 0.2952 | 0.292 | 0.293 | 3897600.0 |
| 2001-09-20 09:45:00 | AAPL | Stock | 0.2929 | 0.2949 | 0.2916 | 0.2929 | 2805600.0 |
| 2001-09-20 09:50:00 | AAPL | Stock | 0.2929 | 0.2946 | 0.2916 | 0.2946 | 2676800.0 |
| 2001-09-20 09:55:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2896 | 0.2927 | 5140800.0 |
| 2001-09-20 10:00:00 | AAPL | Stock | 0.2936 | 0.2959 | 0.2914 | 0.2946 | 2956800.0 |
| 2001-09-20 10:05:00 | AAPL | Stock | 0.2948 | 0.2948 | 0.2902 | 0.2902 | 3029600.0 |
| 2001-09-20 10:10:00 | AAPL | Stock | 0.2902 | 0.2911 | 0.2884 | 0.2884 | 3880800.0 |
| 2001-09-20 10:15:00 | AAPL | Stock | 0.2884 | 0.2902 | 0.287 | 0.2873 | 2576000.0 |
| 2001-09-20 10:20:00 | AAPL | Stock | 0.2873 | 0.2889 | 0.2871 | 0.2871 | 1887200.0 |
| 2001-09-20 10:25:00 | AAPL | Stock | 0.2871 | 0.2873 | 0.2843 | 0.2863 | 3651200.0 |
| 2001-09-20 10:30:00 | AAPL | Stock | 0.2863 | 0.2875 | 0.2857 | 0.2861 | 2223200.0 |
| 2001-09-20 10:35:00 | AAPL | Stock | 0.2859 | 0.2882 | 0.285 | 0.2854 | 2990400.0 |
| 2001-09-20 10:40:00 | AAPL | Stock | 0.2854 | 0.2854 | 0.2836 | 0.2836 | 4149600.0 |
| 2001-09-20 10:45:00 | AAPL | Stock | 0.2845 | 0.2864 | 0.283 | 0.2839 | 3348800.0 |
| 2001-09-20 10:50:00 | AAPL | Stock | 0.2839 | 0.2873 | 0.2839 | 0.2863 | 2956800.0 |
| 2001-09-20 10:55:00 | AAPL | Stock | 0.2861 | 0.2911 | 0.285 | 0.2909 | 6630400.0 |
| 2001-09-20 11:00:00 | AAPL | Stock | 0.2905 | 0.2918 | 0.2891 | 0.2896 | 5572000.0 |
| 2001-09-20 11:05:00 | AAPL | Stock | 0.2893 | 0.2929 | 0.2891 | 0.2921 | 6322400.0 |
| 2001-09-20 11:10:00 | AAPL | Stock | 0.2925 | 0.2932 | 0.2905 | 0.293 | 2419200.0 |
| 2001-09-20 11:15:00 | AAPL | Stock | 0.2929 | 0.2977 | 0.2923 | 0.2977 | 5320000.0 |
| 2001-09-20 11:20:00 | AAPL | Stock | 0.2971 | 0.3 | 0.2968 | 0.2998 | 10505600.0 |
| 2001-09-20 11:25:00 | AAPL | Stock | 0.3 | 0.3021 | 0.2973 | 0.2988 | 7526400.0 |
| 2001-09-20 11:30:00 | AAPL | Stock | 0.2987 | 0.2991 | 0.297 | 0.2977 | 3746400.0 |
| 2001-09-20 11:35:00 | AAPL | Stock | 0.2977 | 0.2977 | 0.2966 | 0.2971 | 2828000.0 |
| 2001-09-20 11:40:00 | AAPL | Stock | 0.2971 | 0.2977 | 0.2959 | 0.2964 | 3427200.0 |
| 2001-09-20 11:45:00 | AAPL | Stock | 0.2964 | 0.2977 | 0.2964 | 0.2975 | 3085600.0 |
| 2001-09-20 11:50:00 | AAPL | Stock | 0.2977 | 0.2982 | 0.2943 | 0.2945 | 2038400.0 |
| 2001-09-20 11:55:00 | AAPL | Stock | 0.2943 | 0.2991 | 0.2938 | 0.2986 | 2912000.0 |
| 2001-09-20 12:00:00 | AAPL | Stock | 0.2986 | 0.2998 | 0.2959 | 0.2998 | 2357600.0 |
| 2001-09-20 12:05:00 | AAPL | Stock | 0.2998 | 0.3027 | 0.2996 | 0.3014 | 5280800.0 |
| 2001-09-20 12:10:00 | AAPL | Stock | 0.3016 | 0.3021 | 0.2995 | 0.3 | 2172800.0 |
| 2001-09-20 12:15:00 | AAPL | Stock | 0.3002 | 0.3004 | 0.2943 | 0.2948 | 5460000.0 |
| 2001-09-20 12:20:00 | AAPL | Stock | 0.2948 | 0.2964 | 0.2925 | 0.2925 | 2822400.0 |
| 2001-09-20 12:25:00 | AAPL | Stock | 0.2925 | 0.2936 | 0.2921 | 0.2929 | 3992800.0 |
| 2001-09-20 12:30:00 | AAPL | Stock | 0.2929 | 0.2939 | 0.2925 | 0.2932 | 5796000.0 |
| 2001-09-20 12:35:00 | AAPL | Stock | 0.2932 | 0.2938 | 0.2911 | 0.2918 | 3432800.0 |
| 2001-09-20 12:40:00 | AAPL | Stock | 0.2918 | 0.2927 | 0.2893 | 0.2898 | 3763200.0 |
| 2001-09-20 12:45:00 | AAPL | Stock | 0.2898 | 0.2918 | 0.287 | 0.2873 | 5017600.0 |
| 2001-09-20 12:50:00 | AAPL | Stock | 0.2871 | 0.2886 | 0.2866 | 0.2879 | 4950400.0 |
> showing 50 of 117,536 rows — these rows as CSV