PREVIEW / futures_daily / 2018-08-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-20.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-08-20	ES	Futures	3097.28	3107.05	3095.65	3104.61	817383.0
2018-08-20	NQ	Futures	8616.6	8651.87	8571.13	8612.52	286070.0
2018-08-20	YM	Futures	27083.1	27175.8	27040.9	27141.0	102528.0
2018-08-20	CL	Futures	67.92	68.35	67.55	68.14	496524.0
2018-08-20	GC	Futures	1508.7	1518.0	1507.7	1514.1	205769.0
2018-08-20	ZN	Futures	119.665465	120.022861	119.618848	119.960705	1286812.0
2018-08-20	A6	Futures	0.75246	0.75534	0.75041	0.7537	71101.0
2018-08-20	AD	Futures	0.77629	0.77725	0.77396	0.77634	51076.0
2018-08-20	B	Futures	52.32	53.03	52.06	52.64	249098.0
2018-08-20	B6	Futures	1.3162	1.3219	1.3146	1.3203	72948.0
2018-08-20	BR	Futures	0.19428	0.19428	0.19157	0.19199	1574.0
2018-08-20	BTC	Futures	9245.6	9281.3	9060.5	9160.2	2381.0
2018-08-20	BZ	Futures	52.25	52.95	52.01	52.57	18514.0
2018-08-20	C	Futures	1461.0	1499.0	1457.0	1484.0	2526.0
2018-08-20	CB	Futures	275.551	275.551	269.884	271.053	33.0
2018-08-20	CC	Futures	1497.0	1554.0	1492.0	1533.0	18583.0
2018-08-20	CNH	Futures	6.9092	6.9343	6.9089	6.9134	510.0
2018-08-20	CSC	Futures	3.26	3.26	3.218	3.232	156.0
2018-08-20	CT	Futures	93.24	93.24	93.24	93.24	1.0
2018-08-20	DC	Futures	26.26	26.46	26.01	26.15	684.0
2018-08-20	DX	Futures	90.969	91.206	90.595	90.722	17935.0
2018-08-20	E1	Futures	1.20349	1.20863	1.20158	1.20731	20811.0
2018-08-20	E6	Futures	1.28176	1.28702	1.27679	1.28501	214346.0
2018-08-20	E7	Futures	1.275	1.2805	1.2703	1.2785	3151.0
2018-08-20	EBM	Futures	221.0	221.27	217.6	218.65	9764.0
2018-08-20	ED	Futures	95.074	95.0911	95.074	95.0862	311516.0
2018-08-20	ER	Futures	98.367	98.367	98.362	98.367	24470.0
2018-08-20	EW	Futures	2133.3	2142.3	2129.3	2138.1	9187.0
2018-08-20	FBON	Futures	128.73	129.27	128.71	129.26	227.0
2018-08-20	FBTP	Futures	104.16	105.19	104.08	104.82	59182.0
2018-08-20	FBTS	Futures	101.641	101.947	101.529	101.789	33762.0
2018-08-20	FCE	Futures	4822.5	4862.6	4819.8	4846.3	46956.0
2018-08-20	FDAX	Futures	12802.2	12929.2	12782.3	12889.0	62648.0
2018-08-20	FDIV	Futures	147.29	147.34	147.11	147.11	14.0
2018-08-20	FDXM	Futures	12637.6	12764.6	12620.1	12724.3	29653.0
2018-08-20	FESX	Futures	2821.3	2843.0	2818.8	2833.8	631187.0
2018-08-20	FGBL	Futures	154.2	154.29	153.99	154.28	354790.0
2018-08-20	FGBM	Futures	131.59	131.61	131.51	131.6	210288.0
2018-08-20	FGBS	Futures	112.749	112.759	112.734	112.754	159321.0
2018-08-20	FGBX	Futures	180.2	180.4	179.7	180.36	19964.0
2018-08-20	FMWO	Futures	7140.5	7154.5	7138.2	7144.0	2120.0
2018-08-20	FOAT	Futures	141.42	141.49	141.31	141.49	57665.0
2018-08-20	FTDX	Futures	2842.1	2864.7	2836.7	2860.3	113.0
2018-08-20	FTI	Futures	513.2	516.67	513.06	515.38	16309.0
2018-08-20	FTUK	Futures	6727.4	6779.5	6718.5	6764.8	72333.0
2018-08-20	FVSA	Futures	279.6	279.6	264.79	268.27	36450.0
2018-08-20	FXXP	Futures	329.5	332.0	329.5	331.5	27266.0
2018-08-20	G	Futures	116.01	116.25	115.91	116.24	152834.0
2018-08-20	GF	Futures	315.006	316.722	313.914	314.33	3461.0
2018-08-20	GSCI	Futures	509.22	510.12	508.49	509.61	7.0

> showing 50 of 115 rows — these rows as CSV

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