PREVIEW / futures_daily / 2019-01-31

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-31.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-01-31	ES	Futures	2905.34	2937.28	2896.95	2928.08	1935195.0
2019-01-31	NQ	Futures	7923.95	8038.28	7918.17	8005.58	557023.0
2019-01-31	YM	Futures	26296.5	26417.8	26154.1	26343.9	230827.0
2019-01-31	CL	Futures	56.45	57.58	55.76	55.94	718650.0
2019-01-31	GC	Futures	1656.7	1663.9	1652.7	1656.5	224751.0
2019-01-31	ZN	Futures	121.611536	122.093936	121.564852	121.969445	1941362.0
2019-01-31	A6	Futures	0.74682	0.75207	0.74672	0.74898	140333.0
2019-01-31	AD	Futures	0.77073	0.77245	0.76982	0.77189	98642.0
2019-01-31	B	Futures	44.73	45.28	43.96	44.11	322619.0
2019-01-31	B6	Futures	1.3497	1.3543	1.3478	1.3493	95048.0
2019-01-31	BR	Futures	0.21532	0.21883	0.21532	0.21831	4131.0
2019-01-31	BTC	Futures	5042.7	5094.3	4961.6	5005.8	4066.0
2019-01-31	BZ	Futures	44.21	44.81	43.5	43.65	32889.0
2019-01-31	C	Futures	1383.0	1390.0	1372.0	1376.0	8679.0
2019-01-31	CB	Futures	279.183	279.396	277.604	277.604	11.0
2019-01-31	CC	Futures	1504.0	1510.0	1489.0	1494.0	18152.0
2019-01-31	CNH	Futures	6.7186	6.7317	6.7137	6.7206	831.0
2019-01-31	CSC	Futures	2.715	2.726	2.691	2.693	187.0
2019-01-31	CT	Futures	80.78	81.54	80.61	81.05	26336.0
2019-01-31	DC	Futures	23.11	23.23	22.96	23.03	361.0
2019-01-31	DX	Futures	90.673	90.93	90.482	90.891	23623.0
2019-01-31	E1	Futures	1.18759	1.19159	1.18618	1.18677	24292.0
2019-01-31	E6	Futures	1.27342	1.27691	1.26818	1.26917	233027.0
2019-01-31	E7	Futures	1.267	1.2706	1.262	1.263	4981.0
2019-01-31	EBM	Futures	211.54	211.8	209.74	210.0	20563.0
2019-01-31	ED	Futures	95.0525	95.0672	95.0428	95.0623	335429.0
2019-01-31	ER	Futures	98.401	98.406	98.396	98.401	101848.0
2019-01-31	EW	Futures	1947.2	1961.0	1938.4	1955.1	19696.0
2019-01-31	FBON	Futures	131.67	132.31	131.67	132.2	473.0
2019-01-31	FBTP	Futures	113.3	113.56	113.13	113.35	90355.0
2019-01-31	FBTS	Futures	105.559	105.616	105.427	105.493	55209.0
2019-01-31	FCE	Futures	4465.6	4492.1	4435.6	4470.6	87426.0
2019-01-31	FDAX	Futures	11804.2	11881.0	11602.0	11721.2	130268.0
2019-01-31	FDXM	Futures	11771.3	11852.0	11574.2	11692.7	65776.0
2019-01-31	FESX	Futures	2706.4	2713.3	2669.7	2693.6	1473505.0
2019-01-31	FEU3	Futures	98.996	99.006	98.996	99.006	597.0
2019-01-31	FGBL	Futures	157.38	157.71	157.17	157.52	802465.0
2019-01-31	FGBM	Futures	132.35	132.41	132.16	132.32	567980.0
2019-01-31	FGBS	Futures	112.693	112.698	112.638	112.668	454701.0
2019-01-31	FGBX	Futures	187.82	188.97	187.45	188.55	50925.0
2019-01-31	FMWO	Futures	6798.8	6827.9	6766.1	6803.4	2381.0
2019-01-31	FOAT	Futures	142.96	143.28	142.96	143.25	157879.0
2019-01-31	FTDX	Futures	2601.0	2601.0	2554.8	2567.7	155.0
2019-01-31	FTI	Futures	489.61	492.3	486.63	490.61	29372.0
2019-01-31	FTUK	Futures	6265.3	6315.0	6256.7	6287.2	125749.0
2019-01-31	FVSA	Futures	303.87	315.13	298.25	302.94	30222.0
2019-01-31	FXXP	Futures	314.1	315.5	311.6	313.7	69758.0
2019-01-31	G	Futures	117.11	117.23	116.95	117.12	254822.0
2019-01-31	GF	Futures	316.001	318.352	311.409	311.737	11382.0
2019-01-31	GSCI	Futures	470.11	474.11	466.16	466.16	31.0

> showing 50 of 115 rows — these rows as CSV

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