PREVIEW / stock_5min / 2005-05-03
file: by_date/stock_5min/2005/2005-05-03.parquet size: 2.7 MB rows: 197,056 symbols: 1,963
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-03 08:10:00 | AAPL | Stock | 1.2946 | 1.2946 | 1.2932 | 1.2932 | 16800.0 |
| 2005-05-03 08:15:00 | AAPL | Stock | 1.2932 | 1.2932 | 1.2929 | 1.2929 | 45444.0 |
| 2005-05-03 08:20:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.2925 | 1.2925 | 14000.0 |
| 2005-05-03 08:25:00 | AAPL | Stock | 1.2925 | 1.3011 | 1.2925 | 1.3011 | 401996.0 |
| 2005-05-03 08:30:00 | AAPL | Stock | 1.2925 | 1.2925 | 1.2925 | 1.2925 | 63812.0 |
| 2005-05-03 08:35:00 | AAPL | Stock | 1.2925 | 1.2975 | 1.2925 | 1.2975 | 105000.0 |
| 2005-05-03 08:40:00 | AAPL | Stock | 1.2982 | 1.2986 | 1.2957 | 1.2986 | 64260.0 |
| 2005-05-03 08:45:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 56000.0 |
| 2005-05-03 08:50:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 14000.0 |
| 2005-05-03 09:10:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 63980.0 |
| 2005-05-03 09:15:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.2957 | 1.2957 | 5600.0 |
| 2005-05-03 09:20:00 | AAPL | Stock | 1.2971 | 1.2979 | 1.2971 | 1.2979 | 11200.0 |
| 2005-05-03 09:25:00 | AAPL | Stock | 1.2982 | 1.3007 | 1.2964 | 1.3 | 266980.0 |
| 2005-05-03 09:30:00 | AAPL | Stock | 1.3 | 1.3014 | 1.2946 | 1.2968 | 9920484.0 |
| 2005-05-03 09:35:00 | AAPL | Stock | 1.2964 | 1.3039 | 1.2929 | 1.3025 | 9573676.0 |
| 2005-05-03 09:40:00 | AAPL | Stock | 1.3025 | 1.3025 | 1.2957 | 1.2993 | 7114380.0 |
| 2005-05-03 09:45:00 | AAPL | Stock | 1.2989 | 1.2993 | 1.2957 | 1.2986 | 6490988.0 |
| 2005-05-03 09:50:00 | AAPL | Stock | 1.2986 | 1.2993 | 1.2971 | 1.2989 | 3875648.0 |
| 2005-05-03 09:55:00 | AAPL | Stock | 1.2993 | 1.3029 | 1.2982 | 1.2993 | 7315784.0 |
| 2005-05-03 10:00:00 | AAPL | Stock | 1.2993 | 1.3007 | 1.2982 | 1.3 | 3895724.0 |
| 2005-05-03 10:05:00 | AAPL | Stock | 1.3 | 1.3011 | 1.2982 | 1.3004 | 5625984.0 |
| 2005-05-03 10:10:00 | AAPL | Stock | 1.3004 | 1.3021 | 1.2993 | 1.3018 | 4061792.0 |
| 2005-05-03 10:15:00 | AAPL | Stock | 1.3018 | 1.3018 | 1.2996 | 1.2996 | 3872120.0 |
| 2005-05-03 10:20:00 | AAPL | Stock | 1.3 | 1.3007 | 1.2971 | 1.2982 | 7320376.0 |
| 2005-05-03 10:25:00 | AAPL | Stock | 1.2982 | 1.3011 | 1.2975 | 1.3 | 13397188.0 |
| 2005-05-03 10:30:00 | AAPL | Stock | 1.3 | 1.3011 | 1.2996 | 1.3 | 3452120.0 |
| 2005-05-03 10:35:00 | AAPL | Stock | 1.2996 | 1.3004 | 1.2993 | 1.2996 | 5772592.0 |
| 2005-05-03 10:40:00 | AAPL | Stock | 1.2996 | 1.3 | 1.2986 | 1.2996 | 12873056.0 |
| 2005-05-03 10:45:00 | AAPL | Stock | 1.2996 | 1.3018 | 1.2993 | 1.3011 | 5593168.0 |
| 2005-05-03 10:50:00 | AAPL | Stock | 1.3014 | 1.3014 | 1.2996 | 1.3 | 2549792.0 |
| 2005-05-03 10:55:00 | AAPL | Stock | 1.3 | 1.3007 | 1.2986 | 1.3004 | 3997756.0 |
| 2005-05-03 11:00:00 | AAPL | Stock | 1.3004 | 1.3004 | 1.2982 | 1.2989 | 6274268.0 |
| 2005-05-03 11:05:00 | AAPL | Stock | 1.2986 | 1.2996 | 1.2986 | 1.2996 | 2327528.0 |
| 2005-05-03 11:10:00 | AAPL | Stock | 1.2996 | 1.2996 | 1.2979 | 1.2982 | 9476460.0 |
| 2005-05-03 11:15:00 | AAPL | Stock | 1.2982 | 1.2989 | 1.2968 | 1.2989 | 6038648.0 |
| 2005-05-03 11:20:00 | AAPL | Stock | 1.2986 | 1.3 | 1.2982 | 1.3 | 4436320.0 |
| 2005-05-03 11:25:00 | AAPL | Stock | 1.3 | 1.3014 | 1.2993 | 1.301 | 2728544.0 |
| 2005-05-03 11:30:00 | AAPL | Stock | 1.301 | 1.3011 | 1.2996 | 1.3 | 1536976.0 |
| 2005-05-03 11:35:00 | AAPL | Stock | 1.3 | 1.3004 | 1.2993 | 1.3004 | 872620.0 |
| 2005-05-03 11:40:00 | AAPL | Stock | 1.3 | 1.3004 | 1.2989 | 1.2989 | 1473164.0 |
| 2005-05-03 11:45:00 | AAPL | Stock | 1.2993 | 1.2996 | 1.2976 | 1.2986 | 2000068.0 |
| 2005-05-03 11:50:00 | AAPL | Stock | 1.2982 | 1.3004 | 1.2979 | 1.2996 | 2678340.0 |
| 2005-05-03 11:55:00 | AAPL | Stock | 1.3 | 1.3 | 1.2979 | 1.2982 | 3126508.0 |
| 2005-05-03 12:00:00 | AAPL | Stock | 1.2982 | 1.2996 | 1.2979 | 1.2982 | 2620128.0 |
| 2005-05-03 12:05:00 | AAPL | Stock | 1.2982 | 1.2986 | 1.2946 | 1.2951 | 3683372.0 |
| 2005-05-03 12:10:00 | AAPL | Stock | 1.295 | 1.2971 | 1.2943 | 1.2957 | 2965116.0 |
| 2005-05-03 12:15:00 | AAPL | Stock | 1.2957 | 1.2957 | 1.295 | 1.295 | 1020572.0 |
| 2005-05-03 12:20:00 | AAPL | Stock | 1.295 | 1.295 | 1.2936 | 1.2936 | 3198132.0 |
| 2005-05-03 12:25:00 | AAPL | Stock | 1.2939 | 1.2943 | 1.2929 | 1.2939 | 2848412.0 |
| 2005-05-03 12:30:00 | AAPL | Stock | 1.2939 | 1.295 | 1.2939 | 1.2946 | 2015468.0 |
> showing 50 of 197,056 rows — these rows as CSV