PREVIEW / futures_daily / 2018-03-15

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-15.parquet
  size:    9 KB
  rows:    111

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-03-15	ES	Futures	2995.7	3009.3	2985.1	2996.52	1392307.0
2018-03-15	NQ	Futures	8264.14	8310.08	8224.93	8275.55	349315.0
2018-03-15	YM	Futures	26129.6	26414.0	26011.6	26255.0	241672.0
2018-03-15	CL	Futures	61.26	61.86	61.12	61.51	321844.0
2018-03-15	GC	Futures	1692.1	1696.4	1679.6	1683.3	257888.0
2018-03-15	ZN	Futures	119.633202	119.819305	119.493625	119.602185	1317326.0
2018-03-15	A6	Futures	0.81036	0.81118	0.80172	0.80213	59164.0
2018-03-15	AD	Futures	0.78227	0.78303	0.77574	0.77635	60853.0
2018-03-15	B	Futures	46.84	47.19	46.63	47.0	208594.0
2018-03-15	B6	Futures	1.4528	1.4551	1.448	1.4491	74139.0
2018-03-15	BTC	Futures	11104.4	11721.7	10681.4	11423.5	3093.0
2018-03-15	BZ	Futures	46.23	46.62	46.06	46.42	22542.0
2018-03-15	C	Futures	1672.0	1690.0	1656.0	1677.0	12989.0
2018-03-15	CB	Futures	279.332	279.332	279.332	279.332	2.0
2018-03-15	CC	Futures	1876.0	1886.0	1841.0	1861.0	17741.0
2018-03-15	CNH	Futures	6.4458	6.4533	6.4458	6.4484	5.0
2018-03-15	CSC	Futures	3.275	3.289	3.275	3.287	18.0
2018-03-15	CT	Futures	96.08	96.39	95.0	96.01	12456.0
2018-03-15	DC	Futures	26.13	26.13	26.01	26.05	24.0
2018-03-15	DX	Futures	84.179	84.604	84.076	84.581	24635.0
2018-03-15	E1	Futures	1.28523	1.28728	1.2756	1.27596	15025.0
2018-03-15	E6	Futures	1.40372	1.40524	1.39578	1.39617	234370.0
2018-03-15	E7	Futures	1.3957	1.3976	1.3884	1.3888	5275.0
2018-03-15	EBM	Futures	177.74	178.28	176.13	177.74	23229.0
2018-03-15	ED	Futures	95.0084	95.0181	94.9986	95.0084	426105.0
2018-03-15	ER	Futures	98.337	98.337	98.332	98.337	52546.0
2018-03-15	EW	Futures	2048.1	2052.6	2035.4	2040.4	15853.0
2018-03-15	FBON	Futures	128.01	128.47	127.87	128.27	356.0
2018-03-15	FBTP	Futures	113.19	113.64	112.95	113.52	101403.0
2018-03-15	FBTS	Futures	103.871	103.899	103.853	103.89	47098.0
2018-03-15	FCE	Futures	4611.3	4635.1	4599.8	4628.9	64431.0
2018-03-15	FDAX	Futures	12724.1	12851.7	12696.1	12823.7	99051.0
2018-03-15	FDXM	Futures	12645.4	12762.8	12611.4	12737.5	4719.0
2018-03-15	FESX	Futures	2765.6	2773.9	2749.8	2773.1	987773.0
2018-03-15	FEU3	Futures	99.021	99.021	99.016	99.021	95.0
2018-03-15	FGBL	Futures	148.54	148.91	148.51	148.82	607084.0
2018-03-15	FGBM	Futures	129.16	129.26	129.1	129.23	378159.0
2018-03-15	FGBS	Futures	112.477	112.492	112.457	112.482	214391.0
2018-03-15	FGBX	Futures	167.74	168.65	167.62	168.42	44715.0
2018-03-15	FMWO	Futures	7046.0	7069.4	7036.7	7053.0	4623.0
2018-03-15	FOAT	Futures	137.58	138.0	137.56	137.9	120246.0
2018-03-15	FTDX	Futures	2675.1	2675.1	2645.9	2666.6	1497.0
2018-03-15	FTI	Futures	486.85	488.73	485.15	487.63	17627.0
2018-03-15	FTUK	Futures	6190.7	6254.7	6190.7	6237.9	155725.0
2018-03-15	FVSA	Futures	412.61	423.31	399.53	401.9	20080.0
2018-03-15	FXXP	Futures	320.3	320.3	317.2	319.2	77368.0
2018-03-15	G	Futures	113.36	113.59	113.3	113.45	187426.0
2018-03-15	GF	Futures	310.857	312.327	305.466	306.718	5840.0
2018-03-15	GSCI	Futures	505.13	505.13	503.81	504.61	71.0
2018-03-15	HE	Futures	85.262	85.808	84.331	84.396	21770.0

> showing 50 of 111 rows — these rows as CSV

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