PREVIEW / futures_daily / 2019-05-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-05-01.parquet
  size:    9 KB
  rows:    92

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2019-05-01	ES	Futures	3191.92	3198.67	3149.79	3157.35	1502201.0
2019-05-01	NQ	Futures	9043.37	9064.68	8913.46	8937.08	484406.0
2019-05-01	YM	Futures	28126.4	28173.9	27796.0	27856.1	178492.0
2019-05-01	CL	Futures	65.09	65.64	64.44	65.3	676872.0
2019-05-01	GC	Futures	1599.6	1604.8	1586.3	1598.3	275425.0
2019-05-01	ZN	Futures	123.010525	123.445631	122.792972	122.901749	1929299.0
2019-05-01	A6	Futures	0.72735	0.72869	0.72312	0.72374	82209.0
2019-05-01	AD	Futures	0.75559	0.75661	0.75185	0.75246	74230.0
2019-05-01	B	Futures	52.86	53.32	52.54	53.19	230800.0
2019-05-01	B6	Futures	1.3391	1.3456	1.338	1.3397	83017.0
2019-05-01	BR	Futures	0.2036	0.20488	0.20232	0.20356	654.0
2019-05-01	BTC	Futures	8119.1	8273.7	8119.1	8196.4	3557.0
2019-05-01	BZ	Futures	52.56	53.17	52.39	53.04	32617.0
2019-05-01	C	Futures	1722.0	1739.0	1699.0	1706.0	2490.0
2019-05-01	CB	Futures	279.022	279.022	278.125	278.603	22.0
2019-05-01	CC	Futures	1592.0	1616.0	1555.0	1559.0	23626.0
2019-05-01	CNH	Futures	6.7464	6.7488	6.7355	6.7406	112.0
2019-05-01	CSC	Futures	2.948	2.961	2.941	2.957	46.0
2019-05-01	CT	Futures	80.23	80.47	79.19	80.3	21438.0
2019-05-01	DC	Futures	24.8	24.95	24.78	24.9	318.0
2019-05-01	DX	Futures	93.197	93.417	92.852	93.369	18042.0
2019-05-01	E1	Futures	1.15022	1.15757	1.1494	1.15127	32732.0
2019-05-01	E6	Futures	1.23596	1.24139	1.23278	1.23366	162143.0
2019-05-01	E7	Futures	1.2298	1.2351	1.2267	1.2276	5890.0
2019-05-01	ED	Futures	95.1648	95.199	95.155	95.1648	562992.0
2019-05-01	ER	Futures	98.416	98.416	98.416	98.416	0.0
2019-05-01	EW	Futures	2099.8	2101.9	2064.4	2070.8	12545.0
2019-05-01	FTUK	Futures	6786.2	6796.7	6689.9	6724.3	50105.0
2019-05-01	G	Futures	117.42	117.78	117.32	117.68	94895.0
2019-05-01	GF	Futures	296.208	296.781	293.866	294.335	1893.0
2019-05-01	GSCI	Futures	503.66	504.34	500.1	504.0	106.0
2019-05-01	HE	Futures	83.244	86.418	82.937	86.418	21541.0
2019-05-01	HG	Futures	3.3293	3.3361	3.1907	3.2079	112251.0
2019-05-01	HH	Futures	17.371	17.491	17.358	17.465	593.0
2019-05-01	HO	Futures	1.3765	1.3949	1.3703	1.3926	62092.0
2019-05-01	HRC	Futures	1531.3	1531.3	1521.9	1524.2	45.0
2019-05-01	J1	Futures	0.0106108	0.0106474	0.0105926	0.0105943	106709.0
2019-05-01	J7	Futures	0.010566	0.010617	0.010549	0.01055	425.0
2019-05-01	JB	Futures	140.35	140.45	140.33	140.35	758.0
2019-05-01	KC	Futures	100.25	100.58	98.15	98.42	27190.0
2019-05-01	KE	Futures	591.62	603.25	590.87	599.87	23175.0
2019-05-01	L	Futures	99.44	99.445	99.435	99.44	59447.0
2019-05-01	LBS	Futures	544.5	547.1	535.1	541.3	139.0
2019-05-01	LE	Futures	167.833	168.346	166.88	167.026	31520.0
2019-05-01	MFS	Futures	1982.8	1987.3	1958.6	1964.5	24715.0
2019-05-01	MGC	Futures	1566.2	1570.7	1553.0	1564.7	10932.0
2019-05-01	MME	Futures	1105.8	1115.4	1094.1	1096.6	90618.0
2019-05-01	MP	Futures	0.03874	0.03904	0.03856	0.03868	62635.0
2019-05-01	N6	Futures	0.6637	0.6643	0.65794	0.65824	35963.0
2019-05-01	NG	Futures	22.346	22.815	22.25	22.763	105388.0

> showing 50 of 92 rows — these rows as CSV

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