PREVIEW / futures_daily / 2020-07-20

all futures daily files

  file:    by_date/futures_daily/2020/2020-07-20.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-20	ES	Futures	3618.2	3658.72	3590.9	3652.81	1401168.0
2020-07-20	NQ	Futures	12327.44	12725.83	12240.39	12710.16	496402.0
2020-07-20	YM	Futures	28443.8	28565.9	28217.6	28542.4	168308.0
2020-07-20	CL	Futures	29.75	29.93	29.17	29.86	329773.0
2020-07-20	GC	Futures	2175.9	2189.2	2169.0	2182.0	177739.0
2020-07-20	ZN	Futures	138.109614	138.310917	138.078644	138.140584	531156.0
2020-07-20	A6	Futures	0.71926	0.72203	0.7173	0.72142	65531.0
2020-07-20	AD	Futures	0.74713	0.75063	0.74642	0.75012	44591.0
2020-07-20	ALI	Futures	2035.49	2047.93	2032.15	2043.08	502.0
2020-07-20	B	Futures	28.07	28.31	27.6	28.2	179430.0
2020-07-20	B6	Futures	1.2763	1.2865	1.2715	1.2864	86895.0
2020-07-20	BR	Futures	0.14742	0.14837	0.14678	0.14837	126.0
2020-07-20	BTC	Futures	12671.0	12781.2	12609.0	12657.2	2432.0
2020-07-20	BZ	Futures	27.45	27.66	26.99	27.57	18019.0
2020-07-20	C	Futures	1404.0	1421.0	1381.0	1418.0	6370.0
2020-07-20	CB	Futures	192.553	192.579	190.44	191.51	26.0
2020-07-20	CC	Futures	1418.0	1460.0	1402.0	1455.0	21834.0
2020-07-20	CNH	Futures	6.9042	6.9093	6.8994	6.9055	221.0
2020-07-20	CSC	Futures	4.154	4.297	4.154	4.297	49.0
2020-07-20	CT	Futures	63.3	63.78	63.3	63.71	10.0
2020-07-20	DC	Futures	34.11	35.36	33.96	35.36	361.0
2020-07-20	DX	Futures	92.73	92.87	92.416	92.509	18204.0
2020-07-20	E1	Futures	1.2107	1.21365	1.20899	1.21104	20696.0
2020-07-20	E6	Futures	1.22673	1.23199	1.22501	1.2292	201493.0
2020-07-20	E7	Futures	1.2208	1.2259	1.2188	1.2231	7365.0
2020-07-20	EBM	Futures	221.25	221.55	216.46	217.66	26734.0
2020-07-20	ED	Futures	96.4137	96.4185	96.4088	96.4137	53331.0
2020-07-20	ER	Futures	98.362	98.367	98.357	98.367	36785.0
2020-07-20	ESG	Futures	290.98	295.4	290.98	293.02	323.0
2020-07-20	EW	Futures	1944.2	1950.1	1927.0	1937.1	9872.0
2020-07-20	FBON	Futures	145.7	146.33	145.62	146.29	131.0
2020-07-20	FBTP	Futures	131.3	132.03	131.09	131.92	88329.0
2020-07-20	FBTS	Futures	108.56	108.735	108.531	108.706	45627.0
2020-07-20	FCE	Futures	4901.1	4930.1	4841.7	4919.5	53329.0
2020-07-20	FDAX	Futures	13772.2	13907.2	13590.6	13859.9	87815.0
2020-07-20	FDIV	Futures	147.49	149.81	147.49	149.81	300.0
2020-07-20	FDXM	Futures	13717.8	13856.5	13543.1	13809.9	50853.0
2020-07-20	FESX	Futures	3110.0	3130.3	3069.4	3124.8	757742.0
2020-07-20	FEU3	Futures	99.109	99.114	99.109	99.114	50.0
2020-07-20	FGBL	Futures	168.34	168.68	167.94	168.51	465199.0
2020-07-20	FGBM	Futures	134.7	134.83	134.56	134.78	279876.0
2020-07-20	FGBS	Futures	112.714	112.749	112.689	112.734	196608.0
2020-07-20	FGBX	Futures	226.6	227.92	224.97	227.43	36841.0
2020-07-20	FMWO	Futures	8021.9	8125.0	7988.7	8082.3	2563.0
2020-07-20	FOAT	Futures	155.75	156.27	155.57	156.11	125230.0
2020-07-20	FTDX	Futures	3160.4	3218.7	3160.4	3215.6	32.0
2020-07-20	FTI	Futures	534.79	540.49	529.97	539.07	22100.0
2020-07-20	FTUK	Futures	5930.3	5931.2	5846.6	5885.8	77237.0
2020-07-20	FVSA	Futures	247.04	250.21	230.3	234.37	24228.0
2020-07-20	FXXP	Futures	342.9	346.5	340.3	345.7	47261.0

> showing 50 of 120 rows — these rows as CSV

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