PREVIEW / futures_daily / 2016-11-22

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-22.parquet
  size:    9 KB
  rows:    110

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
2016-11-22	ES	Futures	2372.21	2382.76	2370.59	2379.78	1257560.0
2016-11-22	NQ	Futures	5725.39	5756.91	5724.21	5745.13	157465.0
2016-11-22	YM	Futures	19865.8	19963.5	19858.5	19945.6	115567.0
2016-11-22	CL	Futures	52.19	53.09	50.9	51.83	826208.0
2016-11-22	GC	Futures	1556.9	1566.4	1546.8	1554.0	210554.0
2016-11-22	ZN	Futures	122.377208	122.544411	122.134004	122.286006	2263826.0
2016-11-22	A6	Futures	0.75122	0.75591	0.75081	0.75428	97279.0
2016-11-22	AD	Futures	0.76311	0.76577	0.76075	0.76229	70804.0
2016-11-22	ALI	Futures	2394.16	2408.59	2394.16	2407.63	10.0
2016-11-22	B	Futures	37.41	37.95	36.57	37.31	436934.0
2016-11-22	B6	Futures	1.3159	1.3181	1.3044	1.3075	95002.0
2016-11-22	BFX	Futures	4137.2	4141.3	4131.2	4131.2	3.0
2016-11-22	BR	Futures	0.20349	0.20516	0.2028	0.20345	1102.0
2016-11-22	BZ	Futures	37.12	37.78	36.39	37.13	62072.0
2016-11-22	C	Futures	2181.0	2203.0	2160.0	2192.0	3104.0
2016-11-22	CB	Futures	255.375	255.406	255.375	255.406	7.0
2016-11-22	CC	Futures	1846.0	1869.0	1845.0	1858.0	13632.0
2016-11-22	CNH	Futures	7.4136	7.4352	7.4136	7.4304	32.0
2016-11-22	CSC	Futures	4.071	4.107	4.071	4.098	87.0
2016-11-22	CT	Futures	82.45	82.73	81.55	82.59	6379.0
2016-11-22	DC	Futures	32.5	32.82	32.48	32.76	404.0
2016-11-22	DX	Futures	93.849	94.347	93.733	94.101	33989.0
2016-11-22	E1	Futures	1.23696	1.23896	1.23086	1.23322	20432.0
2016-11-22	E6	Futures	1.23342	1.23673	1.22803	1.23279	177466.0
2016-11-22	E7	Futures	1.2271	1.23	1.2214	1.2261	3426.0
2016-11-22	EBM	Futures	198.0	200.06	198.0	199.18	19227.0
2016-11-22	ED	Futures	95.5959	95.5983	95.5911	95.5935	237859.0
2016-11-22	ER	Futures	98.279	98.279	98.274	98.279	35863.0
2016-11-22	EW	Futures	1718.4	1733.0	1717.9	1731.8	15269.0
2016-11-22	FBON	Futures	120.15	120.51	120.14	120.25	134.0
2016-11-22	FBTP	Futures	103.32	104.11	103.18	103.45	118795.0
2016-11-22	FBTS	Futures	100.718	100.808	100.709	100.763	33461.0
2016-11-22	FCE	Futures	4034.9	4035.4	4004.9	4011.5	98540.0
2016-11-22	FDAX	Futures	11379.6	11393.3	11305.1	11317.2	76603.0
2016-11-22	FDXM	Futures	11348.1	11366.1	11280.6	11292.8	18229.0
2016-11-22	FESX	Futures	2448.6	2451.0	2433.4	2436.6	885394.0
2016-11-22	FEU3	Futures	98.956	98.956	98.956	98.956	31.0
2016-11-22	FGBL	Futures	146.77	147.53	146.73	147.37	741667.0
2016-11-22	FGBM	Futures	128.2	128.56	128.18	128.49	550555.0
2016-11-22	FGBS	Futures	111.997	112.092	111.987	112.077	446596.0
2016-11-22	FGBX	Futures	172.99	175.13	172.99	174.22	46155.0
2016-11-22	FMWO	Futures	5741.3	5743.7	5714.6	5718.3	38.0
2016-11-22	FOAT	Futures	132.42	133.19	132.34	132.81	158316.0
2016-11-22	FTDX	Futures	1705.3	1708.3	1701.4	1703.8	79.0
2016-11-22	FTI	Futures	416.29	417.93	415.42	415.83	27868.0
2016-11-22	FTUK	Futures	5733.0	5777.7	5727.5	5747.4	88511.0
2016-11-22	FVSA	Futures	1300.76	1307.04	1281.91	1300.76	10727.0
2016-11-22	FXXP	Futures	282.6	282.6	280.8	281.1	17921.0
2016-11-22	G	Futures	110.49	110.98	110.48	110.68	265606.0
2016-11-22	GF	Futures	276.173	278.181	274.611	276.731	3174.0

> showing 50 of 110 rows — these rows as CSV

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