PREVIEW / futures_daily / 2017-03-31

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-31.parquet
  size:    9 KB
  rows:    109

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-03-31	ES	Futures	2569.04	2570.39	2559.53	2562.25	1568884.0
2017-03-31	NQ	Futures	6408.06	6422.19	6384.8	6405.41	166661.0
2017-03-31	YM	Futures	21806.1	21811.4	21732.2	21740.7	105486.0
2017-03-31	CL	Futures	52.74	53.3	52.3	53.03	527607.0
2017-03-31	GC	Futures	1591.6	1602.1	1587.6	1600.0	165212.0
2017-03-31	ZN	Futures	122.245855	122.537758	122.153675	122.476304	1525342.0
2017-03-31	A6	Futures	0.78399	0.78553	0.78143	0.78389	73682.0
2017-03-31	AD	Futures	0.76538	0.76849	0.7637	0.76824	64715.0
2017-03-31	ALI	Futures	2606.15	2606.15	2606.15	2606.15	0.0
2017-03-31	B	Futures	38.47	39.0	38.15	38.82	388846.0
2017-03-31	B6	Futures	1.3095	1.3197	1.3057	1.3163	127035.0
2017-03-31	BFX	Futures	4606.2	4623.1	4606.2	4623.1	5.0
2017-03-31	BR	Futures	0.2264	0.22857	0.22495	0.22857	234.0
2017-03-31	BZ	Futures	38.4	38.88	38.06	38.71	31997.0
2017-03-31	C	Futures	1746.0	1752.0	1731.0	1742.0	10983.0
2017-03-31	CB	Futures	263.065	263.95	263.065	263.645	6.0
2017-03-31	CC	Futures	1595.0	1609.0	1586.0	1599.0	17662.0
2017-03-31	CNH	Futures	7.2207	7.2216	7.1984	7.1984	32.0
2017-03-31	CSC	Futures	3.668	3.668	3.618	3.632	65.0
2017-03-31	CT	Futures	84.97	86.27	84.49	86.19	23070.0
2017-03-31	DC	Futures	30.29	30.37	29.77	29.88	199.0
2017-03-31	DX	Futures	93.483	93.637	93.274	93.369	25572.0
2017-03-31	E1	Futures	1.24008	1.24181	1.23736	1.24058	21770.0
2017-03-31	E6	Futures	1.23486	1.23716	1.23123	1.23503	182770.0
2017-03-31	E7	Futures	1.2283	1.2308	1.2251	1.2287	3132.0
2017-03-31	EBM	Futures	183.7	185.1	182.3	184.26	41719.0
2017-03-31	ED	Futures	95.5591	95.5639	95.5494	95.5542	266783.0
2017-03-31	ER	Futures	98.323	98.328	98.323	98.328	45909.0
2017-03-31	EW	Futures	1826.1	1834.4	1819.5	1826.3	17238.0
2017-03-31	FBON	Futures	121.85	122.11	121.71	121.83	857.0
2017-03-31	FBTP	Futures	104.66	104.97	104.66	104.83	67568.0
2017-03-31	FBTS	Futures	101.836	101.864	101.737	101.773	45473.0
2017-03-31	FCE	Futures	4473.4	4523.7	4465.9	4514.0	79282.0
2017-03-31	FDAX	Futures	12932.4	13055.9	12923.4	13016.3	68443.0
2017-03-31	FDXM	Futures	12818.8	12941.2	12810.4	12902.0	19560.0
2017-03-31	FESX	Futures	2776.9	2804.7	2771.2	2796.5	1069547.0
2017-03-31	FGBL	Futures	148.39	148.45	148.16	148.35	617282.0
2017-03-31	FGBM	Futures	129.34	129.41	129.24	129.35	394590.0
2017-03-31	FGBS	Futures	112.312	112.337	112.282	112.327	282294.0
2017-03-31	FGBX	Futures	168.59	168.79	167.93	168.33	43541.0
2017-03-31	FMWO	Futures	6208.5	6230.2	6208.5	6230.2	283.0
2017-03-31	FOAT	Futures	131.85	131.97	131.56	131.63	107811.0
2017-03-31	FTDX	Futures	2000.9	2007.3	1994.5	2005.8	79.0
2017-03-31	FTI	Futures	466.52	469.16	465.93	468.52	24081.0
2017-03-31	FTUK	Futures	6241.5	6241.5	6204.3	6226.1	111359.0
2017-03-31	FVSA	Futures	648.87	658.58	636.39	640.55	18840.0
2017-03-31	FXXP	Futures	315.5	317.6	314.6	317.1	22210.0
2017-03-31	G	Futures	115.02	115.29	114.89	115.11	192034.0
2017-03-31	GF	Futures	304.886	309.267	302.695	308.921	2358.0
2017-03-31	GSCI	Futures	492.87	496.31	491.98	495.42	493.0

> showing 50 of 109 rows — these rows as CSV

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