PREVIEW / futures_daily / 2018-04-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-18.parquet
  size:    10 KB
  rows:    112

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-04-18	ES	Futures	2941.06	2956.28	2940.24	2946.77	1044851.0
2018-04-18	NQ	Futures	7981.77	8037.37	7955.14	8009.86	298181.0
2018-04-18	YM	Futures	26018.0	26133.8	25990.6	26053.8	150510.0
2018-04-18	CL	Futures	66.93	69.15	66.78	68.72	674700.0
2018-04-18	GC	Futures	1724.0	1735.0	1717.1	1728.0	311371.0
2018-04-18	ZN	Futures	119.555659	119.617694	119.183454	119.245488	1215936.0
2018-04-18	A6	Futures	0.79905	0.80183	0.79627	0.80049	87308.0
2018-04-18	AD	Futures	0.80716	0.80716	0.80007	0.80174	118190.0
2018-04-18	B	Futures	52.13	53.74	52.09	53.41	352649.0
2018-04-18	B6	Futures	1.4838	1.486	1.4713	1.4747	130290.0
2018-04-18	BR	Futures	0.22327	0.22502	0.22304	0.22502	269.0
2018-04-18	BTC	Futures	11176.6	11702.1	11162.4	11538.8	2826.0
2018-04-18	BZ	Futures	51.49	53.04	51.41	52.72	34300.0
2018-04-18	C	Futures	1673.0	1727.0	1671.0	1714.0	8775.0
2018-04-18	CB	Futures	295.269	295.269	294.188	294.188	29.0
2018-04-18	CC	Futures	1968.0	2082.0	1966.0	2041.0	33626.0
2018-04-18	CNH	Futures	6.3828	6.3858	6.3688	6.3718	175.0
2018-04-18	CSC	Futures	3.417	3.419	3.394	3.409	24.0
2018-04-18	CT	Futures	95.73	95.85	94.83	95.11	6160.0
2018-04-18	DC	Futures	27.42	27.57	27.32	27.42	91.0
2018-04-18	DX	Futures	84.151	84.41	84.094	84.266	19771.0
2018-04-18	E1	Futures	1.25247	1.25404	1.2479	1.24982	27656.0
2018-04-18	E6	Futures	1.40017	1.40265	1.39634	1.40034	194067.0
2018-04-18	E7	Futures	1.3927	1.395	1.3889	1.3929	3132.0
2018-04-18	EBM	Futures	177.47	178.01	176.4	176.66	14596.0
2018-04-18	ED	Futures	94.9452	94.95	94.9257	94.9306	288031.0
2018-04-18	ER	Futures	98.337	98.342	98.337	98.337	22685.0
2018-04-18	EW	Futures	2032.7	2048.7	2032.0	2037.6	9666.0
2018-04-18	FBON	Futures	130.13	130.3	130.08	130.1	307.0
2018-04-18	FBTP	Futures	115.94	116.48	115.94	116.29	114941.0
2018-04-18	FBTS	Futures	104.278	104.287	104.241	104.26	56104.0
2018-04-18	FCE	Futures	4729.0	4748.2	4722.8	4743.7	131585.0
2018-04-18	FDAX	Futures	13119.5	13144.5	13045.7	13099.3	83759.0
2018-04-18	FDXM	Futures	12996.5	13027.4	12930.6	12982.6	27416.0
2018-04-18	FESX	Futures	2841.4	2848.9	2835.6	2847.3	947276.0
2018-04-18	FEU3	Futures	99.03	99.03	99.026	99.026	50.0
2018-04-18	FGBL	Futures	149.87	150.14	149.59	149.67	754417.0
2018-04-18	FGBM	Futures	129.7	129.76	129.54	129.57	446765.0
2018-04-18	FGBS	Futures	112.512	112.522	112.477	112.482	321337.0
2018-04-18	FGBX	Futures	170.53	171.34	170.08	170.35	55960.0
2018-04-18	FMWO	Futures	7039.0	7065.9	7039.0	7062.4	2213.0
2018-04-18	FOAT	Futures	139.1	139.4	138.92	138.93	102696.0
2018-04-18	FTDX	Futures	2630.0	2640.9	2616.7	2636.5	220.0
2018-04-18	FTI	Futures	504.71	505.68	502.64	504.99	30836.0
2018-04-18	FTUK	Futures	6339.6	6421.7	6335.6	6412.9	94222.0
2018-04-18	FVSA	Futures	340.97	344.42	331.79	335.23	31344.0
2018-04-18	FXXP	Futures	325.6	325.6	324.1	325.4	28759.0
2018-04-18	G	Futures	113.6	114.33	113.55	113.77	239267.0
2018-04-18	GF	Futures	302.571	304.293	301.28	302.733	4606.0
2018-04-18	GSCI	Futures	532.09	536.65	531.08	534.74	96.0

> showing 50 of 112 rows — these rows as CSV

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