PREVIEW / futures_daily / 2020-09-24

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-24.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-09-24	ES	Futures	3626.6	3671.82	3592.89	3637.83	2277010.0
2020-09-24	NQ	Futures	12507.31	12748.4	12341.47	12609.48	791934.0
2020-09-24	YM	Futures	28733.9	29036.4	28429.2	28760.8	254511.0
2020-09-24	CL	Futures	28.43	28.98	28.09	28.94	269992.0
2020-09-24	GC	Futures	2204.8	2221.4	2186.1	2216.6	345036.0
2020-09-24	ZN	Futures	138.373186	138.466168	138.326694	138.435174	1041394.0
2020-09-24	A6	Futures	0.7264	0.72712	0.72034	0.72393	130396.0
2020-09-24	AD	Futures	0.75751	0.76065	0.75543	0.75913	84260.0
2020-09-24	ALI	Futures	2093.71	2115.4	2093.71	2098.46	186.0
2020-09-24	B	Futures	26.37	26.79	26.31	26.73	162931.0
2020-09-24	B6	Futures	1.2906	1.2966	1.2873	1.2924	113983.0
2020-09-24	BR	Futures	0.13971	0.14254	0.13971	0.1423	223.0
2020-09-24	BTC	Futures	13879.8	14531.5	13785.7	14410.5	4089.0
2020-09-24	BZ	Futures	25.88	26.2	25.64	26.15	21940.0
2020-09-24	C	Futures	1665.0	1700.0	1654.0	1680.0	5156.0
2020-09-24	CB	Futures	167.45	168.314	167.45	167.705	55.0
2020-09-24	CC	Futures	1692.0	1736.0	1691.0	1707.0	13267.0
2020-09-24	CNH	Futures	6.7108	6.7368	6.7033	6.7209	597.0
2020-09-24	CSC	Futures	3.373	3.373	3.357	3.357	25.0
2020-09-24	CT	Futures	64.48	64.75	63.89	64.69	19037.0
2020-09-24	DC	Futures	27.63	27.63	26.95	27.41	177.0
2020-09-24	DX	Futures	91.226	91.433	91.018	91.181	23950.0
2020-09-24	E1	Futures	1.22835	1.23141	1.2228	1.22495	27063.0
2020-09-24	E6	Futures	1.25117	1.254	1.24747	1.25175	191755.0
2020-09-24	E7	Futures	1.2449	1.2476	1.2412	1.2454	7951.0
2020-09-24	EBM	Futures	232.67	232.97	230.86	231.76	36816.0
2020-09-24	ED	Futures	96.4648	96.4697	96.46	96.4697	115606.0
2020-09-24	ER	Futures	98.435	98.44	98.431	98.435	40824.0
2020-09-24	ESG	Futures	297.24	300.97	297.24	300.47	82.0
2020-09-24	EW	Futures	1914.6	1934.2	1882.3	1908.6	14844.0
2020-09-24	FBON	Futures	148.53	148.53	147.89	148.06	377.0
2020-09-24	FBTP	Futures	135.56	135.61	134.98	135.24	114853.0
2020-09-24	FBTS	Futures	109.402	109.402	109.315	109.354	64458.0
2020-09-24	FCE	Futures	4599.8	4653.2	4582.8	4610.0	75628.0
2020-09-24	FDAX	Futures	13323.9	13513.7	13258.4	13415.6	93946.0
2020-09-24	FDIV	Futures	144.12	145.12	144.12	145.12	200.0
2020-09-24	FDXM	Futures	13262.1	13444.5	13195.2	13348.0	63956.0
2020-09-24	FESX	Futures	2899.2	2931.6	2881.7	2909.4	1099028.0
2020-09-24	FGBL	Futures	169.64	169.92	169.43	169.64	557158.0
2020-09-24	FGBM	Futures	135.16	135.25	135.03	135.09	333246.0
2020-09-24	FGBS	Futures	112.78	112.805	112.754	112.769	311302.0
2020-09-24	FGBX	Futures	230.86	232.24	230.49	231.36	51676.0
2020-09-24	FMWO	Futures	8052.9	8126.3	8009.1	8071.9	5246.0
2020-09-24	FOAT	Futures	157.82	158.01	157.46	157.66	134406.0
2020-09-24	FTDX	Futures	3069.4	3099.7	3068.4	3091.5	187.0
2020-09-24	FTI	Futures	501.69	508.4	499.87	504.0	29217.0
2020-09-24	FTUK	Futures	5547.2	5606.0	5518.5	5540.5	102102.0
2020-09-24	FVSA	Futures	215.07	217.67	208.76	213.59	15599.0
2020-09-24	FXXP	Futures	329.1	331.2	326.9	328.4	77111.0
2020-09-24	G	Futures	127.02	127.1	126.78	126.94	241608.0

> showing 50 of 119 rows — these rows as CSV

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