PREVIEW / stock_5min / 2005-04-25
file: by_date/stock_5min/2005/2005-04-25.parquet size: 2.6 MB rows: 193,257 symbols: 1,971
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-04-25 07:25:00 | AAPL | Stock | 1.2932 | 1.2932 | 1.2929 | 1.2929 | 11200.0 |
| 2005-04-25 07:50:00 | AAPL | Stock | 1.2964 | 1.2964 | 1.2964 | 1.2964 | 11200.0 |
| 2005-04-25 07:55:00 | AAPL | Stock | 1.2914 | 1.2914 | 1.2914 | 1.2914 | 19600.0 |
| 2005-04-25 08:00:00 | AAPL | Stock | 1.2914 | 1.3014 | 1.2914 | 1.2982 | 1493800.0 |
| 2005-04-25 08:05:00 | AAPL | Stock | 1.2986 | 1.3018 | 1.2964 | 1.2989 | 464520.0 |
| 2005-04-25 08:10:00 | AAPL | Stock | 1.2982 | 1.2982 | 1.2946 | 1.2946 | 556080.0 |
| 2005-04-25 08:15:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.2857 | 1.2914 | 405720.0 |
| 2005-04-25 08:20:00 | AAPL | Stock | 1.2918 | 1.2943 | 1.2911 | 1.2932 | 144200.0 |
| 2005-04-25 08:25:00 | AAPL | Stock | 1.2932 | 1.2943 | 1.2921 | 1.2943 | 358400.0 |
| 2005-04-25 08:30:00 | AAPL | Stock | 1.2936 | 1.2982 | 1.2929 | 1.2964 | 776720.0 |
| 2005-04-25 08:35:00 | AAPL | Stock | 1.2964 | 1.2971 | 1.2946 | 1.2946 | 141596.0 |
| 2005-04-25 08:40:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2932 | 1.2946 | 434420.0 |
| 2005-04-25 08:45:00 | AAPL | Stock | 1.2961 | 1.2961 | 1.2946 | 1.2946 | 207200.0 |
| 2005-04-25 08:50:00 | AAPL | Stock | 1.2946 | 1.2961 | 1.2936 | 1.295 | 201936.0 |
| 2005-04-25 08:55:00 | AAPL | Stock | 1.2954 | 1.2957 | 1.2929 | 1.2929 | 145040.0 |
| 2005-04-25 09:00:00 | AAPL | Stock | 1.2932 | 1.2975 | 1.2932 | 1.2964 | 340144.0 |
| 2005-04-25 09:05:00 | AAPL | Stock | 1.2957 | 1.3011 | 1.2957 | 1.3007 | 638120.0 |
| 2005-04-25 09:10:00 | AAPL | Stock | 1.3011 | 1.3029 | 1.3 | 1.3 | 1113532.0 |
| 2005-04-25 09:15:00 | AAPL | Stock | 1.2975 | 1.3004 | 1.2971 | 1.2993 | 182000.0 |
| 2005-04-25 09:20:00 | AAPL | Stock | 1.2989 | 1.2996 | 1.295 | 1.2964 | 374584.0 |
| 2005-04-25 09:25:00 | AAPL | Stock | 1.2918 | 1.3029 | 1.2918 | 1.3029 | 3316236.0 |
| 2005-04-25 09:30:00 | AAPL | Stock | 1.3032 | 1.3064 | 1.2946 | 1.3007 | 34138104.0 |
| 2005-04-25 09:35:00 | AAPL | Stock | 1.3 | 1.3018 | 1.2896 | 1.2918 | 20671364.0 |
| 2005-04-25 09:40:00 | AAPL | Stock | 1.2918 | 1.3007 | 1.2904 | 1.2968 | 20671196.0 |
| 2005-04-25 09:45:00 | AAPL | Stock | 1.2971 | 1.2971 | 1.29 | 1.2939 | 21402808.0 |
| 2005-04-25 09:50:00 | AAPL | Stock | 1.2946 | 1.2957 | 1.2896 | 1.2954 | 14591136.0 |
| 2005-04-25 09:55:00 | AAPL | Stock | 1.2957 | 1.3018 | 1.2943 | 1.2982 | 17550316.0 |
| 2005-04-25 10:00:00 | AAPL | Stock | 1.2982 | 1.3014 | 1.2968 | 1.2986 | 7631428.0 |
| 2005-04-25 10:05:00 | AAPL | Stock | 1.2989 | 1.3089 | 1.2982 | 1.3071 | 18967956.0 |
| 2005-04-25 10:10:00 | AAPL | Stock | 1.3071 | 1.3189 | 1.3071 | 1.3171 | 27782720.0 |
| 2005-04-25 10:15:00 | AAPL | Stock | 1.3175 | 1.3196 | 1.3157 | 1.3171 | 13305908.0 |
| 2005-04-25 10:20:00 | AAPL | Stock | 1.3171 | 1.3196 | 1.3143 | 1.3143 | 14545244.0 |
| 2005-04-25 10:25:00 | AAPL | Stock | 1.3146 | 1.3214 | 1.3121 | 1.3186 | 23135756.0 |
| 2005-04-25 10:30:00 | AAPL | Stock | 1.3189 | 1.3207 | 1.3168 | 1.3189 | 17594444.0 |
| 2005-04-25 10:35:00 | AAPL | Stock | 1.3193 | 1.3204 | 1.3157 | 1.3179 | 9697436.0 |
| 2005-04-25 10:40:00 | AAPL | Stock | 1.3182 | 1.3221 | 1.3175 | 1.3179 | 16895396.0 |
| 2005-04-25 10:45:00 | AAPL | Stock | 1.3182 | 1.3182 | 1.3132 | 1.3143 | 11311300.0 |
| 2005-04-25 10:50:00 | AAPL | Stock | 1.3143 | 1.3164 | 1.3111 | 1.3132 | 10977316.0 |
| 2005-04-25 10:55:00 | AAPL | Stock | 1.3136 | 1.3171 | 1.3132 | 1.315 | 7135632.0 |
| 2005-04-25 11:00:00 | AAPL | Stock | 1.3154 | 1.3182 | 1.315 | 1.3179 | 6484884.0 |
| 2005-04-25 11:05:00 | AAPL | Stock | 1.3175 | 1.3193 | 1.3129 | 1.3136 | 10282160.0 |
| 2005-04-25 11:10:00 | AAPL | Stock | 1.3136 | 1.3154 | 1.3129 | 1.3132 | 7421008.0 |
| 2005-04-25 11:15:00 | AAPL | Stock | 1.3139 | 1.3154 | 1.3111 | 1.3132 | 9947140.0 |
| 2005-04-25 11:20:00 | AAPL | Stock | 1.3136 | 1.3157 | 1.3132 | 1.3136 | 6666520.0 |
| 2005-04-25 11:25:00 | AAPL | Stock | 1.3136 | 1.3146 | 1.3125 | 1.3132 | 3227196.0 |
| 2005-04-25 11:30:00 | AAPL | Stock | 1.3129 | 1.3179 | 1.3125 | 1.3161 | 8474284.0 |
| 2005-04-25 11:35:00 | AAPL | Stock | 1.3164 | 1.3164 | 1.3118 | 1.3139 | 4822860.0 |
| 2005-04-25 11:40:00 | AAPL | Stock | 1.3136 | 1.315 | 1.3104 | 1.3118 | 8177792.0 |
| 2005-04-25 11:45:00 | AAPL | Stock | 1.3118 | 1.3189 | 1.3118 | 1.3136 | 6676404.0 |
| 2005-04-25 11:50:00 | AAPL | Stock | 1.3136 | 1.3143 | 1.3118 | 1.3136 | 3481576.0 |
> showing 50 of 193,257 rows — these rows as CSV