PREVIEW / futures_daily / 2020-07-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-17.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-07-17	ES	Futures	3600.19	3630.3	3595.97	3617.64	1261113.0
2020-07-17	NQ	Futures	12224.15	12383.73	12214.28	12328.89	443143.0
2020-07-17	YM	Futures	28469.5	28639.9	28402.0	28421.3	151722.0
2020-07-17	CL	Futures	29.84	29.95	29.32	29.73	272444.0
2020-07-17	GC	Futures	2157.4	2177.8	2155.3	2173.1	167012.0
2020-07-17	ZN	Futures	138.187038	138.310917	138.063159	138.109614	566674.0
2020-07-17	A6	Futures	0.7172	0.7208	0.7171	0.72028	56228.0
2020-07-17	AD	Futures	0.74794	0.74845	0.74703	0.74779	37329.0
2020-07-17	ALI	Futures	2032.76	2039.43	2026.99	2038.83	275.0
2020-07-17	B	Futures	28.28	28.31	27.78	28.11	162402.0
2020-07-17	B6	Futures	1.2752	1.2772	1.2709	1.2767	50819.0
2020-07-17	BR	Futures	0.14873	0.14877	0.14698	0.14698	291.0
2020-07-17	BTC	Futures	12574.6	12698.6	12526.4	12664.1	1674.0
2020-07-17	BZ	Futures	27.61	27.68	27.15	27.48	21774.0
2020-07-17	C	Futures	1403.0	1434.0	1398.0	1406.0	5416.0
2020-07-17	CB	Futures	191.804	191.83	191.51	191.51	33.0
2020-07-17	CC	Futures	1423.0	1451.0	1415.0	1417.0	13169.0
2020-07-17	CNH	Futures	6.9104	6.9186	6.9053	6.9053	798.0
2020-07-17	CSC	Futures	4.151	4.166	4.141	4.151	23.0
2020-07-17	CT	Futures	63.67	63.67	62.71	62.71	10.0
2020-07-17	DC	Futures	34.16	34.38	33.79	34.08	301.0
2020-07-17	DX	Futures	92.981	93.014	92.58	92.622	11602.0
2020-07-17	E1	Futures	1.2032	1.21274	1.20263	1.21229	18093.0
2020-07-17	E6	Futures	1.22292	1.22952	1.22233	1.22882	150700.0
2020-07-17	E7	Futures	1.2168	1.2233	1.2163	1.2227	5582.0
2020-07-17	EBM	Futures	222.75	223.65	221.25	221.25	12789.0
2020-07-17	ED	Futures	96.4185	96.4185	96.4088	96.4137	79724.0
2020-07-17	ER	Futures	98.372	98.372	98.362	98.367	49635.0
2020-07-17	ESG	Futures	291.85	292.7	291.32	291.85	58.0
2020-07-17	EW	Futures	1938.6	1955.0	1934.9	1948.4	9616.0
2020-07-17	FBON	Futures	145.6	145.93	145.6	145.61	99.0
2020-07-17	FBTP	Futures	130.95	131.11	130.7	130.95	49684.0
2020-07-17	FBTS	Futures	108.531	108.551	108.454	108.541	25911.0
2020-07-17	FCE	Futures	4918.5	4922.9	4874.3	4896.3	97516.0
2020-07-17	FDAX	Futures	13721.2	13771.7	13656.4	13722.8	69846.0
2020-07-17	FDIV	Futures	148.48	148.96	148.48	148.96	100.0
2020-07-17	FDXM	Futures	13665.9	13721.0	13606.6	13673.3	41764.0
2020-07-17	FESX	Futures	3112.8	3115.5	3087.8	3101.7	813056.0
2020-07-17	FEU3	Futures	99.119	99.119	99.114	99.114	55.0
2020-07-17	FGBL	Futures	168.55	168.81	168.26	168.42	332214.0
2020-07-17	FGBM	Futures	134.81	134.91	134.68	134.75	240579.0
2020-07-17	FGBS	Futures	112.759	112.769	112.719	112.729	151833.0
2020-07-17	FGBX	Futures	227.1	228.05	226.17	226.6	28338.0
2020-07-17	FMWO	Futures	8012.4	8068.1	7995.8	8036.1	1387.0
2020-07-17	FOAT	Futures	156.01	156.14	155.73	155.83	100312.0
2020-07-17	FTDX	Futures	3151.2	3156.4	3146.6	3155.8	18.0
2020-07-17	FTI	Futures	536.42	537.31	532.64	534.18	23931.0
2020-07-17	FTUK	Futures	5886.3	5924.6	5854.2	5911.4	75187.0
2020-07-17	FVSA	Futures	252.47	255.18	241.61	247.04	10210.0
2020-07-17	FXXP	Futures	343.3	344.1	341.5	342.9	56639.0

> showing 50 of 120 rows — these rows as CSV

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