PREVIEW / stock_5min / 2005-05-02
file: by_date/stock_5min/2005/2005-05-02.parquet size: 2.7 MB rows: 198,563 symbols: 1,968
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 |
|---|---|---|---|---|---|---|---|
| 2005-05-02 07:15:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 2800.0 |
| 2005-05-02 07:40:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 2800.0 |
| 2005-05-02 08:00:00 | AAPL | Stock | 1.3 | 1.3 | 1.2879 | 1.2879 | 381276.0 |
| 2005-05-02 08:05:00 | AAPL | Stock | 1.3 | 1.3032 | 1.2968 | 1.2971 | 193284.0 |
| 2005-05-02 08:10:00 | AAPL | Stock | 1.2968 | 1.2996 | 1.2968 | 1.2996 | 50400.0 |
| 2005-05-02 08:15:00 | AAPL | Stock | 1.2993 | 1.3007 | 1.2993 | 1.3007 | 95200.0 |
| 2005-05-02 08:20:00 | AAPL | Stock | 1.2982 | 1.2982 | 1.2982 | 1.2982 | 11200.0 |
| 2005-05-02 08:25:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2975 | 1.2975 | 8400.0 |
| 2005-05-02 08:30:00 | AAPL | Stock | 1.2961 | 1.2968 | 1.2954 | 1.2957 | 82516.0 |
| 2005-05-02 08:35:00 | AAPL | Stock | 1.2964 | 1.2979 | 1.2957 | 1.2957 | 158284.0 |
| 2005-05-02 08:40:00 | AAPL | Stock | 1.2954 | 1.2964 | 1.295 | 1.295 | 30800.0 |
| 2005-05-02 08:45:00 | AAPL | Stock | 1.295 | 1.295 | 1.2911 | 1.2946 | 154000.0 |
| 2005-05-02 08:50:00 | AAPL | Stock | 1.2946 | 1.2954 | 1.2946 | 1.2946 | 30800.0 |
| 2005-05-02 08:55:00 | AAPL | Stock | 1.295 | 1.295 | 1.295 | 1.295 | 2800.0 |
| 2005-05-02 09:00:00 | AAPL | Stock | 1.295 | 1.295 | 1.2946 | 1.2946 | 56980.0 |
| 2005-05-02 09:05:00 | AAPL | Stock | 1.2946 | 1.2964 | 1.2943 | 1.2946 | 56000.0 |
| 2005-05-02 09:10:00 | AAPL | Stock | 1.2943 | 1.2954 | 1.2943 | 1.2954 | 90496.0 |
| 2005-05-02 09:15:00 | AAPL | Stock | 1.2954 | 1.2954 | 1.2929 | 1.2929 | 161504.0 |
| 2005-05-02 09:20:00 | AAPL | Stock | 1.2939 | 1.2979 | 1.2939 | 1.2971 | 268800.0 |
| 2005-05-02 09:25:00 | AAPL | Stock | 1.2971 | 1.2993 | 1.2896 | 1.2896 | 1195152.0 |
| 2005-05-02 09:30:00 | AAPL | Stock | 1.2932 | 1.2986 | 1.2929 | 1.295 | 14378616.0 |
| 2005-05-02 09:35:00 | AAPL | Stock | 1.2954 | 1.3021 | 1.2943 | 1.2996 | 14344232.0 |
| 2005-05-02 09:40:00 | AAPL | Stock | 1.2996 | 1.3014 | 1.2971 | 1.3 | 9849588.0 |
| 2005-05-02 09:45:00 | AAPL | Stock | 1.2996 | 1.3054 | 1.2966 | 1.3029 | 15830696.0 |
| 2005-05-02 09:50:00 | AAPL | Stock | 1.3032 | 1.3054 | 1.3021 | 1.3025 | 9612988.0 |
| 2005-05-02 09:55:00 | AAPL | Stock | 1.3018 | 1.3036 | 1.2996 | 1.3032 | 9276204.0 |
| 2005-05-02 10:00:00 | AAPL | Stock | 1.3032 | 1.3046 | 1.3004 | 1.3011 | 9961840.0 |
| 2005-05-02 10:05:00 | AAPL | Stock | 1.3011 | 1.3036 | 1.3011 | 1.3018 | 8632428.0 |
| 2005-05-02 10:10:00 | AAPL | Stock | 1.3018 | 1.3039 | 1.2979 | 1.3004 | 9428132.0 |
| 2005-05-02 10:15:00 | AAPL | Stock | 1.3007 | 1.3014 | 1.2989 | 1.3007 | 5892572.0 |
| 2005-05-02 10:20:00 | AAPL | Stock | 1.3004 | 1.3036 | 1.2993 | 1.3021 | 6126372.0 |
| 2005-05-02 10:25:00 | AAPL | Stock | 1.3025 | 1.3032 | 1.3004 | 1.3018 | 5254536.0 |
| 2005-05-02 10:30:00 | AAPL | Stock | 1.3021 | 1.3025 | 1.2986 | 1.2996 | 8915228.0 |
| 2005-05-02 10:35:00 | AAPL | Stock | 1.2996 | 1.3011 | 1.2989 | 1.3007 | 5762988.0 |
| 2005-05-02 10:40:00 | AAPL | Stock | 1.3007 | 1.3021 | 1.3004 | 1.3021 | 4535020.0 |
| 2005-05-02 10:45:00 | AAPL | Stock | 1.3018 | 1.3068 | 1.3011 | 1.3057 | 9388092.0 |
| 2005-05-02 10:50:00 | AAPL | Stock | 1.3054 | 1.3068 | 1.3039 | 1.305 | 6482840.0 |
| 2005-05-02 10:55:00 | AAPL | Stock | 1.305 | 1.3089 | 1.3039 | 1.3057 | 8935360.0 |
| 2005-05-02 11:00:00 | AAPL | Stock | 1.3057 | 1.3071 | 1.3054 | 1.3057 | 2001132.0 |
| 2005-05-02 11:05:00 | AAPL | Stock | 1.3057 | 1.3061 | 1.3032 | 1.3036 | 4930912.0 |
| 2005-05-02 11:10:00 | AAPL | Stock | 1.3033 | 1.3061 | 1.3032 | 1.3061 | 2558248.0 |
| 2005-05-02 11:15:00 | AAPL | Stock | 1.3061 | 1.3064 | 1.3011 | 1.3011 | 7963452.0 |
| 2005-05-02 11:20:00 | AAPL | Stock | 1.3011 | 1.3021 | 1.2996 | 1.3007 | 6843648.0 |
| 2005-05-02 11:25:00 | AAPL | Stock | 1.3007 | 1.3032 | 1.3004 | 1.3032 | 4104744.0 |
| 2005-05-02 11:30:00 | AAPL | Stock | 1.3029 | 1.3039 | 1.2996 | 1.3 | 3571372.0 |
| 2005-05-02 11:35:00 | AAPL | Stock | 1.3 | 1.3025 | 1.2996 | 1.3007 | 3050348.0 |
| 2005-05-02 11:40:00 | AAPL | Stock | 1.3007 | 1.3018 | 1.2996 | 1.3018 | 3357676.0 |
| 2005-05-02 11:45:00 | AAPL | Stock | 1.3018 | 1.3021 | 1.3004 | 1.3004 | 1537564.0 |
| 2005-05-02 11:50:00 | AAPL | Stock | 1.3004 | 1.3004 | 1.2979 | 1.2986 | 7685524.0 |
| 2005-05-02 11:55:00 | AAPL | Stock | 1.2986 | 1.3014 | 1.2982 | 1.3007 | 3429356.0 |
> showing 50 of 198,563 rows — these rows as CSV