PREVIEW / futures_daily / 2018-06-22

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-22.parquet
  size:    10 KB
  rows:    114

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-22	ES	Futures	2987.31	3006.86	2985.95	2997.09	1108771.0
2018-06-22	NQ	Futures	8427.14	8480.77	8392.45	8421.02	322915.0
2018-06-22	YM	Futures	25770.2	25988.3	25757.5	25919.8	156310.0
2018-06-22	CL	Futures	66.78	70.28	66.56	69.47	1136232.0
2018-06-22	GC	Futures	1619.6	1625.3	1619.3	1622.3	184223.0
2018-06-22	ZN	Futures	119.183757	119.245913	118.981751	119.168218	937367.0
2018-06-22	A6	Futures	0.75884	0.76563	0.75853	0.76522	94542.0
2018-06-22	AD	Futures	0.76161	0.76495	0.75786	0.76383	108659.0
2018-06-22	B	Futures	53.63	55.53	53.63	55.32	377394.0
2018-06-22	B6	Futures	1.3713	1.379	1.371	1.3734	110583.0
2018-06-22	BR	Futures	0.20125	0.2014	0.20068	0.20098	224.0
2018-06-22	BTC	Futures	9528.7	9571.3	8470.0	8761.3	3832.0
2018-06-22	BZ	Futures	53.22	54.99	53.09	54.81	59882.0
2018-06-22	C	Futures	1666.0	1676.0	1637.0	1670.0	2072.0
2018-06-22	CB	Futures	279.988	281.248	279.988	280.228	18.0
2018-06-22	CC	Futures	1806.0	1820.0	1780.0	1802.0	13240.0
2018-06-22	CNH	Futures	6.5992	6.6083	6.5974	6.5999	146.0
2018-06-22	CSC	Futures	3.363	3.363	3.337	3.341	49.0
2018-06-22	CT	Futures	94.63	97.53	94.46	97.11	2639.0
2018-06-22	DC	Futures	26.56	26.71	26.45	26.54	262.0
2018-06-22	DX	Futures	89.548	89.548	89.118	89.198	18273.0
2018-06-22	E1	Futures	1.21424	1.21926	1.21353	1.21903	17227.0
2018-06-22	E6	Futures	1.30626	1.31403	1.30564	1.31269	241796.0
2018-06-22	E7	Futures	1.2996	1.3074	1.2989	1.3061	5974.0
2018-06-22	EBM	Futures	183.87	185.17	183.87	184.39	9020.0
2018-06-22	ED	Futures	94.9767	94.9815	94.9621	94.9815	164860.0
2018-06-22	ER	Futures	98.347	98.357	98.347	98.352	65091.0
2018-06-22	EW	Futures	2108.6	2124.7	2107.4	2110.7	18977.0
2018-06-22	FBON	Futures	128.96	129.15	128.57	128.67	437.0
2018-06-22	FBTP	Futures	107.04	108.04	106.94	107.45	68386.0
2018-06-22	FBTS	Futures	102.067	102.67	102.067	102.318	48902.0
2018-06-22	FCE	Futures	4783.6	4845.1	4780.0	4839.7	71647.0
2018-06-22	FDAX	Futures	13068.2	13159.7	13032.2	13106.9	80707.0
2018-06-22	FDIV	Futures	149.22	149.53	149.22	149.53	4.0
2018-06-22	FDXM	Futures	12893.6	12991.6	12865.7	12939.5	35734.0
2018-06-22	FESX	Futures	2838.9	2870.6	2837.2	2862.2	839305.0
2018-06-22	FGBL	Futures	152.79	152.87	152.46	152.74	536134.0
2018-06-22	FGBM	Futures	131.27	131.27	131.09	131.2	281712.0
2018-06-22	FGBS	Futures	112.799	112.799	112.759	112.774	257114.0
2018-06-22	FGBX	Futures	174.53	174.75	173.71	174.49	39765.0
2018-06-22	FMWO	Futures	7052.0	7071.8	7046.1	7061.3	3475.0
2018-06-22	FOAT	Futures	140.48	140.59	140.41	140.5	88040.0
2018-06-22	FTDX	Futures	2735.7	2747.0	2722.0	2733.8	76.0
2018-06-22	FTI	Futures	510.4	517.09	510.4	517.09	25817.0
2018-06-22	FTUK	Futures	6667.7	6799.6	6666.4	6790.7	113778.0
2018-06-22	FVSA	Futures	301.28	305.17	286.7	289.62	21731.0
2018-06-22	FXXP	Futures	328.2	332.0	327.9	331.4	28116.0
2018-06-22	G	Futures	115.39	115.39	114.98	115.15	136386.0
2018-06-22	GF	Futures	307.576	309.337	306.334	309.078	4661.0
2018-06-22	GSCI	Futures	525.69	530.68	523.34	527.94	38.0

> showing 50 of 114 rows — these rows as CSV

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