PREVIEW / futures_daily / 2019-03-27

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-27.parquet
  size:    10 KB
  rows:    115

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
2019-03-27	ES	Futures	3049.87	3058.79	3015.58	3035.83	1726746.0
2019-03-27	NQ	Futures	8507.3	8531.79	8383.44	8450.85	592979.0
2019-03-27	YM	Futures	27102.5	27213.3	26854.4	27085.6	242937.0
2019-03-27	CL	Futures	61.64	61.84	60.39	61.0	732150.0
2019-03-27	GC	Futures	1645.0	1649.4	1635.1	1639.0	201609.0
2019-03-27	ZN	Futures	123.632104	124.284762	123.585486	124.005052	2172081.0
2019-03-27	A6	Futures	0.73673	0.73724	0.72972	0.73147	109356.0
2019-03-27	AD	Futures	0.75691	0.75731	0.75377	0.75585	76002.0
2019-03-27	B	Futures	49.06	49.31	48.52	48.98	351955.0
2019-03-27	B6	Futures	1.3585	1.3647	1.3542	1.3642	147011.0
2019-03-27	BR	Futures	0.20352	0.20352	0.19936	0.2016	80.0
2019-03-27	BTC	Futures	6025.9	6226.8	6025.9	6188.1	1268.0
2019-03-27	BZ	Futures	48.96	49.18	48.4	48.84	38310.0
2019-03-27	C	Futures	1497.0	1509.0	1486.0	1505.0	9353.0
2019-03-27	CB	Futures	281.115	281.504	280.517	280.517	61.0
2019-03-27	CC	Futures	1502.0	1526.0	1493.0	1517.0	17570.0
2019-03-27	CNH	Futures	6.7317	6.7502	6.7273	6.7501	430.0
2019-03-27	CSC	Futures	2.849	2.85	2.836	2.843	75.0
2019-03-27	CT	Futures	82.54	82.57	81.31	81.7	16692.0
2019-03-27	DC	Futures	23.96	24.06	23.88	23.97	150.0
2019-03-27	DX	Futures	92.257	92.487	92.2	92.289	11335.0
2019-03-27	E1	Futures	1.18278	1.18733	1.18009	1.18196	32949.0
2019-03-27	E6	Futures	1.24545	1.24721	1.24238	1.24485	215000.0
2019-03-27	E7	Futures	1.2393	1.241	1.2363	1.2387	6466.0
2019-03-27	EBM	Futures	199.25	199.51	196.87	197.4	22216.0
2019-03-27	ED	Futures	95.1697	95.2039	95.1697	95.1843	544551.0
2019-03-27	ER	Futures	98.406	98.416	98.401	98.411	233084.0
2019-03-27	EW	Futures	1996.6	2003.9	1976.7	1994.6	14089.0
2019-03-27	FBON	Futures	135.19	135.6	135.03	135.45	1046.0
2019-03-27	FBTP	Futures	114.85	115.26	114.06	115.17	132406.0
2019-03-27	FBTS	Futures	105.779	105.903	105.551	105.855	77813.0
2019-03-27	FCE	Futures	4736.5	4754.7	4698.1	4718.6	78734.0
2019-03-27	FDAX	Futures	12043.2	12128.0	11981.7	12034.3	128598.0
2019-03-27	FDIV	Futures	139.18	139.78	139.13	139.78	20.0
2019-03-27	FDXM	Futures	11955.6	12022.3	11877.3	11930.0	63513.0
2019-03-27	FESX	Futures	2829.1	2853.5	2815.9	2833.4	1143175.0
2019-03-27	FGBL	Futures	160.01	160.89	159.9	160.78	1067587.0
2019-03-27	FGBM	Futures	132.85	133.34	132.81	133.29	833951.0
2019-03-27	FGBS	Futures	112.729	112.839	112.724	112.824	859708.0
2019-03-27	FGBX	Futures	196.08	198.11	195.72	197.25	74603.0
2019-03-27	FMWO	Futures	7062.2	7066.9	6985.9	7011.3	3889.0
2019-03-27	FOAT	Futures	146.86	147.63	146.83	147.57	189664.0
2019-03-27	FTDX	Futures	2687.9	2687.9	2627.7	2639.5	443.0
2019-03-27	FTI	Futures	510.85	512.39	507.14	510.01	27267.0
2019-03-27	FTUK	Futures	6539.5	6558.3	6494.5	6518.4	81179.0
2019-03-27	FVSA	Futures	254.97	270.45	254.16	263.93	33623.0
2019-03-27	FXXP	Futures	332.2	333.4	329.7	331.4	52613.0
2019-03-27	G	Futures	119.38	119.61	118.96	119.28	252812.0
2019-03-27	GF	Futures	313.3	313.514	311.696	312.017	2285.0
2019-03-27	GSCI	Futures	493.62	493.62	489.77	492.09	21.0

> showing 50 of 115 rows — these rows as CSV

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