PREVIEW / futures_daily / 2018-08-28

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-28.parquet
  size:    10 KB
  rows:    114

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-08-28	ES	Futures	3148.6	3156.47	3143.44	3148.87	902705.0
2018-08-28	NQ	Futures	8823.84	8857.65	8819.17	8835.21	273330.0
2018-08-28	YM	Futures	27479.2	27560.4	27442.4	27485.6	110164.0
2018-08-28	CL	Futures	71.8	72.08	71.05	71.38	426833.0
2018-08-28	GC	Futures	1543.3	1547.1	1528.3	1539.2	273176.0
2018-08-28	ZN	Futures	119.696543	119.743159	119.401303	119.43238	3160594.0
2018-08-28	A6	Futures	0.75586	0.7573	0.75318	0.75442	85529.0
2018-08-28	AD	Futures	0.78181	0.78627	0.7805	0.78353	71738.0
2018-08-28	B	Futures	55.86	56.3	55.44	55.61	221288.0
2018-08-28	B6	Futures	1.3315	1.3354	1.328	1.3285	78864.0
2018-08-28	BR	Futures	0.18513	0.18513	0.18258	0.18258	359.0
2018-08-28	BTC	Futures	9589.4	10161.4	9589.4	10125.7	738.0
2018-08-28	BZ	Futures	55.62	56.03	55.21	55.37	16178.0
2018-08-28	C	Futures	1581.0	1581.0	1559.0	1572.0	2537.0
2018-08-28	CB	Futures	273.67	274.061	272.769	272.889	33.0
2018-08-28	CC	Futures	1638.0	1647.0	1610.0	1620.0	14268.0
2018-08-28	CNH	Futures	6.8652	6.885	6.8572	6.8711	278.0
2018-08-28	CSC	Futures	3.323	3.325	3.323	3.325	6.0
2018-08-28	CT	Futures	93.29	94.23	93.26	94.04	18.0
2018-08-28	DC	Futures	27.3	27.46	27.2	27.35	168.0
2018-08-28	DX	Futures	89.653	89.809	89.35	89.629	18564.0
2018-08-28	E1	Futures	1.22201	1.22835	1.22034	1.22536	29179.0
2018-08-28	E6	Futures	1.30816	1.31414	1.3062	1.30972	232968.0
2018-08-28	E7	Futures	1.3015	1.3074	1.2996	1.303	3998.0
2018-08-28	EBM	Futures	205.84	208.45	205.84	206.62	9790.0
2018-08-28	ED	Futures	95.0789	95.0862	95.0765	95.0813	170035.0
2018-08-28	ER	Futures	98.362	98.367	98.362	98.367	32542.0
2018-08-28	EW	Futures	2168.0	2172.3	2156.7	2165.4	8673.0
2018-08-28	FBON	Futures	129.25	129.25	128.67	128.78	360.0
2018-08-28	FBTP	Futures	104.4	104.78	103.89	104.12	98218.0
2018-08-28	FBTS	Futures	101.733	101.808	101.483	101.715	71515.0
2018-08-28	FCE	Futures	4937.4	4961.7	4934.2	4941.9	45549.0
2018-08-28	FDAX	Futures	13118.4	13164.4	13078.7	13115.8	57673.0
2018-08-28	FDIV	Futures	149.76	149.76	149.76	149.76	15.0
2018-08-28	FDXM	Futures	12949.3	12995.7	12912.1	12948.3	25023.0
2018-08-28	FESX	Futures	2888.1	2892.3	2875.6	2885.6	593968.0
2018-08-28	FGBL	Futures	153.28	153.47	152.98	153.14	817708.0
2018-08-28	FGBM	Futures	131.13	131.18	131.0	131.06	595245.0
2018-08-28	FGBS	Futures	112.643	112.653	112.618	112.628	399513.0
2018-08-28	FGBX	Futures	177.34	177.98	176.57	176.95	46530.0
2018-08-28	FMWO	Futures	7275.6	7290.7	7265.1	7277.9	2005.0
2018-08-28	FOAT	Futures	140.87	140.97	140.59	140.69	198324.0
2018-08-28	FTDX	Futures	2972.6	2990.2	2956.9	2970.1	173.0
2018-08-28	FTI	Futures	524.1	524.51	521.31	522.15	14512.0
2018-08-28	FTUK	Futures	6770.6	6800.5	6760.8	6791.6	86718.0
2018-08-28	FVSA	Futures	253.47	256.08	251.72	253.47	16372.0
2018-08-28	FXXP	Futures	334.5	334.6	333.1	333.9	53088.0
2018-08-28	G	Futures	114.87	115.05	114.68	114.85	675964.0
2018-08-28	GF	Futures	313.654	314.538	307.777	311.053	2755.0
2018-08-28	GSCI	Futures	525.9	525.9	521.11	521.56	10.0

> showing 50 of 114 rows — these rows as CSV

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