PREVIEW / futures_daily / 2018-05-01

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-01.parquet
  size:    9 KB
  rows:    88

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
2018-05-01	ES	Futures	2877.71	2890.49	2852.7	2884.24	1323628.0
2018-05-01	NQ	Futures	7731.88	7888.72	7699.99	7832.54	360806.0
2018-05-01	YM	Futures	25393.3	25479.7	25021.4	25356.4	215013.0
2018-05-01	CL	Futures	68.81	69.15	67.09	67.5	694771.0
2018-05-01	GC	Futures	1680.1	1681.9	1662.6	1668.4	283431.0
2018-05-01	ZN	Futures	118.656162	118.687179	118.470059	118.485567	921986.0
2018-05-01	A6	Futures	0.77427	0.77591	0.76841	0.77026	102087.0
2018-05-01	AD	Futures	0.78884	0.78986	0.78414	0.78814	84860.0
2018-05-01	B	Futures	54.71	54.95	53.31	53.59	360973.0
2018-05-01	B6	Futures	1.4289	1.4295	1.4103	1.4132	132035.0
2018-05-01	BR	Futures	0.21645	0.21679	0.21363	0.21435	2766.0
2018-05-01	BTC	Futures	13038.8	13080.9	12378.7	12617.5	3143.0
2018-05-01	BZ	Futures	54.15	54.39	52.77	53.04	39208.0
2018-05-01	C	Futures	1722.0	1770.0	1716.0	1762.0	1819.0
2018-05-01	CB	Futures	301.446	301.446	301.446	301.446	6.0
2018-05-01	CC	Futures	2050.0	2119.0	2024.0	2110.0	26274.0
2018-05-01	CNH	Futures	6.4167	6.4409	6.4166	6.4379	13.0
2018-05-01	CSC	Futures	3.457	3.492	3.457	3.467	42.0
2018-05-01	CT	Futures	95.35	96.27	95.04	96.03	13386.0
2018-05-01	DC	Futures	28.07	28.35	28.03	28.09	264.0
2018-05-01	DX	Futures	86.41	87.117	86.386	87.009	27413.0
2018-05-01	E1	Futures	1.22044	1.2208	1.21261	1.21321	19704.0
2018-05-01	E6	Futures	1.36508	1.36604	1.35438	1.3559	188349.0
2018-05-01	E7	Futures	1.3578	1.3586	1.3472	1.3486	3087.0
2018-05-01	ED	Futures	94.9354	94.9597	94.9354	94.9452	204318.0
2018-05-01	EW	Futures	1981.2	1993.9	1963.1	1989.9	15086.0
2018-05-01	FTUK	Futures	6599.8	6629.4	6582.1	6601.1	71912.0
2018-05-01	G	Futures	113.8	114.02	113.67	113.96	116561.0
2018-05-01	GF	Futures	301.872	302.356	295.524	296.761	3209.0
2018-05-01	GSCI	Futures	532.48	532.48	529.5	530.57	155.0
2018-05-01	HE	Futures	77.015	78.039	76.673	77.645	22329.0
2018-05-01	HG	Futures	3.6172	3.6343	3.5571	3.5783	97579.0
2018-05-01	HH	Futures	17.881	18.151	17.848	18.055	2362.0
2018-05-01	HO	Futures	1.4197	1.4229	1.3815	1.3872	87033.0
2018-05-01	HRC	Futures	1946.6	1964.5	1930.9	1930.9	10.0
2018-05-01	J1	Futures	0.0111242	0.0111303	0.0110636	0.0110745	87975.0
2018-05-01	J7	Futures	0.011095	0.011099	0.011035	0.011044	308.0
2018-05-01	JB	Futures	138.42	138.57	138.34	138.55	3167.0
2018-05-01	KC	Futures	147.49	150.62	146.71	150.08	30534.0
2018-05-01	KE	Futures	963.92	988.91	945.62	987.12	33445.0
2018-05-01	L	Futures	99.375	99.395	99.37	99.39	84333.0
2018-05-01	LBS	Futures	851.9	880.8	851.9	873.4	584.0
2018-05-01	LE	Futures	160.273	160.423	156.541	159.556	42073.0
2018-05-01	MFS	Futures	2101.8	2101.8	2071.9	2081.7	19609.0
2018-05-01	MGC	Futures	1641.5	1643.2	1624.6	1630.1	5306.0
2018-05-01	MME	Futures	1163.0	1164.5	1141.2	1156.1	56532.0
2018-05-01	MP	Futures	0.03709	0.03713	0.03654	0.03667	44935.0
2018-05-01	N6	Futures	0.69787	0.69867	0.69361	0.6948	29126.0
2018-05-01	NG	Futures	23.35	23.823	23.307	23.671	166920.0
2018-05-01	NIY	Futures	19760.9	19910.7	19756.5	19862.3	22254.0

> showing 50 of 88 rows — these rows as CSV

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