PREVIEW / futures_daily / 2017-11-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-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
2017-11-29	ES	Futures	2855.74	2865.26	2849.49	2855.2	1661775.0
2017-11-29	NQ	Futures	7545.12	7550.99	7380.08	7406.51	625761.0
2017-11-29	YM	Futures	25136.9	25286.8	25122.1	25257.3	158617.0
2017-11-29	CL	Futures	57.79	58.36	56.81	57.36	741564.0
2017-11-29	GC	Futures	1645.6	1648.6	1629.2	1630.6	392057.0
2017-11-29	ZN	Futures	123.285695	123.347314	122.761927	122.962191	1899713.0
2017-11-29	A6	Futures	0.78197	0.78269	0.77683	0.7795	98944.0
2017-11-29	AD	Futures	0.79438	0.79473	0.79041	0.79199	79874.0
2017-11-29	B	Futures	44.77	45.18	44.0	44.42	441956.0
2017-11-29	B6	Futures	1.3936	1.4029	1.3924	1.4004	215806.0
2017-11-29	BFX	Futures	4774.9	4774.9	4761.8	4761.8	1.0
2017-11-29	BR	Futures	0.23419	0.23495	0.23241	0.23241	199.0
2017-11-29	BZ	Futures	44.45	44.82	43.67	44.08	40252.0
2017-11-29	C	Futures	1445.0	1468.0	1432.0	1464.0	11057.0
2017-11-29	CB	Futures	280.444	281.71	280.444	281.71	8.0
2017-11-29	CC	Futures	1529.0	1580.0	1522.0	1571.0	26839.0
2017-11-29	CNH	Futures	6.7895	6.8002	6.7766	6.7959	44.0
2017-11-29	CSC	Futures	3.402	3.402	3.381	3.385	33.0
2017-11-29	CT	Futures	84.19	85.8	83.8	85.76	24316.0
2017-11-29	DC	Futures	27.09	27.09	26.83	26.96	88.0
2017-11-29	DX	Futures	87.133	87.321	86.9	87.07	17793.0
2017-11-29	E1	Futures	1.24435	1.24668	1.2402	1.24423	23701.0
2017-11-29	E6	Futures	1.35333	1.35732	1.34973	1.35492	198240.0
2017-11-29	E7	Futures	1.3461	1.3502	1.3427	1.3479	4817.0
2017-11-29	EBM	Futures	169.11	171.54	169.11	171.54	19694.0
2017-11-29	ED	Futures	95.4552	95.4576	95.4527	95.4552	217384.0
2017-11-29	ER	Futures	98.347	98.347	98.342	98.347	39543.0
2017-11-29	EW	Futures	1997.4	2013.5	1995.8	2007.4	14412.0
2017-11-29	FBON	Futures	126.36	126.54	126.08	126.17	467.0
2017-11-29	FBTP	Futures	113.12	113.33	112.87	112.96	121192.0
2017-11-29	FBTS	Futures	103.86	103.869	103.832	103.842	42556.0
2017-11-29	FCE	Futures	4849.0	4873.2	4825.7	4834.2	72132.0
2017-11-29	FDAX	Futures	13794.2	13870.4	13693.3	13718.0	113372.0
2017-11-29	FDXM	Futures	13678.3	13754.4	13578.2	13602.2	47777.0
2017-11-29	FESX	Futures	2936.8	2951.5	2919.7	2926.2	1043548.0
2017-11-29	FGBL	Futures	150.76	150.81	150.16	150.23	950340.0
2017-11-29	FGBM	Futures	130.03	130.05	129.77	129.8	683517.0
2017-11-29	FGBS	Futures	112.487	112.497	112.457	112.462	467741.0
2017-11-29	FGBX	Futures	170.77	170.97	169.58	169.85	65177.0
2017-11-29	FMWO	Futures	6895.0	6896.2	6867.9	6876.1	1091.0
2017-11-29	FOAT	Futures	139.17	139.27	138.67	138.78	120615.0
2017-11-29	FTDX	Futures	2578.3	2578.3	2505.5	2511.4	615.0
2017-11-29	FTI	Futures	506.3	507.65	501.48	502.68	33507.0
2017-11-29	FTUK	Futures	6456.0	6459.5	6380.0	6415.6	132033.0
2017-11-29	FVSA	Futures	307.53	318.1	304.01	314.57	18989.0
2017-11-29	FXXP	Futures	330.9	331.9	328.8	329.6	33887.0
2017-11-29	G	Futures	114.14	114.26	113.7	113.78	286209.0
2017-11-29	GF	Futures	334.462	337.002	334.029	336.354	4506.0
2017-11-29	GSCI	Futures	498.99	500.22	497.71	497.71	16.0
2017-11-29	HE	Futures	95.711	96.378	94.21	94.577	19197.0

> showing 50 of 110 rows — these rows as CSV

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