PREVIEW / futures_daily / 2020-11-18

all futures daily files

  file:    by_date/futures_daily/2020/2020-11-18.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-11-18	ES	Futures	4049.59	4070.65	3995.66	4005.21	1325309.0
2020-11-18	NQ	Futures	13860.09	13924.34	13732.17	13773.26	475826.0
2020-11-18	YM	Futures	31966.9	32185.4	31577.1	31641.7	164844.0
2020-11-18	CL	Futures	29.55	30.36	29.38	29.88	322651.0
2020-11-18	GC	Futures	2219.7	2225.3	2197.0	2213.1	209000.0
2020-11-18	ZN	Futures	137.226404	137.381374	136.947457	137.055936	1486514.0
2020-11-18	A6	Futures	0.74929	0.75278	0.74672	0.75155	69623.0
2020-11-18	AD	Futures	0.77357	0.77752	0.77261	0.77666	59287.0
2020-11-18	ALI	Futures	2357.97	2365.05	2355.03	2364.75	172.0
2020-11-18	B	Futures	27.57	28.28	27.4	27.94	242879.0
2020-11-18	B6	Futures	1.3451	1.3501	1.3431	1.347	60913.0
2020-11-18	BR	Futures	0.14738	0.14907	0.14612	0.14781	7974.0
2020-11-18	BTC	Futures	23326.2	24467.8	22745.5	23339.4	12925.0
2020-11-18	BZ	Futures	27.0	27.68	26.82	27.35	28668.0
2020-11-18	C	Futures	1527.0	1551.0	1519.0	1548.0	4714.0
2020-11-18	CB	Futures	147.504	149.41	147.504	149.384	278.0
2020-11-18	CC	Futures	1663.0	1713.0	1650.0	1696.0	27785.0
2020-11-18	CNH	Futures	6.4232	6.4394	6.4079	6.428	1120.0
2020-11-18	CSC	Futures	3.154	3.168	3.071	3.101	176.0
2020-11-18	CT	Futures	68.15	68.94	68.11	68.86	6416.0
2020-11-18	DC	Futures	25.9	26.18	25.16	25.5	1027.0
2020-11-18	DX	Futures	89.294	89.361	89.057	89.169	14660.0
2020-11-18	E1	Futures	1.24364	1.24624	1.24205	1.24488	16519.0
2020-11-18	E6	Futures	1.27146	1.27446	1.27002	1.27146	113510.0
2020-11-18	E7	Futures	1.265	1.2679	1.2634	1.265	4985.0
2020-11-18	EBM	Futures	253.76	256.78	252.86	256.48	15515.0
2020-11-18	ED	Futures	96.4842	96.4842	96.4769	96.4818	167633.0
2020-11-18	ER	Futures	98.455	98.465	98.455	98.465	76313.0
2020-11-18	ESG	Futures	334.9	334.9	329.98	329.98	329.0
2020-11-18	EW	Futures	2302.7	2325.0	2270.7	2275.9	11884.0
2020-11-18	FBON	Futures	150.45	150.45	150.13	150.25	318.0
2020-11-18	FBTP	Futures	138.42	138.59	137.77	138.19	89883.0
2020-11-18	FBTS	Futures	110.01	110.049	109.942	109.991	63514.0
2020-11-18	FCE	Futures	5327.6	5377.8	5308.6	5367.1	64331.0
2020-11-18	FDAX	Futures	13977.5	14080.9	13930.1	14067.1	58965.0
2020-11-18	FDIV	Futures	156.73	157.3	156.73	157.3	3.0
2020-11-18	FDXM	Futures	13906.0	14009.9	13859.3	13996.1	35682.0
2020-11-18	FESX	Futures	3201.6	3223.7	3187.7	3217.3	745141.0
2020-11-18	FEU3	Futures	99.198	99.203	99.188	99.203	192.0
2020-11-18	FGBL	Futures	170.46	170.64	170.1	170.31	526036.0
2020-11-18	FGBM	Futures	135.31	135.37	135.22	135.27	286642.0
2020-11-18	FGBS	Futures	112.78	112.795	112.775	112.78	238352.0
2020-11-18	FGBX	Futures	236.21	237.04	234.98	235.75	52149.0
2020-11-18	FMWO	Futures	8987.4	9049.0	8946.0	9034.8	2306.0
2020-11-18	FOAT	Futures	159.11	159.22	158.73	158.95	161335.0
2020-11-18	FTDX	Futures	3083.8	3108.0	3083.8	3103.3	60.0
2020-11-18	FTI	Futures	559.9	564.15	557.42	561.42	18707.0
2020-11-18	FTUK	Futures	6057.2	6099.7	6023.2	6094.0	92611.0
2020-11-18	FVSA	Futures	161.34	164.3	155.05	156.53	20772.0
2020-11-18	FXXP	Futures	358.9	362.2	358.3	361.7	61582.0

> showing 50 of 120 rows — these rows as CSV

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