PREVIEW / futures_daily / 2012-04-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-18.parquet
  size:    9 KB
  rows:    99

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
2012-04-18	ES	Futures	1394.43	1397.45	1388.38	1388.88	1848236.0
2012-04-18	NQ	Futures	3108.91	3125.81	3087.14	3087.14	285992.0
2012-04-18	YM	Futures	12667.7	12690.0	12595.7	12600.5	120684.0
2012-04-18	CL	Futures	192.04	192.5	188.26	189.16	188262.0
2012-04-18	GC	Futures	2206.8	2212.7	2189.8	2191.8	106988.0
2012-04-18	ZN	Futures	113.908568	114.0981	113.75965	113.989796	810236.0
2012-04-18	A6	Futures	0.92897	0.93077	0.92411	0.92582	104194.0
2012-04-18	AD	Futures	1.01457	1.01668	1.01235	1.01426	91275.0
2012-04-18	B	Futures	107.13	107.49	105.54	106.69	251106.0
2012-04-18	B6	Futures	1.6708	1.6832	1.6677	1.6817	161279.0
2012-04-18	BFX	Futures	2727.3	2729.6	2685.6	2685.6	238.0
2012-04-18	BR	Futures	0.25404	0.25404	0.25142	0.25194	358.0
2012-04-18	BZ	Futures	113.36	113.57	111.68	112.85	894.0
2012-04-18	C	Futures	1481.0	1483.0	1456.0	1470.0	3802.0
2012-04-18	CB	Futures	78.043	78.043	77.64	77.693	35.0
2012-04-18	CC	Futures	1727.0	1729.0	1683.0	1702.0	8315.0
2012-04-18	CSC	Futures	3.485	3.49	3.426	3.432	133.0
2012-04-18	CT	Futures	112.28	116.93	112.01	115.05	13191.0
2012-04-18	DC	Futures	24.14	24.14	23.54	23.71	300.0
2012-04-18	DX	Futures	77.22	77.535	77.153	77.195	15908.0
2012-04-18	E1	Futures	1.4318	1.43285	1.42264	1.43102	43390.0
2012-04-18	E6	Futures	1.56764	1.56931	1.55916	1.5674	242766.0
2012-04-18	E7	Futures	1.5533	1.5543	1.5443	1.5524	3630.0
2012-04-18	EBM	Futures	285.02	289.74	284.69	289.4	7718.0
2012-04-18	ED	Futures	95.0693	95.074	95.0597	95.0693	83566.0
2012-04-18	ER	Futures	97.513	97.528	97.503	97.518	68935.0
2012-04-18	EW	Futures	987.3	990.2	982.8	984.3	22723.0
2012-04-18	FBTP	Futures	66.44	66.9	66.02	66.34	16869.0
2012-04-18	FBTS	Futures	84.908	85.225	84.81	84.924	2067.0
2012-04-18	FCE	Futures	2338.1	2338.1	2286.1	2296.9	166232.0
2012-04-18	FDAX	Futures	7530.8	7540.8	7433.0	7452.9	144460.0
2012-04-18	FESX	Futures	1590.9	1590.9	1557.1	1563.3	1393687.0
2012-04-18	FEU3	Futures	98.098	98.098	98.093	98.093	1.0
2012-04-18	FGBL	Futures	114.78	115.2	114.65	115.09	746555.0
2012-04-18	FGBM	Futures	114.39	114.61	114.32	114.53	351638.0
2012-04-18	FGBS	Futures	110.079	110.123	110.054	110.103	368280.0
2012-04-18	FGBX	Futures	119.11	120.13	118.88	119.89	8740.0
2012-04-18	FOAT	Futures	94.47	94.78	94.33	94.56	8323.0
2012-04-18	FTDX	Futures	733.5	734.9	728.4	731.2	113.0
2012-04-18	FTI	Futures	269.93	269.93	263.34	264.16	38522.0
2012-04-18	FTUK	Futures	4173.2	4188.5	4149.1	4160.4	92583.0
2012-04-18	FVSA	Futures	9275.89	9556.98	9242.82	9358.56	7307.0
2012-04-18	FXXP	Futures	185.2	185.3	183.7	184.1	2248.0
2012-04-18	G	Futures	94.87	95.07	94.09	94.48	154890.0
2012-04-18	GF	Futures	319.165	319.686	316.093	316.666	2445.0
2012-04-18	GSCI	Futures	1072.67	1073.31	1063.23	1066.96	77.0
2012-04-18	HE	Futures	97.423	97.946	95.553	96.02	660.0
2012-04-18	HG	Futures	4.7814	4.822	4.7408	4.765	16779.0
2012-04-18	HO	Futures	2.5737	2.5763	2.543	2.5664	37527.0
2012-04-18	HRC	Futures	2668.7	2668.7	2668.7	2668.7	25.0

> showing 50 of 99 rows — these rows as CSV

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