PREVIEW / futures_daily / 2017-03-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-22.parquet
  size:    9 KB
  rows:    109

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-22	ES	Futures	2541.88	2550.84	2532.92	2544.06	1883451.0
2017-03-22	NQ	Futures	6282.62	6332.09	6259.95	6319.72	335865.0
2017-03-22	YM	Futures	21736.5	21771.3	21657.3	21732.2	208619.0
2017-03-22	CL	Futures	50.48	50.64	49.27	50.35	680849.0
2017-03-22	GC	Futures	1589.8	1598.8	1588.9	1596.5	216447.0
2017-03-22	ZN	Futures	122.322671	122.629937	122.261218	122.445578	1678891.0
2017-03-22	A6	Futures	0.78789	0.7881	0.78286	0.78687	100776.0
2017-03-22	AD	Futures	0.76446	0.76655	0.7614	0.76528	61709.0
2017-03-22	ALI	Futures	2565.82	2565.82	2565.82	2565.82	0.0
2017-03-22	B	Futures	37.14	37.23	36.3	36.98	327912.0
2017-03-22	B6	Futures	1.3113	1.3142	1.3054	1.3121	113163.0
2017-03-22	BR	Futures	0.22966	0.2314	0.22966	0.23053	100.0
2017-03-22	BZ	Futures	36.98	37.05	36.08	36.81	39102.0
2017-03-22	C	Futures	1803.0	1817.0	1772.0	1809.0	10658.0
2017-03-22	CB	Futures	265.781	265.781	262.455	264.804	18.0
2017-03-22	CC	Futures	1647.0	1656.0	1619.0	1653.0	19941.0
2017-03-22	CNH	Futures	7.2159	7.2159	7.1986	7.1986	177.0
2017-03-22	CSC	Futures	3.647	3.701	3.641	3.685	109.0
2017-03-22	CT	Futures	85.56	87.14	85.46	86.21	15953.0
2017-03-22	DC	Futures	29.85	30.15	29.59	29.87	291.0
2017-03-22	DX	Futures	92.701	92.91	92.551	92.671	30154.0
2017-03-22	E1	Futures	1.25021	1.25726	1.2491	1.25256	24832.0
2017-03-22	E6	Futures	1.25041	1.25231	1.24661	1.24908	199399.0
2017-03-22	E7	Futures	1.244	1.246	1.2403	1.2427	3019.0
2017-03-22	EBM	Futures	190.98	191.26	188.46	188.74	24721.0
2017-03-22	ED	Futures	95.5349	95.5494	95.53	95.5446	288994.0
2017-03-22	ER	Futures	98.303	98.318	98.303	98.308	78342.0
2017-03-22	EW	Futures	1792.7	1798.3	1783.7	1796.6	16966.0
2017-03-22	FBON	Futures	120.22	120.96	120.22	120.79	804.0
2017-03-22	FBTP	Futures	103.34	103.64	103.18	103.56	96645.0
2017-03-22	FBTS	Futures	101.564	101.646	101.555	101.637	36475.0
2017-03-22	FCE	Futures	4381.2	4410.3	4361.8	4399.7	91480.0
2017-03-22	FDAX	Futures	12567.7	12644.7	12540.2	12608.8	88512.0
2017-03-22	FDXM	Futures	12453.6	12532.1	12429.5	12498.1	28266.0
2017-03-22	FESX	Futures	2721.4	2738.6	2710.8	2732.8	1066758.0
2017-03-22	FEU3	Futures	98.986	98.986	98.986	98.986	750.0
2017-03-22	FGBL	Futures	146.79	147.35	146.73	147.23	828800.0
2017-03-22	FGBM	Futures	128.75	128.94	128.7	128.89	435769.0
2017-03-22	FGBS	Futures	112.237	112.297	112.222	112.277	259363.0
2017-03-22	FGBX	Futures	165.65	167.47	165.59	167.15	52842.0
2017-03-22	FMWO	Futures	6156.7	6172.4	6155.5	6168.8	262.0
2017-03-22	FOAT	Futures	130.44	130.84	130.22	130.72	117959.0
2017-03-22	FTDX	Futures	1921.0	1921.0	1897.9	1918.0	158.0
2017-03-22	FTI	Futures	462.29	463.06	458.84	461.65	35617.0
2017-03-22	FTUK	Futures	6216.3	6223.1	6186.3	6209.9	119293.0
2017-03-22	FVSA	Futures	651.65	665.51	644.71	648.87	19101.0
2017-03-22	FXXP	Futures	310.1	310.6	308.3	310.2	30525.0
2017-03-22	G	Futures	113.76	114.57	113.75	114.54	255855.0
2017-03-22	GF	Futures	306.615	316.186	306.212	314.456	6949.0
2017-03-22	GSCI	Futures	481.01	482.73	478.78	482.41	210.0

> showing 50 of 109 rows — these rows as CSV

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