PREVIEW / futures_1hour / 2018-06-01

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-06-01.parquet
  size:    47 KB
  rows:    1,406

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-01 00:00:00	ES	Futures	2956.41	2958.05	2955.05	2956.96	6038.0
2018-06-01 01:00:00	ES	Futures	2956.69	2958.6	2955.32	2956.41	5434.0
2018-06-01 02:00:00	ES	Futures	2956.69	2967.6	2956.41	2965.96	18568.0
2018-06-01 03:00:00	ES	Futures	2966.24	2967.06	2961.6	2963.78	18044.0
2018-06-01 04:00:00	ES	Futures	2963.51	2965.15	2962.69	2963.51	7634.0
2018-06-01 05:00:00	ES	Futures	2963.24	2968.69	2962.96	2967.33	15052.0
2018-06-01 06:00:00	ES	Futures	2967.33	2967.88	2965.15	2967.06	10350.0
2018-06-01 07:00:00	ES	Futures	2967.33	2968.97	2965.96	2967.33	18399.0
2018-06-01 08:00:00	ES	Futures	2967.33	2971.42	2963.51	2971.42	53901.0
2018-06-01 09:00:00	ES	Futures	2971.42	2977.97	2969.79	2976.34	143592.0
2018-06-01 10:00:00	ES	Futures	2976.61	2983.98	2970.88	2980.16	261505.0
2018-06-01 11:00:00	ES	Futures	2980.16	2982.61	2977.15	2981.79	105898.0
2018-06-01 12:00:00	ES	Futures	2981.79	2985.34	2981.25	2984.25	89394.0
2018-06-01 13:00:00	ES	Futures	2984.25	2987.8	2983.98	2984.52	59062.0
2018-06-01 14:00:00	ES	Futures	2984.52	2985.61	2980.43	2984.25	80747.0
2018-06-01 15:00:00	ES	Futures	2984.25	2984.52	2978.52	2984.52	160324.0
2018-06-01 16:00:00	ES	Futures	2984.52	2985.61	2982.34	2985.34	61142.0
2018-06-01 00:00:00	NQ	Futures	8255.69	8262.49	8250.08	8259.53	1153.0
2018-06-01 01:00:00	NQ	Futures	8259.24	8264.85	8254.21	8258.94	1464.0
2018-06-01 02:00:00	NQ	Futures	8259.24	8284.06	8258.65	8278.45	4318.0
2018-06-01 03:00:00	NQ	Futures	8278.74	8281.99	8264.26	8270.47	4600.0
2018-06-01 04:00:00	NQ	Futures	8270.76	8274.6	8267.81	8271.65	1862.0
2018-06-01 05:00:00	NQ	Futures	8271.35	8282.58	8270.47	8275.2	3319.0
2018-06-01 06:00:00	NQ	Futures	8274.9	8277.86	8269.88	8276.38	2276.0
2018-06-01 07:00:00	NQ	Futures	8276.38	8286.13	8273.72	8281.99	4653.0
2018-06-01 08:00:00	NQ	Futures	8282.29	8292.34	8266.63	8291.15	13492.0
2018-06-01 09:00:00	NQ	Futures	8290.86	8320.12	8284.95	8314.21	44751.0
2018-06-01 10:00:00	NQ	Futures	8315.09	8360.9	8298.84	8353.51	83138.0
2018-06-01 11:00:00	NQ	Futures	8353.51	8373.61	8352.33	8367.99	37220.0
2018-06-01 12:00:00	NQ	Futures	8368.29	8376.27	8365.33	8368.58	20909.0
2018-06-01 13:00:00	NQ	Futures	8369.47	8381.88	8367.99	8374.79	20294.0
2018-06-01 14:00:00	NQ	Futures	8374.79	8378.34	8360.6	8369.77	23782.0
2018-06-01 15:00:00	NQ	Futures	8369.47	8377.75	8354.1	8377.45	32336.0
2018-06-01 16:00:00	NQ	Futures	8377.45	8378.04	8370.65	8376.27	8548.0
2018-06-01 00:00:00	YM	Futures	26542.4	26554.4	26530.5	26544.6	1112.0
2018-06-01 01:00:00	YM	Futures	26543.5	26554.4	26521.8	26529.4	1526.0
2018-06-01 02:00:00	YM	Futures	26529.4	26626.0	26529.4	26611.9	5148.0
2018-06-01 03:00:00	YM	Futures	26611.9	26621.7	26580.4	26598.9	4191.0
2018-06-01 04:00:00	YM	Futures	26597.8	26616.3	26592.4	26601.1	1953.0
2018-06-01 05:00:00	YM	Futures	26600.0	26663.0	26596.7	26647.8	4195.0
2018-06-01 06:00:00	YM	Futures	26646.7	26668.4	26636.9	26660.8	2913.0
2018-06-01 07:00:00	YM	Futures	26661.9	26678.2	26648.8	26661.9	3244.0
2018-06-01 08:00:00	YM	Futures	26663.0	26710.7	26633.6	26708.6	9964.0
2018-06-01 09:00:00	YM	Futures	26707.5	26771.6	26702.1	26750.9	24756.0
2018-06-01 10:00:00	YM	Futures	26745.5	26802.0	26671.6	26729.2	40870.0
2018-06-01 11:00:00	YM	Futures	26729.2	26753.1	26697.7	26736.8	19088.0
2018-06-01 12:00:00	YM	Futures	26736.8	26782.4	26734.6	26768.3	12613.0
2018-06-01 13:00:00	YM	Futures	26769.4	26797.6	26761.8	26767.2	9781.0
2018-06-01 14:00:00	YM	Futures	26768.3	26775.9	26721.6	26764.0	12829.0
2018-06-01 15:00:00	YM	Futures	26762.9	26764.0	26703.1	26750.9	16827.0

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

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