PREVIEW / futures_daily / 2018-09-10

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-10.parquet
  size:    9 KB
  rows:    107

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-09-10	ES	Futures	3121.17	3136.92	3120.63	3128.23	1248308.0
2018-09-10	NQ	Futures	8666.15	8725.03	8644.0	8697.92	418797.0
2018-09-10	YM	Futures	27352.8	27458.1	27266.5	27298.0	2635.0
2018-09-10	CL	Futures	70.64	71.37	70.13	70.35	571174.0
2018-09-10	GC	Futures	1521.8	1525.7	1516.1	1520.6	213402.0
2018-09-10	ZN	Futures	119.13714	119.261647	119.106014	119.18383	856145.0
2018-09-10	A6	Futures	0.73128	0.73405	0.73076	0.73189	21018.0
2018-09-10	AD	Futures	0.7691	0.77021	0.76769	0.76991	12530.0
2018-09-10	B	Futures	56.18	56.79	56.05	56.39	244533.0
2018-09-10	B6	Futures	1.3338	1.348	1.332	1.3456	59295.0
2018-09-10	BR	Futures	0.18521	0.18521	0.18437	0.18513	88.0
2018-09-10	BTC	Futures	9067.4	9081.7	8831.4	8960.1	1936.0
2018-09-10	BZ	Futures	55.77	56.54	55.77	56.15	23036.0
2018-09-10	C	Futures	1525.0	1544.0	1510.0	1529.0	9538.0
2018-09-10	CB	Futures	269.164	270.065	269.164	270.005	23.0
2018-09-10	CC	Futures	1576.0	1620.0	1571.0	1606.0	20241.0
2018-09-10	CNH	Futures	6.9438	6.948	6.9319	6.9384	274.0
2018-09-10	CSC	Futures	3.297	3.317	3.295	3.317	18.0
2018-09-10	CT	Futures	93.3	94.17	93.3	94.17	9.0
2018-09-10	DC	Futures	27.35	27.43	27.16	27.43	24.0
2018-09-10	DX	Futures	90.286	90.396	89.864	89.982	10664.0
2018-09-10	E1	Futures	1.23408	1.23408	1.22567	1.22614	6923.0
2018-09-10	E6	Futures	1.29412	1.30129	1.29112	1.29912	57442.0
2018-09-10	E7	Futures	1.2876	1.2948	1.285	1.2928	951.0
2018-09-10	EBM	Futures	206.64	210.53	206.12	210.01	19670.0
2018-09-10	ED	Futures	95.0818	95.0866	95.0671	95.0769	301715.0
2018-09-10	ER	Futures	98.372	98.377	98.372	98.377	35899.0
2018-09-10	EW	Futures	2147.3	2148.2	2142.7	2142.7	60.0
2018-09-10	FBON	Futures	128.43	128.65	128.35	128.51	459.0
2018-09-10	FBTP	Futures	107.14	108.42	107.08	108.2	84465.0
2018-09-10	FBTS	Futures	102.715	103.202	102.696	103.117	43545.0
2018-09-10	FCE	Futures	4727.8	4767.9	4721.5	4748.1	64551.0
2018-09-10	FDAX	Futures	12481.3	12584.8	12465.6	12535.1	85070.0
2018-09-10	FDXM	Futures	12329.6	12412.2	12313.0	12375.0	220.0
2018-09-10	FESX	Futures	2747.8	2776.4	2747.0	2766.3	70836.0
2018-09-10	FGBL	Futures	153.07	153.22	152.66	152.83	607667.0
2018-09-10	FGBM	Futures	130.95	131.0	130.81	130.85	395595.0
2018-09-10	FGBS	Futures	112.583	112.588	112.552	112.557	332568.0
2018-09-10	FGBX	Futures	176.71	177.15	175.82	176.16	37419.0
2018-09-10	FMWO	Futures	7118.4	7156.8	7118.4	7149.8	775.0
2018-09-10	FOAT	Futures	140.67	140.9	140.58	140.78	116890.0
2018-09-10	FTDX	Futures	2858.3	2858.3	2847.0	2857.3	10.0
2018-09-10	FTI	Futures	499.51	501.74	499.51	500.62	61.0
2018-09-10	FTUK	Futures	6484.6	6495.8	6460.1	6472.1	2879.0
2018-09-10	FVSA	Futures	284.82	285.69	270.89	271.76	22544.0
2018-09-10	FXXP	Futures	323.1	324.2	323.1	323.7	2933.0
2018-09-10	G	Futures	114.88	114.89	114.54	114.71	187938.0
2018-09-10	GF	Futures	318.23	318.906	316.41	317.606	5365.0
2018-09-10	GSCI	Futures	519.25	520.65	517.73	517.96	2523.0
2018-09-10	HE	Futures	76.373	77.524	75.628	75.763	36847.0

> showing 50 of 107 rows — these rows as CSV

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