PREVIEW / futures_daily / 2018-09-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-25.parquet
  size:    10 KB
  rows:    115

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-09-25	ES	Futures	3173.82	3182.23	3164.88	3168.13	1032045.0
2018-09-25	NQ	Futures	8817.14	8831.37	8770.1	8822.08	318332.0
2018-09-25	YM	Futures	28033.1	28120.5	27906.7	27926.7	136466.0
2018-09-25	CL	Futures	75.63	76.19	75.26	75.66	551280.0
2018-09-25	GC	Futures	1524.8	1530.9	1522.5	1527.4	197635.0
2018-09-25	ZN	Futures	118.047709	118.094399	117.876512	117.985455	1154172.0
2018-09-25	A6	Futures	0.74671	0.74764	0.74496	0.74619	58670.0
2018-09-25	AD	Futures	0.78215	0.78295	0.78063	0.78199	52500.0
2018-09-25	B	Futures	59.18	60.11	59.13	59.71	338882.0
2018-09-25	B6	Futures	1.354	1.362	1.3517	1.3612	90137.0
2018-09-25	BR	Futures	0.18353	0.18578	0.18353	0.18578	2281.0
2018-09-25	BTC	Futures	9516.8	9516.8	9112.7	9163.2	668.0
2018-09-25	BZ	Futures	58.93	59.64	58.69	59.26	32986.0
2018-09-25	C	Futures	1471.0	1478.0	1445.0	1447.0	7233.0
2018-09-25	CB	Futures	275.172	276.975	274.271	274.271	12.0
2018-09-25	CC	Futures	1549.0	1573.0	1529.0	1533.0	18159.0
2018-09-25	CNH	Futures	6.9294	6.9364	6.922	6.932	568.0
2018-09-25	CSC	Futures	3.272	3.274	3.254	3.266	27.0
2018-09-25	CT	Futures	88.2	88.91	87.66	88.66	11244.0
2018-09-25	DC	Futures	27.11	27.18	27.04	27.13	136.0
2018-09-25	DX	Futures	89.127	89.26	88.909	89.024	14779.0
2018-09-25	E1	Futures	1.23787	1.23918	1.23467	1.2374	22588.0
2018-09-25	E6	Futures	1.3148	1.31969	1.31274	1.3168	227077.0
2018-09-25	E7	Futures	1.3085	1.3133	1.3064	1.3104	5149.0
2018-09-25	EBM	Futures	210.27	211.83	208.72	208.98	25102.0
2018-09-25	ED	Futures	95.0622	95.0671	95.0476	95.0525	366502.0
2018-09-25	ER	Futures	98.377	98.377	98.372	98.377	59498.0
2018-09-25	EW	Futures	2143.4	2148.9	2139.5	2140.9	11421.0
2018-09-25	FBON	Futures	127.72	127.88	127.67	127.73	279.0
2018-09-25	FBTP	Futures	108.49	109.41	108.49	108.92	83557.0
2018-09-25	FBTS	Futures	103.07	103.351	103.033	103.155	59106.0
2018-09-25	FCE	Futures	4921.2	4952.3	4920.7	4935.6	48473.0
2018-09-25	FDAX	Futures	12970.6	13043.2	12939.1	12999.6	71014.0
2018-09-25	FDIV	Futures	147.51	147.56	146.89	146.89	9.0
2018-09-25	FDXM	Futures	12747.0	12817.3	12715.0	12774.4	25731.0
2018-09-25	FESX	Futures	2849.5	2866.3	2849.5	2860.4	560940.0
2018-09-25	FGBL	Futures	151.41	151.41	150.97	151.08	783486.0
2018-09-25	FGBM	Futures	130.18	130.22	130.01	130.06	690826.0
2018-09-25	FGBS	Futures	112.472	112.492	112.442	112.452	460491.0
2018-09-25	FGBX	Futures	173.88	173.96	173.01	173.27	49772.0
2018-09-25	FMWO	Futures	7308.9	7332.1	7301.9	7322.8	1078.0
2018-09-25	FOAT	Futures	139.38	139.44	139.07	139.13	156363.0
2018-09-25	FTDX	Futures	2762.1	2804.3	2762.1	2801.3	198.0
2018-09-25	FTI	Futures	508.6	513.34	508.6	512.64	17427.0
2018-09-25	FTUK	Futures	6627.6	6683.9	6620.0	6673.7	79628.0
2018-09-25	FVSA	Futures	253.62	253.62	246.72	249.31	14610.0
2018-09-25	FXXP	Futures	329.8	331.6	329.5	331.3	39380.0
2018-09-25	G	Futures	113.27	113.39	113.17	113.28	265633.0
2018-09-25	GF	Futures	325.147	326.395	324.263	325.511	2647.0
2018-09-25	GSCI	Futures	541.32	541.32	539.98	540.37	30.0

> showing 50 of 115 rows — these rows as CSV

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