PREVIEW / futures_daily / 2014-09-29

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-29.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-29	ES	Futures	2062.8	2065.15	2042.69	2057.31	1786769.0
2014-09-29	NQ	Futures	4688.93	4695.3	4633.59	4677.05	350305.0
2014-09-29	YM	Futures	17286.5	17286.5	17092.7	17226.6	178934.0
2014-09-29	CL	Futures	175.84	178.27	174.69	178.14	261246.0
2014-09-29	GC	Futures	1599.0	1605.3	1594.1	1598.6	105757.0
2014-09-29	ZN	Futures	116.679657	117.031102	116.577152	116.928597	1157724.0
2014-09-29	A6	Futures	0.84605	0.84634	0.83924	0.84332	126684.0
2014-09-29	AD	Futures	0.90889	0.91093	0.90707	0.9095	62781.0
2014-09-29	ALI	Futures	2962.74	2962.74	2962.74	2962.74	0.0
2014-09-29	B	Futures	101.14	101.65	100.62	101.53	130369.0
2014-09-29	B6	Futures	1.7059	1.7096	1.7032	1.707	80931.0
2014-09-29	BFX	Futures	3863.5	3863.9	3861.3	3862.4	7.0
2014-09-29	BR	Futures	0.21642	0.21706	0.21418	0.21636	2218.0
2014-09-29	BZ	Futures	101.81	102.4	101.36	102.27	18476.0
2014-09-29	C	Futures	2264.0	2274.0	2247.0	2258.0	4734.0
2014-09-29	CB	Futures	156.467	156.467	154.54	154.54	6.0
2014-09-29	CC	Futures	2447.0	2463.0	2424.0	2444.0	9697.0
2014-09-29	CNH	Futures	7.0923	7.1212	7.089	7.1202	11.0
2014-09-29	CSC	Futures	5.329	5.344	5.161	5.171	53.0
2014-09-29	CT	Futures	78.07	79.67	77.8	77.89	10401.0
2014-09-29	DC	Futures	42.7	42.95	41.34	41.41	377.0
2014-09-29	DX	Futures	81.457	81.571	81.248	81.368	21877.0
2014-09-29	E1	Futures	1.34425	1.34847	1.34246	1.34566	33716.0
2014-09-29	E6	Futures	1.49352	1.49752	1.4914	1.49493	181938.0
2014-09-29	E7	Futures	1.484	1.4881	1.4821	1.4855	2383.0
2014-09-29	ED	Futures	95.4374	95.4374	95.4278	95.4326	125333.0
2014-09-29	ER	Futures	98.004	98.014	98.004	98.009	47930.0
2014-09-29	EW	Futures	1438.6	1439.2	1422.1	1435.9	19522.0
2014-09-29	FBTP	Futures	94.94	95.02	94.61	94.91	88505.0
2014-09-29	FBTS	Futures	98.668	98.668	98.597	98.641	12722.0
2014-09-29	FCE	Futures	3505.3	3505.3	3449.6	3469.9	100753.0
2014-09-29	FDAX	Futures	10422.6	10423.2	10265.4	10332.3	120061.0
2014-09-29	FESX	Futures	2328.9	2328.9	2286.1	2302.0	885176.0
2014-09-29	FGBL	Futures	131.67	131.86	131.45	131.72	568402.0
2014-09-29	FGBM	Futures	122.85	122.92	122.78	122.88	288970.0
2014-09-29	FGBS	Futures	110.943	110.958	110.928	110.943	157179.0
2014-09-29	FGBX	Futures	141.95	142.23	141.33	141.95	22325.0
2014-09-29	FMWO	Futures	5653.6	5653.6	5621.0	5651.1	96.0
2014-09-29	FOAT	Futures	121.4	121.6	121.23	121.48	52938.0
2014-09-29	FTDX	Futures	1173.8	1180.9	1168.2	1178.1	99.0
2014-09-29	FTI	Futures	361.65	362.34	359.1	361.17	34281.0
2014-09-29	FTUK	Futures	5125.9	5137.5	5088.8	5117.8	82500.0
2014-09-29	FVSA	Futures	1449.26	1510.15	1441.14	1469.56	12936.0
2014-09-29	FXXP	Futures	259.1	259.4	256.6	258.3	6031.0
2014-09-29	G	Futures	96.65	97.01	96.56	96.82	129516.0
2014-09-29	GF	Futures	362.529	367.04	360.817	365.057	3506.0
2014-09-29	GSCI	Futures	979.32	988.58	977.8	988.07	818.0
2014-09-29	HE	Futures	123.419	128.265	123.285	127.659	19748.0
2014-09-29	HG	Futures	3.8522	3.8908	3.8211	3.8769	49883.0
2014-09-29	HH	Futures	49.095	50.22	49.095	50.22	1179.0

> showing 50 of 105 rows — these rows as CSV

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