PREVIEW / futures_daily / 2017-03-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-16.parquet
  size:    9 KB
  rows:    108

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
2017-03-16	ES	Futures	2583.97	2594.29	2577.72	2583.7	1616078.0
2017-03-16	NQ	Futures	6380.09	6407.18	6362.71	6377.73	187337.0
2017-03-16	YM	Futures	22037.2	22138.5	21992.9	22034.0	151026.0
2017-03-16	CL	Futures	51.99	52.55	51.37	51.61	376317.0
2017-03-16	GC	Futures	1557.9	1576.4	1556.1	1567.6	257887.0
2017-03-16	ZN	Futures	121.723502	121.800319	121.324056	121.523779	1231017.0
2017-03-16	A6	Futures	0.78933	0.79108	0.78533	0.78594	106627.0
2017-03-16	AD	Futures	0.76773	0.76916	0.76472	0.76579	72381.0
2017-03-16	ALI	Futures	2492.53	2492.53	2492.53	2492.53	0.0
2017-03-16	B	Futures	38.03	38.45	37.61	37.78	281525.0
2017-03-16	B6	Futures	1.2917	1.3007	1.2864	1.2987	126931.0
2017-03-16	BR	Futures	0.22966	0.22966	0.22861	0.22872	7.0
2017-03-16	BZ	Futures	37.87	38.23	37.44	37.61	28932.0
2017-03-16	C	Futures	1746.0	1759.0	1706.0	1713.0	7818.0
2017-03-16	CB	Futures	265.781	266.757	264.865	265.537	41.0
2017-03-16	CC	Futures	1569.0	1580.0	1544.0	1548.0	14881.0
2017-03-16	CNH	Futures	7.1966	7.2157	7.1966	7.2088	58.0
2017-03-16	CSC	Futures	3.618	3.618	3.533	3.576	141.0
2017-03-16	CT	Futures	87.03	87.93	86.94	87.13	11748.0
2017-03-16	DC	Futures	29.47	29.47	28.78	29.12	441.0
2017-03-16	DX	Futures	93.488	93.707	93.208	93.339	36549.0
2017-03-16	E1	Futures	1.24255	1.24873	1.24095	1.247	26127.0
2017-03-16	E6	Futures	1.242	1.24626	1.23877	1.24373	214522.0
2017-03-16	E7	Futures	1.2358	1.2398	1.2325	1.2374	3730.0
2017-03-16	EBM	Futures	193.5	194.06	192.38	193.22	18117.0
2017-03-16	ED	Futures	95.5252	95.53	95.5058	95.5252	386008.0
2017-03-16	ER	Futures	98.313	98.318	98.298	98.313	86792.0
2017-03-16	EW	Futures	1833.1	1844.2	1831.8	1836.2	15621.0
2017-03-16	FBON	Futures	120.14	120.45	119.29	119.38	696.0
2017-03-16	FBTP	Futures	103.73	104.01	102.8	102.93	102460.0
2017-03-16	FBTS	Futures	101.61	101.673	101.537	101.564	39760.0
2017-03-16	FCE	Futures	4415.6	4430.2	4401.0	4409.4	88527.0
2017-03-16	FDAX	Futures	12773.0	12855.9	12712.8	12756.1	112364.0
2017-03-16	FDXM	Futures	12693.2	12774.9	12637.8	12677.5	3587.0
2017-03-16	FESX	Futures	2743.4	2754.1	2735.3	2744.3	1135731.0
2017-03-16	FEU3	Futures	98.986	98.986	98.986	98.986	190.0
2017-03-16	FGBL	Futures	147.26	147.4	146.28	146.79	796744.0
2017-03-16	FGBM	Futures	129.15	129.19	128.59	128.93	559900.0
2017-03-16	FGBS	Futures	112.407	112.417	112.252	112.357	286082.0
2017-03-16	FGBX	Futures	166.71	167.21	163.89	165.13	50691.0
2017-03-16	FMWO	Futures	6250.7	6250.7	6237.4	6242.2	3691.0
2017-03-16	FOAT	Futures	131.02	131.47	129.99	130.23	153144.0
2017-03-16	FTDX	Futures	1956.8	1958.7	1942.6	1948.4	531.0
2017-03-16	FTI	Futures	466.52	468.25	465.02	466.2	18408.0
2017-03-16	FTUK	Futures	6247.1	6308.3	6247.1	6283.9	116466.0
2017-03-16	FVSA	Futures	671.06	671.06	653.03	662.74	22308.0
2017-03-16	FXXP	Futures	311.9	313.5	311.9	312.8	60918.0
2017-03-16	G	Futures	114.28	114.34	113.29	113.78	230154.0
2017-03-16	GF	Futures	297.909	301.945	297.736	301.08	5452.0
2017-03-16	GSCI	Futures	490.26	490.64	486.94	487.13	250.0

> showing 50 of 108 rows — these rows as CSV

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