PREVIEW / futures_daily / 2019-10-14

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-14.parquet
  size:    10 KB
  rows:    119

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-10-14	ES	Futures	3213.06	3228.76	3197.63	3210.35	833670.0
2019-10-14	NQ	Futures	9046.79	9098.07	8996.95	9055.15	311101.0
2019-10-14	YM	Futures	28093.5	28233.1	27963.3	28077.7	123162.0
2019-10-14	CL	Futures	56.16	56.18	54.0	54.81	186989.0
2019-10-14	GC	Futures	1840.5	1852.2	1834.4	1847.4	228323.0
2019-10-14	ZN	Futures	128.892246	129.418716	128.76837	129.04709	451647.0
2019-10-14	A6	Futures	0.69886	0.69907	0.69393	0.69629	82727.0
2019-10-14	AD	Futures	0.76368	0.76393	0.76116	0.76171	54135.0
2019-10-14	ALI	Futures	2076.82	2079.84	2069.27	2079.84	67.0
2019-10-14	B	Futures	48.08	48.11	46.34	47.02	283065.0
2019-10-14	B6	Futures	1.2883	1.289	1.2752	1.2813	132123.0
2019-10-14	BR	Futures	0.19623	0.19623	0.19493	0.19513	64.0
2019-10-14	BTC	Futures	11872.9	12131.8	11822.6	12016.7	1774.0
2019-10-14	BZ	Futures	47.3	47.45	45.7	46.36	39154.0
2019-10-14	C	Futures	1702.0	1703.0	1662.0	1671.0	9129.0
2019-10-14	CB	Futures	247.983	247.983	247.393	247.393	14.0
2019-10-14	CC	Futures	1636.0	1637.0	1601.0	1607.0	16958.0
2019-10-14	CNH	Futures	7.0726	7.0896	7.0478	7.0631	1263.0
2019-10-14	CSC	Futures	3.234	3.255	3.224	3.228	269.0
2019-10-14	CT	Futures	62.49	64.1	60.53	60.56	33245.0
2019-10-14	DC	Futures	26.93	27.17	26.87	26.94	307.0
2019-10-14	DX	Futures	94.758	94.976	94.758	94.884	11242.0
2019-10-14	E1	Futures	1.1599	1.16232	1.15772	1.15933	19408.0
2019-10-14	E6	Futures	1.20152	1.2019	1.1987	1.2006	102714.0
2019-10-14	E7	Futures	1.1951	1.1957	1.1925	1.1944	2061.0
2019-10-14	EBM	Futures	197.55	198.1	195.91	197.28	29327.0
2019-10-14	ED	Futures	95.3326	95.3666	95.3277	95.3423	83316.0
2019-10-14	ER	Futures	98.435	98.445	98.426	98.431	43173.0
2019-10-14	EW	Futures	2015.1	2023.0	1998.1	2005.6	6255.0
2019-10-14	FBON	Futures	145.28	145.75	145.28	145.47	206.0
2019-10-14	FBTP	Futures	131.63	131.82	131.36	131.64	55191.0
2019-10-14	FBTS	Futures	108.5	108.5	108.413	108.471	17854.0
2019-10-14	FCE	Futures	5128.7	5128.7	5078.3	5118.3	95800.0
2019-10-14	FDAX	Futures	13158.3	13187.9	13058.1	13157.3	81028.0
2019-10-14	FDIV	Futures	149.2	150.17	149.2	150.17	80.0
2019-10-14	FDXM	Futures	12991.2	13011.0	12888.1	12985.5	34774.0
2019-10-14	FESX	Futures	3111.5	3118.5	3086.0	3108.0	740463.0
2019-10-14	FGBL	Futures	166.52	167.06	166.46	166.71	405054.0
2019-10-14	FGBM	Futures	134.57	134.79	134.55	134.62	349458.0
2019-10-14	FGBS	Futures	112.89	112.925	112.865	112.875	240291.0
2019-10-14	FGBX	Futures	218.33	220.74	218.33	219.57	31074.0
2019-10-14	FMWO	Futures	7261.9	7267.6	7226.6	7258.5	3697.0
2019-10-14	FOAT	Futures	153.94	154.15	153.79	153.89	74708.0
2019-10-14	FTDX	Futures	2751.1	2763.9	2736.3	2759.0	72.0
2019-10-14	FTI	Futures	547.74	547.74	543.87	546.98	9065.0
2019-10-14	FTUK	Futures	6688.8	6704.1	6643.4	6659.1	84769.0
2019-10-14	FVSA	Futures	176.27	178.92	170.96	173.08	37880.0
2019-10-14	FXXP	Futures	352.4	352.4	349.0	351.3	45824.0
2019-10-14	G	Futures	121.41	121.79	121.28	121.46	158745.0
2019-10-14	GF	Futures	302.105	307.391	301.634	305.821	4936.0

> showing 50 of 119 rows — these rows as CSV

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