PREVIEW / futures_daily / 2020-06-22

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-22.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-06-22	ES	Futures	3422.07	3505.36	3407.43	3501.42	1392325.0
2020-06-22	NQ	Futures	11453.19	11762.5	11424.75	11751.18	354768.0
2020-06-22	YM	Futures	27188.8	27850.0	27038.8	27813.6	176355.0
2020-06-22	CL	Futures	28.29	29.56	28.27	29.53	315264.0
2020-06-22	GC	Futures	2120.0	2135.9	2105.3	2120.8	228682.0
2020-06-22	ZN	Futures	137.676037	137.707007	137.39731	137.459249	733415.0
2020-06-22	A6	Futures	0.70187	0.71226	0.70074	0.71164	78011.0
2020-06-22	AD	Futures	0.74586	0.75099	0.7448	0.75063	39459.0
2020-06-22	ALI	Futures	1945.9	1964.34	1941.67	1962.83	139.0
2020-06-22	B	Futures	27.32	28.26	27.22	28.2	187649.0
2020-06-22	B6	Futures	1.255	1.2675	1.253	1.267	69721.0
2020-06-22	BR	Futures	0.15039	0.15087	0.15019	0.15019	2.0
2020-06-22	BTC	Futures	13004.3	13491.0	12906.9	13331.1	5062.0
2020-06-22	BZ	Futures	26.56	27.6	26.54	27.54	24433.0
2020-06-22	C	Futures	1716.0	1740.0	1706.0	1733.0	2223.0
2020-06-22	CB	Futures	209.698	210.767	207.023	207.023	36.0
2020-06-22	CC	Futures	1473.0	1497.0	1455.0	1489.0	9884.0
2020-06-22	CNH	Futures	7.0053	7.0053	6.9851	6.9858	228.0
2020-06-22	CSC	Futures	3.741	3.917	3.737	3.917	156.0
2020-06-22	CT	Futures	59.95	61.26	59.61	60.94	3598.0
2020-06-22	DC	Futures	31.04	32.54	31.04	32.47	550.0
2020-06-22	DX	Futures	94.304	94.372	93.637	93.681	15164.0
2020-06-22	E1	Futures	1.19707	1.20297	1.19502	1.20161	14702.0
2020-06-22	E6	Futures	1.20199	1.21171	1.20065	1.21058	117766.0
2020-06-22	E7	Futures	1.1961	1.2057	1.1948	1.2045	5489.0
2020-06-22	EBM	Futures	214.96	215.26	213.47	213.77	14908.0
2020-06-22	ED	Futures	96.3847	96.3895	96.375	96.3847	99489.0
2020-06-22	ER	Futures	98.367	98.372	98.362	98.372	42922.0
2020-06-22	ESG	Futures	277.99	281.37	277.99	281.37	65.0
2020-06-22	EW	Futures	1874.4	1906.9	1853.7	1898.9	11280.0
2020-06-22	FBON	Futures	144.44	144.98	144.42	144.81	188.0
2020-06-22	FBTP	Futures	128.88	129.93	128.87	129.78	68759.0
2020-06-22	FBTS	Futures	108.27	108.483	108.26	108.425	57347.0
2020-06-22	FCE	Futures	4798.2	4870.3	4764.4	4812.4	55933.0
2020-06-22	FDAX	Futures	12844.2	13144.9	12801.7	12984.5	89717.0
2020-06-22	FDIV	Futures	143.93	143.93	141.71	141.71	41.0
2020-06-22	FDXM	Futures	12814.8	13097.5	12755.6	12937.6	47411.0
2020-06-22	FESX	Futures	2938.2	3007.5	2932.7	2968.7	829485.0
2020-06-22	FEU3	Futures	99.114	99.114	99.114	99.114	1.0
2020-06-22	FGBL	Futures	167.91	168.51	167.78	168.27	440910.0
2020-06-22	FGBM	Futures	134.63	134.89	134.59	134.81	332034.0
2020-06-22	FGBS	Futures	112.785	112.82	112.754	112.805	231414.0
2020-06-22	FGBX	Futures	225.38	226.99	225.01	225.84	34512.0
2020-06-22	FMWO	Futures	7704.3	7783.7	7697.2	7745.8	6343.0
2020-06-22	FOAT	Futures	154.97	155.6	154.91	155.44	120454.0
2020-06-22	FTDX	Futures	3019.4	3036.8	2992.4	2997.5	230.0
2020-06-22	FTI	Futures	520.33	529.14	518.75	523.12	22319.0
2020-06-22	FTUK	Futures	5810.7	5925.5	5807.4	5863.6	77363.0
2020-06-22	FVSA	Futures	295.55	297.79	280.3	287.93	12049.0
2020-06-22	FXXP	Futures	332.2	336.3	330.7	332.7	44754.0

> showing 50 of 120 rows — these rows as CSV

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