PREVIEW / futures_daily / 2014-09-04

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-04.parquet
  size:    9 KB
  rows:    106

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-04	ES	Futures	2076.29	2087.98	2067.98	2075.26	1519084.0
2014-09-04	NQ	Futures	4697.9	4731.65	4680.01	4695.01	276115.0
2014-09-04	YM	Futures	17225.4	17308.1	17169.9	17232.5	135777.0
2014-09-04	CL	Futures	177.08	177.68	175.39	175.93	254140.0
2014-09-04	GC	Futures	1665.5	1677.9	1654.4	1661.2	151579.0
2014-09-04	ZN	Futures	117.484012	117.717434	117.090113	117.163057	103405.0
2014-09-04	A6	Futures	0.90224	0.90726	0.90127	0.9032	117123.0
2014-09-04	AD	Futures	0.93256	0.93825	0.93063	0.93327	64108.0
2014-09-04	ALI	Futures	3091.7	3091.7	3091.7	3091.7	0.0
2014-09-04	B	Futures	107.54	108.07	106.74	106.86	159671.0
2014-09-04	B6	Futures	1.7302	1.7308	1.7166	1.7168	139197.0
2014-09-04	BFX	Futures	3873.2	3904.2	3873.2	3904.2	2.0
2014-09-04	BR	Futures	0.23577	0.23618	0.2351	0.23518	631.0
2014-09-04	BZ	Futures	108.25	108.82	107.48	107.62	10600.0
2014-09-04	C	Futures	2108.0	2110.0	2081.0	2100.0	4437.0
2014-09-04	CB	Futures	157.912	158.008	157.43	158.008	27.0
2014-09-04	CC	Futures	2326.0	2331.0	2305.0	2312.0	10962.0
2014-09-04	CNH	Futures	7.0379	7.0481	7.0379	7.0481	3.0
2014-09-04	CSC	Futures	5.064	5.079	5.043	5.079	28.0
2014-09-04	CT	Futures	84.42	84.5	84.21	84.23	15.0
2014-09-04	DC	Futures	41.01	41.07	40.55	40.93	228.0
2014-09-04	DX	Futures	78.681	79.635	78.658	79.578	42979.0
2014-09-04	E1	Futures	1.39674	1.39712	1.37417	1.37456	72040.0
2014-09-04	E6	Futures	1.55149	1.55208	1.52459	1.5266	443017.0
2014-09-04	E7	Futures	1.5414	1.542	1.5145	1.5166	7818.0
2014-09-04	ED	Futures	95.4162	95.4186	95.4162	95.4186	100855.0
2014-09-04	ER	Futures	97.955	98.019	97.955	97.999	210718.0
2014-09-04	EW	Futures	1492.9	1501.6	1485.5	1489.6	13346.0
2014-09-04	FBTP	Futures	94.57	95.71	94.3	95.24	169371.0
2014-09-04	FBTS	Futures	98.792	99.023	98.756	98.917	31401.0
2014-09-04	FCE	Futures	3514.5	3590.5	3504.6	3579.4	143070.0
2014-09-04	FDAX	Futures	10587.4	10722.9	10503.7	10712.4	173224.0
2014-09-04	FESX	Futures	2309.5	2364.1	2301.6	2356.2	1888913.0
2014-09-04	FEU3	Futures	98.581	98.621	98.581	98.621	281.0
2014-09-04	FGBL	Futures	131.26	131.73	130.86	131.0	1578682.0
2014-09-04	FGBM	Futures	122.49	122.92	122.44	122.73	1075314.0
2014-09-04	FGBS	Futures	110.858	110.998	110.843	110.968	762991.0
2014-09-04	FGBX	Futures	141.47	141.63	139.16	139.36	89665.0
2014-09-04	FMWO	Futures	5825.5	5850.6	5824.2	5840.6	495.0
2014-09-04	FOAT	Futures	121.13	122.03	121.07	121.28	258424.0
2014-09-04	FTDX	Futures	1180.9	1189.3	1179.5	1187.0	311.0
2014-09-04	FTI	Futures	359.32	364.23	358.71	363.15	47300.0
2014-09-04	FTUK	Futures	5282.7	5313.1	5275.0	5290.4	126206.0
2014-09-04	FVSA	Futures	1472.2	1472.2	1369.49	1386.6	19980.0
2014-09-04	FXXP	Futures	259.5	263.5	259.2	262.8	11786.0
2014-09-04	G	Futures	96.58	96.92	96.22	96.3	247352.0
2014-09-04	GF	Futures	346.334	349.281	343.425	347.187	2127.0
2014-09-04	GSCI	Futures	1019.63	1019.96	1010.24	1011.58	358.0
2014-09-04	HE	Futures	123.343	125.852	122.981	124.099	35140.0
2014-09-04	HG	Futures	3.9708	4.0247	3.9663	3.9968	33518.0

> showing 50 of 106 rows — these rows as CSV

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