PREVIEW / futures_daily / 2019-08-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-20.parquet
  size:    10 KB
  rows:    120

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-20	ES	Futures	3152.19	3164.06	3123.06	3127.38	1475214.0
2019-08-20	NQ	Futures	8885.06	8925.07	8813.97	8828.36	414176.0
2019-08-20	YM	Futures	27407.8	27508.6	27179.9	27228.2	157400.0
2019-08-20	CL	Futures	57.65	58.13	56.65	57.65	659258.0
2019-08-20	GC	Futures	1858.1	1873.5	1854.0	1869.7	247535.0
2019-08-20	ZN	Futures	129.757729	130.348739	129.757729	130.130999	1318349.0
2019-08-20	A6	Futures	0.69678	0.69966	0.69545	0.69761	47914.0
2019-08-20	AD	Futures	0.75672	0.75768	0.75561	0.75723	60837.0
2019-08-20	ALI	Futures	2197.55	2197.55	2170.53	2182.37	301.0
2019-08-20	B	Futures	45.02	45.5	44.47	45.29	245249.0
2019-08-20	B6	Futures	1.2391	1.2449	1.2328	1.2432	120956.0
2019-08-20	BR	Futures	0.19632	0.19824	0.1958	0.1976	7051.0
2019-08-20	BTC	Futures	14821.6	15165.8	14580.6	14835.3	2558.0
2019-08-20	BZ	Futures	44.49	44.92	43.9	44.7	30782.0
2019-08-20	C	Futures	1540.0	1545.0	1526.0	1529.0	2728.0
2019-08-20	CB	Futures	275.699	275.991	274.824	274.824	70.0
2019-08-20	CC	Futures	1432.0	1440.0	1421.0	1427.0	23026.0
2019-08-20	CNH	Futures	7.0786	7.0831	7.0736	7.0769	286.0
2019-08-20	CSC	Futures	3.112	3.125	3.085	3.09	148.0
2019-08-20	CT	Futures	58.85	59.02	58.43	58.43	24.0
2019-08-20	DC	Futures	26.16	26.26	25.85	25.98	418.0
2019-08-20	DX	Futures	94.586	94.678	94.346	94.416	11519.0
2019-08-20	E1	Futures	1.18441	1.18916	1.18429	1.18835	16306.0
2019-08-20	E6	Futures	1.21087	1.21409	1.20956	1.213	130817.0
2019-08-20	E7	Futures	1.205	1.2077	1.2032	1.2067	2695.0
2019-08-20	EBM	Futures	190.87	192.02	190.0	190.58	9799.0
2019-08-20	ED	Futures	95.4061	95.4255	95.4036	95.4134	196916.0
2019-08-20	ER	Futures	98.548	98.553	98.543	98.548	55105.0
2019-08-20	EW	Futures	1986.5	1992.5	1967.7	1970.8	9493.0
2019-08-20	FBON	Futures	146.29	146.8	146.26	146.65	447.0
2019-08-20	FBTP	Futures	126.57	128.23	126.25	127.82	93463.0
2019-08-20	FBTS	Futures	107.379	107.686	107.35	107.638	49129.0
2019-08-20	FCE	Futures	4864.6	4882.7	4825.2	4840.1	63439.0
2019-08-20	FDAX	Futures	12293.6	12383.1	12226.7	12259.9	96579.0
2019-08-20	FDIV	Futures	140.94	140.94	140.11	140.29	60.0
2019-08-20	FDXM	Futures	12142.2	12231.6	12073.5	12108.9	39145.0
2019-08-20	FESX	Futures	2930.5	2949.7	2913.9	2921.7	852236.0
2019-08-20	FEU3	Futures	99.179	99.183	99.174	99.174	298.0
2019-08-20	FGBL	Futures	169.43	170.38	169.43	170.11	638606.0
2019-08-20	FGBM	Futures	136.0	136.24	135.99	136.15	361917.0
2019-08-20	FGBS	Futures	113.373	113.408	113.373	113.393	195832.0
2019-08-20	FGBX	Futures	227.31	230.04	226.86	229.03	61856.0
2019-08-20	FMWO	Futures	7166.4	7194.1	7130.6	7159.5	3261.0
2019-08-20	FOAT	Futures	155.84	156.61	155.77	156.38	112870.0
2019-08-20	FTDX	Futures	2714.1	2726.4	2690.9	2693.3	94.0
2019-08-20	FTI	Futures	518.43	520.13	514.26	515.6	20023.0
2019-08-20	FTUK	Futures	6612.6	6667.1	6548.4	6564.6	109197.0
2019-08-20	FVSA	Futures	213.21	220.73	210.7	216.34	46631.0
2019-08-20	FXXP	Futures	335.1	335.9	331.6	332.4	55611.0
2019-08-20	G	Futures	123.76	124.28	123.7	123.86	208845.0

> showing 50 of 120 rows — these rows as CSV

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