PREVIEW / futures_daily / 2019-09-30

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-30.parquet
  size:    10 KB
  rows:    122

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-09-30	ES	Futures	3221.72	3232.82	3209.27	3224.43	1155807.0
2019-09-30	NQ	Futures	8914.55	8975.92	8880.27	8954.89	337872.0
2019-09-30	YM	Futures	28237.3	28313.9	28138.6	28240.4	131797.0
2019-09-30	CL	Futures	58.05	58.08	55.42	55.51	532522.0
2019-09-30	GC	Futures	1852.4	1859.2	1813.9	1816.9	439706.0
2019-09-30	ZN	Futures	129.04709	129.217418	128.861277	129.139996	1214229.0
2019-09-30	A6	Futures	0.69558	0.69629	0.69342	0.69445	74348.0
2019-09-30	AD	Futures	0.76197	0.76257	0.7605	0.76186	63569.0
2019-09-30	ALI	Futures	2103.08	2104.89	2090.4	2091.61	75.0
2019-09-30	B	Futures	48.68	48.75	46.89	46.94	272842.0
2019-09-30	B6	Futures	1.2538	1.259	1.2516	1.2539	101556.0
2019-09-30	BFX	Futures	4461.7	4482.9	4461.7	4482.9	8.0
2019-09-30	BR	Futures	0.19328	0.19408	0.19328	0.19408	192.0
2019-09-30	BTC	Futures	11635.6	12103.0	11089.0	11988.0	4976.0
2019-09-30	BZ	Futures	48.08	48.08	46.23	46.28	34510.0
2019-09-30	C	Futures	1706.0	1709.0	1685.0	1688.0	8410.0
2019-09-30	CB	Futures	256.899	256.899	256.25	256.25	12.0
2019-09-30	CC	Futures	1633.0	1637.0	1601.0	1603.0	24207.0
2019-09-30	CNH	Futures	7.1453	7.1479	7.1162	7.1386	673.0
2019-09-30	CSC	Futures	3.115	3.127	3.109	3.119	31.0
2019-09-30	CT	Futures	59.36	59.5	58.48	59.21	14175.0
2019-09-30	DC	Futures	26.27	26.3	26.19	26.19	105.0
2019-09-30	DX	Futures	95.464	95.797	95.406	95.706	13808.0
2019-09-30	E1	Futures	1.16784	1.16864	1.1591	1.15979	34816.0
2019-09-30	E6	Futures	1.1922	1.19312	1.18624	1.18819	169462.0
2019-09-30	E7	Futures	1.1861	1.1868	1.1801	1.1821	2977.0
2019-09-30	EBM	Futures	190.44	191.53	189.89	191.26	24400.0
2019-09-30	ED	Futures	95.2694	95.2743	95.2549	95.2743	179734.0
2019-09-30	ER	Futures	98.46	98.46	98.45	98.46	27860.0
2019-09-30	EW	Futures	2028.6	2041.0	2020.7	2035.6	14342.0
2019-09-30	FBON	Futures	146.05	146.12	145.64	146.05	131.0
2019-09-30	FBTP	Futures	132.63	132.72	132.25	132.67	59976.0
2019-09-30	FBTS	Futures	108.625	108.625	108.519	108.616	35974.0
2019-09-30	FCE	Futures	5094.8	5140.9	5087.5	5138.7	70035.0
2019-09-30	FDAX	Futures	13032.8	13117.2	13011.7	13095.5	87948.0
2019-09-30	FDIV	Futures	148.87	149.57	148.87	149.57	40.0
2019-09-30	FDXM	Futures	12853.7	12946.4	12842.3	12924.6	31188.0
2019-09-30	FESX	Futures	3090.4	3122.0	3089.5	3117.6	958004.0
2019-09-30	FEU3	Futures	99.154	99.159	99.154	99.159	200.0
2019-09-30	FGBL	Futures	168.42	168.43	167.86	168.33	531338.0
2019-09-30	FGBM	Futures	135.21	135.23	135.06	135.2	313707.0
2019-09-30	FGBS	Futures	113.036	113.041	113.006	113.026	187397.0
2019-09-30	FGBX	Futures	226.93	226.99	224.08	225.8	40768.0
2019-09-30	FMWO	Futures	7265.3	7283.5	7247.1	7274.4	1478.0
2019-09-30	FOAT	Futures	155.16	155.26	154.69	155.12	94182.0
2019-09-30	FTDX	Futures	2763.9	2780.7	2763.9	2770.3	76.0
2019-09-30	FTI	Futures	546.42	550.78	546.23	550.21	22473.0
2019-09-30	FTUK	Futures	6833.8	6863.0	6826.9	6843.1	109399.0
2019-09-30	FVSA	Futures	190.87	192.55	183.57	185.25	23836.0
2019-09-30	FXXP	Futures	352.5	354.6	352.1	354.0	46269.0

> showing 50 of 122 rows — these rows as CSV

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