PREVIEW / futures_daily / 2017-04-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-06.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-04-06	ES	Futures	2547.31	2564.42	2539.17	2556.27	1595949.0
2017-04-06	NQ	Futures	6376.55	6403.94	6348.29	6386.86	287867.0
2017-04-06	YM	Futures	21705.9	21831.4	21643.6	21741.7	159505.0
2017-04-06	CL	Futures	53.24	54.31	53.21	54.19	473019.0
2017-04-06	GC	Futures	1608.2	1612.5	1600.2	1602.7	165264.0
2017-04-06	ZN	Futures	123.1062	123.19838	122.845024	123.029383	1079521.0
2017-04-06	A6	Futures	0.77609	0.77681	0.77219	0.77311	69277.0
2017-04-06	AD	Futures	0.75962	0.76186	0.75891	0.7612	42302.0
2017-04-06	ALI	Futures	2578.31	2578.31	2578.31	2578.31	0.0
2017-04-06	B	Futures	39.26	39.89	39.18	39.81	239472.0
2017-04-06	B6	Futures	1.3115	1.3133	1.3075	1.3102	81326.0
2017-04-06	BR	Futures	0.22944	0.22962	0.2277	0.2277	76.0
2017-04-06	BZ	Futures	39.16	39.77	39.07	39.7	21011.0
2017-04-06	C	Futures	1760.0	1760.0	1727.0	1734.0	13939.0
2017-04-06	CB	Futures	263.675	263.675	261.814	261.814	7.0
2017-04-06	CC	Futures	1615.0	1619.0	1586.0	1598.0	25102.0
2017-04-06	CNH	Futures	7.2181	7.2182	7.2146	7.2146	6.0
2017-04-06	CSC	Futures	3.56	3.56	3.491	3.509	143.0
2017-04-06	CT	Futures	83.42	83.68	83.02	83.05	16808.0
2017-04-06	DC	Futures	29.23	29.27	28.54	28.73	434.0
2017-04-06	DX	Futures	93.511	93.791	93.432	93.697	18133.0
2017-04-06	E1	Futures	1.23514	1.23736	1.23242	1.23427	17687.0
2017-04-06	E6	Futures	1.23238	1.23463	1.22835	1.23042	143303.0
2017-04-06	E7	Futures	1.2264	1.2282	1.2221	1.2241	3001.0
2017-04-06	EBM	Futures	183.7	184.26	183.14	183.42	12873.0
2017-04-06	ED	Futures	95.5542	95.5591	95.5397	95.5397	292822.0
2017-04-06	ER	Futures	98.328	98.332	98.323	98.328	48971.0
2017-04-06	EW	Futures	1796.6	1818.1	1788.4	1814.7	21258.0
2017-04-06	FBON	Futures	122.32	122.32	121.95	122.15	721.0
2017-04-06	FBTP	Futures	105.31	105.34	104.95	105.29	74598.0
2017-04-06	FBTS	Futures	101.855	101.891	101.836	101.873	18649.0
2017-04-06	FCE	Futures	4461.5	4519.3	4451.8	4514.0	97828.0
2017-04-06	FDAX	Futures	12844.8	12953.5	12818.4	12946.1	84744.0
2017-04-06	FDXM	Futures	12735.1	12838.7	12705.8	12832.4	22647.0
2017-04-06	FESX	Futures	2759.8	2795.7	2754.9	2794.1	1010097.0
2017-04-06	FEU3	Futures	99.001	99.001	99.001	99.001	6.0
2017-04-06	FGBL	Futures	149.47	149.5	149.12	149.24	588849.0
2017-04-06	FGBM	Futures	129.89	129.93	129.7	129.75	337086.0
2017-04-06	FGBS	Futures	112.472	112.487	112.412	112.422	199593.0
2017-04-06	FGBX	Futures	171.14	171.22	170.27	170.82	35896.0
2017-04-06	FMWO	Futures	6179.6	6210.9	6179.6	6210.9	463.0
2017-04-06	FOAT	Futures	132.27	132.4	132.14	132.32	151484.0
2017-04-06	FTDX	Futures	1993.5	2003.8	1978.3	1998.4	151.0
2017-04-06	FTI	Futures	464.84	468.7	463.43	468.48	31001.0
2017-04-06	FTUK	Futures	6176.9	6213.7	6158.1	6200.5	111672.0
2017-04-06	FVSA	Futures	655.81	662.74	636.39	640.55	14756.0
2017-04-06	FXXP	Futures	313.5	317.0	313.5	316.7	26099.0
2017-04-06	G	Futures	115.71	115.79	115.37	115.48	127716.0
2017-04-06	GF	Futures	303.156	305.289	300.561	304.309	3299.0
2017-04-06	GSCI	Futures	500.33	501.03	499.82	500.78	494.0

> showing 50 of 110 rows — these rows as CSV

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