PREVIEW / futures_daily / 2016-07-25

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-25.parquet
  size:    9 KB
  rows:    110

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
2016-07-25	ES	Futures	2340.5	2345.63	2327.54	2334.56	1264905.0
2016-07-25	NQ	Futures	5492.02	5504.11	5473.46	5485.54	146154.0
2016-07-25	YM	Futures	19311.0	19351.8	19196.2	19240.0	104711.0
2016-07-25	CL	Futures	50.1	50.29	48.71	48.89	389837.0
2016-07-25	GC	Futures	1701.7	1702.6	1686.7	1697.6	263660.0
2016-07-25	ZN	Futures	127.607298	127.743115	127.380937	127.546935	732638.0
2016-07-25	A6	Futures	0.75757	0.76083	0.75707	0.75839	47424.0
2016-07-25	AD	Futures	0.77889	0.77986	0.7729	0.77423	48147.0
2016-07-25	ALI	Futures	2104.42	2104.42	2103.46	2103.46	3.0
2016-07-25	B	Futures	36.48	36.62	35.57	35.7	188805.0
2016-07-25	B6	Futures	1.3843	1.3887	1.3814	1.3848	57767.0
2016-07-25	BFX	Futures	3978.7	3978.7	3970.6	3970.6	10.0
2016-07-25	BR	Futures	0.20167	0.20167	0.1997	0.2001	484.0
2016-07-25	BZ	Futures	36.38	36.48	35.44	35.57	19167.0
2016-07-25	C	Futures	2536.0	2552.0	2495.0	2499.0	8802.0
2016-07-25	CB	Futures	276.699	276.699	273.739	273.915	38.0
2016-07-25	CC	Futures	2115.0	2136.0	2090.0	2093.0	21766.0
2016-07-25	CNH	Futures	7.2534	7.2548	7.2495	7.2495	5.0
2016-07-25	CSC	Futures	3.773	3.809	3.773	3.786	63.0
2016-07-25	CT	Futures	82.1	82.23	81.22	81.7	17.0
2016-07-25	DC	Futures	30.04	30.67	30.04	30.38	322.0
2016-07-25	DX	Futures	90.639	90.792	90.448	90.519	11319.0
2016-07-25	E1	Futures	1.27053	1.27492	1.26891	1.27316	11354.0
2016-07-25	E6	Futures	1.28008	1.28334	1.27781	1.28223	87057.0
2016-07-25	E7	Futures	1.2732	1.2763	1.2712	1.2754	1438.0
2016-07-25	EBM	Futures	211.71	213.21	204.49	205.09	26298.0
2016-07-25	ED	Futures	95.6798	95.6846	95.6605	95.6653	183242.0
2016-07-25	ER	Futures	98.313	98.313	98.308	98.308	24514.0
2016-07-25	EW	Futures	1643.5	1645.4	1633.7	1636.9	9980.0
2016-07-25	FBON	Futures	123.22	123.22	123.14	123.14	1.0
2016-07-25	FBTP	Futures	109.35	109.58	109.2	109.5	49975.0
2016-07-25	FBTS	Futures	101.284	101.302	101.266	101.275	11732.0
2016-07-25	FCE	Futures	3819.2	3858.1	3810.5	3828.8	63246.0
2016-07-25	FDAX	Futures	10766.4	10914.9	10755.2	10830.3	75143.0
2016-07-25	FDIV	Futures	132.01	132.34	131.32	131.69	152.0
2016-07-25	FDXM	Futures	10497.0	10639.1	10488.7	10556.6	18087.0
2016-07-25	FESX	Futures	2321.2	2344.7	2315.0	2321.2	870802.0
2016-07-25	FGBL	Futures	149.75	150.09	149.51	150.02	403368.0
2016-07-25	FGBM	Futures	128.71	128.8	128.64	128.77	310860.0
2016-07-25	FGBS	Futures	111.857	111.862	111.832	111.857	191022.0
2016-07-25	FGBX	Futures	186.5	187.99	185.57	187.71	21805.0
2016-07-25	FMWO	Futures	5699.0	5707.5	5679.6	5679.6	14.0
2016-07-25	FOAT	Futures	137.65	138.06	137.47	137.96	59738.0
2016-07-25	FTDX	Futures	1619.7	1624.0	1612.9	1620.2	78.0
2016-07-25	FTI	Futures	404.43	407.44	402.86	404.16	23905.0
2016-07-25	FTUK	Futures	5574.8	5591.9	5536.9	5551.0	71232.0
2016-07-25	FVSA	Futures	2220.59	2254.75	2162.03	2244.99	18233.0
2016-07-25	FXXP	Futures	274.6	276.7	273.8	274.5	16738.0
2016-07-25	G	Futures	114.74	114.78	114.42	114.73	134440.0
2016-07-25	GF	Futures	277.26	282.951	276.711	282.951	3903.0

> showing 50 of 110 rows — these rows as CSV

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