PREVIEW / futures_daily / 2017-12-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-26.parquet
  size:    8 KB
  rows:    83

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-12-26	ES	Futures	2920.17	2923.16	2916.64	2920.44	376101.0
2017-12-26	NQ	Futures	7592.17	7603.3	7533.32	7565.82	135130.0
2017-12-26	YM	Futures	26132.1	26152.1	26056.2	26145.8	43677.0
2017-12-26	CL	Futures	58.39	60.0	58.31	59.96	437785.0
2017-12-26	GC	Futures	1621.5	1633.4	1619.8	1632.3	134618.0
2017-12-26	ZN	Futures	121.913484	122.098599	121.851779	122.05232	317247.0
2017-12-26	A6	Futures	0.7937	0.79524	0.79329	0.79514	17995.0
2017-12-26	AD	Futures	0.79899	0.80188	0.79853	0.80148	19513.0
2017-12-26	B	Futures	46.36	47.64	46.17	47.59	126506.0
2017-12-26	B6	Futures	1.3967	1.3982	1.3936	1.3969	24689.0
2017-12-26	BR	Futures	0.22679	0.22725	0.22679	0.22725	232.0
2017-12-26	BTC	Futures	17801.9	20619.4	17545.7	20216.0	406.0
2017-12-26	BZ	Futures	45.75	46.98	45.54	46.94	13250.0
2017-12-26	CB	Futures	274.668	274.668	273.031	273.68	27.0
2017-12-26	CC	Futures	1348.0	1394.0	1348.0	1385.0	15558.0
2017-12-26	CNH	Futures	6.7049	6.7051	6.7049	6.7051	1.0
2017-12-26	CSC	Futures	3.21	3.214	3.201	3.206	53.0
2017-12-26	CT	Futures	90.98	91.29	90.13	90.44	8623.0
2017-12-26	DC	Futures	25.24	25.26	25.04	25.17	166.0
2017-12-26	DX	Futures	87.228	87.299	87.106	87.15	6306.0
2017-12-26	E1	Futures	1.23698	1.23723	1.23322	1.2365	5874.0
2017-12-26	E6	Futures	1.35422	1.35587	1.35156	1.35371	55969.0
2017-12-26	E7	Futures	1.3471	1.3509	1.3448	1.3469	1626.0
2017-12-26	ED	Futures	95.3747	95.3796	95.3747	95.3747	27344.0
2017-12-26	ER	Futures	98.337	98.337	98.337	98.337	0.0
2017-12-26	EW	Futures	2024.3	2029.4	2021.2	2025.7	5108.0
2017-12-26	GF	Futures	306.194	313.49	306.194	312.193	2371.0
2017-12-26	GSCI	Futures	502.29	512.94	502.29	508.87	62.0
2017-12-26	HE	Futures	93.71	95.611	93.243	95.411	14808.0
2017-12-26	HG	Futures	3.8826	3.9503	3.8677	3.9269	71140.0
2017-12-26	HH	Futures	15.694	15.979	15.323	15.398	4418.0
2017-12-26	HO	Futures	1.2895	1.3326	1.2853	1.3299	31793.0
2017-12-26	HRC	Futures	1543.7	1543.7	1543.7	1543.7	0.0
2017-12-26	J1	Futures	0.0108308	0.0108546	0.0108241	0.0108461	33864.0
2017-12-26	J7	Futures	0.010791	0.010816	0.01079	0.01081	175.0
2017-12-26	JB	Futures	138.29	138.29	138.15	138.2	703.0
2017-12-26	KC	Futures	150.74	152.68	150.62	152.55	7541.0
2017-12-26	KE	Futures	813.28	817.61	803.17	808.47	12331.0
2017-12-26	LBS	Futures	628.0	630.6	624.6	628.7	236.0
2017-12-26	LE	Futures	164.608	168.773	164.608	168.634	18816.0
2017-12-26	MFS	Futures	2089.8	2094.4	2085.3	2091.9	6892.0
2017-12-26	MGC	Futures	1602.9	1614.9	1601.6	1613.8	2286.0
2017-12-26	MME	Futures	1155.3	1169.8	1075.4	1154.6	18494.0
2017-12-26	MP	Futures	0.03444	0.03481	0.03419	0.03425	34812.0
2017-12-26	N6	Futures	0.69531	0.69788	0.69461	0.69739	5899.0
2017-12-26	NG	Futures	20.403	21.049	20.052	20.197	172743.0
2017-12-26	NIY	Futures	19986.1	20038.6	19964.3	19986.1	4374.0
2017-12-26	NKD	Futures	21207.2	21262.8	21184.1	21211.8	2374.0
2017-12-26	NOK	Futures	0.126402	0.126402	0.126402	0.126402	0.0
2017-12-26	OJ	Futures	128.72	129.05	127.06	127.2	908.0

> showing 50 of 83 rows — these rows as CSV

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