PREVIEW / futures_daily / 2018-07-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-18.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-07-18	ES	Futures	3055.19	3060.9	3048.4	3058.45	860523.0
2018-07-18	NQ	Futures	8655.95	8671.69	8606.11	8632.92	267804.0
2018-07-18	YM	Futures	26466.6	26549.9	26427.7	26512.0	108762.0
2018-07-18	CL	Futures	69.03	70.37	68.59	70.1	472612.0
2018-07-18	GC	Futures	1566.5	1569.2	1558.7	1567.6	283976.0
2018-07-18	ZN	Futures	119.447919	119.58777	119.339147	119.401303	866201.0
2018-07-18	A6	Futures	0.75966	0.76192	0.75524	0.76121	79247.0
2018-07-18	AD	Futures	0.76839	0.77027	0.76464	0.76946	62874.0
2018-07-18	B	Futures	52.92	54.05	52.51	53.77	287114.0
2018-07-18	B6	Futures	1.3564	1.3567	1.3457	1.351	139379.0
2018-07-18	BR	Futures	0.19706	0.19831	0.1963	0.19774	68.0
2018-07-18	BTC	Futures	10520.7	10819.8	10314.1	10534.9	6956.0
2018-07-18	BZ	Futures	52.56	53.76	52.24	53.48	25625.0
2018-07-18	C	Futures	1671.0	1685.0	1626.0	1629.0	9362.0
2018-07-18	CB	Futures	275.221	275.221	275.221	275.221	13.0
2018-07-18	CC	Futures	1718.0	1722.0	1664.0	1675.0	19502.0
2018-07-18	CNH	Futures	6.8036	6.8384	6.8036	6.8243	215.0
2018-07-18	CSC	Futures	3.23	3.278	3.23	3.26	93.0
2018-07-18	CT	Futures	99.64	100.11	99.64	99.67	6.0
2018-07-18	DC	Futures	25.73	26.18	25.73	26.03	291.0
2018-07-18	DX	Futures	89.785	90.145	89.709	89.796	27546.0
2018-07-18	E1	Futures	1.20098	1.20313	1.19692	1.20194	20888.0
2018-07-18	E6	Futures	1.30989	1.31039	1.30324	1.30844	204532.0
2018-07-18	E7	Futures	1.3032	1.3037	1.2966	1.3018	2855.0
2018-07-18	EBM	Futures	196.16	196.42	194.33	194.59	11932.0
2018-07-18	ED	Futures	94.9815	94.9815	94.9718	94.9767	139217.0
2018-07-18	ER	Futures	98.367	98.367	98.362	98.367	11293.0
2018-07-18	EW	Futures	2116.7	2122.9	2106.4	2122.0	9123.0
2018-07-18	FBON	Futures	129.82	129.85	129.46	129.53	433.0
2018-07-18	FBTP	Futures	109.93	110.0	109.47	109.49	59018.0
2018-07-18	FBTS	Futures	103.134	103.134	102.921	103.013	33772.0
2018-07-18	FCE	Futures	4882.3	4897.1	4875.6	4885.4	92913.0
2018-07-18	FDAX	Futures	13285.1	13348.4	13264.8	13327.5	77161.0
2018-07-18	FDXM	Futures	13113.4	13177.4	13095.8	13157.2	28222.0
2018-07-18	FESX	Futures	2889.8	2908.2	2889.0	2904.8	891819.0
2018-07-18	FEU3	Futures	99.016	99.021	99.016	99.021	108.0
2018-07-18	FGBL	Futures	153.35	153.78	153.35	153.54	429737.0
2018-07-18	FGBM	Futures	131.17	131.32	131.17	131.22	288499.0
2018-07-18	FGBS	Futures	112.698	112.723	112.693	112.708	127572.0
2018-07-18	FGBX	Futures	178.0	178.88	177.84	178.22	40391.0
2018-07-18	FMWO	Futures	7134.7	7139.3	7120.7	7134.7	1496.0
2018-07-18	FOAT	Futures	141.48	141.77	141.46	141.56	68922.0
2018-07-18	FTDX	Futures	2819.1	2826.4	2816.6	2818.1	203.0
2018-07-18	FTI	Futures	516.86	522.91	516.44	521.94	34941.0
2018-07-18	FTUK	Futures	6768.0	6794.7	6759.9	6786.7	79990.0
2018-07-18	FVSA	Futures	266.56	268.47	260.83	263.69	23600.0
2018-07-18	FXXP	Futures	332.8	334.1	332.8	333.8	40810.0
2018-07-18	G	Futures	115.62	116.33	115.62	116.04	210517.0
2018-07-18	GF	Futures	314.205	320.886	313.118	319.954	7169.0
2018-07-18	GSCI	Futures	507.41	513.16	507.13	511.98	69.0

> showing 50 of 115 rows — these rows as CSV

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