PREVIEW / futures_daily / 2019-07-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-17.parquet
  size:    10 KB
  rows:    117

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
2019-07-17	ES	Futures	3243.37	3251.2	3216.13	3220.98	1039457.0
2019-07-17	NQ	Futures	9141.23	9171.74	9058.62	9078.77	303890.0
2019-07-17	YM	Futures	28684.6	28746.6	28543.9	28593.2	135792.0
2019-07-17	CL	Futures	58.83	59.68	57.51	58.08	375221.0
2019-07-17	GC	Futures	1752.3	1777.8	1744.1	1771.5	358172.0
2019-07-17	ZN	Futures	126.444965	126.942657	126.382753	126.771575	1072723.0
2019-07-17	A6	Futures	0.7226	0.72405	0.72106	0.72302	70637.0
2019-07-17	AD	Futures	0.77098	0.77421	0.77063	0.77376	48999.0
2019-07-17	ALI	Futures	2269.69	2269.69	2269.69	2269.69	0.0
2019-07-17	B	Futures	48.44	49.08	47.53	47.86	274930.0
2019-07-17	B6	Futures	1.2699	1.2751	1.2674	1.2732	81264.0
2019-07-17	BR	Futures	0.21118	0.21186	0.21118	0.21174	3.0
2019-07-17	BTC	Futures	13571.9	14033.9	12732.0	13711.9	8039.0
2019-07-17	BZ	Futures	47.75	48.46	46.94	47.25	34392.0
2019-07-17	C	Futures	1733.0	1748.0	1715.0	1728.0	4947.0
2019-07-17	CB	Futures	289.411	291.162	289.411	289.995	155.0
2019-07-17	CC	Futures	1629.0	1631.0	1609.0	1615.0	10186.0
2019-07-17	CNH	Futures	6.8831	6.8869	6.875	6.8791	715.0
2019-07-17	CSC	Futures	3.095	3.13	3.095	3.129	87.0
2019-07-17	CT	Futures	61.47	61.66	60.77	61.12	13.0
2019-07-17	DC	Futures	26.01	26.35	25.96	26.26	252.0
2019-07-17	DX	Futures	93.421	93.489	93.2	93.251	13963.0
2019-07-17	E1	Futures	1.18046	1.1822	1.17698	1.18139	14997.0
2019-07-17	E6	Futures	1.22882	1.23138	1.22767	1.23018	118100.0
2019-07-17	E7	Futures	1.2226	1.2249	1.2213	1.2237	2488.0
2019-07-17	EBM	Futures	202.38	204.69	201.23	203.53	14595.0
2019-07-17	ED	Futures	95.3476	95.3574	95.3282	95.3379	301696.0
2019-07-17	ER	Futures	98.529	98.538	98.529	98.533	53278.0
2019-07-17	EW	Futures	2051.3	2056.6	2032.8	2037.1	11110.0
2019-07-17	FBON	Futures	142.51	142.86	142.43	142.76	185.0
2019-07-17	FBTP	Futures	124.79	125.3	124.75	124.98	60471.0
2019-07-17	FBTS	Futures	107.686	107.724	107.609	107.647	41999.0
2019-07-17	FCE	Futures	5107.0	5119.8	5065.1	5073.8	146990.0
2019-07-17	FDAX	Futures	13062.8	13102.3	12946.5	12982.3	96430.0
2019-07-17	FDIV	Futures	146.6	146.6	146.18	146.18	20.0
2019-07-17	FDXM	Futures	12906.6	12940.9	12787.0	12822.3	34677.0
2019-07-17	FESX	Futures	3062.3	3075.4	3044.0	3051.0	867654.0
2019-07-17	FGBL	Futures	163.99	164.62	163.97	164.43	528061.0
2019-07-17	FGBM	Futures	134.37	134.57	134.35	134.52	309790.0
2019-07-17	FGBS	Futures	113.066	113.096	113.061	113.086	128926.0
2019-07-17	FGBX	Futures	207.45	209.16	207.3	208.58	47401.0
2019-07-17	FMWO	Futures	7438.7	7446.8	7394.8	7416.8	1136.0
2019-07-17	FOAT	Futures	151.42	151.86	151.38	151.75	88395.0
2019-07-17	FTDX	Futures	2857.2	2857.2	2831.5	2838.4	35.0
2019-07-17	FTI	Futures	537.25	542.28	537.2	539.93	41383.0
2019-07-17	FTUK	Futures	6915.4	6936.2	6881.3	6893.7	67670.0
2019-07-17	FVSA	Futures	171.89	176.83	170.03	176.22	33686.0
2019-07-17	FXXP	Futures	347.0	348.0	345.7	346.2	35864.0
2019-07-17	G	Futures	120.37	120.74	120.19	120.65	191019.0
2019-07-17	GF	Futures	275.962	276.502	272.577	275.864	3901.0

> showing 50 of 117 rows — these rows as CSV

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