PREVIEW / futures_daily / 2019-08-19

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-19.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
2019-08-19	ES	Futures	3121.71	3164.06	3121.17	3154.89	1285798.0
2019-08-19	NQ	Futures	8769.93	8922.77	8768.49	8896.86	401476.0
2019-08-19	YM	Futures	27208.3	27549.5	27208.3	27424.6	152096.0
2019-08-19	CL	Futures	56.44	57.84	56.27	57.66	584014.0
2019-08-19	GC	Futures	1878.7	1879.4	1854.4	1864.6	295828.0
2019-08-19	ZN	Futures	130.208763	130.208763	129.695518	129.835494	1296412.0
2019-08-19	A6	Futures	0.69833	0.69905	0.69627	0.69668	44373.0
2019-08-19	AD	Futures	0.75964	0.76101	0.75607	0.75652	52653.0
2019-08-19	ALI	Futures	2203.62	2203.62	2198.77	2198.77	30.0
2019-08-19	B	Futures	44.3	45.2	44.24	45.07	211453.0
2019-08-19	B6	Futures	1.2412	1.2442	1.237	1.24	66631.0
2019-08-19	BFX	Futures	4232.4	4248.1	4232.4	4248.1	6.0
2019-08-19	BR	Futures	0.20012	0.20016	0.19584	0.19632	3940.0
2019-08-19	BTC	Futures	14381.0	14993.7	14188.2	14794.0	2653.0
2019-08-19	BZ	Futures	43.66	44.62	43.63	44.49	30652.0
2019-08-19	C	Futures	1537.0	1553.0	1536.0	1540.0	3157.0
2019-08-19	CB	Futures	276.341	276.341	275.407	276.283	67.0
2019-08-19	CC	Futures	1433.0	1454.0	1433.0	1438.0	17888.0
2019-08-19	CNH	Futures	7.0535	7.0813	7.0523	7.0726	609.0
2019-08-19	CSC	Futures	3.112	3.112	3.099	3.105	54.0
2019-08-19	CT	Futures	58.94	59.28	58.44	58.44	7.0
2019-08-19	DC	Futures	26.2	26.2	26.07	26.1	157.0
2019-08-19	DX	Futures	94.413	94.615	94.36	94.568	9286.0
2019-08-19	E1	Futures	1.18777	1.18951	1.18371	1.18499	19070.0
2019-08-19	E6	Futures	1.21262	1.21502	1.21076	1.21153	112292.0
2019-08-19	E7	Futures	1.2064	1.2087	1.2045	1.2052	2412.0
2019-08-19	EBM	Futures	192.02	192.88	190.87	190.87	7178.0
2019-08-19	ED	Futures	95.4377	95.4377	95.4036	95.4109	266334.0
2019-08-19	ER	Futures	98.553	98.553	98.543	98.543	54191.0
2019-08-19	EW	Futures	1970.4	1995.5	1970.4	1987.4	8106.0
2019-08-19	FBON	Futures	146.99	146.99	145.83	146.26	487.0
2019-08-19	FBTP	Futures	127.06	127.68	126.1	126.8	62938.0
2019-08-19	FBTS	Futures	107.485	107.609	107.341	107.446	36203.0
2019-08-19	FCE	Futures	4820.7	4870.5	4817.0	4864.2	79262.0
2019-08-19	FDAX	Futures	12214.6	12377.3	12176.7	12333.6	96073.0
2019-08-19	FDXM	Futures	12054.8	12224.3	12026.7	12181.7	38864.0
2019-08-19	FESX	Futures	2913.9	2947.9	2905.1	2940.1	847591.0
2019-08-19	FGBL	Futures	169.94	170.05	169.08	169.4	739110.0
2019-08-19	FGBM	Futures	136.08	136.08	135.87	135.98	368654.0
2019-08-19	FGBS	Futures	113.403	113.403	113.343	113.373	252160.0
2019-08-19	FGBX	Futures	230.67	231.56	225.29	227.13	73196.0
2019-08-19	FMWO	Futures	7134.1	7188.3	7134.1	7182.5	3990.0
2019-08-19	FOAT	Futures	156.15	156.4	155.38	155.72	114804.0
2019-08-19	FTDX	Futures	2698.3	2714.6	2671.6	2709.6	177.0
2019-08-19	FTI	Futures	515.06	518.8	514.69	518.03	27791.0
2019-08-19	FTUK	Futures	6592.3	6652.3	6575.2	6633.4	89838.0
2019-08-19	FVSA	Futures	221.99	224.5	214.46	216.97	53061.0
2019-08-19	FXXP	Futures	332.5	335.1	332.5	334.6	63752.0
2019-08-19	G	Futures	123.72	123.8	123.21	123.57	179229.0
2019-08-19	GF	Futures	273.493	275.019	270.033	270.288	2987.0

> showing 50 of 120 rows — these rows as CSV

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