PREVIEW / futures_daily / 2018-01-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-29.parquet
  size:    10 KB
  rows:    111

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-01-29	ES	Futures	3123.96	3128.58	3099.23	3101.41	1395078.0
2018-01-29	NQ	Futures	8233.39	8253.6	8174.83	8189.47	407157.0
2018-01-29	YM	Futures	28035.7	28141.1	27858.5	27873.3	212388.0
2018-01-29	CL	Futures	66.16	66.44	64.96	65.54	656168.0
2018-01-29	GC	Futures	1729.1	1732.5	1712.8	1718.2	233757.0
2018-01-29	ZN	Futures	120.494271	120.571402	120.016058	120.262878	1927423.0
2018-01-29	A6	Futures	0.83371	0.83495	0.83042	0.8333	106364.0
2018-01-29	AD	Futures	0.82407	0.82508	0.82178	0.82437	65927.0
2018-01-29	B	Futures	50.36	50.42	49.33	49.66	353738.0
2018-01-29	B6	Futures	1.4739	1.475	1.4613	1.4669	139286.0
2018-01-29	BR	Futures	0.24012	0.24061	0.23864	0.23883	8169.0
2018-01-29	BTC	Futures	14977.2	15322.0	14274.5	14534.8	463.0
2018-01-29	BZ	Futures	49.77	49.77	48.69	49.0	26936.0
2018-01-29	C	Futures	1267.0	1276.0	1247.0	1253.0	10590.0
2018-01-29	CB	Futures	267.194	267.472	266.885	266.885	14.0
2018-01-29	CC	Futures	1479.0	1495.0	1443.0	1452.0	32145.0
2018-01-29	CNH	Futures	6.4685	6.494	6.4685	6.4801	56.0
2018-01-29	CSC	Futures	3.127	3.137	3.122	3.137	31.0
2018-01-29	CT	Futures	94.04	94.16	91.28	91.52	36663.0
2018-01-29	DC	Futures	24.83	25.04	24.81	25.02	86.0
2018-01-29	DX	Futures	83.533	83.993	83.425	83.703	25766.0
2018-01-29	E1	Futures	1.30423	1.30496	1.29792	1.30059	43902.0
2018-01-29	E6	Futures	1.41204	1.41357	1.4028	1.40875	282188.0
2018-01-29	E7	Futures	1.4053	1.4065	1.3957	1.4017	4931.0
2018-01-29	EBM	Futures	171.0	172.62	171.0	171.27	25085.0
2018-01-29	ED	Futures	95.3019	95.3019	95.2873	95.2922	218573.0
2018-01-29	ER	Futures	98.332	98.337	98.332	98.337	78294.0
2018-01-29	EW	Futures	2115.8	2120.5	2097.9	2099.3	13038.0
2018-01-29	FBON	Futures	126.96	127.13	126.7	126.71	396.0
2018-01-29	FBTP	Futures	111.29	111.31	110.79	110.97	116081.0
2018-01-29	FBTS	Futures	103.576	103.576	103.476	103.503	64434.0
2018-01-29	FCE	Futures	4943.7	4943.7	4915.1	4921.4	44304.0
2018-01-29	FDAX	Futures	13866.4	13871.5	13764.2	13816.0	69805.0
2018-01-29	FDXM	Futures	13891.4	13894.6	13788.6	13839.5	20749.0
2018-01-29	FESX	Futures	2981.0	2981.8	2963.0	2968.7	629595.0
2018-01-29	FGBL	Futures	147.91	147.95	147.04	147.09	1017994.0
2018-01-29	FGBM	Futures	128.35	128.39	128.13	128.18	810855.0
2018-01-29	FGBS	Futures	112.226	112.236	112.166	112.201	628357.0
2018-01-29	FGBX	Futures	167.55	167.86	165.74	165.88	74759.0
2018-01-29	FMWO	Futures	7424.2	7424.2	7370.5	7376.3	921.0
2018-01-29	FOAT	Futures	136.67	136.74	135.95	136.0	128248.0
2018-01-29	FTDX	Futures	2673.0	2680.5	2664.5	2666.5	179.0
2018-01-29	FTI	Futures	526.83	526.88	523.58	524.51	18588.0
2018-01-29	FTUK	Futures	6686.4	6689.1	6634.9	6654.1	78287.0
2018-01-29	FVSA	Futures	251.21	258.95	251.21	256.37	17591.0
2018-01-29	FXXP	Futures	340.8	340.8	338.7	339.4	33184.0
2018-01-29	G	Futures	112.77	113.03	112.77	112.89	188456.0
2018-01-29	GF	Futures	325.113	328.242	320.941	322.807	5861.0
2018-01-29	GSCI	Futures	532.47	532.47	530.22	531.61	390.0
2018-01-29	HE	Futures	95.086	95.278	94.122	94.283	13060.0

> showing 50 of 111 rows — these rows as CSV

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