PREVIEW / futures_daily / 2020-07-23

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-23.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
2020-07-23	ES	Futures	3678.14	3696.99	3617.92	3632.83	1704453.0
2020-07-23	NQ	Futures	12592.94	12695.66	12203.54	12242.72	644189.0
2020-07-23	YM	Futures	28812.4	28996.8	28345.2	28445.9	193084.0
2020-07-23	CL	Futures	30.61	30.91	29.79	29.97	389412.0
2020-07-23	GC	Futures	2247.1	2278.4	2236.9	2269.2	418749.0
2020-07-23	ZN	Futures	138.279948	138.450281	138.264463	138.372857	661255.0
2020-07-23	A6	Futures	0.73448	0.73685	0.72954	0.73129	103939.0
2020-07-23	AD	Futures	0.75672	0.76038	0.75606	0.75819	63542.0
2020-07-23	ALI	Futures	2064.93	2078.28	2062.8	2074.33	319.0
2020-07-23	B	Futures	28.73	29.17	28.1	28.22	262235.0
2020-07-23	B6	Futures	1.2932	1.2961	1.2872	1.2942	96255.0
2020-07-23	BR	Futures	0.15522	0.15633	0.15162	0.15237	1003.0
2020-07-23	BTC	Futures	12980.9	13407.9	12980.9	13290.8	6653.0
2020-07-23	BZ	Futures	28.25	28.52	27.47	27.59	25759.0
2020-07-23	C	Futures	1403.0	1425.0	1390.0	1403.0	5293.0
2020-07-23	CB	Futures	189.397	191.777	189.397	191.777	12.0
2020-07-23	CC	Futures	1449.0	1462.0	1427.0	1444.0	10788.0
2020-07-23	CNH	Futures	6.9264	6.9291	6.9083	6.9247	809.0
2020-07-23	CSC	Futures	4.306	4.326	4.267	4.326	98.0
2020-07-23	CT	Futures	63.64	63.65	62.38	62.38	40.0
2020-07-23	DC	Futures	35.78	35.78	34.96	35.58	448.0
2020-07-23	DX	Futures	91.72	91.908	91.319	91.425	17883.0
2020-07-23	E1	Futures	1.22421	1.23012	1.22319	1.22921	18532.0
2020-07-23	E6	Futures	1.24331	1.24899	1.23971	1.24706	232205.0
2020-07-23	E7	Futures	1.2373	1.2427	1.2336	1.2408	8534.0
2020-07-23	EBM	Futures	220.05	220.65	219.15	219.75	11511.0
2020-07-23	ED	Futures	96.4185	96.4378	96.4185	96.433	117419.0
2020-07-23	ER	Futures	98.372	98.372	98.367	98.372	20476.0
2020-07-23	ESG	Futures	296.19	296.72	291.75	292.64	72.0
2020-07-23	EW	Futures	1981.8	2004.1	1963.1	1979.6	13018.0
2020-07-23	FBON	Futures	146.6	146.88	145.81	146.69	63.0
2020-07-23	FBTP	Futures	132.65	133.24	132.54	133.12	87194.0
2020-07-23	FBTS	Futures	108.89	108.929	108.822	108.9	38785.0
2020-07-23	FCE	Futures	4878.4	4910.8	4807.4	4861.5	45870.0
2020-07-23	FDAX	Futures	13943.3	14032.0	13748.3	13921.0	80792.0
2020-07-23	FDIV	Futures	151.52	151.52	150.52	150.52	50.0
2020-07-23	FDXM	Futures	13905.1	13982.4	13697.7	13870.7	49806.0
2020-07-23	FESX	Futures	3111.8	3134.9	3072.1	3108.1	797748.0
2020-07-23	FGBL	Futures	168.92	169.01	168.72	168.85	404222.0
2020-07-23	FGBM	Futures	134.92	134.97	134.81	134.84	338148.0
2020-07-23	FGBS	Futures	112.769	112.78	112.729	112.734	244712.0
2020-07-23	FGBX	Futures	229.3	229.65	228.64	229.28	33652.0
2020-07-23	FMWO	Futures	8165.3	8212.7	8050.3	8168.9	1844.0
2020-07-23	FOAT	Futures	156.33	156.46	156.27	156.36	128701.0
2020-07-23	FTDX	Futures	3225.3	3227.9	3183.4	3217.1	33.0
2020-07-23	FTI	Futures	535.53	540.53	530.07	536.63	21616.0
2020-07-23	FTUK	Futures	5831.5	5901.4	5783.8	5844.2	77160.0
2020-07-23	FVSA	Futures	228.04	240.71	222.61	227.58	15435.0
2020-07-23	FXXP	Futures	344.7	346.5	340.5	344.2	44481.0
2020-07-23	G	Futures	127.76	127.98	127.7	127.78	172181.0

> showing 50 of 119 rows — these rows as CSV

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