PREVIEW / futures_daily / 2019-04-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-18.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
2019-04-18	ES	Futures	3133.59	3145.2	3121.17	3143.31	1335778.0
2019-04-18	NQ	Futures	8862.18	8898.48	8826.18	8886.38	393586.0
2019-04-18	YM	Futures	27902.6	28076.8	27772.8	28041.9	181027.0
2019-04-18	CL	Futures	65.55	65.95	65.25	65.78	508981.0
2019-04-18	GC	Futures	1588.4	1592.7	1584.4	1588.1	229629.0
2019-04-18	ZN	Futures	122.186933	122.55988	122.171393	122.466643	1434418.0
2019-04-18	A6	Futures	0.74095	0.74312	0.73642	0.73663	99337.0
2019-04-18	AD	Futures	0.75837	0.75878	0.75544	0.7562	73893.0
2019-04-18	B	Futures	52.17	52.47	51.86	52.42	259040.0
2019-04-18	B6	Futures	1.3391	1.3407	1.3333	1.3334	88102.0
2019-04-18	BR	Futures	0.20216	0.20332	0.20216	0.20264	1793.0
2019-04-18	BTC	Futures	8080.9	8227.7	8042.3	8181.3	6451.0
2019-04-18	BZ	Futures	51.97	52.32	51.73	52.28	38122.0
2019-04-18	C	Futures	1645.0	1670.0	1642.0	1654.0	4031.0
2019-04-18	CB	Futures	278.215	278.364	278.005	278.364	5.0
2019-04-18	CC	Futures	1609.0	1625.0	1590.0	1597.0	13984.0
2019-04-18	CNH	Futures	6.6883	6.7192	6.6883	6.719	614.0
2019-04-18	CSC	Futures	2.894	2.905	2.868	2.892	72.0
2019-04-18	CT	Futures	83.15	83.15	81.78	82.08	4337.0
2019-04-18	DC	Futures	24.38	24.52	24.19	24.43	270.0
2019-04-18	DX	Futures	92.684	93.254	92.612	93.121	16759.0
2019-04-18	E1	Futures	1.16096	1.16212	1.15466	1.15512	36129.0
2019-04-18	E6	Futures	1.24567	1.2465	1.23794	1.23832	253387.0
2019-04-18	E7	Futures	1.2396	1.2404	1.2318	1.2322	5863.0
2019-04-18	EBM	Futures	195.54	195.81	193.96	194.22	19168.0
2019-04-18	ED	Futures	95.1209	95.1306	95.1209	95.1257	141166.0
2019-04-18	ER	Futures	98.416	98.421	98.411	98.416	28801.0
2019-04-18	EW	Futures	2070.1	2079.8	2060.5	2076.9	9084.0
2019-04-18	FBON	Futures	135.08	135.59	135.08	135.46	47.0
2019-04-18	FBTP	Futures	115.26	115.55	115.09	115.4	43056.0
2019-04-18	FBTS	Futures	105.836	105.874	105.779	105.827	28485.0
2019-04-18	FCE	Futures	4932.1	4988.4	4922.7	4970.0	99219.0
2019-04-18	FDAX	Futures	12856.9	12939.0	12762.2	12883.8	118378.0
2019-04-18	FDIV	Futures	150.31	151.19	150.31	150.82	31.0
2019-04-18	FDXM	Futures	12731.9	12826.9	12650.5	12772.1	54679.0
2019-04-18	FESX	Futures	2981.1	3005.6	2964.5	2993.4	1251634.0
2019-04-18	FEU3	Futures	99.016	99.016	99.011	99.011	99.0
2019-04-18	FGBL	Futures	158.69	159.51	158.6	159.46	768220.0
2019-04-18	FGBM	Futures	132.63	132.9	132.62	132.87	520449.0
2019-04-18	FGBS	Futures	112.724	112.749	112.718	112.744	306594.0
2019-04-18	FGBX	Futures	189.81	192.34	189.64	192.14	41268.0
2019-04-18	FMWO	Futures	7241.6	7269.3	7227.7	7243.9	1137.0
2019-04-18	FOAT	Futures	145.94	146.74	145.9	146.68	146137.0
2019-04-18	FTDX	Futures	2763.9	2779.7	2749.1	2754.0	335.0
2019-04-18	FTI	Futures	529.45	536.04	528.59	533.88	35702.0
2019-04-18	FTUK	Futures	6798.5	6820.6	6769.2	6793.5	75306.0
2019-04-18	FVSA	Futures	201.09	203.19	197.6	198.3	24733.0
2019-04-18	FXXP	Futures	342.8	345.8	342.6	344.6	48391.0
2019-04-18	G	Futures	116.75	117.35	116.75	117.25	163371.0
2019-04-18	GF	Futures	314.009	316.039	312.864	315.466	5546.0

> showing 50 of 115 rows — these rows as CSV

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