PREVIEW / futures_daily / 2019-06-18

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-18.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-06-18	ES	Futures	3127.11	3168.65	3117.39	3157.59	2257843.0
2019-06-18	NQ	Futures	8716.1	8890.24	8683.0	8834.69	490205.0
2019-06-18	YM	Futures	27466.6	27878.2	27378.4	27829.9	203538.0
2019-06-18	CL	Futures	53.35	55.78	52.91	55.35	618302.0
2019-06-18	GC	Futures	1672.6	1690.8	1670.4	1681.1	376267.0
2019-06-18	ZN	Futures	126.662705	127.315926	126.616046	126.911551	2049160.0
2019-06-18	A6	Futures	0.70697	0.70985	0.7046	0.70903	117132.0
2019-06-18	AD	Futures	0.75284	0.75496	0.75168	0.75461	75160.0
2019-06-18	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-06-18	B	Futures	45.35	46.78	44.85	46.25	327700.0
2019-06-18	B6	Futures	1.2847	1.2877	1.2816	1.2872	87704.0
2019-06-18	BFX	Futures	4117.6	4118.8	4117.6	4118.8	52.0
2019-06-18	BR	Futures	0.20591	0.20591	0.20563	0.20591	96.0
2019-06-18	BTC	Futures	14390.7	14713.4	13806.8	14006.6	6733.0
2019-06-18	BZ	Futures	44.84	46.17	44.28	45.66	46430.0
2019-06-18	C	Futures	1779.0	1784.0	1770.0	1781.0	2288.0
2019-06-18	CB	Futures	285.327	285.327	283.868	283.868	47.0
2019-06-18	CC	Futures	1654.0	1669.0	1645.0	1665.0	13948.0
2019-06-18	CNH	Futures	6.9442	6.951	6.9078	6.9109	1218.0
2019-06-18	CSC	Futures	3.041	3.05	3.033	3.05	100.0
2019-06-18	CT	Futures	68.7	70.12	68.01	68.37	9666.0
2019-06-18	DC	Futures	25.5	25.61	25.38	25.52	223.0
2019-06-18	DX	Futures	93.412	93.648	93.282	93.54	23566.0
2019-06-18	E1	Futures	1.17072	1.17316	1.16771	1.1691	26869.0
2019-06-18	E6	Futures	1.23285	1.23531	1.22849	1.22996	255530.0
2019-06-18	E7	Futures	1.2266	1.2287	1.222	1.2235	9949.0
2019-06-18	EBM	Futures	209.29	209.87	207.85	208.43	20038.0
2019-06-18	ED	Futures	95.3282	95.3769	95.3087	95.3282	507561.0
2019-06-18	ER	Futures	98.445	98.519	98.445	98.499	328593.0
2019-06-18	EW	Futures	2002.9	2037.1	1996.0	2022.7	24143.0
2019-06-18	FBON	Futures	141.42	143.13	141.23	143.09	2943.0
2019-06-18	FBTP	Futures	118.73	121.01	118.66	120.55	173718.0
2019-06-18	FBTS	Futures	106.296	106.909	106.296	106.737	148752.0
2019-06-18	FCE	Futures	4910.6	5031.7	4902.0	5025.3	168090.0
2019-06-18	FDAX	Futures	12713.2	12999.6	12603.7	12987.0	60668.0
2019-06-18	FDIV	Futures	146.23	147.48	146.23	147.48	15.0
2019-06-18	FDXM	Futures	12559.2	12839.0	12449.0	12827.0	2357.0
2019-06-18	FESX	Futures	2947.9	3010.8	2929.6	3009.0	2244836.0
2019-06-18	FEU3	Futures	99.1	99.129	99.1	99.129	121.0
2019-06-18	FGBL	Futures	163.11	164.38	163.08	164.37	1006231.0
2019-06-18	FGBM	Futures	134.08	134.7	134.08	134.63	753754.0
2019-06-18	FGBS	Futures	112.965	113.131	112.965	113.106	476636.0
2019-06-18	FGBX	Futures	205.86	209.34	205.67	209.28	89117.0
2019-06-18	FMWO	Futures	7175.6	7281.8	7175.6	7272.5	15496.0
2019-06-18	FOAT	Futures	150.01	151.33	150.0	151.26	202670.0
2019-06-18	FTDX	Futures	2734.3	2805.4	2734.3	2803.4	1713.0
2019-06-18	FTI	Futures	518.62	527.94	515.09	526.48	34199.0
2019-06-18	FTUK	Futures	6738.6	6831.9	6716.5	6819.4	376409.0
2019-06-18	FVSA	Futures	208.35	209.04	196.58	199.35	73150.0
2019-06-18	FXXP	Futures	337.1	343.6	335.8	343.3	202586.0

> showing 50 of 120 rows — these rows as CSV

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