PREVIEW / stock_5min / 2001-09-17
file: by_date/stock_5min/2001/2001-09-17.parquet size: 1.7 MB rows: 119,055 symbols: 1,344
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-17 08:15:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 5600.0 |
| 2001-09-17 08:20:00 | AAPL | Stock | 0.2991 | 0.3125 | 0.2991 | 0.3045 | 173600.0 |
| 2001-09-17 08:25:00 | AAPL | Stock | 0.2946 | 0.3036 | 0.2946 | 0.3036 | 22400.0 |
| 2001-09-17 08:30:00 | AAPL | Stock | 0.2991 | 0.2991 | 0.2991 | 0.2991 | 16800.0 |
| 2001-09-17 08:40:00 | AAPL | Stock | 0.2991 | 0.3018 | 0.2991 | 0.3009 | 369600.0 |
| 2001-09-17 08:45:00 | AAPL | Stock | 0.2946 | 0.2946 | 0.2946 | 0.2946 | 28000.0 |
| 2001-09-17 08:50:00 | AAPL | Stock | 0.3 | 0.3 | 0.3 | 0.3 | 50400.0 |
| 2001-09-17 09:00:00 | AAPL | Stock | 0.2911 | 0.2911 | 0.2911 | 0.2911 | 56000.0 |
| 2001-09-17 09:05:00 | AAPL | Stock | 0.2868 | 0.2929 | 0.2857 | 0.2929 | 1226400.0 |
| 2001-09-17 09:10:00 | AAPL | Stock | 0.2929 | 0.2929 | 0.2929 | 0.2929 | 67200.0 |
| 2001-09-17 09:15:00 | AAPL | Stock | 0.2929 | 0.2929 | 0.2902 | 0.2902 | 39200.0 |
| 2001-09-17 09:20:00 | AAPL | Stock | 0.2902 | 0.2902 | 0.2875 | 0.2891 | 593600.0 |
| 2001-09-17 09:25:00 | AAPL | Stock | 0.2891 | 0.2946 | 0.2857 | 0.2861 | 1590400.0 |
| 2001-09-17 09:30:00 | AAPL | Stock | 0.2857 | 0.2859 | 0.2813 | 0.2836 | 10399200.0 |
| 2001-09-17 09:35:00 | AAPL | Stock | 0.2834 | 0.29 | 0.282 | 0.288 | 9671200.0 |
| 2001-09-17 09:40:00 | AAPL | Stock | 0.2879 | 0.2893 | 0.2813 | 0.2857 | 6434400.0 |
| 2001-09-17 09:45:00 | AAPL | Stock | 0.2875 | 0.2891 | 0.2839 | 0.2888 | 4984000.0 |
| 2001-09-17 09:50:00 | AAPL | Stock | 0.2888 | 0.2929 | 0.2845 | 0.2927 | 6876800.0 |
| 2001-09-17 09:55:00 | AAPL | Stock | 0.2922 | 0.2943 | 0.2907 | 0.292 | 6540800.0 |
| 2001-09-17 10:00:00 | AAPL | Stock | 0.293 | 0.2941 | 0.2884 | 0.29 | 4625600.0 |
| 2001-09-17 10:05:00 | AAPL | Stock | 0.2899 | 0.2911 | 0.2889 | 0.2905 | 5364800.0 |
| 2001-09-17 10:10:00 | AAPL | Stock | 0.2902 | 0.2925 | 0.2902 | 0.2916 | 1624000.0 |
| 2001-09-17 10:15:00 | AAPL | Stock | 0.2913 | 0.2938 | 0.2905 | 0.2929 | 5896800.0 |
| 2001-09-17 10:20:00 | AAPL | Stock | 0.2927 | 0.2973 | 0.2927 | 0.297 | 6843200.0 |
| 2001-09-17 10:25:00 | AAPL | Stock | 0.2973 | 0.2982 | 0.2946 | 0.2973 | 4793600.0 |
| 2001-09-17 10:30:00 | AAPL | Stock | 0.2973 | 0.2977 | 0.2946 | 0.2961 | 2660000.0 |
| 2001-09-17 10:35:00 | AAPL | Stock | 0.297 | 0.2988 | 0.295 | 0.2986 | 3455200.0 |
| 2001-09-17 10:40:00 | AAPL | Stock | 0.298 | 0.2996 | 0.2973 | 0.2995 | 4614400.0 |
| 2001-09-17 10:45:00 | AAPL | Stock | 0.2996 | 0.3036 | 0.2986 | 0.3018 | 4743200.0 |
| 2001-09-17 10:50:00 | AAPL | Stock | 0.3023 | 0.3032 | 0.3018 | 0.3018 | 3175200.0 |
| 2001-09-17 10:55:00 | AAPL | Stock | 0.3023 | 0.3029 | 0.2984 | 0.2993 | 8461600.0 |
| 2001-09-17 11:00:00 | AAPL | Stock | 0.2991 | 0.3025 | 0.2982 | 0.3 | 12040000.0 |
| 2001-09-17 11:05:00 | AAPL | Stock | 0.3007 | 0.3009 | 0.2991 | 0.3005 | 9206400.0 |
| 2001-09-17 11:10:00 | AAPL | Stock | 0.3004 | 0.3018 | 0.3 | 0.3014 | 6568800.0 |
| 2001-09-17 11:15:00 | AAPL | Stock | 0.3018 | 0.3027 | 0.2995 | 0.3009 | 16738400.0 |
| 2001-09-17 11:20:00 | AAPL | Stock | 0.3007 | 0.3021 | 0.3005 | 0.3018 | 10942400.0 |
| 2001-09-17 11:25:00 | AAPL | Stock | 0.3018 | 0.3023 | 0.2982 | 0.2998 | 8456000.0 |
| 2001-09-17 11:30:00 | AAPL | Stock | 0.3 | 0.3013 | 0.2991 | 0.3004 | 7554400.0 |
| 2001-09-17 11:35:00 | AAPL | Stock | 0.3004 | 0.3009 | 0.2988 | 0.2993 | 10819200.0 |
| 2001-09-17 11:40:00 | AAPL | Stock | 0.3 | 0.3007 | 0.2989 | 0.2993 | 9352000.0 |
| 2001-09-17 11:45:00 | AAPL | Stock | 0.2995 | 0.3009 | 0.2991 | 0.3004 | 8075200.0 |
| 2001-09-17 11:50:00 | AAPL | Stock | 0.3005 | 0.3014 | 0.3 | 0.3014 | 3740800.0 |
| 2001-09-17 11:55:00 | AAPL | Stock | 0.3009 | 0.3014 | 0.3 | 0.3009 | 5264000.0 |
| 2001-09-17 12:00:00 | AAPL | Stock | 0.3009 | 0.3011 | 0.3002 | 0.3011 | 3455200.0 |
| 2001-09-17 12:05:00 | AAPL | Stock | 0.3011 | 0.3014 | 0.2991 | 0.2993 | 3186400.0 |
| 2001-09-17 12:10:00 | AAPL | Stock | 0.2995 | 0.3 | 0.2982 | 0.2982 | 4939200.0 |
| 2001-09-17 12:15:00 | AAPL | Stock | 0.2982 | 0.2995 | 0.2975 | 0.2975 | 2497600.0 |
| 2001-09-17 12:20:00 | AAPL | Stock | 0.2977 | 0.2977 | 0.2964 | 0.2973 | 4972800.0 |
| 2001-09-17 12:25:00 | AAPL | Stock | 0.2973 | 0.2973 | 0.2959 | 0.2959 | 5252800.0 |
| 2001-09-17 12:30:00 | AAPL | Stock | 0.2963 | 0.2963 | 0.2923 | 0.2929 | 4396000.0 |
> showing 50 of 119,055 rows — these rows as CSV