PREVIEW / futures_daily / 2020-07-31

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-31.parquet
  size:    10 KB
  rows:    112

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-31	ES	Futures	3679.83	3684.89	3615.95	3673.35	2282794.0
2020-07-31	NQ	Futures	12658.51	12696.24	12408.4	12639.94	631553.0
2020-07-31	YM	Futures	28307.7	28353.7	27762.2	28205.8	235903.0
2020-07-31	CL	Futures	29.44	29.59	28.94	29.38	318788.0
2020-07-31	GC	Futures	2330.8	2368.4	2328.2	2345.4	279319.0
2020-07-31	ZN	Futures	138.713524	138.930312	138.620615	138.821918	1257506.0
2020-07-31	A6	Futures	0.73983	0.74364	0.73386	0.7352	116695.0
2020-07-31	AD	Futures	0.75611	0.75916	0.7555	0.75845	86822.0
2020-07-31	ALI	Futures	2099.83	2107.41	2092.85	2101.04	36.0
2020-07-31	B	Futures	28.16	28.23	27.67	28.06	196616.0
2020-07-31	B6	Futures	1.33	1.3377	1.3274	1.331	148309.0
2020-07-31	BR	Futures	0.15316	0.15368	0.15122	0.15182	5236.0
2020-07-31	BTC	Futures	15500.2	16109.0	15329.2	15883.3	9692.0
2020-07-31	BZ	Futures	27.47	27.65	27.03	27.4	23641.0
2020-07-31	C	Futures	1459.0	1476.0	1457.0	1472.0	4933.0
2020-07-31	CC	Futures	1555.0	1587.0	1547.0	1574.0	19622.0
2020-07-31	CNH	Futures	6.9078	6.9078	6.8889	6.9014	415.0
2020-07-31	CSC	Futures	3.944	3.944	3.889	3.936	73.0
2020-07-31	CT	Futures	63.33	63.34	62.66	63.01	6.0
2020-07-31	DC	Futures	31.89	32.27	31.67	32.27	262.0
2020-07-31	DX	Futures	89.614	90.339	89.358	90.142	28572.0
2020-07-31	E1	Futures	1.2509	1.25567	1.24284	1.24431	44769.0
2020-07-31	E6	Futures	1.27201	1.27898	1.26321	1.26611	320893.0
2020-07-31	E7	Futures	1.2654	1.2726	1.257	1.2598	10531.0
2020-07-31	EBM	Futures	219.75	220.95	218.26	218.85	10185.0
2020-07-31	ED	Futures	96.4475	96.4572	96.4475	96.4523	106065.0
2020-07-31	ER	Futures	98.382	98.386	98.377	98.382	20835.0
2020-07-31	ESG	Futures	295.66	296.55	291.88	296.55	547.0
2020-07-31	EW	Futures	1998.5	1998.5	1948.7	1978.8	20346.0
2020-07-31	FBON	Futures	146.91	147.03	146.4	146.49	82.0
2020-07-31	FBTP	Futures	133.4	133.58	132.66	132.96	73339.0
2020-07-31	FBTS	Futures	108.88	108.909	108.735	108.803	51078.0
2020-07-31	FCE	Futures	4658.5	4737.3	4586.0	4620.8	83934.0
2020-07-31	FDAX	Futures	13270.8	13297.9	12960.6	13121.0	98096.0
2020-07-31	FDXM	Futures	13229.8	13248.8	12913.3	13073.7	53001.0
2020-07-31	FEU3	Futures	99.129	99.134	99.129	99.134	75.0
2020-07-31	FGBL	Futures	169.79	170.08	169.35	169.61	574593.0
2020-07-31	FGBM	Futures	135.22	135.3	135.09	135.19	370603.0
2020-07-31	FGBS	Futures	112.84	112.86	112.805	112.835	347916.0
2020-07-31	FGBX	Futures	233.08	233.84	231.01	231.84	49695.0
2020-07-31	FOAT	Futures	156.99	157.0	156.32	156.62	178747.0
2020-07-31	FTI	Futures	509.74	518.76	503.76	507.83	29384.0
2020-07-31	FTUK	Futures	5693.0	5693.0	5496.4	5563.5	120009.0
2020-07-31	G	Futures	128.23	128.37	127.87	128.09	181089.0
2020-07-31	GF	Futures	277.493	280.885	276.524	280.449	1481.0
2020-07-31	GSCI	Futures	337.33	337.33	335.4	335.84	44.0
2020-07-31	HE	Futures	34.779	35.356	34.677	35.288	5689.0
2020-07-31	HG	Futures	3.2587	3.271	3.1761	3.2001	79683.0
2020-07-31	HH	Futures	9.377	9.418	9.138	9.148	1155.0
2020-07-31	HO	Futures	0.7241	0.732	0.7192	0.7233	51407.0

> showing 50 of 112 rows — these rows as CSV

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