PREVIEW / futures_daily / 2020-01-31

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-31.parquet
  size:    10 KB
  rows:    121

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-01-31	ES	Futures	3555.41	3561.35	3469.81	3481.96	3152069.0
2020-01-31	NQ	Futures	10582.97	10608.49	10284.17	10320.59	898384.0
2020-01-31	YM	Futures	30285.8	30331.0	29516.0	29611.6	369128.0
2020-01-31	CL	Futures	54.27	54.72	52.27	52.88	827907.0
2020-01-31	GC	Futures	1924.5	1945.3	1920.3	1936.1	343366.0
2020-01-31	ZN	Futures	129.852535	130.657822	129.775103	130.487472	2664632.0
2020-01-31	A6	Futures	0.68943	0.69046	0.68564	0.68718	131579.0
2020-01-31	AD	Futures	0.76282	0.76363	0.7603	0.76156	90757.0
2020-01-31	ALI	Futures	2095.67	2095.67	2095.67	2095.67	0.0
2020-01-31	B	Futures	48.24	48.55	46.36	46.93	477867.0
2020-01-31	B6	Futures	1.3289	1.3411	1.3284	1.3403	115217.0
2020-01-31	BR	Futures	0.19003	0.19137	0.18881	0.1891	9506.0
2020-01-31	BTC	Futures	14578.6	14623.6	14008.4	14165.9	9428.0
2020-01-31	BZ	Futures	47.49	47.82	45.67	46.24	68547.0
2020-01-31	C	Futures	1892.0	1895.0	1855.0	1859.0	7269.0
2020-01-31	CB	Futures	231.565	232.98	231.565	232.98	17.0
2020-01-31	CC	Futures	1825.0	1838.0	1807.0	1817.0	24356.0
2020-01-31	CNH	Futures	6.9621	6.9789	6.9471	6.9712	284.0
2020-01-31	CSC	Futures	3.45	3.459	3.441	3.45	161.0
2020-01-31	CT	Futures	65.59	65.96	64.11	64.21	27610.0
2020-01-31	DC	Futures	28.7	28.87	28.62	28.7	279.0
2020-01-31	DX	Futures	94.812	94.914	94.308	94.354	19448.0
2020-01-31	E1	Futures	1.18164	1.18986	1.17947	1.18906	37729.0
2020-01-31	E6	Futures	1.19171	1.19849	1.18993	1.19779	227529.0
2020-01-31	E7	Futures	1.1855	1.1922	1.1838	1.1916	2616.0
2020-01-31	EBM	Futures	211.54	211.54	209.35	209.9	25350.0
2020-01-31	ED	Futures	95.352	95.4247	95.352	95.4102	426529.0
2020-01-31	ER	Futures	98.396	98.401	98.391	98.396	57680.0
2020-01-31	ESG	Futures	291.03	291.03	288.71	288.71	11.0
2020-01-31	EW	Futures	2158.2	2161.3	2107.0	2113.2	23961.0
2020-01-31	FBON	Futures	145.32	145.85	145.25	145.82	378.0
2020-01-31	FBTP	Futures	132.41	132.88	132.41	132.76	102882.0
2020-01-31	FBTS	Futures	108.586	108.682	108.576	108.653	54285.0
2020-01-31	FCE	Futures	5347.4	5355.1	5222.8	5261.3	107421.0
2020-01-31	FDAX	Futures	13996.8	14038.6	13621.4	13741.4	151619.0
2020-01-31	FDIV	Futures	155.28	155.28	153.37	153.56	225.0
2020-01-31	FDXM	Futures	13826.9	13861.3	13445.7	13569.0	82815.0
2020-01-31	FESX	Futures	3263.4	3274.0	3177.1	3205.3	1615133.0
2020-01-31	FGBL	Futures	166.47	167.44	166.35	167.19	764224.0
2020-01-31	FGBM	Futures	134.3	134.6	134.26	134.54	474030.0
2020-01-31	FGBS	Futures	112.759	112.805	112.749	112.795	404538.0
2020-01-31	FGBX	Futures	218.3	221.14	217.84	220.53	73251.0
2020-01-31	FMWO	Futures	7933.6	7933.6	7773.7	7808.9	5206.0
2020-01-31	FOAT	Futures	154.07	154.63	154.01	154.59	160263.0
2020-01-31	FTDX	Futures	3130.3	3132.3	3065.5	3078.5	116.0
2020-01-31	FTI	Futures	575.17	575.65	559.45	563.43	42683.0
2020-01-31	FTUK	Futures	6914.3	6921.8	6721.0	6771.2	136375.0
2020-01-31	FVSA	Futures	125.84	142.85	124.99	133.5	62020.0
2020-01-31	FXXP	Futures	379.2	379.7	370.5	373.4	75852.0
2020-01-31	G	Futures	122.81	123.15	122.61	123.08	260155.0

> showing 50 of 121 rows — these rows as CSV

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