PREVIEW / futures_daily / 2018-05-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-23.parquet
  size:    10 KB
  rows:    113

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
2018-05-23	ES	Futures	2962.81	2972.05	2941.06	2969.6	1295885.0
2018-05-23	NQ	Futures	8082.43	8147.97	7993.77	8142.7	390903.0
2018-05-23	YM	Futures	26162.3	26207.6	25942.1	26186.5	219951.0
2018-05-23	CL	Futures	72.58	72.73	71.65	72.31	702791.0
2018-05-23	GC	Futures	1647.7	1657.6	1642.7	1646.4	402342.0
2018-05-23	ZN	Futures	117.989293	118.56311	117.958276	118.501076	2875558.0
2018-05-23	A6	Futures	0.7789	0.77982	0.77355	0.77746	149224.0
2018-05-23	AD	Futures	0.78976	0.79006	0.78374	0.78829	117351.0
2018-05-23	B	Futures	58.24	58.52	57.31	58.48	292969.0
2018-05-23	B6	Futures	1.3926	1.3937	1.3794	1.3837	160465.0
2018-05-23	BR	Futures	0.21028	0.2118	0.20555	0.20993	6596.0
2018-05-23	BTC	Futures	11304.5	11339.6	10426.8	10658.5	4586.0
2018-05-23	BZ	Futures	57.66	57.92	56.74	57.88	30786.0
2018-05-23	C	Futures	1698.0	1715.0	1698.0	1712.0	7846.0
2018-05-23	CB	Futures	301.817	301.817	299.238	299.238	20.0
2018-05-23	CC	Futures	1901.0	1921.0	1885.0	1909.0	20797.0
2018-05-23	CNH	Futures	6.454	6.4815	6.4519	6.4703	107.0
2018-05-23	CSC	Futures	3.515	3.517	3.478	3.492	87.0
2018-05-23	CT	Futures	99.28	99.75	98.58	98.85	19700.0
2018-05-23	DC	Futures	28.39	28.46	28.07	28.19	339.0
2018-05-23	DX	Futures	88.136	88.763	88.112	88.577	28844.0
2018-05-23	E1	Futures	1.21574	1.21983	1.20948	1.21152	38717.0
2018-05-23	E6	Futures	1.32909	1.33055	1.3176	1.32019	430841.0
2018-05-23	E7	Futures	1.322	1.3233	1.3106	1.3131	7173.0
2018-05-23	EBM	Futures	186.74	188.05	185.96	187.53	18849.0
2018-05-23	ED	Futures	94.9841	95.0132	94.9768	95.0011	327278.0
2018-05-23	ER	Futures	98.337	98.337	98.328	98.332	150119.0
2018-05-23	EW	Futures	2064.3	2067.3	2052.9	2066.3	12829.0
2018-05-23	FBON	Futures	127.7	127.88	127.31	127.8	1123.0
2018-05-23	FBTP	Futures	110.51	110.7	109.07	109.69	251424.0
2018-05-23	FBTS	Futures	103.529	103.575	103.261	103.326	156757.0
2018-05-23	FCE	Futures	5008.2	5013.2	4935.0	4955.6	119764.0
2018-05-23	FDAX	Futures	13633.3	13664.5	13431.2	13481.1	123917.0
2018-05-23	FDIV	Futures	156.27	156.27	156.23	156.23	2.0
2018-05-23	FDXM	Futures	13516.6	13542.3	13311.7	13361.1	44740.0
2018-05-23	FESX	Futures	2959.7	2963.9	2919.7	2932.2	1441770.0
2018-05-23	FGBL	Futures	149.68	150.42	149.65	150.34	1195812.0
2018-05-23	FGBM	Futures	129.82	130.17	129.81	130.11	710278.0
2018-05-23	FGBS	Futures	112.578	112.643	112.568	112.628	582283.0
2018-05-23	FGBX	Futures	169.19	170.82	169.09	170.29	92612.0
2018-05-23	FMWO	Futures	7023.9	7061.2	7009.8	7027.4	885.0
2018-05-23	FOAT	Futures	138.25	138.77	138.2	138.52	253708.0
2018-05-23	FTDX	Futures	2785.9	2813.6	2752.2	2771.0	150.0
2018-05-23	FTI	Futures	526.1	526.1	519.26	520.97	32849.0
2018-05-23	FTUK	Futures	6933.3	6942.2	6844.5	6864.4	157557.0
2018-05-23	FVSA	Futures	303.94	325.42	302.87	320.05	42335.0
2018-05-23	FXXP	Futures	340.8	341.5	337.1	338.3	56730.0
2018-05-23	G	Futures	113.28	113.85	113.28	113.83	424076.0
2018-05-23	GF	Futures	291.211	297.478	290.693	296.96	7087.0
2018-05-23	GSCI	Futures	552.29	555.32	552.29	554.87	26.0

> showing 50 of 113 rows — these rows as CSV

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