PREVIEW / futures_daily / 2017-01-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-26.parquet
  size:    9 KB
  rows:    110

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
2017-01-26	ES	Futures	2486.65	2492.89	2482.05	2486.92	1170427.0
2017-01-26	NQ	Futures	6067.77	6091.64	6060.11	6067.18	173375.0
2017-01-26	YM	Futures	21069.1	21138.6	21056.5	21119.7	109273.0
2017-01-26	CL	Futures	56.68	57.85	56.49	57.55	578065.0
2017-01-26	GC	Futures	1538.2	1539.4	1515.9	1523.4	95061.0
2017-01-26	ZN	Futures	121.2018	121.293492	120.850313	121.247646	1392976.0
2017-01-26	A6	Futures	0.77474	0.77597	0.76952	0.77259	64729.0
2017-01-26	AD	Futures	0.78169	0.78286	0.77827	0.78062	51430.0
2017-01-26	ALI	Futures	2486.37	2486.37	2470.97	2473.86	31.0
2017-01-26	B	Futures	41.1	41.87	40.91	41.66	299608.0
2017-01-26	B6	Futures	1.3267	1.3307	1.3183	1.3238	96329.0
2017-01-26	BFX	Futures	4391.8	4391.8	4377.2	4377.2	4.0
2017-01-26	BR	Futures	0.22223	0.22315	0.22105	0.22155	976.0
2017-01-26	BZ	Futures	40.92	41.65	40.71	41.45	30617.0
2017-01-26	C	Futures	1811.0	1813.0	1779.0	1783.0	11753.0
2017-01-26	CB	Futures	268.954	272.067	268.222	270.663	41.0
2017-01-26	CC	Futures	1663.0	1665.0	1617.0	1623.0	19674.0
2017-01-26	CNH	Futures	7.2388	7.2725	7.2388	7.2668	77.0
2017-01-26	CSC	Futures	3.921	3.976	3.905	3.949	162.0
2017-01-26	CT	Futures	84.94	86.08	84.63	85.23	16325.0
2017-01-26	DC	Futures	32.46	32.98	32.21	32.61	639.0
2017-01-26	DX	Futures	92.918	93.793	92.89	93.458	35132.0
2017-01-26	E1	Futures	1.24322	1.24632	1.23913	1.24322	23420.0
2017-01-26	E6	Futures	1.24378	1.24569	1.23321	1.23795	204441.0
2017-01-26	E7	Futures	1.2376	1.2393	1.2269	1.2316	4099.0
2017-01-26	EBM	Futures	193.42	194.27	193.13	193.7	13620.0
2017-01-26	ED	Futures	95.5472	95.552	95.5375	95.5472	221313.0
2017-01-26	ER	Futures	98.308	98.308	98.303	98.308	50929.0
2017-01-26	EW	Futures	1819.2	1826.0	1809.9	1813.5	13885.0
2017-01-26	FBON	Futures	121.21	121.45	120.74	121.01	1421.0
2017-01-26	FBTP	Futures	104.7	104.87	103.52	103.89	170502.0
2017-01-26	FBTS	Futures	101.746	101.773	101.611	101.656	70548.0
2017-01-26	FCE	Futures	4303.4	4316.2	4273.9	4284.9	101993.0
2017-01-26	FDAX	Futures	12503.8	12556.6	12478.5	12498.5	68801.0
2017-01-26	FDXM	Futures	12459.7	12506.0	12426.1	12448.2	19300.0
2017-01-26	FESX	Futures	2661.5	2668.7	2641.5	2646.3	825663.0
2017-01-26	FEU3	Futures	98.971	98.976	98.971	98.976	211.0
2017-01-26	FGBL	Futures	145.74	145.99	145.48	145.58	875402.0
2017-01-26	FGBM	Futures	128.33	128.38	128.24	128.27	577208.0
2017-01-26	FGBS	Futures	111.987	112.017	111.977	112.002	309031.0
2017-01-26	FGBX	Futures	162.83	164.0	162.26	162.81	51602.0
2017-01-26	FMWO	Futures	6058.9	6058.9	6034.8	6034.8	723.0
2017-01-26	FOAT	Futures	130.96	131.0	130.23	130.45	151989.0
2017-01-26	FTDX	Futures	1818.5	1826.9	1818.5	1825.4	151.0
2017-01-26	FTI	Futures	444.07	445.35	441.1	442.29	27708.0
2017-01-26	FTUK	Futures	6028.3	6044.0	6008.0	6011.8	82600.0
2017-01-26	FVSA	Futures	810.0	826.58	807.63	817.11	7214.0
2017-01-26	FXXP	Futures	303.8	304.8	303.2	303.4	24816.0
2017-01-26	G	Futures	110.06	110.13	109.61	109.82	176638.0
2017-01-26	GF	Futures	295.454	295.454	287.874	289.754	5264.0

> showing 50 of 110 rows — these rows as CSV

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