PREVIEW / futures_daily / 2014-11-28

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-28.parquet
  size:    9 KB
  rows:    102

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-11-28	ES	Futures	2166.47	2167.25	2155.5	2158.38	783116.0
2014-11-28	NQ	Futures	5010.83	5039.23	4998.08	5027.93	134101.0
2014-11-28	YM	Futures	18076.8	18136.6	18016.9	18070.7	82524.0
2014-11-28	CL	Futures	141.69	141.8	126.63	127.52	552882.0
2014-11-28	GC	Futures	1567.8	1569.8	1523.4	1538.6	254472.0
2014-11-28	ZN	Futures	119.300849	119.754798	119.286205	119.63765	234761.0
2014-11-28	A6	Futures	0.82904	0.83633	0.82379	0.82583	126639.0
2014-11-28	AD	Futures	0.9026	0.90382	0.88726	0.88787	104373.0
2014-11-28	ALI	Futures	3014.28	3014.28	3014.28	3014.28	0.0
2014-11-28	B	Futures	75.71	76.32	72.54	72.93	113007.0
2014-11-28	B6	Futures	1.6601	1.6633	1.6412	1.6416	110808.0
2014-11-28	BFX	Futures	3980.1	3980.5	3960.4	3976.7	160.0
2014-11-28	BR	Futures	0.21509	0.21509	0.20905	0.20905	57.0
2014-11-28	BZ	Futures	80.63	80.63	73.23	73.58	14465.0
2014-11-28	C	Futures	2071.0	2075.0	2046.0	2049.0	5654.0
2014-11-28	CC	Futures	2119.0	2130.0	2085.0	2098.0	10983.0
2014-11-28	CNH	Futures	7.0522	7.0719	7.0522	7.0657	140.0
2014-11-28	CT	Futures	76.39	77.54	76.39	76.73	8480.0
2014-11-28	DX	Futures	83.664	83.968	83.531	83.928	26820.0
2014-11-28	E1	Futures	1.33031	1.33223	1.32238	1.32341	41805.0
2014-11-28	E6	Futures	1.47233	1.47433	1.46291	1.46385	233459.0
2014-11-28	E7	Futures	1.4628	1.4649	1.4537	1.4546	3526.0
2014-11-28	ED	Futures	95.4398	95.4422	95.4374	95.4398	68929.0
2014-11-28	ER	Futures	98.004	98.004	97.994	97.999	11617.0
2014-11-28	EW	Futures	1514.5	1518.3	1500.3	1501.6	10329.0
2014-11-28	FBTP	Futures	97.75	98.05	97.69	97.91	70251.0
2014-11-28	FBTS	Futures	98.801	98.819	98.712	98.739	15019.0
2014-11-28	FCE	Futures	3542.3	3556.0	3522.4	3552.8	70169.0
2014-11-28	FDAX	Futures	10923.8	10954.5	10848.8	10926.6	81051.0
2014-11-28	FESX	Futures	2348.4	2354.9	2332.5	2349.9	776436.0
2014-11-28	FGBL	Futures	134.7	134.79	134.57	134.66	504952.0
2014-11-28	FGBM	Futures	123.31	123.32	123.25	123.28	270919.0
2014-11-28	FGBS	Futures	110.863	110.873	110.843	110.848	186167.0
2014-11-28	FGBX	Futures	149.61	150.05	149.53	149.59	33790.0
2014-11-28	FMWO	Futures	5801.5	5802.7	5787.7	5802.7	160.0
2014-11-28	FOAT	Futures	124.5	124.68	124.5	124.6	59621.0
2014-11-28	FTDX	Futures	1279.2	1279.2	1263.2	1275.0	64.0
2014-11-28	FTI	Futures	369.98	370.55	367.77	370.33	21911.0
2014-11-28	FTUK	Futures	5190.5	5210.6	5155.7	5204.4	87407.0
2014-11-28	FVSA	Futures	1512.03	1534.01	1507.64	1512.03	4818.0
2014-11-28	FXXP	Futures	263.7	264.1	262.0	263.6	7448.0
2014-11-28	G	Futures	101.48	101.63	101.33	101.36	136434.0
2014-11-28	GF	Futures	369.514	372.121	369.193	370.757	1608.0
2014-11-28	GSCI	Futures	835.93	837.37	819.21	821.06	212.0
2014-11-28	HE	Futures	120.204	120.673	117.789	118.359	8229.0
2014-11-28	HG	Futures	3.7499	3.7734	3.6121	3.6152	107848.0
2014-11-28	HH	Futures	50.892	50.892	49.102	49.102	826.0
2014-11-28	HO	Futures	1.8465	1.8579	1.7255	1.7325	7228.0
2014-11-28	HRC	Futures	2495.8	2495.8	2495.8	2495.8	0.0
2014-11-28	J1	Futures	0.0106549	0.0106875	0.0105484	0.0105534	164540.0

> showing 50 of 102 rows — these rows as CSV

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