PREVIEW / futures_daily / 2017-11-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-09.parquet
  size:    9 KB
  rows:    111

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-09	ES	Futures	2818.49	2822.02	2788.03	2810.6	2218191.0
2017-11-09	NQ	Futures	7449.68	7460.55	7335.16	7417.08	550267.0
2017-11-09	YM	Futures	24806.4	24852.8	24562.4	24727.2	222954.0
2017-11-09	CL	Futures	57.33	58.01	57.17	57.65	666949.0
2017-11-09	GC	Futures	1631.4	1640.8	1629.3	1638.2	394181.0
2017-11-09	ZN	Futures	123.408934	123.562983	123.285695	123.424339	1685943.0
2017-11-09	A6	Futures	0.78959	0.79123	0.78681	0.7901	90929.0
2017-11-09	AD	Futures	0.79941	0.80343	0.79885	0.80313	64994.0
2017-11-09	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-09	B	Futures	44.93	45.44	44.74	45.22	319856.0
2017-11-09	B6	Futures	1.3686	1.3741	1.3656	1.3731	117062.0
2017-11-09	BFX	Futures	4852.4	4852.4	4804.7	4804.7	1.0
2017-11-09	BR	Futures	0.23136	0.23245	0.23041	0.23094	2371.0
2017-11-09	BZ	Futures	44.52	45.03	44.35	44.82	24929.0
2017-11-09	C	Futures	1595.0	1605.0	1589.0	1597.0	15077.0
2017-11-09	CB	Futures	277.11	282.18	277.11	281.33	44.0
2017-11-09	CC	Futures	1638.0	1640.0	1618.0	1630.0	26484.0
2017-11-09	CNH	Futures	6.841	6.841	6.836	6.836	2.0
2017-11-09	CSC	Futures	3.363	3.454	3.338	3.445	191.0
2017-11-09	CT	Futures	80.79	81.61	80.08	80.21	31783.0
2017-11-09	DC	Futures	27.18	28.01	26.85	27.89	763.0
2017-11-09	DX	Futures	88.7	88.714	88.19	88.234	22013.0
2017-11-09	E1	Futures	1.22577	1.23506	1.22332	1.23384	40188.0
2017-11-09	E6	Futures	1.3256	1.33244	1.32457	1.33159	242010.0
2017-11-09	E7	Futures	1.3186	1.3254	1.3176	1.3246	4443.0
2017-11-09	EBM	Futures	174.24	174.51	172.89	172.89	24905.0
2017-11-09	ED	Futures	95.4648	95.4794	95.4648	95.4745	290901.0
2017-11-09	ER	Futures	98.347	98.347	98.342	98.347	17709.0
2017-11-09	EW	Futures	1951.5	1955.0	1926.9	1940.1	24247.0
2017-11-09	FBON	Futures	126.13	126.13	125.65	125.74	713.0
2017-11-09	FBTP	Futures	113.29	113.33	112.26	112.42	138530.0
2017-11-09	FBTS	Futures	103.732	103.732	103.649	103.677	73207.0
2017-11-09	FCE	Futures	4905.0	4911.3	4814.1	4846.3	111892.0
2017-11-09	FDAX	Futures	14071.6	14085.3	13770.5	13871.4	136924.0
2017-11-09	FDIV	Futures	155.22	155.22	155.01	155.01	4.0
2017-11-09	FDXM	Futures	13949.2	13965.9	13657.4	13754.4	48700.0
2017-11-09	FESX	Futures	2976.8	2981.7	2922.1	2947.4	1619361.0
2017-11-09	FEU3	Futures	99.011	99.016	99.011	99.016	700.0
2017-11-09	FGBL	Futures	150.96	151.08	150.23	150.33	940376.0
2017-11-09	FGBM	Futures	130.29	130.33	130.08	130.12	531015.0
2017-11-09	FGBS	Futures	112.572	112.582	112.537	112.552	226505.0
2017-11-09	FGBX	Futures	169.85	170.4	168.03	168.24	59316.0
2017-11-09	FMWO	Futures	6815.9	6815.9	6754.5	6780.5	1420.0
2017-11-09	FOAT	Futures	138.87	138.96	138.11	138.2	140946.0
2017-11-09	FTDX	Futures	2512.4	2512.4	2445.6	2452.5	580.0
2017-11-09	FTI	Futures	512.89	513.82	505.66	509.0	35437.0
2017-11-09	FTUK	Futures	6514.6	6525.8	6453.8	6479.8	96345.0
2017-11-09	FVSA	Futures	318.46	361.95	318.46	342.76	49481.0
2017-11-09	FXXP	Futures	334.5	334.9	329.2	331.1	44102.0
2017-11-09	G	Futures	114.91	114.99	114.45	114.53	176674.0

> showing 50 of 111 rows — these rows as CSV

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