PREVIEW / futures_1hour / 2018-06-26

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-26.parquet
  size:    53 KB
  rows:    1,665

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-06-26 00:00:00	ES	Futures	2969.88	2970.43	2967.43	2968.79	3900.0
2018-06-26 01:00:00	ES	Futures	2968.52	2971.52	2967.98	2971.24	6842.0
2018-06-26 02:00:00	ES	Futures	2970.97	2973.7	2970.43	2973.42	13160.0
2018-06-26 03:00:00	ES	Futures	2973.7	2973.7	2961.98	2964.16	30306.0
2018-06-26 04:00:00	ES	Futures	2963.89	2968.52	2963.34	2966.61	13877.0
2018-06-26 05:00:00	ES	Futures	2966.61	2969.61	2963.62	2965.25	16153.0
2018-06-26 06:00:00	ES	Futures	2965.25	2965.8	2958.71	2963.89	23801.0
2018-06-26 07:00:00	ES	Futures	2963.89	2964.71	2960.62	2963.07	12880.0
2018-06-26 08:00:00	ES	Futures	2963.07	2969.88	2962.53	2969.07	32383.0
2018-06-26 09:00:00	ES	Futures	2968.79	2973.15	2962.53	2969.61	198624.0
2018-06-26 10:00:00	ES	Futures	2969.88	2975.88	2961.44	2967.16	248472.0
2018-06-26 11:00:00	ES	Futures	2967.16	2971.79	2965.8	2971.24	130164.0
2018-06-26 12:00:00	ES	Futures	2971.24	2976.97	2970.97	2975.06	145734.0
2018-06-26 13:00:00	ES	Futures	2975.33	2981.05	2974.24	2978.87	97674.0
2018-06-26 14:00:00	ES	Futures	2978.87	2980.51	2975.88	2977.24	74617.0
2018-06-26 15:00:00	ES	Futures	2977.24	2978.33	2967.98	2969.61	200967.0
2018-06-26 16:00:00	ES	Futures	2969.61	2974.24	2968.52	2969.07	58206.0
2018-06-26 18:00:00	ES	Futures	2971.52	2973.7	2971.24	2972.33	5282.0
2018-06-26 19:00:00	ES	Futures	2972.33	2974.24	2971.52	2974.24	2090.0
2018-06-26 20:00:00	ES	Futures	2974.24	2978.06	2973.15	2975.6	10529.0
2018-06-26 21:00:00	ES	Futures	2975.6	2977.51	2969.88	2970.16	11401.0
2018-06-26 22:00:00	ES	Futures	2970.16	2973.42	2969.07	2969.61	7467.0
2018-06-26 23:00:00	ES	Futures	2969.88	2972.88	2969.34	2972.33	4674.0
2018-06-26 00:00:00	NQ	Futures	8327.03	8328.21	8318.49	8321.14	1751.0
2018-06-26 01:00:00	NQ	Futures	8321.43	8336.74	8319.08	8331.74	2733.0
2018-06-26 02:00:00	NQ	Futures	8331.44	8344.4	8329.97	8343.52	3320.0
2018-06-26 03:00:00	NQ	Futures	8343.52	8346.75	8311.72	8314.96	8298.0
2018-06-26 04:00:00	NQ	Futures	8315.55	8339.1	8312.9	8334.39	6225.0
2018-06-26 05:00:00	NQ	Futures	8334.68	8345.87	8326.73	8334.09	4982.0
2018-06-26 06:00:00	NQ	Futures	8334.39	8343.81	8315.84	8342.34	7796.0
2018-06-26 07:00:00	NQ	Futures	8342.04	8343.81	8325.26	8333.8	4737.0
2018-06-26 08:00:00	NQ	Futures	8333.8	8353.53	8332.92	8345.28	9543.0
2018-06-26 09:00:00	NQ	Futures	8345.28	8372.37	8315.84	8359.41	74558.0
2018-06-26 10:00:00	NQ	Futures	8359.71	8376.2	8314.07	8334.98	73712.0
2018-06-26 11:00:00	NQ	Futures	8334.98	8352.94	8326.73	8347.93	37958.0
2018-06-26 12:00:00	NQ	Futures	8347.93	8378.55	8346.17	8373.55	39575.0
2018-06-26 13:00:00	NQ	Futures	8373.84	8396.81	8370.01	8383.85	29427.0
2018-06-26 14:00:00	NQ	Futures	8383.56	8387.09	8365.01	8369.13	20852.0
2018-06-26 15:00:00	NQ	Futures	8369.42	8372.07	8339.69	8349.7	42053.0
2018-06-26 16:00:00	NQ	Futures	8349.7	8367.36	8348.82	8352.94	8589.0
2018-06-26 18:00:00	NQ	Futures	8359.41	8366.19	8353.82	8357.35	1552.0
2018-06-26 19:00:00	NQ	Futures	8357.35	8367.07	8357.06	8366.78	913.0
2018-06-26 20:00:00	NQ	Futures	8367.07	8384.44	8364.42	8375.9	3614.0
2018-06-26 21:00:00	NQ	Futures	8376.2	8381.79	8352.64	8352.64	3905.0
2018-06-26 22:00:00	NQ	Futures	8353.23	8362.95	8347.93	8349.7	2077.0
2018-06-26 23:00:00	NQ	Futures	8348.82	8358.83	8346.17	8357.94	1620.0
2018-06-26 00:00:00	YM	Futures	26426.2	26432.7	26400.1	26411.0	1257.0
2018-06-26 01:00:00	YM	Futures	26412.0	26455.5	26404.4	26451.2	2783.0
2018-06-26 02:00:00	YM	Futures	26450.1	26478.4	26440.3	26478.4	3397.0
2018-06-26 03:00:00	YM	Futures	26477.3	26477.3	26364.2	26384.9	5780.0

> showing 50 of 1,665 rows — these rows as CSV

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