PREVIEW / futures_daily / 2020-09-23

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-23.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
2020-09-23	ES	Futures	3711.7	3729.68	3618.73	3630.25	1979661.0
2020-09-23	NQ	Futures	12920.61	12991.81	12487.05	12536.83	656111.0
2020-09-23	YM	Futures	29303.4	29489.7	28621.9	28728.5	235983.0
2020-09-23	CL	Futures	28.55	29.26	28.19	28.67	318754.0
2020-09-23	GC	Futures	2249.9	2255.6	2192.0	2206.6	411558.0
2020-09-23	ZN	Futures	138.40418	138.528156	138.249209	138.357689	980781.0
2020-09-23	A6	Futures	0.73605	0.73697	0.72578	0.7266	108881.0
2020-09-23	AD	Futures	0.76191	0.76247	0.75725	0.75761	77296.0
2020-09-23	ALI	Futures	2123.42	2129.66	2105.89	2112.72	384.0
2020-09-23	B	Futures	26.56	27.17	26.27	26.63	183876.0
2020-09-23	B6	Futures	1.292	1.2961	1.2856	1.2898	107173.0
2020-09-23	BR	Futures	0.1423	0.1423	0.14077	0.14081	9.0
2020-09-23	BTC	Futures	14237.6	14244.3	13690.8	13879.8	7721.0
2020-09-23	BZ	Futures	26.03	26.59	25.72	26.05	23779.0
2020-09-23	C	Futures	1648.0	1674.0	1637.0	1659.0	6531.0
2020-09-23	CB	Futures	170.754	171.135	168.721	169.763	45.0
2020-09-23	CC	Futures	1677.0	1706.0	1669.0	1694.0	13939.0
2020-09-23	CNH	Futures	6.6768	6.7172	6.6768	6.7172	546.0
2020-09-23	CSC	Futures	3.401	3.405	3.375	3.377	35.0
2020-09-23	CT	Futures	64.1	64.48	64.1	64.48	2.0
2020-09-23	DC	Futures	27.6	27.89	27.41	27.62	219.0
2020-09-23	DX	Futures	90.83	91.279	90.767	91.228	30722.0
2020-09-23	E1	Futures	1.23412	1.23503	1.2279	1.22801	27189.0
2020-09-23	E6	Futures	1.25625	1.25749	1.2502	1.2509	204073.0
2020-09-23	E7	Futures	1.2499	1.2511	1.2437	1.2446	9265.0
2020-09-23	EBM	Futures	234.17	235.08	233.27	233.87	30889.0
2020-09-23	ED	Futures	96.46	96.4697	96.4552	96.46	226908.0
2020-09-23	ER	Futures	98.435	98.445	98.431	98.431	51738.0
2020-09-23	ESG	Futures	308.87	308.87	299.39	299.47	49.0
2020-09-23	EW	Futures	1949.7	1970.1	1907.7	1908.7	14764.0
2020-09-23	FBON	Futures	148.17	148.59	148.09	148.23	573.0
2020-09-23	FBTP	Futures	135.25	135.74	135.23	135.41	108427.0
2020-09-23	FBTS	Futures	109.344	109.421	109.344	109.382	60223.0
2020-09-23	FCE	Futures	4673.0	4716.2	4607.6	4648.3	63320.0
2020-09-23	FDAX	Futures	13497.2	13657.1	13334.1	13466.8	81892.0
2020-09-23	FDIV	Futures	146.68	146.68	145.36	145.36	100.0
2020-09-23	FDXM	Futures	13415.9	13587.7	13266.3	13398.9	44451.0
2020-09-23	FESX	Futures	2934.4	2968.6	2901.1	2930.7	896005.0
2020-09-23	FGBL	Futures	169.59	169.84	169.4	169.42	574539.0
2020-09-23	FGBM	Futures	135.14	135.22	135.06	135.07	263584.0
2020-09-23	FGBS	Futures	112.8	112.8	112.764	112.769	225263.0
2020-09-23	FGBX	Futures	230.53	231.72	230.13	230.22	51479.0
2020-09-23	FMWO	Futures	8229.4	8281.5	8074.2	8204.5	965.0
2020-09-23	FOAT	Futures	157.77	158.01	157.57	157.64	130489.0
2020-09-23	FTDX	Futures	3140.4	3142.9	3097.7	3124.9	14.0
2020-09-23	FTI	Futures	509.05	512.96	503.13	508.24	22431.0
2020-09-23	FTUK	Futures	5591.2	5682.9	5558.7	5617.0	117817.0
2020-09-23	FVSA	Futures	204.3	217.3	202.07	206.53	11971.0
2020-09-23	FXXP	Futures	332.4	335.3	328.7	331.9	55385.0
2020-09-23	G	Futures	126.97	127.34	126.75	126.76	186377.0

> showing 50 of 120 rows — these rows as CSV

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