PREVIEW / futures_daily / 2017-03-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-09.parquet
  size:    9 KB
  rows:    108

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
2017-03-09	ES	Futures	2562.54	2568.5	2551.97	2565.25	1788548.0
2017-03-09	NQ	Futures	6319.99	6331.48	6288.46	6325.3	249227.0
2017-03-09	YM	Futures	21970.7	22021.3	21888.6	21981.3	178610.0
2017-03-09	CL	Futures	53.29	53.95	51.56	52.29	1073506.0
2017-03-09	GC	Futures	1542.8	1544.3	1531.7	1537.1	233510.0
2017-03-09	ZN	Futures	120.986063	121.06288	120.64807	120.770977	1220428.0
2017-03-09	A6	Futures	0.77044	0.77156	0.76716	0.7687	134696.0
2017-03-09	AD	Futures	0.75666	0.75753	0.75462	0.75574	93723.0
2017-03-09	ALI	Futures	2501.81	2501.81	2501.81	2501.81	0.0
2017-03-09	B	Futures	39.06	39.33	37.61	38.11	504122.0
2017-03-09	B6	Futures	1.2766	1.2793	1.2728	1.2774	195965.0
2017-03-09	BR	Futures	0.2231	0.2231	0.2226	0.2226	1.0
2017-03-09	BZ	Futures	38.62	39.14	37.42	37.94	61215.0
2017-03-09	C	Futures	1632.0	1638.0	1613.0	1630.0	5366.0
2017-03-09	CB	Futures	274.325	277.04	273.409	273.44	77.0
2017-03-09	CC	Futures	1457.0	1466.0	1434.0	1449.0	22363.0
2017-03-09	CNH	Futures	7.3109	7.3158	7.2815	7.2899	42.0
2017-03-09	CSC	Futures	3.744	3.744	3.708	3.708	34.0
2017-03-09	CT	Futures	87.11	87.59	85.94	86.74	16921.0
2017-03-09	DC	Futures	30.74	30.99	30.33	30.5	173.0
2017-03-09	DX	Futures	95.111	95.204	94.692	94.834	31010.0
2017-03-09	E1	Futures	1.22128	1.22835	1.21967	1.22735	39519.0
2017-03-09	E6	Futures	1.21768	1.22623	1.21577	1.22363	402889.0
2017-03-09	E7	Futures	1.2115	1.2201	1.2096	1.2174	7000.0
2017-03-09	EBM	Futures	194.9	196.3	194.62	195.46	15511.0
2017-03-09	ED	Futures	95.5109	95.5134	95.5037	95.5061	204384.0
2017-03-09	ER	Futures	98.308	98.308	98.303	98.303	54393.0
2017-03-09	EW	Futures	1820.6	1826.2	1805.5	1812.8	29892.0
2017-03-09	FBON	Futures	120.06	120.44	119.72	119.98	623.0
2017-03-09	FBTP	Futures	103.76	104.27	103.31	103.5	104605.0
2017-03-09	FBTS	Futures	101.755	101.845	101.583	101.637	46224.0
2017-03-09	FCE	Futures	4356.6	4389.6	4345.1	4383.0	113966.0
2017-03-09	FDAX	Futures	12609.4	12693.8	12578.2	12650.0	88392.0
2017-03-09	FDXM	Futures	12561.7	12642.7	12529.1	12599.1	23299.0
2017-03-09	FESX	Futures	2705.5	2734.3	2703.1	2727.9	1250980.0
2017-03-09	FGBL	Futures	147.54	147.65	146.65	147.04	921291.0
2017-03-09	FGBM	Futures	129.38	129.58	129.1	129.26	608582.0
2017-03-09	FGBS	Futures	112.397	112.482	112.372	112.457	463371.0
2017-03-09	FGBX	Futures	165.47	165.67	162.92	163.97	57125.0
2017-03-09	FMWO	Futures	6142.1	6151.8	6130.1	6151.8	1988.0
2017-03-09	FOAT	Futures	130.88	131.31	130.15	130.43	141324.0
2017-03-09	FTDX	Futures	1904.3	1911.7	1899.4	1909.2	98.0
2017-03-09	FTI	Futures	458.29	461.75	457.38	461.34	31509.0
2017-03-09	FTUK	Futures	6203.0	6203.8	6151.7	6198.3	201355.0
2017-03-09	FVSA	Futures	669.62	677.99	659.16	669.62	24221.0
2017-03-09	FXXP	Futures	308.3	309.9	307.7	309.6	45569.0
2017-03-09	G	Futures	113.85	114.34	113.82	114.1	196759.0
2017-03-09	GF	Futures	285.081	288.102	284.853	287.589	1754.0
2017-03-09	GSCI	Futures	490.84	494.96	488.46	490.0	3491.0
2017-03-09	HE	Futures	87.658	87.977	86.16	86.829	26674.0

> showing 50 of 108 rows — these rows as CSV

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