PREVIEW / futures_daily / 2018-06-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-21.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-06-21	ES	Futures	3010.39	3025.05	2983.51	2989.48	1493235.0
2018-06-21	NQ	Futures	8528.86	8579.29	8425.1	8438.51	424012.0
2018-06-21	YM	Futures	25997.8	26126.3	25713.3	25786.0	237197.0
2018-06-21	CL	Futures	66.18	67.08	65.17	66.39	760719.0
2018-06-21	GC	Futures	1621.0	1624.3	1611.7	1622.0	281809.0
2018-06-21	ZN	Futures	118.8419	119.261452	118.764206	119.199296	1566709.0
2018-06-21	A6	Futures	0.7575	0.76059	0.75545	0.76028	109675.0
2018-06-21	AD	Futures	0.76186	0.76353	0.76049	0.76252	80340.0
2018-06-21	B	Futures	54.52	54.69	53.4	53.49	411809.0
2018-06-21	B6	Futures	1.3648	1.3743	1.3569	1.3728	156409.0
2018-06-21	BR	Futures	0.20125	0.20125	0.20125	0.20125	57.0
2018-06-21	BTC	Futures	9528.7	9635.3	9479.0	9535.8	1135.0
2018-06-21	BZ	Futures	53.94	54.17	52.91	52.99	49077.0
2018-06-21	C	Futures	1683.0	1683.0	1647.0	1667.0	2185.0
2018-06-21	CB	Futures	280.948	280.948	279.389	279.419	31.0
2018-06-21	CC	Futures	1821.0	1821.0	1785.0	1801.0	18005.0
2018-06-21	CNH	Futures	6.5733	6.611	6.5733	6.5938	79.0
2018-06-21	CSC	Futures	3.351	3.367	3.345	3.363	75.0
2018-06-21	CT	Futures	94.81	95.71	94.36	94.59	3585.0
2018-06-21	DC	Futures	26.79	26.79	26.45	26.78	201.0
2018-06-21	DX	Futures	89.776	90.183	89.35	89.41	28338.0
2018-06-21	E1	Futures	1.20851	1.2164	1.20528	1.21484	26981.0
2018-06-21	E6	Futures	1.30273	1.30944	1.2953	1.30827	333933.0
2018-06-21	E7	Futures	1.2964	1.3027	1.2888	1.3016	8271.0
2018-06-21	EBM	Futures	182.03	185.43	182.03	184.39	15267.0
2018-06-21	ED	Futures	94.9621	94.9815	94.9621	94.9767	200340.0
2018-06-21	ER	Futures	98.357	98.357	98.342	98.352	166089.0
2018-06-21	EW	Futures	2124.6	2136.4	2103.5	2109.4	16292.0
2018-06-21	FBON	Futures	129.82	129.82	128.74	128.91	1438.0
2018-06-21	FBTP	Futures	108.89	108.89	106.89	107.08	109429.0
2018-06-21	FBTS	Futures	102.985	102.985	102.03	102.262	74733.0
2018-06-21	FCE	Futures	4841.5	4849.6	4761.1	4775.0	95929.0
2018-06-21	FDAX	Futures	13276.8	13281.0	12994.5	13058.3	113802.0
2018-06-21	FDXM	Futures	13103.0	13115.4	12826.5	12891.5	53145.0
2018-06-21	FESX	Futures	2873.1	2879.8	2825.5	2833.8	1082708.0
2018-06-21	FEU3	Futures	99.001	99.001	99.001	99.001	423.0
2018-06-21	FGBL	Futures	152.0	152.98	151.95	152.79	977797.0
2018-06-21	FGBM	Futures	130.89	131.33	130.87	131.25	545841.0
2018-06-21	FGBS	Futures	112.713	112.819	112.708	112.794	371964.0
2018-06-21	FGBX	Futures	172.93	175.11	172.91	174.41	66636.0
2018-06-21	FMWO	Futures	7061.3	7061.3	7011.2	7022.9	1774.0
2018-06-21	FOAT	Futures	140.3	140.74	140.3	140.55	176517.0
2018-06-21	FTDX	Futures	2785.8	2785.8	2733.3	2740.2	201.0
2018-06-21	FTI	Futures	514.0	515.2	508.27	509.89	29999.0
2018-06-21	FTUK	Futures	6765.7	6786.7	6664.6	6674.0	108512.0
2018-06-21	FVSA	Futures	280.87	314.89	279.9	304.2	28999.0
2018-06-21	FXXP	Futures	331.4	332.4	326.7	327.7	82828.0
2018-06-21	G	Futures	115.21	115.53	114.73	115.43	271085.0
2018-06-21	GF	Futures	309.337	309.544	306.385	307.576	4991.0
2018-06-21	GSCI	Futures	517.56	517.9	515.26	517.45	144.0

> showing 50 of 115 rows — these rows as CSV

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