PREVIEW / futures_daily / 2019-10-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-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
2019-10-18	ES	Futures	3245.27	3249.06	3220.64	3234.98	1335276.0
2019-10-18	NQ	Futures	9166.07	9171.54	9030.08	9081.94	437753.0
2019-10-18	YM	Futures	28339.1	28368.5	28056.7	28086.1	149070.0
2019-10-18	CL	Futures	55.37	55.87	54.6	55.04	472558.0
2019-10-18	GC	Futures	1844.9	1847.7	1835.9	1843.0	232552.0
2019-10-18	ZN	Futures	128.752886	129.000637	128.598042	128.861277	894043.0
2019-10-18	A6	Futures	0.70184	0.70471	0.70101	0.7043	80152.0
2019-10-18	AD	Futures	0.76725	0.76816	0.7666	0.76801	61835.0
2019-10-18	ALI	Futures	2117.48	2120.52	2115.96	2120.52	73.0
2019-10-18	B	Futures	47.36	47.76	46.75	47.07	228144.0
2019-10-18	B6	Futures	1.3133	1.3238	1.3078	1.3188	134490.0
2019-10-18	BR	Futures	0.19396	0.19594	0.19396	0.1959	1293.0
2019-10-18	BTC	Futures	11599.6	11693.1	11225.7	11448.6	3414.0
2019-10-18	BZ	Futures	46.77	47.08	46.09	46.41	33528.0
2019-10-18	C	Futures	1691.0	1699.0	1658.0	1670.0	7291.0
2019-10-18	CB	Futures	247.836	247.836	247.127	247.127	8.0
2019-10-18	CC	Futures	1650.0	1666.0	1616.0	1631.0	18622.0
2019-10-18	CNH	Futures	7.0753	7.0831	7.0648	7.0679	267.0
2019-10-18	CSC	Futures	3.229	3.229	3.217	3.226	45.0
2019-10-18	CT	Futures	63.46	63.65	63.27	63.43	16479.0
2019-10-18	DC	Futures	26.99	27.06	26.93	27.02	275.0
2019-10-18	DX	Futures	94.096	94.135	93.666	93.761	19047.0
2019-10-18	E1	Futures	1.16991	1.17394	1.16795	1.17267	23718.0
2019-10-18	E6	Futures	1.21079	1.21556	1.20927	1.21437	142494.0
2019-10-18	E7	Futures	1.2044	1.2091	1.2031	1.2081	3032.0
2019-10-18	EBM	Futures	198.1	198.65	196.46	198.37	22056.0
2019-10-18	ED	Futures	95.3375	95.3715	95.3277	95.3618	278745.0
2019-10-18	ER	Futures	98.421	98.421	98.406	98.416	61456.0
2019-10-18	EW	Futures	2037.6	2039.5	2022.6	2034.7	10450.0
2019-10-18	FBON	Futures	145.18	145.32	145.01	145.09	132.0
2019-10-18	FBTP	Futures	131.69	131.96	131.49	131.58	58966.0
2019-10-18	FBTS	Futures	108.491	108.529	108.442	108.452	28394.0
2019-10-18	FCE	Futures	5134.6	5142.8	5097.4	5113.7	89781.0
2019-10-18	FDAX	Futures	13359.9	13392.6	13284.4	13344.0	102133.0
2019-10-18	FDIV	Futures	152.77	153.79	152.77	153.79	40.0
2019-10-18	FDXM	Futures	13168.2	13218.2	13111.0	13169.8	40035.0
2019-10-18	FESX	Futures	3140.4	3145.7	3119.4	3132.5	991558.0
2019-10-18	FGBL	Futures	165.89	166.04	165.42	165.66	443117.0
2019-10-18	FGBM	Futures	134.21	134.26	134.06	134.19	278057.0
2019-10-18	FGBS	Futures	112.785	112.81	112.764	112.8	274546.0
2019-10-18	FGBX	Futures	217.17	217.79	215.46	216.11	26194.0
2019-10-18	FMWO	Futures	7323.3	7343.8	7291.4	7327.8	45931.0
2019-10-18	FOAT	Futures	153.46	153.46	152.93	153.03	74604.0
2019-10-18	FTDX	Futures	2744.7	2759.5	2723.4	2735.8	53.0
2019-10-18	FTI	Futures	546.64	547.5	542.49	544.44	27627.0
2019-10-18	FTUK	Futures	6639.2	6649.4	6588.2	6615.6	99130.0
2019-10-18	FVSA	Futures	172.02	172.02	165.65	166.71	28155.0
2019-10-18	FXXP	Futures	354.0	355.0	352.4	353.8	42375.0
2019-10-18	G	Futures	120.8	120.92	120.44	120.74	190276.0
2019-10-18	GF	Futures	302.157	302.471	296.661	299.069	5973.0

> showing 50 of 120 rows — these rows as CSV

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