PREVIEW / futures_30min / 2018-07-02

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-02.parquet
  size:    88 KB
  rows:    3,151

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-07-02 00:00:00	ES	Futures	2962.25	2962.53	2958.17	2959.26	4663.0
2018-07-02 00:30:00	ES	Futures	2959.26	2961.44	2957.35	2960.07	3560.0
2018-07-02 01:00:00	ES	Futures	2960.35	2960.62	2954.35	2955.17	5083.0
2018-07-02 01:30:00	ES	Futures	2955.44	2955.44	2950.54	2951.35	7792.0
2018-07-02 02:00:00	ES	Futures	2951.35	2954.9	2949.45	2950.81	10182.0
2018-07-02 02:30:00	ES	Futures	2951.08	2951.9	2944.82	2949.72	11024.0
2018-07-02 03:00:00	ES	Futures	2949.99	2951.08	2941.55	2945.36	18470.0
2018-07-02 03:30:00	ES	Futures	2945.63	2949.72	2941.0	2945.91	17297.0
2018-07-02 04:00:00	ES	Futures	2945.91	2950.27	2945.36	2948.9	10181.0
2018-07-02 04:30:00	ES	Futures	2948.9	2953.53	2947.27	2952.17	9106.0
2018-07-02 05:00:00	ES	Futures	2952.44	2953.53	2949.45	2951.08	6391.0
2018-07-02 05:30:00	ES	Futures	2950.81	2952.17	2947.81	2950.54	7372.0
2018-07-02 06:00:00	ES	Futures	2950.27	2951.35	2945.36	2946.72	6278.0
2018-07-02 06:30:00	ES	Futures	2946.45	2952.17	2946.18	2951.08	9155.0
2018-07-02 07:00:00	ES	Futures	2951.08	2952.72	2949.18	2950.81	7356.0
2018-07-02 07:30:00	ES	Futures	2950.81	2952.99	2949.18	2951.9	7475.0
2018-07-02 08:00:00	ES	Futures	2951.63	2952.17	2949.18	2949.99	7841.0
2018-07-02 08:30:00	ES	Futures	2950.27	2950.54	2946.72	2948.09	14269.0
2018-07-02 09:00:00	ES	Futures	2947.81	2949.99	2944.27	2946.18	24182.0
2018-07-02 09:30:00	ES	Futures	2946.18	2952.44	2943.18	2952.17	130039.0
2018-07-02 10:00:00	ES	Futures	2952.44	2956.53	2947.0	2954.62	109415.0
2018-07-02 10:30:00	ES	Futures	2954.62	2960.07	2954.08	2957.62	81738.0
2018-07-02 11:00:00	ES	Futures	2957.62	2963.34	2954.08	2955.71	76944.0
2018-07-02 11:30:00	ES	Futures	2955.44	2955.71	2951.35	2953.53	48189.0
2018-07-02 12:00:00	ES	Futures	2953.53	2954.08	2948.09	2951.63	41793.0
2018-07-02 12:30:00	ES	Futures	2951.63	2955.44	2950.81	2952.99	29709.0
2018-07-02 13:00:00	ES	Futures	2952.99	2954.08	2947.0	2947.54	43116.0
2018-07-02 13:30:00	ES	Futures	2947.27	2958.98	2947.0	2957.62	43553.0
2018-07-02 14:00:00	ES	Futures	2957.35	2964.98	2957.08	2964.71	61234.0
2018-07-02 14:30:00	ES	Futures	2964.98	2966.61	2959.26	2960.07	48413.0
2018-07-02 15:00:00	ES	Futures	2959.8	2966.34	2958.17	2965.8	44528.0
2018-07-02 15:30:00	ES	Futures	2965.8	2973.7	2962.8	2972.33	127309.0
2018-07-02 16:00:00	ES	Futures	2972.33	2973.15	2970.43	2972.33	48827.0
2018-07-02 16:30:00	ES	Futures	2972.88	2973.15	2970.7	2971.79	7091.0
2018-07-02 18:00:00	ES	Futures	2972.33	2972.61	2970.43	2971.79	3152.0
2018-07-02 18:30:00	ES	Futures	2971.79	2971.79	2969.88	2970.7	925.0
2018-07-02 19:00:00	ES	Futures	2970.7	2970.97	2970.16	2970.16	373.0
2018-07-02 19:30:00	ES	Futures	2970.43	2972.33	2970.16	2972.33	1825.0
2018-07-02 20:00:00	ES	Futures	2972.33	2972.88	2971.24	2971.52	3137.0
2018-07-02 20:30:00	ES	Futures	2971.24	2972.06	2969.34	2970.43	2117.0
2018-07-02 21:00:00	ES	Futures	2970.7	2978.33	2970.16	2974.79	10509.0
2018-07-02 21:30:00	ES	Futures	2974.79	2975.06	2965.8	2967.98	15301.0
2018-07-02 22:00:00	ES	Futures	2967.7	2973.97	2966.61	2973.15	7138.0
2018-07-02 22:30:00	ES	Futures	2972.88	2973.42	2968.79	2969.07	3584.0
2018-07-02 23:00:00	ES	Futures	2969.34	2971.24	2964.98	2970.43	7451.0
2018-07-02 23:30:00	ES	Futures	2970.43	2970.97	2967.16	2970.7	3128.0
2018-07-02 00:00:00	NQ	Futures	8317.31	8318.49	8304.65	8307.6	1179.0
2018-07-02 00:30:00	NQ	Futures	8307.6	8311.72	8301.12	8306.42	1320.0
2018-07-02 01:00:00	NQ	Futures	8307.01	8307.6	8287.28	8293.17	2076.0
2018-07-02 01:30:00	NQ	Futures	8293.17	8294.35	8279.04	8279.33	2251.0

> showing 50 of 3,151 rows — these rows as CSV

> unlock the full archive -- $79 one-time