PREVIEW / futures_daily / 2020-06-18

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-18.parquet
  size:    10 KB
  rows:    122

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-18	ES	Futures	3493.82	3511.83	3449.36	3487.07	1636217.0
2020-06-18	NQ	Futures	11585.79	11640.05	11451.45	11586.66	431111.0
2020-06-18	YM	Futures	27885.4	28022.6	27453.5	27755.7	223584.0
2020-06-18	CL	Futures	27.55	28.4	27.11	28.31	341476.0
2020-06-18	GC	Futures	2083.7	2100.1	2068.3	2078.4	155912.0
2020-06-18	ZN	Futures	137.257946	137.629583	137.257946	137.583128	866605.0
2020-06-18	A6	Futures	0.70825	0.7102	0.70331	0.70444	85808.0
2020-06-18	AD	Futures	0.74855	0.75083	0.74561	0.74637	46310.0
2020-06-18	ALI	Futures	1971.9	1981.88	1971.9	1977.95	53.0
2020-06-18	B	Futures	26.46	27.26	26.22	27.17	175785.0
2020-06-18	B6	Futures	1.2752	1.2767	1.2598	1.2617	128210.0
2020-06-18	BFX	Futures	3451.9	3459.4	3451.9	3459.4	15.0
2020-06-18	BR	Futures	0.14778	0.14778	0.14718	0.14718	43.0
2020-06-18	BTC	Futures	13108.6	13233.7	12962.5	13087.7	2135.0
2020-06-18	BZ	Futures	25.94	26.62	25.6	26.54	31042.0
2020-06-18	C	Futures	1734.0	1766.0	1725.0	1765.0	2269.0
2020-06-18	CB	Futures	205.418	210.233	205.418	209.163	14.0
2020-06-18	CC	Futures	1470.0	1490.0	1449.0	1489.0	13930.0
2020-06-18	CNH	Futures	7.0065	7.0114	6.988	7.008	216.0
2020-06-18	CSC	Futures	3.605	3.698	3.605	3.656	86.0
2020-06-18	CT	Futures	59.83	60.17	59.32	59.63	4449.0
2020-06-18	DC	Futures	29.85	30.77	29.8	30.26	504.0
2020-06-18	DX	Futures	93.773	94.232	93.628	94.082	13312.0
2020-06-18	E1	Futures	1.20036	1.2007	1.19514	1.19718	13371.0
2020-06-18	E6	Futures	1.20859	1.21074	1.20264	1.20505	141141.0
2020-06-18	E7	Futures	1.2025	1.2047	1.1965	1.1991	5571.0
2020-06-18	EBM	Futures	216.46	217.96	215.26	215.56	17223.0
2020-06-18	ED	Futures	96.3798	96.3895	96.375	96.3798	129558.0
2020-06-18	ER	Futures	98.352	98.362	98.342	98.357	124360.0
2020-06-18	ESG	Futures	279.48	280.58	279.16	280.58	43.0
2020-06-18	EW	Futures	1904.2	1919.9	1876.5	1901.5	11671.0
2020-06-18	FBON	Futures	143.9	144.41	143.6	144.17	852.0
2020-06-18	FBTP	Futures	128.3	128.99	128.27	128.87	61759.0
2020-06-18	FBTS	Futures	108.25	108.405	108.221	108.299	95245.0
2020-06-18	FCE	Futures	4824.7	4881.0	4770.8	4822.2	54357.0
2020-06-18	FDAX	Futures	13042.9	13241.0	12894.2	13038.7	54266.0
2020-06-18	FDIV	Futures	143.13	143.13	142.56	142.56	73.0
2020-06-18	FDXM	Futures	12987.4	13191.7	12851.9	12991.6	5839.0
2020-06-18	FESX	Futures	2959.5	3010.3	2931.8	2972.4	964593.0
2020-06-18	FGBL	Futures	167.47	167.93	167.36	167.77	548603.0
2020-06-18	FGBM	Futures	134.46	134.62	134.42	134.54	400521.0
2020-06-18	FGBS	Futures	112.709	112.744	112.699	112.729	237911.0
2020-06-18	FGBX	Futures	223.76	226.29	223.18	225.18	42922.0
2020-06-18	FMWO	Futures	7725.6	7803.8	7696.0	7761.2	7954.0
2020-06-18	FOAT	Futures	154.62	154.97	154.44	154.87	165756.0
2020-06-18	FTDX	Futures	3249.3	3264.2	3045.0	3068.5	624.0
2020-06-18	FTI	Futures	520.23	527.47	518.01	520.82	14257.0
2020-06-18	FTUK	Futures	5830.5	5901.9	5771.0	5836.2	83095.0
2020-06-18	FVSA	Futures	299.14	301.83	287.03	292.41	12708.0
2020-06-18	FXXP	Futures	333.4	337.0	331.2	333.1	90916.0

> showing 50 of 122 rows — these rows as CSV

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