PREVIEW / futures_daily / 2019-10-11

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-11.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-11	ES	Futures	3192.49	3241.21	3184.64	3216.04	1743810.0
2019-10-11	NQ	Futures	8969.58	9125.44	8950.85	9056.87	490521.0
2019-10-11	YM	Futures	27865.7	28318.1	27815.3	28108.2	237623.0
2019-10-11	CL	Futures	55.32	56.4	55.07	56.16	741704.0
2019-10-11	GC	Futures	1848.2	1860.2	1823.2	1836.4	485955.0
2019-10-11	ZN	Futures	129.465169	129.635498	128.551589	128.706433	2087451.0
2019-10-11	A6	Futures	0.69517	0.70019	0.69424	0.69907	113691.0
2019-10-11	AD	Futures	0.75829	0.76519	0.75773	0.76443	138035.0
2019-10-11	ALI	Futures	2109.42	2109.42	2081.95	2083.76	113.0
2019-10-11	B	Futures	47.16	48.08	46.91	47.94	367632.0
2019-10-11	B6	Futures	1.268	1.2949	1.2644	1.29	271660.0
2019-10-11	BR	Futures	0.19602	0.1972	0.19574	0.19695	90.0
2019-10-11	BTC	Futures	12361.9	12728.7	11916.0	12016.7	4134.0
2019-10-11	BZ	Futures	46.54	47.41	46.25	47.27	51613.0
2019-10-11	C	Futures	1701.0	1720.0	1687.0	1700.0	9944.0
2019-10-11	CB	Futures	248.721	248.721	247.983	247.983	18.0
2019-10-11	CC	Futures	1610.0	1679.0	1608.0	1645.0	28185.0
2019-10-11	CNH	Futures	7.1021	7.1037	7.0683	7.0726	1528.0
2019-10-11	CSC	Futures	3.2	3.226	3.2	3.221	49.0
2019-10-11	CT	Futures	60.17	62.3	59.84	62.18	39033.0
2019-10-11	DC	Futures	26.63	26.9	26.63	26.84	239.0
2019-10-11	DX	Futures	95.106	95.155	94.608	94.724	31389.0
2019-10-11	E1	Futures	1.16025	1.16094	1.15714	1.15898	34183.0
2019-10-11	E6	Futures	1.19843	1.20434	1.19757	1.20201	230306.0
2019-10-11	E7	Futures	1.1921	1.198	1.1914	1.1958	4154.0
2019-10-11	EBM	Futures	194.27	197.28	194.0	197.01	30689.0
2019-10-11	ED	Futures	95.3666	95.3715	95.2986	95.3326	635557.0
2019-10-11	ER	Futures	98.44	98.445	98.435	98.44	77384.0
2019-10-11	EW	Futures	1987.9	2031.5	1983.0	2014.1	19318.0
2019-10-11	FBON	Futures	145.06	145.66	144.98	145.24	230.0
2019-10-11	FBTP	Futures	131.17	131.6	131.07	131.34	102839.0
2019-10-11	FBTS	Futures	108.442	108.462	108.365	108.423	48735.0
2019-10-11	FCE	Futures	5058.1	5137.8	5036.8	5128.7	115558.0
2019-10-11	FDAX	Futures	12822.3	13246.4	12822.3	13174.7	139423.0
2019-10-11	FDIV	Futures	147.34	150.22	147.34	150.22	110.0
2019-10-11	FDXM	Futures	12661.1	13066.2	12656.9	13002.7	61550.0
2019-10-11	FESX	Futures	3053.6	3126.4	3050.1	3118.5	1335570.0
2019-10-11	FGBL	Futures	166.8	167.26	166.23	166.53	951972.0
2019-10-11	FGBM	Futures	134.62	134.78	134.49	134.68	533831.0
2019-10-11	FGBS	Futures	112.895	112.925	112.87	112.92	378377.0
2019-10-11	FGBX	Futures	220.45	222.15	217.62	218.39	60818.0
2019-10-11	FMWO	Futures	7200.5	7311.9	7200.5	7307.4	3361.0
2019-10-11	FOAT	Futures	153.79	154.22	153.42	153.66	202272.0
2019-10-11	FTDX	Futures	2714.6	2758.5	2710.6	2755.0	151.0
2019-10-11	FTI	Futures	542.92	549.22	541.01	549.1	702.0
2019-10-11	FTUK	Futures	6614.7	6699.9	6596.6	6690.2	154431.0
2019-10-11	FVSA	Futures	186.37	187.5	172.9	176.27	52316.0
2019-10-11	FXXP	Futures	346.7	353.5	346.4	353.0	78927.0
2019-10-11	G	Futures	122.07	122.39	120.65	120.78	365790.0
2019-10-11	GF	Futures	301.477	302.837	300.168	302.0	5956.0

> showing 50 of 120 rows — these rows as CSV

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