PREVIEW / futures_daily / 2014-09-17

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-17.parquet
  size:    9 KB
  rows:    105

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
2014-09-17	ES	Futures	2080.29	2092.57	2071.67	2082.64	2039712.0
2014-09-17	NQ	Futures	4700.81	4733.26	4681.39	4711.53	320715.0
2014-09-17	YM	Futures	17306.8	17382.9	17252.0	17316.9	188944.0
2014-09-17	CL	Futures	176.47	177.09	174.66	175.56	157911.0
2014-09-17	GC	Futures	1620.3	1627.1	1602.8	1621.1	132084.0
2014-09-17	ZN	Futures	116.40143	116.796805	116.035342	116.254995	1661310.0
2014-09-17	A6	Futures	0.87753	0.87753	0.86422	0.86956	160218.0
2014-09-17	AD	Futures	0.92393	0.92769	0.91976	0.92383	84260.0
2014-09-17	ALI	Futures	2993.97	2993.97	2993.97	2993.97	0.0
2014-09-17	B	Futures	103.37	104.05	102.91	103.39	190165.0
2014-09-17	B6	Futures	1.7092	1.7182	1.7066	1.7111	126837.0
2014-09-17	BFX	Futures	3846.5	3847.5	3841.7	3842.3	155.0
2014-09-17	BR	Futures	0.22465	0.22541	0.22414	0.22516	63.0
2014-09-17	BZ	Futures	104.11	104.78	103.64	104.12	14769.0
2014-09-17	C	Futures	2138.0	2184.0	2134.0	2178.0	9233.0
2014-09-17	CB	Futures	152.227	156.351	152.227	155.696	22.0
2014-09-17	CC	Futures	2272.0	2336.0	2267.0	2328.0	19577.0
2014-09-17	CNH	Futures	7.0947	7.1025	7.0944	7.0991	14.0
2014-09-17	CSC	Futures	5.208	5.384	5.208	5.368	39.0
2014-09-17	CT	Futures	86.88	88.68	86.54	88.18	21.0
2014-09-17	DC	Futures	41.84	43.32	41.76	43.24	430.0
2014-09-17	DX	Futures	79.962	80.555	79.81	80.2	66612.0
2014-09-17	E1	Futures	1.37187	1.37264	1.35806	1.36458	59600.0
2014-09-17	E6	Futures	1.52636	1.52942	1.51388	1.52141	298537.0
2014-09-17	E7	Futures	1.517	1.5199	1.5045	1.5118	4797.0
2014-09-17	ED	Futures	95.4183	95.4326	95.4183	95.423	260079.0
2014-09-17	ER	Futures	97.999	98.009	97.999	98.004	80133.0
2014-09-17	EW	Futures	1478.8	1486.9	1473.0	1479.7	26232.0
2014-09-17	FBTP	Futures	94.4	94.89	94.3	94.65	67602.0
2014-09-17	FBTS	Futures	98.694	98.766	98.668	98.739	8996.0
2014-09-17	FCE	Futures	3520.5	3542.8	3514.5	3522.1	87551.0
2014-09-17	FDAX	Futures	10603.4	10648.3	10573.3	10596.3	64522.0
2014-09-17	FESX	Futures	2333.2	2349.9	2327.4	2334.6	1134398.0
2014-09-17	FGBL	Futures	130.51	130.91	130.42	130.73	657340.0
2014-09-17	FGBM	Futures	122.58	122.73	122.52	122.69	430958.0
2014-09-17	FGBS	Futures	110.923	110.953	110.908	110.943	200971.0
2014-09-17	FGBX	Futures	138.26	139.22	137.96	138.8	26185.0
2014-09-17	FMWO	Futures	5777.7	5785.2	5777.7	5777.7	1656.0
2014-09-17	FOAT	Futures	120.15	120.62	119.99	120.47	63904.0
2014-09-17	FTDX	Futures	1172.4	1176.2	1172.4	1173.8	1329.0
2014-09-17	FTI	Futures	362.12	362.81	360.7	361.04	37155.0
2014-09-17	FTUK	Futures	5243.0	5251.9	5214.8	5229.1	158071.0
2014-09-17	FVSA	Futures	1416.78	1416.78	1376.19	1400.54	15479.0
2014-09-17	FXXP	Futures	260.7	261.4	259.8	260.6	49399.0
2014-09-17	G	Futures	96.06	96.29	95.95	96.14	131816.0
2014-09-17	GF	Futures	351.833	355.645	351.833	354.867	3538.0
2014-09-17	GSCI	Futures	996.32	997.83	984.96	993.54	22.0
2014-09-17	HE	Futures	129.207	130.182	125.068	126.38	16279.0
2014-09-17	HG	Futures	4.0101	4.0266	3.9701	3.9872	40800.0
2014-09-17	HH	Futures	49.164	49.164	49.164	49.164	1030.0

> showing 50 of 105 rows — these rows as CSV

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