PREVIEW / futures_daily / 2016-11-07

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-07.parquet
  size:    9 KB
  rows:    109

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
2016-11-07	ES	Futures	2277.84	2304.61	2274.33	2302.72	1761750.0
2016-11-07	NQ	Futures	5550.67	5635.52	5550.67	5628.45	223773.0
2016-11-07	YM	Futures	18900.9	19120.3	18883.0	19102.5	172027.0
2016-11-07	CL	Futures	48.5	49.12	48.13	48.98	605733.0
2016-11-07	GC	Futures	1660.9	1663.4	1640.5	1641.5	221681.0
2016-11-07	ZN	Futures	126.329273	126.466075	126.238071	126.314072	788423.0
2016-11-07	A6	Futures	0.78193	0.78785	0.78142	0.78663	75852.0
2016-11-07	AD	Futures	0.76628	0.76823	0.76362	0.76654	56238.0
2016-11-07	ALI	Futures	2304.44	2324.94	2300.59	2324.94	20.0
2016-11-07	B	Futures	34.71	35.23	34.47	35.06	276169.0
2016-11-07	B6	Futures	1.3143	1.3168	1.3042	1.3063	117842.0
2016-11-07	BFX	Futures	4124.1	4127.6	4124.1	4127.6	3.0
2016-11-07	BR	Futures	0.2115	0.21325	0.21064	0.21246	2086.0
2016-11-07	BZ	Futures	34.83	35.06	34.31	34.89	30522.0
2016-11-07	C	Futures	2249.0	2267.0	2165.0	2181.0	15062.0
2016-11-07	CB	Futures	239.308	239.308	238.688	238.688	7.0
2016-11-07	CC	Futures	1934.0	1934.0	1855.0	1861.0	36271.0
2016-11-07	CNH	Futures	7.3069	7.3156	7.305	7.314	19.0
2016-11-07	CSC	Futures	4.008	4.052	4.008	4.052	41.0
2016-11-07	CT	Futures	76.33	77.83	76.25	76.68	26027.0
2016-11-07	DC	Futures	31.46	32.13	31.45	31.98	824.0
2016-11-07	DX	Futures	90.596	91.104	90.508	91.018	19688.0
2016-11-07	E1	Futures	1.28169	1.28331	1.27546	1.28107	22133.0
2016-11-07	E6	Futures	1.28785	1.29011	1.28043	1.2817	151641.0
2016-11-07	E7	Futures	1.2805	1.283	1.2734	1.2748	1786.0
2016-11-07	EBM	Futures	190.64	190.94	188.29	188.58	25650.0
2016-11-07	ED	Futures	95.6345	95.6393	95.6249	95.6345	279999.0
2016-11-07	ER	Futures	98.264	98.269	98.264	98.269	24983.0
2016-11-07	EW	Futures	1589.1	1605.1	1588.5	1603.5	19034.0
2016-11-07	FBON	Futures	123.02	123.45	122.99	123.17	304.0
2016-11-07	FBTP	Futures	106.1	106.42	105.82	106.29	81048.0
2016-11-07	FBTS	Futures	100.987	101.05	100.961	101.041	19484.0
2016-11-07	FCE	Futures	3952.9	3974.7	3940.8	3968.5	91070.0
2016-11-07	FDAX	Futures	11031.4	11063.6	10964.3	11025.6	94779.0
2016-11-07	FDXM	Futures	10999.1	11035.0	10941.1	11001.7	19661.0
2016-11-07	FESX	Futures	2400.5	2410.2	2388.5	2401.3	988945.0
2016-11-07	FGBL	Futures	147.91	148.25	147.86	148.18	455189.0
2016-11-07	FGBM	Futures	128.34	128.44	128.3	128.39	284153.0
2016-11-07	FGBS	Futures	111.837	111.857	111.832	111.852	208101.0
2016-11-07	FGBX	Futures	177.15	178.33	176.82	178.07	41546.0
2016-11-07	FMWO	Futures	5602.1	5622.7	5602.1	5620.3	357.0
2016-11-07	FOAT	Futures	135.3	135.66	135.27	135.59	69839.0
2016-11-07	FTDX	Futures	1744.5	1744.5	1669.1	1685.2	185.0
2016-11-07	FTI	Futures	408.93	411.5	408.1	410.91	28224.0
2016-11-07	FTUK	Futures	5638.9	5731.3	5637.6	5709.8	113500.0
2016-11-07	FVSA	Futures	1375.87	1378.96	1332.58	1360.41	24227.0
2016-11-07	FXXP	Futures	273.5	275.4	273.2	274.5	25172.0
2016-11-07	G	Futures	112.37	112.54	112.07	112.24	124804.0
2016-11-07	GF	Futures	269.996	270.265	263.07	266.453	1890.0
2016-11-07	GSCI	Futures	487.05	488.09	483.66	486.85	2416.0

> showing 50 of 109 rows — these rows as CSV

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