PREVIEW / futures_daily / 2018-07-03

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-03.parquet
  size:    10 KB
  rows:    117

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-03	ES	Futures	2962.06	2977.54	2945.5	2946.85	860533.0
2018-07-03	NQ	Futures	8293.94	8353.69	8187.26	8189.0	300232.0
2018-07-03	YM	Futures	25602.6	25757.5	25423.5	25460.4	134117.0
2018-07-03	CL	Futures	75.04	76.24	73.67	75.1	667235.0
2018-07-03	GC	Futures	1586.8	1606.7	1581.5	1600.3	297343.0
2018-07-03	ZN	Futures	119.370225	119.712082	119.276991	119.649926	1041155.0
2018-07-03	A6	Futures	0.75473	0.76172	0.75257	0.75833	94852.0
2018-07-03	AD	Futures	0.76875	0.77219	0.76778	0.77027	56161.0
2018-07-03	B	Futures	57.09	57.94	56.55	57.36	273456.0
2018-07-03	B6	Futures	1.3598	1.367	1.3575	1.3627	103449.0
2018-07-03	BFX	Futures	4298.1	4301.0	4298.1	4301.0	2.0
2018-07-03	BR	Futures	0.19431	0.19519	0.19431	0.19447	16.0
2018-07-03	BTC	Futures	9466.5	9487.8	9302.6	9373.9	1627.0
2018-07-03	BZ	Futures	56.8	57.64	56.26	57.05	22785.0
2018-07-03	C	Futures	1729.0	1742.0	1691.0	1700.0	2465.0
2018-07-03	CB	Futures	276.24	276.24	271.353	271.353	66.0
2018-07-03	CC	Futures	1798.0	1823.0	1747.0	1759.0	18369.0
2018-07-03	CNH	Futures	6.7709	6.8195	6.7318	6.7571	117.0
2018-07-03	CSC	Futures	3.315	3.315	3.26	3.264	81.0
2018-07-03	CT	Futures	94.25	94.45	93.69	94.03	12.0
2018-07-03	DC	Futures	26.38	26.38	25.81	25.85	249.0
2018-07-03	DX	Futures	89.586	89.719	89.293	89.418	15034.0
2018-07-03	E1	Futures	1.20994	1.21317	1.20875	1.21126	17796.0
2018-07-03	E6	Futures	1.30838	1.31269	1.30681	1.31011	176487.0
2018-07-03	E7	Futures	1.3019	1.3059	1.3003	1.3035	2810.0
2018-07-03	EBM	Futures	189.88	191.45	188.31	190.93	14806.0
2018-07-03	ED	Futures	94.9815	94.9961	94.9718	94.9913	155813.0
2018-07-03	ER	Futures	98.362	98.362	98.357	98.362	24155.0
2018-07-03	EW	Futures	2070.9	2089.9	2066.7	2076.1	8451.0
2018-07-03	FBON	Futures	129.26	129.48	129.21	129.31	477.0
2018-07-03	FBTP	Futures	108.19	108.59	107.82	108.1	50528.0
2018-07-03	FBTS	Futures	102.726	102.93	102.642	102.726	40537.0
2018-07-03	FCE	Futures	4753.9	4794.3	4745.4	4775.9	59800.0
2018-07-03	FDAX	Futures	12859.7	12978.3	12817.9	12892.1	83334.0
2018-07-03	FDXM	Futures	12694.4	12813.1	12653.1	12727.4	34864.0
2018-07-03	FESX	Futures	2819.6	2848.9	2813.0	2837.2	814469.0
2018-07-03	FEU3	Futures	99.001	99.011	99.001	99.011	1.0
2018-07-03	FGBL	Futures	153.03	153.41	152.86	153.33	504751.0
2018-07-03	FGBM	Futures	131.23	131.29	131.14	131.25	335866.0
2018-07-03	FGBS	Futures	112.804	112.804	112.769	112.779	202891.0
2018-07-03	FGBX	Futures	177.74	179.12	177.2	178.86	49564.0
2018-07-03	FMWO	Futures	6953.0	6990.2	6948.3	6968.1	607.0
2018-07-03	FOAT	Futures	141.14	141.39	140.94	141.34	125290.0
2018-07-03	FTDX	Futures	2629.8	2657.3	2627.4	2644.1	500.0
2018-07-03	FTI	Futures	506.94	509.06	504.81	507.63	22454.0
2018-07-03	FTUK	Futures	6684.2	6745.7	6666.4	6701.6	89756.0
2018-07-03	FVSA	Futures	323.63	329.47	311.0	315.86	17018.0
2018-07-03	FXXP	Futures	325.2	328.1	324.8	327.1	68191.0
2018-07-03	G	Futures	115.54	115.86	115.31	115.79	200722.0
2018-07-03	GF	Futures	315.811	317.468	313.947	316.536	4752.0

> showing 50 of 117 rows — these rows as CSV

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