PREVIEW / futures_daily / 2018-11-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-29.parquet
  size:    10 KB
  rows:    113

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-11-29	ES	Futures	2969.39	2987.29	2953.4	2976.17	1489330.0
2018-11-29	NQ	Futures	8022.66	8065.34	7948.32	8029.92	530605.0
2018-11-29	YM	Futures	26668.3	26834.7	26543.0	26737.8	195522.0
2018-11-29	CL	Futures	53.23	55.23	52.28	54.44	812721.0
2018-11-29	GC	Futures	1546.1	1556.0	1545.6	1550.3	246432.0
2018-11-29	ZN	Futures	118.841437	119.261647	118.763621	118.950381	1940800.0
2018-11-29	A6	Futures	0.75185	0.75597	0.75083	0.7534	124684.0
2018-11-29	AD	Futures	0.76192	0.76319	0.7598	0.76197	89051.0
2018-11-29	B	Futures	43.65	44.58	42.42	43.99	370876.0
2018-11-29	B6	Futures	1.3201	1.3225	1.3127	1.3156	89999.0
2018-11-29	BTC	Futures	6355.2	6660.3	6195.0	6370.4	1123.0
2018-11-29	BZ	Futures	42.79	44.02	41.88	43.42	35733.0
2018-11-29	C	Futures	1437.0	1468.0	1432.0	1453.0	4589.0
2018-11-29	CB	Futures	268.249	268.279	268.249	268.279	107.0
2018-11-29	CC	Futures	1461.0	1506.0	1461.0	1492.0	17304.0
2018-11-29	CNH	Futures	6.9773	6.9836	6.9701	6.9729	313.0
2018-11-29	CSC	Futures	2.894	2.894	2.892	2.892	12.0
2018-11-29	CT	Futures	85.78	86.27	84.99	85.71	9655.0
2018-11-29	DC	Futures	24.13	24.13	23.97	24.02	62.0
2018-11-29	DX	Futures	91.939	92.082	91.716	91.862	19212.0
2018-11-29	E1	Futures	1.19473	1.19675	1.18952	1.19118	22227.0
2018-11-29	E6	Futures	1.26549	1.26922	1.26332	1.26794	220747.0
2018-11-29	E7	Futures	1.2595	1.2631	1.257	1.2617	3630.0
2018-11-29	EBM	Futures	207.42	207.68	206.38	206.9	18200.0
2018-11-29	ED	Futures	94.9572	94.9646	94.9328	94.9377	531789.0
2018-11-29	ER	Futures	98.391	98.391	98.386	98.386	39795.0
2018-11-29	EW	Futures	1959.6	1976.0	1945.7	1963.2	17002.0
2018-11-29	FBON	Futures	128.08	128.55	128.08	128.53	429.0
2018-11-29	FBTP	Futures	106.68	107.4	106.58	107.34	213938.0
2018-11-29	FBTS	Futures	103.464	103.614	103.379	103.595	76838.0
2018-11-29	FCE	Futures	4492.4	4497.3	4458.8	4468.7	78292.0
2018-11-29	FDAX	Futures	11978.0	11988.5	11851.3	11894.9	106233.0
2018-11-29	FDXM	Futures	11771.6	11780.9	11645.5	11688.9	51500.0
2018-11-29	FESX	Futures	2683.1	2683.1	2656.3	2664.7	1026562.0
2018-11-29	FGBL	Futures	154.08	154.48	154.06	154.47	852035.0
2018-11-29	FGBM	Futures	131.45	131.63	131.44	131.62	603436.0
2018-11-29	FGBS	Futures	112.718	112.744	112.713	112.744	570587.0
2018-11-29	FGBX	Futures	178.64	179.75	178.58	179.73	60647.0
2018-11-29	FMWO	Futures	6780.5	6781.7	6745.8	6766.6	4394.0
2018-11-29	FOAT	Futures	141.02	141.5	141.02	141.49	151326.0
2018-11-29	FTDX	Futures	2540.1	2578.4	2540.1	2555.3	530.0
2018-11-29	FTI	Futures	486.31	486.36	480.7	482.74	28882.0
2018-11-29	FTUK	Futures	6318.4	6329.6	6272.8	6307.7	131493.0
2018-11-29	FVSA	Futures	327.6	343.72	327.6	339.69	25079.0
2018-11-29	FXXP	Futures	311.9	311.9	309.1	310.5	42016.0
2018-11-29	G	Futures	116.37	116.54	116.06	116.31	272078.0
2018-11-29	GF	Futures	317.939	317.939	311.428	314.226	7540.0
2018-11-29	GSCI	Futures	458.44	461.09	456.81	460.93	58.0
2018-11-29	HE	Futures	78.287	81.143	78.287	80.993	21508.0
2018-11-29	HG	Futures	3.2372	3.2424	3.2026	3.2147	63701.0

> showing 50 of 113 rows — these rows as CSV

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