PREVIEW / futures_daily / 2019-11-21

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-21.parquet
  size:    10 KB
  rows:    121

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-11-21	ES	Futures	3352.98	3371.66	3346.49	3360.29	1434552.0
2019-11-21	NQ	Futures	9520.72	9574.31	9495.95	9535.71	411833.0
2019-11-21	YM	Futures	29106.5	29232.5	29030.9	29129.6	163143.0
2019-11-21	CL	Futures	58.2	59.91	57.79	59.82	593533.0
2019-11-21	GC	Futures	1819.6	1820.6	1803.9	1805.4	388337.0
2019-11-21	ZN	Futures	128.706433	128.892246	128.226416	128.319323	2582282.0
2019-11-21	A6	Futures	0.69773	0.69958	0.6964	0.6965	75637.0
2019-11-21	AD	Futures	0.75698	0.7592	0.75597	0.75869	88445.0
2019-11-21	ALI	Futures	2141.16	2147.23	2141.16	2142.98	25.0
2019-11-21	B	Futures	49.63	51.07	49.39	51.02	318487.0
2019-11-21	B6	Futures	1.3152	1.3197	1.3117	1.3128	90347.0
2019-11-21	BR	Futures	0.19166	0.19324	0.19117	0.1919	14395.0
2019-11-21	BTC	Futures	11711.3	11754.7	10628.3	10946.0	5630.0
2019-11-21	BZ	Futures	49.12	50.37	48.72	50.33	36374.0
2019-11-21	C	Futures	1787.0	1804.0	1781.0	1802.0	3679.0
2019-11-21	CB	Futures	248.042	248.249	247.836	247.836	16.0
2019-11-21	CC	Futures	1719.0	1733.0	1705.0	1728.0	14209.0
2019-11-21	CNH	Futures	7.0375	7.0418	7.0122	7.0194	1208.0
2019-11-21	CSC	Futures	3.314	3.364	3.299	3.354	363.0
2019-11-21	CT	Futures	60.45	61.08	60.09	60.19	7342.0
2019-11-21	DC	Futures	27.74	28.11	27.53	28.05	849.0
2019-11-21	DX	Futures	94.502	94.666	94.352	94.622	15469.0
2019-11-21	E1	Futures	1.16301	1.16485	1.15944	1.16013	24696.0
2019-11-21	E6	Futures	1.20217	1.2045	1.19952	1.20033	147805.0
2019-11-21	E7	Futures	1.196	1.1981	1.1933	1.1942	2332.0
2019-11-21	EBM	Futures	196.46	197.01	195.91	196.19	20143.0
2019-11-21	ED	Futures	95.3423	95.352	95.3229	95.3302	274831.0
2019-11-21	ER	Futures	98.406	98.406	98.396	98.401	60592.0
2019-11-21	ESG	Futures	277.1	277.42	275.76	276.27	92.0
2019-11-21	EW	Futures	2090.3	2102.1	2077.8	2080.7	11422.0
2019-11-21	FBON	Futures	142.93	143.04	142.61	142.66	442.0
2019-11-21	FBTP	Futures	129.09	129.5	128.97	129.29	107449.0
2019-11-21	FBTS	Futures	108.144	108.192	108.095	108.182	92307.0
2019-11-21	FCE	Futures	5298.6	5329.4	5273.3	5315.8	74192.0
2019-11-21	FDAX	Futures	13833.1	13908.0	13757.7	13884.3	108691.0
2019-11-21	FDIV	Futures	159.5	160.43	159.41	160.43	150.0
2019-11-21	FDXM	Futures	13653.5	13724.3	13579.6	13703.0	44411.0
2019-11-21	FESX	Futures	3212.3	3231.6	3198.3	3229.0	891406.0
2019-11-21	FGBL	Futures	165.42	165.53	164.76	164.95	690391.0
2019-11-21	FGBM	Futures	133.96	134.0	133.72	133.77	388862.0
2019-11-21	FGBS	Futures	112.724	112.729	112.664	112.679	268026.0
2019-11-21	FGBX	Futures	216.77	216.77	213.84	214.45	42506.0
2019-11-21	FMWO	Futures	7558.7	7586.0	7547.3	7559.9	3586.0
2019-11-21	FOAT	Futures	152.63	152.8	152.17	152.33	155159.0
2019-11-21	FTDX	Futures	2938.6	2955.4	2933.2	2954.4	68.0
2019-11-21	FTI	Futures	565.4	566.45	562.29	564.6	30505.0
2019-11-21	FTUK	Futures	6694.8	6718.0	6664.7	6700.9	97344.0
2019-11-21	FVSA	Futures	141.9	145.45	139.37	141.4	19803.0
2019-11-21	FXXP	Futures	363.0	364.5	361.6	363.7	56062.0
2019-11-21	G	Futures	120.82	120.86	120.2	120.45	262390.0

> showing 50 of 121 rows — these rows as CSV

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