PREVIEW / futures_daily / 2016-09-29

all futures daily files

  file:    by_date/futures_daily/2016/2016-09-29.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-09-29	ES	Futures	2338.68	2343.82	2311.64	2323.81	2306654.0
2016-09-29	NQ	Futures	5735.7	5747.19	5671.76	5709.18	306337.0
2016-09-29	YM	Futures	19144.5	19193.8	18899.8	19002.7	194374.0
2016-09-29	CL	Futures	52.05	53.28	51.38	52.74	702649.0
2016-09-29	GC	Futures	1700.0	1705.6	1691.8	1701.3	157335.0
2016-09-29	ZN	Futures	127.803697	128.092502	127.606094	127.9709	1165988.0
2016-09-29	A6	Futures	0.78316	0.7853	0.77652	0.77856	92504.0
2016-09-29	AD	Futures	0.78298	0.78544	0.77729	0.7796	86618.0
2016-09-29	ALI	Futures	2202.65	2202.65	2202.65	2202.65	0.0
2016-09-29	B	Futures	38.28	39.0	37.57	38.55	440095.0
2016-09-29	B6	Futures	1.3721	1.3766	1.3656	1.3673	79869.0
2016-09-29	BFX	Futures	4251.5	4251.5	4208.1	4208.1	1.0
2016-09-29	BR	Futures	0.20801	0.20931	0.2064	0.20749	801.0
2016-09-29	BZ	Futures	37.94	38.77	37.37	38.33	38353.0
2016-09-29	C	Futures	2414.0	2414.0	2340.0	2360.0	26353.0
2016-09-29	CB	Futures	243.772	244.175	243.648	244.175	9.0
2016-09-29	CC	Futures	2083.0	2089.0	2005.0	2018.0	32408.0
2016-09-29	CNH	Futures	7.1994	7.2005	7.194	7.194	10.0
2016-09-29	CSC	Futures	3.776	3.776	3.73	3.746	20.0
2016-09-29	CT	Futures	77.08	77.35	75.37	75.88	17537.0
2016-09-29	DC	Futures	29.67	29.82	29.25	29.51	157.0
2016-09-29	DX	Futures	88.712	89.0	88.647	88.858	16753.0
2016-09-29	E1	Futures	1.28879	1.29826	1.2868	1.29502	25186.0
2016-09-29	E6	Futures	1.30483	1.30848	1.30217	1.30437	155508.0
2016-09-29	E7	Futures	1.298	1.3012	1.2951	1.2973	2090.0
2016-09-29	EBM	Futures	190.06	190.64	189.47	190.35	14270.0
2016-09-29	ED	Futures	95.6635	95.6683	95.6538	95.6586	316140.0
2016-09-29	ER	Futures	98.279	98.279	98.259	98.279	71214.0
2016-09-29	EW	Futures	1652.3	1655.3	1629.7	1634.4	28938.0
2016-09-29	FBON	Futures	125.48	125.49	125.13	125.18	983.0
2016-09-29	FBTP	Futures	110.12	110.23	109.76	109.82	100532.0
2016-09-29	FBTS	Futures	101.338	101.338	101.293	101.311	16166.0
2016-09-29	FCE	Futures	3981.8	4004.0	3891.5	3948.0	98375.0
2016-09-29	FDAX	Futures	11126.5	11167.7	10827.9	10979.6	125072.0
2016-09-29	FDXM	Futures	11101.4	11143.6	10805.1	10955.9	38097.0
2016-09-29	FESX	Futures	2410.2	2420.6	2350.9	2386.1	1207923.0
2016-09-29	FEU3	Futures	98.961	98.961	98.956	98.956	3.0
2016-09-29	FGBL	Futures	151.31	151.64	151.19	151.33	587019.0
2016-09-29	FGBM	Futures	129.35	129.43	129.29	129.32	388637.0
2016-09-29	FGBS	Futures	112.007	112.012	111.977	111.992	180486.0
2016-09-29	FGBX	Futures	188.87	189.83	188.22	188.73	29710.0
2016-09-29	FMWO	Futures	5773.9	5775.1	5761.8	5763.0	12.0
2016-09-29	FOAT	Futures	138.92	139.08	138.73	138.82	101660.0
2016-09-29	FTDX	Futures	1771.5	1772.4	1735.7	1748.4	306.0
2016-09-29	FTI	Futures	417.33	419.21	408.66	413.98	30948.0
2016-09-29	FTUK	Futures	5790.0	5828.0	5751.2	5805.6	116881.0
2016-09-29	FVSA	Futures	1501.47	1676.64	1476.45	1544.37	6824.0
2016-09-29	FXXP	Futures	284.4	284.6	278.8	281.8	26804.0
2016-09-29	G	Futures	116.75	116.79	116.27	116.57	161907.0
2016-09-29	GF	Futures	264.11	266.07	262.099	263.027	2193.0

> showing 50 of 110 rows — these rows as CSV

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