PREVIEW / stock_5min / 2003-06-09
file: by_date/stock_5min/2003/2003-06-09.parquet size: 2.1 MB rows: 150,461 symbols: 1,585
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 |
|---|---|---|---|---|---|---|---|
| 2003-06-09 08:00:00 | AAPL | Stock | 0.3059 | 0.3059 | 0.3044 | 0.3044 | 89600.0 |
| 2003-06-09 08:05:00 | AAPL | Stock | 0.3059 | 0.3059 | 0.3059 | 0.3059 | 56000.0 |
| 2003-06-09 08:15:00 | AAPL | Stock | 0.3061 | 0.3061 | 0.3054 | 0.3054 | 61600.0 |
| 2003-06-09 08:25:00 | AAPL | Stock | 0.3059 | 0.3059 | 0.3059 | 0.3059 | 5600.0 |
| 2003-06-09 08:35:00 | AAPL | Stock | 0.3038 | 0.3038 | 0.3038 | 0.3038 | 11200.0 |
| 2003-06-09 08:50:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 50400.0 |
| 2003-06-09 09:00:00 | AAPL | Stock | 0.3036 | 0.3036 | 0.3036 | 0.3036 | 58800.0 |
| 2003-06-09 09:10:00 | AAPL | Stock | 0.3043 | 0.3043 | 0.3036 | 0.3036 | 84000.0 |
| 2003-06-09 09:15:00 | AAPL | Stock | 0.3038 | 0.3038 | 0.3034 | 0.3034 | 49504.0 |
| 2003-06-09 09:25:00 | AAPL | Stock | 0.3043 | 0.3043 | 0.3 | 0.3014 | 1923600.0 |
| 2003-06-09 09:30:00 | AAPL | Stock | 0.3025 | 0.3036 | 0.2991 | 0.3021 | 14532056.0 |
| 2003-06-09 09:35:00 | AAPL | Stock | 0.3021 | 0.3023 | 0.298 | 0.2982 | 5642560.0 |
| 2003-06-09 09:40:00 | AAPL | Stock | 0.298 | 0.3018 | 0.2973 | 0.3018 | 8877904.0 |
| 2003-06-09 09:45:00 | AAPL | Stock | 0.3016 | 0.3043 | 0.3016 | 0.3029 | 7393120.0 |
| 2003-06-09 09:50:00 | AAPL | Stock | 0.303 | 0.3032 | 0.3004 | 0.3013 | 7335944.0 |
| 2003-06-09 09:55:00 | AAPL | Stock | 0.3011 | 0.3017 | 0.2998 | 0.3009 | 3617600.0 |
| 2003-06-09 10:00:00 | AAPL | Stock | 0.3005 | 0.3021 | 0.2995 | 0.2995 | 5462800.0 |
| 2003-06-09 10:05:00 | AAPL | Stock | 0.2995 | 0.301 | 0.2992 | 0.3005 | 2045680.0 |
| 2003-06-09 10:10:00 | AAPL | Stock | 0.3007 | 0.3013 | 0.2993 | 0.2993 | 3060400.0 |
| 2003-06-09 10:15:00 | AAPL | Stock | 0.2995 | 0.3001 | 0.2988 | 0.2988 | 3576608.0 |
| 2003-06-09 10:20:00 | AAPL | Stock | 0.2988 | 0.2993 | 0.2984 | 0.2991 | 3404800.0 |
| 2003-06-09 10:25:00 | AAPL | Stock | 0.2991 | 0.3013 | 0.2991 | 0.2993 | 3819760.0 |
| 2003-06-09 10:30:00 | AAPL | Stock | 0.2993 | 0.2996 | 0.2984 | 0.2984 | 2990400.0 |
| 2003-06-09 10:35:00 | AAPL | Stock | 0.2986 | 0.2988 | 0.297 | 0.2977 | 4155200.0 |
| 2003-06-09 10:40:00 | AAPL | Stock | 0.2977 | 0.2979 | 0.297 | 0.2979 | 1744400.0 |
| 2003-06-09 10:45:00 | AAPL | Stock | 0.2979 | 0.2979 | 0.2973 | 0.2977 | 2522800.0 |
| 2003-06-09 10:50:00 | AAPL | Stock | 0.2977 | 0.2981 | 0.2973 | 0.298 | 2884000.0 |
| 2003-06-09 10:55:00 | AAPL | Stock | 0.2979 | 0.2982 | 0.2973 | 0.2973 | 5515328.0 |
| 2003-06-09 11:00:00 | AAPL | Stock | 0.2977 | 0.298 | 0.297 | 0.297 | 4328800.0 |
| 2003-06-09 11:05:00 | AAPL | Stock | 0.2977 | 0.298 | 0.2975 | 0.2979 | 4695880.0 |
| 2003-06-09 11:10:00 | AAPL | Stock | 0.2979 | 0.2988 | 0.2973 | 0.2979 | 6880048.0 |
| 2003-06-09 11:15:00 | AAPL | Stock | 0.2979 | 0.298 | 0.2975 | 0.2977 | 1766688.0 |
| 2003-06-09 11:20:00 | AAPL | Stock | 0.2975 | 0.2988 | 0.2971 | 0.2979 | 2464112.0 |
| 2003-06-09 11:25:00 | AAPL | Stock | 0.2979 | 0.2983 | 0.2977 | 0.2982 | 5041400.0 |
| 2003-06-09 11:30:00 | AAPL | Stock | 0.2982 | 0.2994 | 0.298 | 0.2986 | 7131600.0 |
| 2003-06-09 11:35:00 | AAPL | Stock | 0.2986 | 0.3 | 0.2982 | 0.2998 | 2262400.0 |
| 2003-06-09 11:40:00 | AAPL | Stock | 0.3 | 0.3 | 0.298 | 0.2984 | 1975400.0 |
| 2003-06-09 11:45:00 | AAPL | Stock | 0.2982 | 0.2989 | 0.2982 | 0.2988 | 1028440.0 |
| 2003-06-09 11:50:00 | AAPL | Stock | 0.2988 | 0.2996 | 0.2988 | 0.2996 | 478240.0 |
| 2003-06-09 11:55:00 | AAPL | Stock | 0.2995 | 0.2998 | 0.2995 | 0.2996 | 912800.0 |
| 2003-06-09 12:00:00 | AAPL | Stock | 0.2996 | 0.3007 | 0.2995 | 0.3004 | 1741600.0 |
| 2003-06-09 12:05:00 | AAPL | Stock | 0.3007 | 0.3011 | 0.2996 | 0.3005 | 1338400.0 |
| 2003-06-09 12:10:00 | AAPL | Stock | 0.3005 | 0.3011 | 0.3004 | 0.3006 | 1912400.0 |
| 2003-06-09 12:15:00 | AAPL | Stock | 0.3004 | 0.3009 | 0.2996 | 0.3004 | 1915368.0 |
| 2003-06-09 12:20:00 | AAPL | Stock | 0.3002 | 0.3007 | 0.2991 | 0.2998 | 1847888.0 |
| 2003-06-09 12:25:00 | AAPL | Stock | 0.2996 | 0.3002 | 0.2993 | 0.3002 | 722512.0 |
| 2003-06-09 12:30:00 | AAPL | Stock | 0.3 | 0.3016 | 0.3 | 0.3013 | 2172800.0 |
| 2003-06-09 12:35:00 | AAPL | Stock | 0.3013 | 0.3014 | 0.2998 | 0.3004 | 1366680.0 |
| 2003-06-09 12:40:00 | AAPL | Stock | 0.3004 | 0.3004 | 0.2993 | 0.3 | 1800848.0 |
| 2003-06-09 12:45:00 | AAPL | Stock | 0.3 | 0.3004 | 0.3 | 0.3 | 2744000.0 |
> showing 50 of 150,461 rows — these rows as CSV