PREVIEW / futures_daily / 2019-11-22

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-22.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-22	ES	Futures	3360.29	3371.66	3353.52	3368.41	995416.0
2019-11-22	NQ	Futures	9542.33	9580.65	9488.17	9542.62	344497.0
2019-11-22	YM	Futures	29135.9	29272.4	29102.3	29249.3	128358.0
2019-11-22	CL	Futures	59.54	59.98	58.71	58.99	508244.0
2019-11-22	GC	Futures	1806.3	1817.5	1802.5	1805.4	320504.0
2019-11-22	ZN	Futures	128.303838	128.536104	128.164478	128.288354	2350148.0
2019-11-22	A6	Futures	0.69691	0.69845	0.69609	0.6966	61736.0
2019-11-22	AD	Futures	0.75834	0.76005	0.75718	0.75779	62055.0
2019-11-22	ALI	Futures	2143.59	2147.54	2142.68	2147.23	31.0
2019-11-22	B	Futures	50.74	51.26	50.23	50.56	228744.0
2019-11-22	B6	Futures	1.3135	1.3154	1.3045	1.3054	113409.0
2019-11-22	BR	Futures	0.19231	0.19356	0.19206	0.19295	34796.0
2019-11-22	BTC	Futures	11003.8	11169.8	9783.5	10585.0	9941.0
2019-11-22	BZ	Futures	50.09	50.59	49.56	49.87	33785.0
2019-11-22	C	Futures	1802.0	1805.0	1795.0	1802.0	3232.0
2019-11-22	CB	Futures	247.895	248.249	247.6	248.013	48.0
2019-11-22	CC	Futures	1724.0	1724.0	1709.0	1712.0	13213.0
2019-11-22	CNH	Futures	7.0204	7.0378	7.0157	7.0328	527.0
2019-11-22	CSC	Futures	3.359	3.384	3.354	3.377	65.0
2019-11-22	CT	Futures	61.66	61.93	60.61	61.73	236.0
2019-11-22	DC	Futures	28.05	28.29	28.04	28.19	374.0
2019-11-22	DX	Futures	94.584	94.927	94.43	94.89	11324.0
2019-11-22	E1	Futures	1.16013	1.16048	1.15427	1.15473	31277.0
2019-11-22	E6	Futures	1.20049	1.20434	1.1954	1.1961	166247.0
2019-11-22	E7	Futures	1.1943	1.1971	1.1892	1.19	3005.0
2019-11-22	EBM	Futures	196.46	197.01	196.19	196.46	18529.0
2019-11-22	ED	Futures	95.3302	95.3326	95.3132	95.3156	259940.0
2019-11-22	ER	Futures	98.401	98.406	98.396	98.401	75424.0
2019-11-22	ESG	Futures	276.74	276.74	276.74	276.74	10.0
2019-11-22	EW	Futures	2080.1	2090.3	2077.8	2086.0	9125.0
2019-11-22	FBON	Futures	142.53	143.11	142.39	143.11	308.0
2019-11-22	FBTP	Futures	129.08	129.39	128.85	129.15	77324.0
2019-11-22	FBTS	Futures	108.144	108.221	108.105	108.182	62481.0
2019-11-22	FCE	Futures	5324.0	5361.1	5319.0	5326.7	62694.0
2019-11-22	FDAX	Futures	13895.9	13975.5	13839.4	13886.9	92760.0
2019-11-22	FDIV	Futures	160.89	161.22	160.52	160.75	90.0
2019-11-22	FDXM	Futures	13704.5	13793.1	13659.8	13705.6	39298.0
2019-11-22	FESX	Futures	3229.9	3250.0	3225.5	3227.2	803846.0
2019-11-22	FGBL	Futures	164.85	165.45	164.52	165.42	687992.0
2019-11-22	FGBM	Futures	133.74	133.94	133.67	133.92	344764.0
2019-11-22	FGBS	Futures	112.669	112.704	112.664	112.699	219568.0
2019-11-22	FGBX	Futures	214.03	216.25	213.03	216.11	48398.0
2019-11-22	FMWO	Futures	7586.0	7599.7	7559.9	7563.3	2014.0
2019-11-22	FOAT	Futures	152.15	152.73	151.93	152.7	101522.0
2019-11-22	FTDX	Futures	2975.2	2979.1	2960.8	2970.7	77.0
2019-11-22	FTI	Futures	564.87	569.04	564.82	567.36	22891.0
2019-11-22	FTUK	Futures	6718.5	6803.3	6712.9	6786.1	104304.0
2019-11-22	FVSA	Futures	139.88	139.88	136.33	138.36	23280.0
2019-11-22	FXXP	Futures	364.0	366.4	363.9	365.1	47816.0
2019-11-22	G	Futures	120.29	121.11	120.14	120.97	343097.0

> showing 50 of 121 rows — these rows as CSV

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