PREVIEW / futures_daily / 2019-12-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-18.parquet
  size:    10 KB
  rows:    119

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
2019-12-18	ES	Futures	3447.94	3459.28	3447.4	3455.23	1181642.0
2019-12-18	NQ	Futures	9861.78	9911.68	9858.92	9888.17	292213.0
2019-12-18	YM	Futures	29686.1	29757.6	29663.0	29700.8	117720.0
2019-12-18	CL	Futures	62.01	62.65	61.76	62.38	553568.0
2019-12-18	GC	Futures	1821.3	1825.2	1813.8	1819.2	197967.0
2019-12-18	ZN	Futures	127.390215	127.498619	126.925626	127.03403	1212185.0
2019-12-18	A6	Futures	0.70358	0.70532	0.70255	0.70409	62176.0
2019-12-18	AD	Futures	0.76625	0.76947	0.76524	0.76882	79895.0
2019-12-18	ALI	Futures	2153.64	2170.53	2153.34	2165.4	159.0
2019-12-18	B	Futures	53.1	53.58	52.88	53.37	262339.0
2019-12-18	B6	Futures	1.3357	1.3358	1.3282	1.3309	116113.0
2019-12-18	BR	Futures	0.19965	0.19985	0.1992	0.1992	126.0
2019-12-18	BTC	Futures	9892.9	10885.9	9659.6	10735.4	11821.0
2019-12-18	BZ	Futures	52.39	52.85	52.18	52.66	31943.0
2019-12-18	C	Futures	1695.0	1707.0	1684.0	1693.0	9310.0
2019-12-18	CB	Futures	245.537	245.537	245.537	245.537	21.0
2019-12-18	CC	Futures	1654.0	1667.0	1624.0	1639.0	20358.0
2019-12-18	CNH	Futures	6.9756	6.9874	6.9737	6.9824	306.0
2019-12-18	CSC	Futures	3.292	3.361	3.292	3.344	101.0
2019-12-18	CT	Futures	63.21	63.9	63.02	63.48	13865.0
2019-12-18	DC	Futures	27.44	28.03	27.44	27.96	246.0
2019-12-18	DX	Futures	93.944	94.191	93.934	94.112	9891.0
2019-12-18	E1	Futures	1.17353	1.17387	1.17102	1.17319	23454.0
2019-12-18	E6	Futures	1.20878	1.20889	1.2042	1.20474	156483.0
2019-12-18	E7	Futures	1.2025	1.2026	1.198	1.1984	2075.0
2019-12-18	EBM	Futures	203.85	204.68	203.3	203.58	21849.0
2019-12-18	ED	Futures	95.2986	95.3083	95.2889	95.3035	170038.0
2019-12-18	ER	Futures	98.377	98.382	98.372	98.377	64960.0
2019-12-18	ESG	Futures	284.51	284.51	284.51	284.51	1803.0
2019-12-18	EW	Futures	2155.5	2161.3	2149.7	2158.1	15515.0
2019-12-18	FBON	Futures	143.52	143.75	143.03	143.11	265.0
2019-12-18	FBTP	Futures	129.13	129.55	128.36	128.56	62567.0
2019-12-18	FBTS	Futures	108.278	108.365	108.172	108.201	33552.0
2019-12-18	FCE	Futures	5394.2	5410.5	5386.5	5388.7	73578.0
2019-12-18	FDAX	Futures	14042.8	14054.5	13968.8	13994.7	43172.0
2019-12-18	FDIV	Futures	161.45	161.45	160.94	160.94	60.0
2019-12-18	FDXM	Futures	13871.8	13878.1	13793.5	13819.1	3585.0
2019-12-18	FESX	Futures	3284.5	3297.7	3280.1	3285.4	1193214.0
2019-12-18	FGBL	Futures	164.39	164.67	163.67	163.79	485239.0
2019-12-18	FGBM	Futures	133.69	133.78	133.49	133.53	343991.0
2019-12-18	FGBS	Futures	112.684	112.704	112.669	112.679	192643.0
2019-12-18	FGBX	Futures	212.92	213.63	210.54	210.91	45032.0
2019-12-18	FMWO	Futures	7786.2	7807.7	7779.4	7802.1	8154.0
2019-12-18	FOAT	Futures	151.93	152.14	151.2	151.32	96212.0
2019-12-18	FTDX	Futures	3065.0	3065.5	3043.4	3044.4	1772.0
2019-12-18	FTI	Futures	580.26	583.08	579.54	580.68	27937.0
2019-12-18	FTUK	Futures	7004.4	7035.8	6980.0	7032.5	172293.0
2019-12-18	FVSA	Futures	129.73	130.66	126.92	127.85	17085.0
2019-12-18	FXXP	Futures	376.3	377.9	376.1	376.8	98625.0
2019-12-18	G	Futures	120.4	120.65	120.06	120.16	160674.0

> showing 50 of 119 rows — these rows as CSV

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