PREVIEW / futures_daily / 2019-08-26

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-26.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-08-26	ES	Futures	3054.81	3116.86	3032.42	3111.19	1850231.0
2019-08-26	NQ	Futures	8560.1	8780.0	8465.98	8739.13	617907.0
2019-08-26	YM	Futures	26735.8	27286.0	26529.9	27240.8	279427.0
2019-08-26	CL	Futures	54.69	56.75	54.39	55.09	679022.0
2019-08-26	GC	Futures	1906.3	1930.5	1893.3	1896.2	411668.0
2019-08-26	ZN	Futures	130.706456	131.00196	130.146552	130.177657	2771285.0
2019-08-26	A6	Futures	0.69359	0.69884	0.68866	0.6974	100516.0
2019-08-26	AD	Futures	0.75864	0.76121	0.75702	0.76025	72215.0
2019-08-26	ALI	Futures	2164.77	2164.77	2164.77	2164.77	0.0
2019-08-26	B	Futures	44.77	46.04	44.6	44.89	137472.0
2019-08-26	B6	Futures	1.2538	1.2553	1.2472	1.2482	69245.0
2019-08-26	BR	Futures	0.19396	0.19396	0.19243	0.19348	3749.0
2019-08-26	BTC	Futures	14401.6	15494.6	14401.6	14958.8	777.0
2019-08-26	BZ	Futures	44.19	45.35	43.97	44.23	19059.0
2019-08-26	CB	Futures	263.482	264.634	261.563	264.073	82.0
2019-08-26	CC	Futures	1467.0	1496.0	1457.0	1469.0	15857.0
2019-08-26	CNH	Futures	7.1792	7.1811	7.1583	7.176	1570.0
2019-08-26	CSC	Futures	3.0	3.0	2.996	2.996	19.0
2019-08-26	CT	Futures	56.86	56.94	55.49	56.94	27.0
2019-08-26	DC	Futures	25.28	25.4	25.28	25.4	56.0
2019-08-26	DX	Futures	93.835	94.35	93.749	94.345	18897.0
2019-08-26	E1	Futures	1.19461	1.19612	1.18359	1.18603	27551.0
2019-08-26	E6	Futures	1.21807	1.21987	1.21224	1.21262	135087.0
2019-08-26	E7	Futures	1.2116	1.2134	1.2058	1.2063	2611.0
2019-08-26	EBM	Futures	190.0	192.31	190.0	191.44	11868.0
2019-08-26	ED	Futures	95.4255	95.4499	95.372	95.3744	260209.0
2019-08-26	ER	Futures	98.543	98.543	98.533	98.533	20859.0
2019-08-26	EW	Futures	1913.9	1957.8	1906.2	1945.1	15694.0
2019-08-26	FBON	Futures	146.15	146.64	146.02	146.22	114.0
2019-08-26	FBTP	Futures	128.36	129.03	127.56	128.04	41429.0
2019-08-26	FBTS	Futures	107.772	107.925	107.609	107.715	18399.0
2019-08-26	FCE	Futures	4769.0	4872.3	4769.0	4846.0	86081.0
2019-08-26	FDAX	Futures	12090.4	12313.6	12082.0	12274.1	103994.0
2019-08-26	FDIV	Futures	140.34	140.34	139.92	140.25	60.0
2019-08-26	FDXM	Futures	11949.8	12161.9	11926.9	12122.9	50039.0
2019-08-26	FESX	Futures	2876.3	2933.1	2869.3	2922.6	837659.0
2019-08-26	FGBL	Futures	170.28	170.4	169.46	169.75	448005.0
2019-08-26	FGBM	Futures	136.14	136.15	135.89	135.96	196714.0
2019-08-26	FGBS	Futures	113.363	113.373	113.318	113.343	131854.0
2019-08-26	FGBX	Futures	230.26	231.62	227.56	228.8	62962.0
2019-08-26	FMWO	Futures	7003.7	7115.6	7003.7	7078.7	1597.0
2019-08-26	FOAT	Futures	156.24	156.24	155.68	155.96	48212.0
2019-08-26	FTDX	Futures	2660.8	2691.9	2645.0	2684.0	150.0
2019-08-26	FTI	Futures	506.73	516.2	505.88	514.0	31552.0
2019-08-26	FVSA	Futures	240.8	240.8	222.61	233.9	42892.0
2019-08-26	FXXP	Futures	328.6	333.9	328.6	332.7	51796.0
2019-08-26	GF	Futures	275.222	277.766	273.747	276.749	3180.0
2019-08-26	GSCI	Futures	447.02	448.14	443.08	443.08	12.0
2019-08-26	HE	Futures	57.423	60.182	57.423	60.182	25772.0
2019-08-26	HG	Futures	2.877	2.9135	2.8474	2.9055	43711.0

> showing 50 of 115 rows — these rows as CSV

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