PREVIEW / futures_daily / 2020-07-01

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-01.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-01	ES	Futures	3472.72	3509.3	3447.39	3492.7	1537321.0
2020-07-01	NQ	Futures	11770.05	11966.19	11694.6	11918.32	402791.0
2020-07-01	YM	Futures	27492.1	27749.3	27200.6	27408.5	218368.0
2020-07-01	CL	Futures	28.88	29.42	28.31	28.87	407170.0
2020-07-01	GC	Futures	2159.8	2170.4	2122.6	2137.0	263254.0
2020-07-01	ZN	Futures	137.908311	137.923795	137.552158	137.707007	1163129.0
2020-07-01	A6	Futures	0.71031	0.71452	0.70763	0.71154	99345.0
2020-07-01	AD	Futures	0.74774	0.74946	0.74642	0.74723	52700.0
2020-07-01	ALI	Futures	1982.48	1989.43	1966.46	1972.81	701.0
2020-07-01	B	Futures	27.09	27.77	26.73	27.38	252515.0
2020-07-01	B6	Futures	1.2596	1.2687	1.2555	1.2668	84726.0
2020-07-01	BR	Futures	0.14441	0.14873	0.14441	0.14857	163.0
2020-07-01	BTC	Futures	12671.0	12932.7	12588.4	12843.2	4789.0
2020-07-01	BZ	Futures	26.57	27.15	26.13	26.77	26731.0
2020-07-01	C	Futures	1547.0	1547.0	1520.0	1532.0	5507.0
2020-07-01	CB	Futures	204.348	204.348	201.673	202.824	30.0
2020-07-01	CC	Futures	1431.0	1437.0	1415.0	1423.0	18819.0
2020-07-01	CNH	Futures	6.9913	6.9976	6.9791	6.9914	329.0
2020-07-01	CSC	Futures	3.757	3.78	3.743	3.78	35.0
2020-07-01	CT	Futures	62.38	63.8	62.32	63.8	18.0
2020-07-01	DC	Futures	30.79	31.35	30.7	31.31	264.0
2020-07-01	DX	Futures	94.058	94.289	93.681	93.845	16047.0
2020-07-01	E1	Futures	1.20161	1.20513	1.19889	1.20275	20537.0
2020-07-01	E6	Futures	1.20714	1.21181	1.20199	1.20859	176435.0
2020-07-01	E7	Futures	1.2013	1.2057	1.196	1.2026	6309.0
2020-07-01	EBM	Futures	217.06	218.26	214.96	217.36	16566.0
2020-07-01	ED	Futures	96.4088	96.4137	96.3992	96.4088	126106.0
2020-07-01	ER	Futures	98.382	98.386	98.372	98.377	61659.0
2020-07-01	ESG	Futures	281.77	283.17	281.13	282.0	141.0
2020-07-01	EW	Futures	1888.2	1905.0	1866.3	1877.1	16924.0
2020-07-01	FBON	Futures	144.92	144.92	144.26	144.44	354.0
2020-07-01	FBTP	Futures	129.86	130.16	129.66	129.81	61640.0
2020-07-01	FBTS	Futures	108.415	108.434	108.357	108.376	28301.0
2020-07-01	FCE	Futures	4814.4	4843.3	4731.6	4807.1	84845.0
2020-07-01	FDAX	Futures	13094.4	13160.8	12817.1	12982.9	87686.0
2020-07-01	FDXM	Futures	13050.9	13111.2	12772.5	12936.0	31502.0
2020-07-01	FESX	Futures	2977.0	2992.7	2918.8	2959.5	963390.0
2020-07-01	FEU3	Futures	99.124	99.124	99.119	99.119	120.0
2020-07-01	FGBL	Futures	168.3	168.35	167.4	167.48	550704.0
2020-07-01	FGBM	Futures	134.8	134.86	134.47	134.5	462441.0
2020-07-01	FGBS	Futures	112.774	112.795	112.704	112.714	344846.0
2020-07-01	FGBX	Futures	224.97	225.32	222.68	222.99	50327.0
2020-07-01	FMWO	Futures	7718.5	7774.2	7651.0	7728.0	2893.0
2020-07-01	FOAT	Futures	155.26	155.33	154.55	154.62	121695.0
2020-07-01	FTDX	Futures	3011.3	3015.9	2978.6	3010.2	75.0
2020-07-01	FTI	Futures	518.43	524.36	513.42	521.72	28187.0
2020-07-01	FTUK	Futures	5798.4	5824.9	5709.1	5782.3	101453.0
2020-07-01	FVSA	Futures	276.27	282.1	256.53	267.3	15928.0
2020-07-01	FXXP	Futures	330.8	334.0	327.4	331.4	79640.0
2020-07-01	G	Futures	126.87	127.04	126.61	126.73	222342.0

> showing 50 of 119 rows — these rows as CSV

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