PREVIEW / futures_30min / 2018-04-17
file: by_date/futures_30min/2018/2018-04-17.parquet size: 82 KB rows: 3,138
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 |
|---|---|---|---|---|---|---|---|
| 2018-04-17 00:00:00 | ES | Futures | 2935.94 | 2935.94 | 2935.13 | 2935.67 | 1249.0 |
| 2018-04-17 00:30:00 | ES | Futures | 2935.67 | 2939.22 | 2935.13 | 2939.22 | 3802.0 |
| 2018-04-17 01:00:00 | ES | Futures | 2939.22 | 2939.49 | 2936.76 | 2937.31 | 3054.0 |
| 2018-04-17 01:30:00 | ES | Futures | 2937.31 | 2940.04 | 2937.04 | 2939.77 | 3443.0 |
| 2018-04-17 02:00:00 | ES | Futures | 2939.77 | 2943.04 | 2938.95 | 2942.49 | 7860.0 |
| 2018-04-17 02:30:00 | ES | Futures | 2942.22 | 2942.77 | 2939.49 | 2940.31 | 5077.0 |
| 2018-04-17 03:00:00 | ES | Futures | 2940.04 | 2940.86 | 2935.67 | 2936.49 | 9548.0 |
| 2018-04-17 03:30:00 | ES | Futures | 2936.49 | 2940.58 | 2935.67 | 2939.49 | 5537.0 |
| 2018-04-17 04:00:00 | ES | Futures | 2939.49 | 2940.04 | 2935.4 | 2936.49 | 7300.0 |
| 2018-04-17 04:30:00 | ES | Futures | 2936.49 | 2940.86 | 2934.58 | 2940.31 | 7395.0 |
| 2018-04-17 05:00:00 | ES | Futures | 2940.58 | 2940.58 | 2938.4 | 2939.22 | 4092.0 |
| 2018-04-17 05:30:00 | ES | Futures | 2939.22 | 2940.86 | 2937.31 | 2940.04 | 6001.0 |
| 2018-04-17 06:00:00 | ES | Futures | 2940.04 | 2942.49 | 2939.77 | 2941.95 | 7056.0 |
| 2018-04-17 06:30:00 | ES | Futures | 2941.95 | 2943.31 | 2940.86 | 2942.49 | 9360.0 |
| 2018-04-17 07:00:00 | ES | Futures | 2942.49 | 2942.77 | 2940.31 | 2940.86 | 8851.0 |
| 2018-04-17 07:30:00 | ES | Futures | 2940.58 | 2942.77 | 2940.31 | 2942.49 | 12022.0 |
| 2018-04-17 08:00:00 | ES | Futures | 2942.49 | 2945.77 | 2941.95 | 2944.68 | 19667.0 |
| 2018-04-17 08:30:00 | ES | Futures | 2944.68 | 2945.77 | 2944.13 | 2944.13 | 13417.0 |
| 2018-04-17 09:00:00 | ES | Futures | 2944.13 | 2946.86 | 2944.13 | 2945.77 | 18172.0 |
| 2018-04-17 09:30:00 | ES | Futures | 2945.5 | 2946.59 | 2939.22 | 2945.77 | 119429.0 |
| 2018-04-17 10:00:00 | ES | Futures | 2945.77 | 2949.04 | 2944.4 | 2946.32 | 94411.0 |
| 2018-04-17 10:30:00 | ES | Futures | 2946.32 | 2953.41 | 2945.77 | 2952.32 | 83527.0 |
| 2018-04-17 11:00:00 | ES | Futures | 2952.59 | 2956.69 | 2952.59 | 2955.32 | 78210.0 |
| 2018-04-17 11:30:00 | ES | Futures | 2955.32 | 2955.59 | 2951.77 | 2953.14 | 52827.0 |
| 2018-04-17 12:00:00 | ES | Futures | 2953.41 | 2956.41 | 2953.14 | 2955.32 | 54698.0 |
| 2018-04-17 12:30:00 | ES | Futures | 2955.59 | 2955.87 | 2951.23 | 2953.14 | 38257.0 |
| 2018-04-17 13:00:00 | ES | Futures | 2953.14 | 2955.32 | 2948.77 | 2953.68 | 60067.0 |
| 2018-04-17 13:30:00 | ES | Futures | 2953.41 | 2955.05 | 2950.68 | 2954.23 | 31708.0 |
| 2018-04-17 14:00:00 | ES | Futures | 2954.23 | 2957.5 | 2949.32 | 2951.77 | 65178.0 |
| 2018-04-17 14:30:00 | ES | Futures | 2951.77 | 2955.87 | 2951.23 | 2954.23 | 47219.0 |
| 2018-04-17 15:00:00 | ES | Futures | 2954.23 | 2961.87 | 2953.14 | 2959.96 | 84200.0 |
| 2018-04-17 15:30:00 | ES | Futures | 2959.69 | 2962.42 | 2953.68 | 2954.5 | 150722.0 |
| 2018-04-17 16:00:00 | ES | Futures | 2954.5 | 2955.32 | 2953.41 | 2954.78 | 55637.0 |
| 2018-04-17 16:30:00 | ES | Futures | 2954.78 | 2956.14 | 2952.87 | 2953.41 | 6728.0 |
| 2018-04-17 18:00:00 | ES | Futures | 2952.32 | 2955.32 | 2951.5 | 2955.05 | 4220.0 |
| 2018-04-17 18:30:00 | ES | Futures | 2955.05 | 2955.05 | 2954.5 | 2955.05 | 1151.0 |
| 2018-04-17 19:00:00 | ES | Futures | 2954.78 | 2955.59 | 2954.5 | 2954.78 | 1031.0 |
| 2018-04-17 19:30:00 | ES | Futures | 2955.05 | 2956.69 | 2954.5 | 2955.05 | 1944.0 |
| 2018-04-17 20:00:00 | ES | Futures | 2955.32 | 2959.96 | 2955.05 | 2958.87 | 5075.0 |
| 2018-04-17 20:30:00 | ES | Futures | 2958.87 | 2961.6 | 2958.6 | 2960.23 | 3936.0 |
| 2018-04-17 21:00:00 | ES | Futures | 2960.23 | 2961.33 | 2959.96 | 2960.51 | 2054.0 |
| 2018-04-17 21:30:00 | ES | Futures | 2960.51 | 2960.78 | 2957.78 | 2958.87 | 3795.0 |
| 2018-04-17 22:00:00 | ES | Futures | 2958.87 | 2959.69 | 2958.05 | 2958.87 | 2063.0 |
| 2018-04-17 22:30:00 | ES | Futures | 2958.87 | 2959.41 | 2957.5 | 2958.87 | 2242.0 |
| 2018-04-17 23:00:00 | ES | Futures | 2958.6 | 2959.69 | 2958.05 | 2959.14 | 1302.0 |
| 2018-04-17 23:30:00 | ES | Futures | 2959.14 | 2960.78 | 2958.6 | 2960.51 | 1544.0 |
| 2018-04-17 00:00:00 | NQ | Futures | 7952.47 | 7953.95 | 7949.22 | 7953.66 | 448.0 |
| 2018-04-17 00:30:00 | NQ | Futures | 7953.36 | 7964.0 | 7950.7 | 7962.82 | 1115.0 |
| 2018-04-17 01:00:00 | NQ | Futures | 7962.82 | 7966.36 | 7957.5 | 7957.79 | 1489.0 |
| 2018-04-17 01:30:00 | NQ | Futures | 7957.5 | 7965.77 | 7956.32 | 7964.89 | 1153.0 |
> showing 50 of 3,138 rows — these rows as CSV