PREVIEW / futures_daily / 2020-07-29

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-29.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-29	ES	Futures	3618.76	3666.04	3606.66	3660.97	1218031.0
2020-07-29	NQ	Futures	12254.03	12418.55	12200.93	12388.96	368010.0
2020-07-29	YM	Futures	28180.1	28399.8	28064.4	28335.5	138125.0
2020-07-29	CL	Futures	30.01	30.33	29.87	30.11	295855.0
2020-07-29	GC	Futures	2328.8	2360.1	2309.7	2334.5	197823.0
2020-07-29	ZN	Futures	138.450281	138.620615	138.326402	138.496736	785966.0
2020-07-29	A6	Futures	0.73633	0.74045	0.73561	0.73767	89043.0
2020-07-29	AD	Futures	0.7588	0.76139	0.75835	0.75961	47981.0
2020-07-29	ALI	Futures	2107.41	2110.75	2098.01	2107.11	351.0
2020-07-29	B	Futures	28.17	28.55	28.08	28.42	196521.0
2020-07-29	B6	Futures	1.3135	1.3217	1.3115	1.3167	111129.0
2020-07-29	BR	Futures	0.15392	0.15467	0.15273	0.15316	10583.0
2020-07-29	BTC	Futures	15363.4	15808.0	15130.8	15630.2	3530.0
2020-07-29	BZ	Futures	27.49	27.88	27.43	27.76	17371.0
2020-07-29	C	Futures	1420.0	1471.0	1418.0	1460.0	8951.0
2020-07-29	CB	Futures	185.652	185.652	181.025	181.613	59.0
2020-07-29	CC	Futures	1509.0	1551.0	1508.0	1535.0	19208.0
2020-07-29	CNH	Futures	6.9203	6.9203	6.9074	6.9126	172.0
2020-07-29	CSC	Futures	4.141	4.141	4.039	4.039	86.0
2020-07-29	CT	Futures	61.89	61.89	61.69	61.72	5.0
2020-07-29	DC	Futures	33.94	34.11	32.99	32.99	556.0
2020-07-29	DX	Futures	90.518	90.575	89.948	90.249	24754.0
2020-07-29	E1	Futures	1.23943	1.24749	1.23784	1.24443	29680.0
2020-07-29	E6	Futures	1.25892	1.2682	1.25822	1.26375	219881.0
2020-07-29	E7	Futures	1.2524	1.2618	1.2519	1.2575	8201.0
2020-07-29	EBM	Futures	217.06	219.45	216.76	217.66	11794.0
2020-07-29	ED	Futures	96.433	96.4427	96.4282	96.4378	105847.0
2020-07-29	ER	Futures	98.372	98.382	98.372	98.377	40935.0
2020-07-29	ESG	Futures	292.7	294.61	292.7	294.59	24.0
2020-07-29	EW	Futures	1969.1	2009.3	1961.9	2005.8	8876.0
2020-07-29	FBON	Futures	146.28	146.48	146.25	146.37	22.0
2020-07-29	FBTP	Futures	132.87	133.06	132.54	132.99	52872.0
2020-07-29	FBTS	Futures	108.822	108.871	108.774	108.861	31480.0
2020-07-29	FCE	Futures	4747.0	4810.7	4747.0	4789.5	44406.0
2020-07-29	FDAX	Futures	13590.6	13675.6	13535.9	13626.7	59845.0
2020-07-29	FDIV	Futures	145.97	146.49	145.97	146.49	100.0
2020-07-29	FDXM	Futures	13533.6	13626.8	13480.7	13577.5	33510.0
2020-07-29	FESX	Futures	3035.2	3057.3	3024.1	3045.3	552869.0
2020-07-29	FGBL	Futures	169.26	169.39	168.95	169.07	431543.0
2020-07-29	FGBM	Futures	134.99	135.05	134.89	134.96	302759.0
2020-07-29	FGBS	Futures	112.769	112.785	112.754	112.764	224452.0
2020-07-29	FGBX	Futures	231.04	231.61	229.61	230.11	34291.0
2020-07-29	FMWO	Futures	8048.0	8148.7	8048.0	8120.3	1178.0
2020-07-29	FOAT	Futures	156.59	156.69	156.24	156.35	105103.0
2020-07-29	FTDX	Futures	3038.8	3135.4	3038.8	3135.4	8.0
2020-07-29	FTI	Futures	524.18	527.87	523.71	525.2	15224.0
2020-07-29	FTUK	Futures	5741.7	5790.4	5735.6	5766.3	62333.0
2020-07-29	FVSA	Futures	234.37	236.18	230.3	232.11	7406.0
2020-07-29	FXXP	Futures	337.7	339.8	337.7	338.6	28665.0
2020-07-29	G	Futures	127.98	128.1	127.77	127.83	154268.0

> showing 50 of 120 rows — these rows as CSV

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