PREVIEW / futures_daily / 2020-06-17

all futures daily files

  file:    by_date/futures_daily/2020/2020-06-17.parquet
  size:    10 KB
  rows:    117

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-17	ES	Futures	3502.55	3542.22	3483.13	3497.2	1850300.0
2020-06-17	NQ	Futures	11550.1	11661.53	11508.03	11586.66	404568.0
2020-06-17	YM	Futures	28003.3	28393.4	27781.5	27890.8	216527.0
2020-06-17	CL	Futures	27.7	28.28	27.17	27.7	289579.0
2020-06-17	GC	Futures	2083.4	2088.2	2061.8	2083.8	140069.0
2020-06-17	ZN	Futures	137.196006	137.428279	137.118582	137.350855	974149.0
2020-06-17	A6	Futures	0.70804	0.71226	0.70496	0.70887	90848.0
2020-06-17	AD	Futures	0.74946	0.75139	0.74683	0.7485	48045.0
2020-06-17	ALI	Futures	1960.41	1974.02	1960.41	1971.3	72.0
2020-06-17	B	Futures	26.58	27.14	26.2	26.65	175235.0
2020-06-17	B6	Futures	1.2767	1.2789	1.271	1.2739	76865.0
2020-06-17	BR	Futures	0.15138	0.15138	0.15023	0.15027	3.0
2020-06-17	BTC	Futures	13268.5	13352.0	12872.1	12969.5	3206.0
2020-06-17	BZ	Futures	26.03	26.5	25.59	26.03	29078.0
2020-06-17	C	Futures	1764.0	1766.0	1733.0	1735.0	6088.0
2020-06-17	CB	Futures	209.163	209.163	204.883	204.883	43.0
2020-06-17	CC	Futures	1483.0	1491.0	1455.0	1463.0	13770.0
2020-06-17	CNH	Futures	7.01	7.0218	6.9974	7.0008	191.0
2020-06-17	CSC	Futures	3.55	3.576	3.55	3.576	28.0
2020-06-17	CT	Futures	58.55	59.81	58.4	59.79	4804.0
2020-06-17	DC	Futures	29.51	29.78	29.49	29.78	92.0
2020-06-17	DX	Futures	93.647	94.034	93.468	93.835	15424.0
2020-06-17	E1	Futures	1.19684	1.20104	1.19502	1.19934	13929.0
2020-06-17	E6	Futures	1.21085	1.21433	1.20489	1.20757	149634.0
2020-06-17	E7	Futures	1.205	1.2082	1.199	1.2015	6516.0
2020-06-17	EBM	Futures	214.96	216.46	213.47	215.86	25636.0
2020-06-17	ED	Futures	96.3702	96.3798	96.3653	96.375	142942.0
2020-06-17	ER	Futures	98.333	98.352	98.333	98.347	112770.0
2020-06-17	ESG	Futures	281.96	282.09	279.99	280.75	1860.0
2020-06-17	EW	Futures	1929.3	1957.2	1901.1	1906.1	15259.0
2020-06-17	FBON	Futures	143.94	144.05	143.49	143.83	132.0
2020-06-17	FBTP	Futures	128.4	128.77	128.2	128.54	70471.0
2020-06-17	FBTS	Futures	108.289	108.405	108.25	108.289	73484.0
2020-06-17	FCE	Futures	4809.0	4889.2	4809.0	4858.5	88425.0
2020-06-17	FDAX	Futures	13032.3	13187.9	12970.1	13123.6	36218.0
2020-06-17	FDXM	Futures	13000.1	13143.0	12923.9	13076.3	3477.0
2020-06-17	FESX	Futures	2967.8	3004.7	2941.9	2988.1	1192698.0
2020-06-17	FGBL	Futures	167.53	167.81	167.01	167.59	596315.0
2020-06-17	FGBM	Futures	134.52	134.61	134.36	134.55	341978.0
2020-06-17	FGBS	Futures	112.714	112.739	112.694	112.724	183699.0
2020-06-17	FGBX	Futures	223.51	224.42	221.38	223.69	47499.0
2020-06-17	FMWO	Futures	7752.7	7798.6	7695.0	7725.6	17384.0
2020-06-17	FOAT	Futures	154.55	154.8	154.19	154.67	126516.0
2020-06-17	FTDX	Futures	3233.0	3267.7	3233.0	3262.1	355.0
2020-06-17	FTI	Futures	518.05	526.68	517.62	524.54	14827.0
2020-06-17	FTUK	Futures	5874.5	5926.9	5839.5	5871.7	135478.0
2020-06-17	FVSA	Futures	289.27	298.69	283.89	295.1	19396.0
2020-06-17	FXXP	Futures	334.5	336.9	333.2	335.5	111807.0
2020-06-17	G	Futures	126.76	127.13	126.56	127.03	173439.0
2020-06-17	GF	Futures	256.461	259.465	255.297	258.932	3057.0

> showing 50 of 117 rows — these rows as CSV

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