PREVIEW / stock_5min / 2007-06-15
file: by_date/stock_5min/2007/2007-06-15.parquet size: 4.0 MB rows: 295,340 symbols: 3,022
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-15 09:30:00 | AAPL | Stock | 4.3079 | 4.3096 | 4.29 | 4.2943 | 31314668.0 |
| 2007-06-15 09:35:00 | AAPL | Stock | 4.295 | 4.3079 | 4.2943 | 4.2971 | 23037952.0 |
| 2007-06-15 09:40:00 | AAPL | Stock | 4.2979 | 4.2989 | 4.2839 | 4.2871 | 28716772.0 |
| 2007-06-15 09:45:00 | AAPL | Stock | 4.2871 | 4.2979 | 4.2832 | 4.2918 | 21204148.0 |
| 2007-06-15 09:50:00 | AAPL | Stock | 4.2914 | 4.2921 | 4.2807 | 4.2882 | 17374700.0 |
| 2007-06-15 09:55:00 | AAPL | Stock | 4.2886 | 4.2946 | 4.2875 | 4.2921 | 12036696.0 |
| 2007-06-15 10:00:00 | AAPL | Stock | 4.2921 | 4.2964 | 4.2882 | 4.2925 | 13835584.0 |
| 2007-06-15 10:05:00 | AAPL | Stock | 4.2921 | 4.2921 | 4.285 | 4.2893 | 11402020.0 |
| 2007-06-15 10:10:00 | AAPL | Stock | 4.2893 | 4.3011 | 4.2893 | 4.2986 | 17464496.0 |
| 2007-06-15 10:15:00 | AAPL | Stock | 4.2982 | 4.2993 | 4.2943 | 4.2954 | 8841672.0 |
| 2007-06-15 10:20:00 | AAPL | Stock | 4.295 | 4.3011 | 4.2929 | 4.2957 | 11468856.0 |
| 2007-06-15 10:25:00 | AAPL | Stock | 4.2957 | 4.2996 | 4.2946 | 4.295 | 7409444.0 |
| 2007-06-15 10:30:00 | AAPL | Stock | 4.2954 | 4.3014 | 4.2954 | 4.2993 | 8650040.0 |
| 2007-06-15 10:35:00 | AAPL | Stock | 4.2996 | 4.2996 | 4.2946 | 4.2957 | 8310764.0 |
| 2007-06-15 10:40:00 | AAPL | Stock | 4.2957 | 4.2979 | 4.2929 | 4.2929 | 8604624.0 |
| 2007-06-15 10:45:00 | AAPL | Stock | 4.2929 | 4.2957 | 4.2889 | 4.2904 | 9057356.0 |
| 2007-06-15 10:50:00 | AAPL | Stock | 4.2911 | 4.2932 | 4.2889 | 4.2909 | 8153432.0 |
| 2007-06-15 10:55:00 | AAPL | Stock | 4.2907 | 4.2925 | 4.2882 | 4.2897 | 5865972.0 |
| 2007-06-15 11:00:00 | AAPL | Stock | 4.29 | 4.2954 | 4.2897 | 4.2946 | 5812632.0 |
| 2007-06-15 11:05:00 | AAPL | Stock | 4.2939 | 4.2943 | 4.2911 | 4.2939 | 3457636.0 |
| 2007-06-15 11:10:00 | AAPL | Stock | 4.2939 | 4.2951 | 4.2921 | 4.295 | 4254936.0 |
| 2007-06-15 11:15:00 | AAPL | Stock | 4.2954 | 4.2964 | 4.2918 | 4.2925 | 3988740.0 |
| 2007-06-15 11:20:00 | AAPL | Stock | 4.2918 | 4.2932 | 4.2911 | 4.2914 | 3300136.0 |
| 2007-06-15 11:25:00 | AAPL | Stock | 4.2914 | 4.2929 | 4.2879 | 4.2904 | 7144648.0 |
| 2007-06-15 11:30:00 | AAPL | Stock | 4.2904 | 4.2929 | 4.29 | 4.2917 | 6716472.0 |
| 2007-06-15 11:35:00 | AAPL | Stock | 4.2914 | 4.2946 | 4.2911 | 4.2943 | 5614224.0 |
| 2007-06-15 11:40:00 | AAPL | Stock | 4.2939 | 4.295 | 4.2929 | 4.2943 | 3779048.0 |
| 2007-06-15 11:45:00 | AAPL | Stock | 4.2946 | 4.3 | 4.2936 | 4.2996 | 9982224.0 |
| 2007-06-15 11:50:00 | AAPL | Stock | 4.2996 | 4.3011 | 4.2961 | 4.2961 | 7109088.0 |
| 2007-06-15 11:55:00 | AAPL | Stock | 4.2961 | 4.2975 | 4.2954 | 4.2971 | 3236044.0 |
| 2007-06-15 12:00:00 | AAPL | Stock | 4.2975 | 4.3 | 4.2954 | 4.2971 | 5314792.0 |
| 2007-06-15 12:05:00 | AAPL | Stock | 4.2971 | 4.2979 | 4.2954 | 4.2975 | 3528812.0 |
| 2007-06-15 12:10:00 | AAPL | Stock | 4.2971 | 4.2975 | 4.2929 | 4.2932 | 6463940.0 |
| 2007-06-15 12:15:00 | AAPL | Stock | 4.2936 | 4.2961 | 4.2936 | 4.2957 | 5678344.0 |
| 2007-06-15 12:20:00 | AAPL | Stock | 4.2957 | 4.2979 | 4.2954 | 4.2975 | 2991184.0 |
| 2007-06-15 12:25:00 | AAPL | Stock | 4.2973 | 4.2982 | 4.2957 | 4.2957 | 3881976.0 |
| 2007-06-15 12:30:00 | AAPL | Stock | 4.296 | 4.2996 | 4.296 | 4.2992 | 4349492.0 |
| 2007-06-15 12:35:00 | AAPL | Stock | 4.2993 | 4.2993 | 4.2961 | 4.2982 | 3788848.0 |
| 2007-06-15 12:40:00 | AAPL | Stock | 4.2982 | 4.3011 | 4.2968 | 4.2989 | 7336392.0 |
| 2007-06-15 12:45:00 | AAPL | Stock | 4.2986 | 4.2993 | 4.2907 | 4.2919 | 10140060.0 |
| 2007-06-15 12:50:00 | AAPL | Stock | 4.2921 | 4.2943 | 4.2911 | 4.2929 | 5457172.0 |
| 2007-06-15 12:55:00 | AAPL | Stock | 4.2929 | 4.2971 | 4.2914 | 4.2968 | 3967180.0 |
| 2007-06-15 13:00:00 | AAPL | Stock | 4.2971 | 4.2975 | 4.2921 | 4.2936 | 3830792.0 |
| 2007-06-15 13:05:00 | AAPL | Stock | 4.2936 | 4.2971 | 4.2911 | 4.2914 | 4049752.0 |
| 2007-06-15 13:10:00 | AAPL | Stock | 4.2911 | 4.2936 | 4.2907 | 4.2929 | 3726324.0 |
| 2007-06-15 13:15:00 | AAPL | Stock | 4.2929 | 4.2943 | 4.2911 | 4.2911 | 3094700.0 |
| 2007-06-15 13:20:00 | AAPL | Stock | 4.2911 | 4.2943 | 4.29 | 4.2914 | 6329232.0 |
| 2007-06-15 13:25:00 | AAPL | Stock | 4.2914 | 4.2943 | 4.2904 | 4.2929 | 6312068.0 |
| 2007-06-15 13:30:00 | AAPL | Stock | 4.2925 | 4.2939 | 4.2911 | 4.2911 | 4319448.0 |
| 2007-06-15 13:35:00 | AAPL | Stock | 4.2911 | 4.2936 | 4.2911 | 4.2936 | 2327528.0 |
> showing 50 of 295,340 rows — these rows as CSV