PREVIEW / futures_daily / 2019-09-04

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-04.parquet
  size:    10 KB
  rows:    120

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-09-04	ES	Futures	3132.5	3171.89	3131.42	3170.81	1252834.0
2019-09-04	NQ	Futures	8766.47	8899.74	8759.85	8891.39	399672.0
2019-09-04	YM	Futures	27407.8	27708.1	27387.8	27691.3	176054.0
2019-09-04	CL	Futures	55.38	58.11	55.3	57.78	682298.0
2019-09-04	GC	Futures	1919.4	1932.0	1902.9	1924.8	412349.0
2019-09-04	ZN	Futures	130.877537	131.048619	130.613138	131.00196	30298.0
2019-09-04	A6	Futures	0.69534	0.69997	0.69524	0.69977	82754.0
2019-09-04	AD	Futures	0.75571	0.76267	0.75546	0.76257	122419.0
2019-09-04	ALI	Futures	2157.78	2164.46	2152.62	2155.36	142.0
2019-09-04	B	Futures	44.93	47.08	44.9	46.88	283104.0
2019-09-04	B6	Futures	1.234	1.2522	1.234	1.2473	155322.0
2019-09-04	BFX	Futures	4318.1	4331.4	4318.1	4331.4	6.0
2019-09-04	BR	Futures	0.19404	0.19623	0.19388	0.19578	341.0
2019-09-04	BTC	Futures	15487.5	15666.1	14958.8	15480.3	3701.0
2019-09-04	BZ	Futures	44.32	46.39	44.2	46.19	36192.0
2019-09-04	C	Futures	1575.0	1600.0	1572.0	1591.0	2054.0
2019-09-04	CB	Futures	266.051	266.169	263.335	266.139	25.0
2019-09-04	CC	Futures	1475.0	1503.0	1469.0	1489.0	32700.0
2019-09-04	CNH	Futures	7.1777	7.1801	7.1469	7.1478	665.0
2019-09-04	CSC	Futures	3.013	3.013	3.0	3.0	30.0
2019-09-04	CT	Futures	58.09	58.68	57.86	58.04	40.0
2019-09-04	DC	Futures	25.5	25.5	25.37	25.41	68.0
2019-09-04	DX	Futures	95.212	95.236	94.683	94.734	18923.0
2019-09-04	E1	Futures	1.17606	1.18487	1.17443	1.18441	26700.0
2019-09-04	E6	Futures	1.19767	1.20525	1.19756	1.20454	219746.0
2019-09-04	E7	Futures	1.1915	1.1989	1.1913	1.1982	2706.0
2019-09-04	EBM	Futures	185.97	186.26	181.65	182.23	3095.0
2019-09-04	ED	Futures	95.3988	95.3988	95.372	95.3842	307057.0
2019-09-04	ER	Futures	98.553	98.553	98.543	98.548	64415.0
2019-09-04	EW	Futures	1946.9	1977.7	1946.3	1975.7	10544.0
2019-09-04	FBON	Futures	145.58	146.38	145.58	145.86	1588.0
2019-09-04	FBTP	Futures	132.29	132.67	131.83	132.29	287208.0
2019-09-04	FBTS	Futures	108.491	108.683	108.462	108.539	147852.0
2019-09-04	FCE	Futures	4978.8	5016.4	4977.9	5011.0	68501.0
2019-09-04	FDAX	Futures	12542.6	12716.9	12533.2	12656.9	92807.0
2019-09-04	FDIV	Futures	144.42	144.42	144.42	144.42	48.0
2019-09-04	FDXM	Futures	12380.3	12559.2	12380.3	12501.0	32698.0
2019-09-04	FESX	Futures	2986.3	3021.3	2983.7	3011.7	1193103.0
2019-09-04	FGBL	Futures	170.18	170.2	169.23	169.75	972346.0
2019-09-04	FGBM	Futures	136.14	136.16	135.78	136.01	770055.0
2019-09-04	FGBS	Futures	113.348	113.363	113.267	113.323	531273.0
2019-09-04	FGBX	Futures	231.05	231.05	227.44	229.42	137244.0
2019-09-04	FMWO	Futures	7169.8	7241.4	7169.8	7228.7	7164.0
2019-09-04	FOAT	Futures	156.17	156.32	155.44	156.03	270090.0
2019-09-04	FTDX	Futures	2752.1	2769.3	2752.1	2764.4	49.0
2019-09-04	FTI	Futures	532.06	534.76	531.3	533.23	24683.0
2019-09-04	FTUK	Futures	6707.2	6764.5	6699.4	6742.3	92033.0
2019-09-04	FVSA	Futures	223.24	223.87	211.33	216.34	30605.0
2019-09-04	FXXP	Futures	341.6	344.5	341.6	343.6	39935.0
2019-09-04	G	Futures	123.44	123.52	122.64	122.75	231335.0

> showing 50 of 120 rows — these rows as CSV

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