PREVIEW / stock_5min / 2005-01-28
file: by_date/stock_5min/2005/2005-01-28.parquet size: 2.6 MB rows: 187,179 symbols: 1,921
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-01-28 08:00:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2946 | 1.2973 | 137200.0 |
| 2005-01-28 08:20:00 | AAPL | Stock | 1.2975 | 1.2975 | 1.2975 | 1.2975 | 16800.0 |
| 2005-01-28 08:25:00 | AAPL | Stock | 1.2968 | 1.2973 | 1.2946 | 1.2973 | 213192.0 |
| 2005-01-28 08:30:00 | AAPL | Stock | 1.2946 | 1.2954 | 1.2946 | 1.2946 | 99064.0 |
| 2005-01-28 08:35:00 | AAPL | Stock | 1.2948 | 1.2948 | 1.2948 | 1.2948 | 24640.0 |
| 2005-01-28 08:40:00 | AAPL | Stock | 1.2963 | 1.2973 | 1.2963 | 1.2973 | 84000.0 |
| 2005-01-28 08:50:00 | AAPL | Stock | 1.2964 | 1.297 | 1.2964 | 1.297 | 28000.0 |
| 2005-01-28 09:00:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 38920.0 |
| 2005-01-28 09:05:00 | AAPL | Stock | 1.2955 | 1.2955 | 1.2955 | 1.2955 | 5600.0 |
| 2005-01-28 09:15:00 | AAPL | Stock | 1.2955 | 1.2964 | 1.2955 | 1.2964 | 246288.0 |
| 2005-01-28 09:20:00 | AAPL | Stock | 1.297 | 1.2973 | 1.2964 | 1.2964 | 37520.0 |
| 2005-01-28 09:25:00 | AAPL | Stock | 1.2964 | 1.3002 | 1.2946 | 1.2966 | 1677648.0 |
| 2005-01-28 09:30:00 | AAPL | Stock | 1.2968 | 1.2995 | 1.2936 | 1.2955 | 12664176.0 |
| 2005-01-28 09:35:00 | AAPL | Stock | 1.2955 | 1.3052 | 1.2936 | 1.3038 | 23371936.0 |
| 2005-01-28 09:40:00 | AAPL | Stock | 1.3041 | 1.3075 | 1.3023 | 1.305 | 18486944.0 |
| 2005-01-28 09:45:00 | AAPL | Stock | 1.3048 | 1.3089 | 1.3004 | 1.3089 | 22179640.0 |
| 2005-01-28 09:50:00 | AAPL | Stock | 1.3089 | 1.3105 | 1.3063 | 1.3098 | 18744936.0 |
| 2005-01-28 09:55:00 | AAPL | Stock | 1.3096 | 1.3114 | 1.3071 | 1.3079 | 16380000.0 |
| 2005-01-28 10:00:00 | AAPL | Stock | 1.308 | 1.3096 | 1.3023 | 1.3041 | 16195760.0 |
| 2005-01-28 10:05:00 | AAPL | Stock | 1.3041 | 1.3079 | 1.3023 | 1.3039 | 13231680.0 |
| 2005-01-28 10:10:00 | AAPL | Stock | 1.3038 | 1.3084 | 1.303 | 1.3064 | 10261160.0 |
| 2005-01-28 10:15:00 | AAPL | Stock | 1.3064 | 1.3086 | 1.3063 | 1.3084 | 5583816.0 |
| 2005-01-28 10:20:00 | AAPL | Stock | 1.3082 | 1.3095 | 1.3079 | 1.3089 | 7356272.0 |
| 2005-01-28 10:25:00 | AAPL | Stock | 1.3088 | 1.3111 | 1.3082 | 1.3089 | 9620800.0 |
| 2005-01-28 10:30:00 | AAPL | Stock | 1.3089 | 1.3098 | 1.3075 | 1.308 | 8387568.0 |
| 2005-01-28 10:35:00 | AAPL | Stock | 1.3084 | 1.3095 | 1.3077 | 1.3091 | 4556832.0 |
| 2005-01-28 10:40:00 | AAPL | Stock | 1.3091 | 1.3141 | 1.3091 | 1.3141 | 19548704.0 |
| 2005-01-28 10:45:00 | AAPL | Stock | 1.3141 | 1.3143 | 1.3086 | 1.3095 | 11156040.0 |
| 2005-01-28 10:50:00 | AAPL | Stock | 1.3095 | 1.3104 | 1.3063 | 1.3077 | 11635456.0 |
| 2005-01-28 10:55:00 | AAPL | Stock | 1.3077 | 1.3102 | 1.3046 | 1.3061 | 12561584.0 |
| 2005-01-28 11:00:00 | AAPL | Stock | 1.3057 | 1.3059 | 1.3025 | 1.3046 | 15675632.0 |
| 2005-01-28 11:05:00 | AAPL | Stock | 1.3045 | 1.3055 | 1.3005 | 1.3016 | 20805624.0 |
| 2005-01-28 11:10:00 | AAPL | Stock | 1.3014 | 1.3032 | 1.2995 | 1.3004 | 15664432.0 |
| 2005-01-28 11:15:00 | AAPL | Stock | 1.3016 | 1.3027 | 1.2979 | 1.298 | 17479504.0 |
| 2005-01-28 11:20:00 | AAPL | Stock | 1.298 | 1.3016 | 1.2955 | 1.3002 | 18776632.0 |
| 2005-01-28 11:25:00 | AAPL | Stock | 1.3002 | 1.3009 | 1.2973 | 1.2991 | 7564704.0 |
| 2005-01-28 11:30:00 | AAPL | Stock | 1.2991 | 1.3018 | 1.298 | 1.2996 | 9739520.0 |
| 2005-01-28 11:35:00 | AAPL | Stock | 1.2996 | 1.3018 | 1.2995 | 1.3007 | 4465664.0 |
| 2005-01-28 11:40:00 | AAPL | Stock | 1.3005 | 1.3016 | 1.3002 | 1.3014 | 5963832.0 |
| 2005-01-28 11:45:00 | AAPL | Stock | 1.3014 | 1.3036 | 1.3009 | 1.3027 | 11909688.0 |
| 2005-01-28 11:50:00 | AAPL | Stock | 1.3029 | 1.303 | 1.3007 | 1.3011 | 3154256.0 |
| 2005-01-28 11:55:00 | AAPL | Stock | 1.3011 | 1.3029 | 1.3005 | 1.3025 | 4123952.0 |
| 2005-01-28 12:00:00 | AAPL | Stock | 1.3025 | 1.3034 | 1.3013 | 1.3016 | 4625376.0 |
| 2005-01-28 12:05:00 | AAPL | Stock | 1.302 | 1.3036 | 1.3016 | 1.303 | 3624824.0 |
| 2005-01-28 12:10:00 | AAPL | Stock | 1.3029 | 1.3034 | 1.3011 | 1.3011 | 3147088.0 |
| 2005-01-28 12:15:00 | AAPL | Stock | 1.3016 | 1.302 | 1.3004 | 1.3014 | 2316776.0 |
| 2005-01-28 12:20:00 | AAPL | Stock | 1.3014 | 1.3014 | 1.2973 | 1.2973 | 6184416.0 |
| 2005-01-28 12:25:00 | AAPL | Stock | 1.2975 | 1.2995 | 1.2968 | 1.298 | 4450320.0 |
| 2005-01-28 12:30:00 | AAPL | Stock | 1.2979 | 1.3 | 1.2977 | 1.2996 | 3631880.0 |
| 2005-01-28 12:35:00 | AAPL | Stock | 1.2993 | 1.2996 | 1.2971 | 1.2991 | 3560648.0 |
> showing 50 of 187,179 rows — these rows as CSV