PREVIEW / futures_daily / 2018-06-27

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-27.parquet
  size:    10 KB
  rows:    115

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-06-27	ES	Futures	2961.25	2984.6	2933.55	2937.89	2117686.0
2018-06-27	NQ	Futures	8275.86	8337.95	8147.32	8159.27	546252.0
2018-06-27	YM	Futures	25582.6	25882.9	25371.9	25430.9	311825.0
2018-06-27	CL	Futures	71.59	74.0	71.47	73.7	775155.0
2018-06-27	GC	Futures	1609.3	1611.0	1598.7	1603.6	256900.0
2018-06-27	ZN	Futures	119.323608	119.743159	119.276991	119.72762	1898576.0
2018-06-27	A6	Futures	0.76028	0.76203	0.75318	0.75637	140696.0
2018-06-27	AD	Futures	0.76257	0.76394	0.75766	0.76196	102640.0
2018-06-27	B	Futures	56.36	57.54	56.14	57.14	390197.0
2018-06-27	B6	Futures	1.3692	1.3703	1.3571	1.3593	131539.0
2018-06-27	BR	Futures	0.19866	0.19866	0.19561	0.19561	213.0
2018-06-27	BTC	Futures	8818.3	8818.3	8512.0	8739.9	875.0
2018-06-27	BZ	Futures	56.09	57.24	55.85	56.83	31362.0
2018-06-27	C	Futures	1669.0	1669.0	1634.0	1656.0	1998.0
2018-06-27	CB	Futures	276.66	278.549	276.66	277.65	71.0
2018-06-27	CC	Futures	1773.0	1777.0	1688.0	1706.0	27185.0
2018-06-27	CNH	Futures	6.6681	6.7113	6.6681	6.7099	183.0
2018-06-27	CSC	Futures	3.297	3.329	3.295	3.327	71.0
2018-06-27	CT	Futures	96.34	96.52	96.27	96.45	4.0
2018-06-27	DC	Futures	26.08	26.53	26.0	26.48	240.0
2018-06-27	DX	Futures	89.383	90.079	89.217	89.945	20158.0
2018-06-27	E1	Futures	1.21436	1.21652	1.20612	1.20707	22286.0
2018-06-27	E6	Futures	1.31039	1.31347	1.29859	1.30044	302853.0
2018-06-27	E7	Futures	1.3038	1.3067	1.292	1.2938	4335.0
2018-06-27	EBM	Futures	181.51	183.34	181.25	182.82	10375.0
2018-06-27	ED	Futures	94.9864	95.001	94.9864	94.9913	274786.0
2018-06-27	ER	Futures	98.362	98.362	98.357	98.362	41216.0
2018-06-27	EW	Futures	2084.5	2096.3	2059.8	2060.6	17179.0
2018-06-27	FBON	Futures	128.28	128.9	128.28	128.68	565.0
2018-06-27	FBTP	Futures	105.95	106.69	105.49	106.44	76232.0
2018-06-27	FBTS	Futures	101.808	102.29	101.78	102.216	55219.0
2018-06-27	FCE	Futures	4758.4	4825.3	4711.7	4785.4	95467.0
2018-06-27	FDAX	Futures	12811.6	12990.9	12654.3	12884.8	136194.0
2018-06-27	FDIV	Futures	146.48	146.66	146.48	146.66	30.0
2018-06-27	FDXM	Futures	12650.0	12824.4	12496.2	12720.2	59484.0
2018-06-27	FESX	Futures	2812.1	2852.2	2781.2	2827.2	1466807.0
2018-06-27	FGBL	Futures	152.73	153.17	152.66	152.93	607725.0
2018-06-27	FGBM	Futures	131.15	131.34	131.13	131.2	363301.0
2018-06-27	FGBS	Futures	112.779	112.814	112.769	112.784	293554.0
2018-06-27	FGBX	Futures	174.59	176.43	174.51	176.07	51414.0
2018-06-27	FMWO	Futures	6948.3	7004.2	6906.4	6969.3	1571.0
2018-06-27	FOAT	Futures	140.15	140.53	140.14	140.47	135628.0
2018-06-27	FTDX	Futures	2672.5	2674.0	2635.2	2661.2	313.0
2018-06-27	FTI	Futures	506.11	512.2	501.81	509.61	39022.0
2018-06-27	FTUK	Futures	6681.5	6748.4	6634.3	6723.0	130917.0
2018-06-27	FVSA	Futures	319.75	340.16	308.08	322.66	43522.0
2018-06-27	FXXP	Futures	325.0	328.8	322.1	326.8	110459.0
2018-06-27	G	Futures	115.29	115.76	115.28	115.72	221571.0
2018-06-27	GF	Futures	302.656	302.708	300.171	301.983	4078.0
2018-06-27	GSCI	Futures	535.51	540.61	535.51	538.87	111.0

> showing 50 of 115 rows — these rows as CSV

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