PREVIEW / stock_5min / 2003-05-06
file: by_date/stock_5min/2003/2003-05-06.parquet size: 2.1 MB rows: 151,124 symbols: 1,584
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 |
|---|---|---|---|---|---|---|---|
| 2003-05-06 08:00:00 | AAPL | Stock | 0.2866 | 0.2929 | 0.2857 | 0.2857 | 691600.0 |
| 2003-05-06 08:05:00 | AAPL | Stock | 0.2859 | 0.2859 | 0.2821 | 0.2827 | 686000.0 |
| 2003-05-06 08:10:00 | AAPL | Stock | 0.2823 | 0.2839 | 0.2822 | 0.2839 | 156800.0 |
| 2003-05-06 08:15:00 | AAPL | Stock | 0.2839 | 0.2839 | 0.2823 | 0.2823 | 117600.0 |
| 2003-05-06 08:20:00 | AAPL | Stock | 0.2839 | 0.2839 | 0.2832 | 0.2832 | 14000.0 |
| 2003-05-06 08:25:00 | AAPL | Stock | 0.2848 | 0.2848 | 0.283 | 0.283 | 33600.0 |
| 2003-05-06 08:30:00 | AAPL | Stock | 0.283 | 0.2843 | 0.2821 | 0.2838 | 294000.0 |
| 2003-05-06 08:35:00 | AAPL | Stock | 0.2839 | 0.2848 | 0.2839 | 0.2843 | 95200.0 |
| 2003-05-06 08:40:00 | AAPL | Stock | 0.2839 | 0.285 | 0.2839 | 0.285 | 33600.0 |
| 2003-05-06 08:45:00 | AAPL | Stock | 0.2836 | 0.2839 | 0.283 | 0.2839 | 67200.0 |
| 2003-05-06 08:50:00 | AAPL | Stock | 0.2848 | 0.2857 | 0.2848 | 0.2857 | 196000.0 |
| 2003-05-06 08:55:00 | AAPL | Stock | 0.2857 | 0.2866 | 0.2857 | 0.2866 | 296800.0 |
| 2003-05-06 09:00:00 | AAPL | Stock | 0.2866 | 0.2879 | 0.2866 | 0.2879 | 263200.0 |
| 2003-05-06 09:05:00 | AAPL | Stock | 0.287 | 0.287 | 0.2866 | 0.287 | 162400.0 |
| 2003-05-06 09:10:00 | AAPL | Stock | 0.287 | 0.2886 | 0.287 | 0.2873 | 201600.0 |
| 2003-05-06 09:15:00 | AAPL | Stock | 0.2875 | 0.2877 | 0.2875 | 0.2875 | 326312.0 |
| 2003-05-06 09:20:00 | AAPL | Stock | 0.2873 | 0.2884 | 0.287 | 0.2884 | 291200.0 |
| 2003-05-06 09:25:00 | AAPL | Stock | 0.2884 | 0.2893 | 0.2871 | 0.2888 | 2962288.0 |
| 2003-05-06 09:30:00 | AAPL | Stock | 0.2889 | 0.2904 | 0.2877 | 0.2882 | 40384680.0 |
| 2003-05-06 09:35:00 | AAPL | Stock | 0.288 | 0.2895 | 0.2876 | 0.2891 | 24939712.0 |
| 2003-05-06 09:40:00 | AAPL | Stock | 0.2893 | 0.2952 | 0.2888 | 0.294 | 25644192.0 |
| 2003-05-06 09:45:00 | AAPL | Stock | 0.2938 | 0.2954 | 0.2925 | 0.2943 | 17046064.0 |
| 2003-05-06 09:50:00 | AAPL | Stock | 0.2943 | 0.2982 | 0.2939 | 0.2973 | 36842176.0 |
| 2003-05-06 09:55:00 | AAPL | Stock | 0.297 | 0.2973 | 0.2934 | 0.2939 | 26106584.0 |
| 2003-05-06 10:00:00 | AAPL | Stock | 0.2939 | 0.2952 | 0.2929 | 0.2934 | 15615040.0 |
| 2003-05-06 10:05:00 | AAPL | Stock | 0.2934 | 0.2943 | 0.2934 | 0.2938 | 8087800.0 |
| 2003-05-06 10:10:00 | AAPL | Stock | 0.2936 | 0.2946 | 0.293 | 0.2934 | 11915512.0 |
| 2003-05-06 10:15:00 | AAPL | Stock | 0.2934 | 0.2934 | 0.2916 | 0.2918 | 20333152.0 |
| 2003-05-06 10:20:00 | AAPL | Stock | 0.2916 | 0.2936 | 0.2911 | 0.2934 | 15970192.0 |
| 2003-05-06 10:25:00 | AAPL | Stock | 0.2934 | 0.2945 | 0.2932 | 0.2945 | 10617040.0 |
| 2003-05-06 10:30:00 | AAPL | Stock | 0.2945 | 0.2946 | 0.293 | 0.2938 | 10521896.0 |
| 2003-05-06 10:35:00 | AAPL | Stock | 0.2938 | 0.2939 | 0.2934 | 0.2936 | 6045928.0 |
| 2003-05-06 10:40:00 | AAPL | Stock | 0.2938 | 0.2945 | 0.2934 | 0.2943 | 4447464.0 |
| 2003-05-06 10:45:00 | AAPL | Stock | 0.2943 | 0.2943 | 0.2934 | 0.2939 | 10420480.0 |
| 2003-05-06 10:50:00 | AAPL | Stock | 0.2938 | 0.2961 | 0.2938 | 0.2952 | 14998424.0 |
| 2003-05-06 10:55:00 | AAPL | Stock | 0.2952 | 0.2961 | 0.2948 | 0.2955 | 6636000.0 |
| 2003-05-06 11:00:00 | AAPL | Stock | 0.2955 | 0.2957 | 0.2945 | 0.2957 | 5710544.0 |
| 2003-05-06 11:05:00 | AAPL | Stock | 0.2957 | 0.2963 | 0.2957 | 0.2959 | 8247680.0 |
| 2003-05-06 11:10:00 | AAPL | Stock | 0.2957 | 0.2957 | 0.2939 | 0.2948 | 8059520.0 |
| 2003-05-06 11:15:00 | AAPL | Stock | 0.2946 | 0.2954 | 0.2943 | 0.2946 | 6944056.0 |
| 2003-05-06 11:20:00 | AAPL | Stock | 0.2946 | 0.2954 | 0.2943 | 0.2954 | 4883200.0 |
| 2003-05-06 11:25:00 | AAPL | Stock | 0.2952 | 0.2961 | 0.295 | 0.2956 | 8877904.0 |
| 2003-05-06 11:30:00 | AAPL | Stock | 0.2957 | 0.2961 | 0.2946 | 0.2946 | 13360704.0 |
| 2003-05-06 11:35:00 | AAPL | Stock | 0.2947 | 0.2963 | 0.2943 | 0.2957 | 8696128.0 |
| 2003-05-06 11:40:00 | AAPL | Stock | 0.2957 | 0.2963 | 0.2948 | 0.2952 | 6008296.0 |
| 2003-05-06 11:45:00 | AAPL | Stock | 0.2952 | 0.2963 | 0.2952 | 0.2955 | 5430600.0 |
| 2003-05-06 11:50:00 | AAPL | Stock | 0.2957 | 0.2971 | 0.2955 | 0.297 | 4913552.0 |
| 2003-05-06 11:55:00 | AAPL | Stock | 0.297 | 0.2998 | 0.2968 | 0.2993 | 16964472.0 |
| 2003-05-06 12:00:00 | AAPL | Stock | 0.2991 | 0.2998 | 0.2988 | 0.2998 | 6720000.0 |
| 2003-05-06 12:05:00 | AAPL | Stock | 0.2996 | 0.2998 | 0.298 | 0.2991 | 7053480.0 |
> showing 50 of 151,124 rows — these rows as CSV