PREVIEW / futures_daily / 2018-03-13

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-13.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-13	ES	Futures	3023.97	3045.98	2998.16	3009.02	1232770.0
2018-03-13	NQ	Futures	8358.42	8419.02	8228.41	8266.48	208524.0
2018-03-13	YM	Futures	26577.3	26763.8	26299.2	26387.7	263454.0
2018-03-13	CL	Futures	61.8	62.41	60.7	61.14	747738.0
2018-03-13	GC	Futures	1690.3	1697.3	1678.2	1695.2	330263.0
2018-03-13	ZN	Futures	119.276505	119.633202	119.183454	119.431591	1676461.0
2018-03-13	A6	Futures	0.80974	0.81252	0.80717	0.80933	26315.0
2018-03-13	AD	Futures	0.7893	0.79001	0.78075	0.78338	24666.0
2018-03-13	B	Futures	46.85	47.4	46.23	46.65	320571.0
2018-03-13	B6	Futures	1.4463	1.4556	1.4431	1.4536	33429.0
2018-03-13	BTC	Futures	12713.6	13199.1	12241.9	12581.8	3375.0
2018-03-13	BZ	Futures	46.28	46.81	45.65	46.08	34247.0
2018-03-13	C	Futures	1672.0	1683.0	1654.0	1658.0	15211.0
2018-03-13	CB	Futures	280.289	280.289	279.208	279.208	21.0
2018-03-13	CC	Futures	1864.0	1878.0	1850.0	1858.0	18993.0
2018-03-13	CNH	Futures	6.4563	6.4563	6.4404	6.4415	266.0
2018-03-13	CSC	Futures	3.298	3.306	3.275	3.279	53.0
2018-03-13	CT	Futures	95.62	96.8	94.3	95.38	19947.0
2018-03-13	DC	Futures	26.21	26.21	25.96	25.99	134.0
2018-03-13	DX	Futures	84.34	84.538	84.047	84.121	5825.0
2018-03-13	E1	Futures	1.28138	1.28788	1.27933	1.28668	8129.0
2018-03-13	E6	Futures	1.39961	1.40806	1.39747	1.40693	130430.0
2018-03-13	E7	Futures	1.3926	1.4005	1.39	1.3994	2664.0
2018-03-13	EBM	Futures	175.59	177.74	175.59	176.13	18646.0
2018-03-13	ED	Futures	95.023	95.023	94.9986	95.0035	392391.0
2018-03-13	ER	Futures	98.337	98.337	98.332	98.332	23660.0
2018-03-13	EW	Futures	2074.0	2083.0	2054.3	2059.6	29177.0
2018-03-13	FBON	Futures	127.88	128.2	127.86	128.05	235.0
2018-03-13	FBTP	Futures	113.23	113.56	113.18	113.38	101602.0
2018-03-13	FBTS	Futures	103.89	103.927	103.89	103.908	50234.0
2018-03-13	FCE	Futures	4637.7	4667.7	4575.5	4605.5	156311.0
2018-03-13	FDAX	Futures	12879.2	12927.4	12569.0	12654.1	183444.0
2018-03-13	FDXM	Futures	12805.0	12842.1	12492.9	12575.3	1667.0
2018-03-13	FESX	Futures	2786.4	2798.1	2734.8	2749.8	2203275.0
2018-03-13	FEU3	Futures	99.021	99.021	99.021	99.021	32.0
2018-03-13	FGBL	Futures	147.98	148.32	147.9	148.19	682872.0
2018-03-13	FGBM	Futures	128.96	129.09	128.94	129.03	435169.0
2018-03-13	FGBS	Futures	112.457	112.482	112.442	112.452	302553.0
2018-03-13	FGBX	Futures	166.87	167.39	166.46	166.93	44668.0
2018-03-13	FMWO	Futures	7117.2	7141.8	7047.2	7084.6	19907.0
2018-03-13	FOAT	Futures	137.18	137.46	137.13	137.37	109792.0
2018-03-13	FTDX	Futures	2684.5	2702.8	2652.3	2661.2	1998.0
2018-03-13	FTI	Futures	492.63	493.41	483.54	486.94	30456.0
2018-03-13	FTUK	Futures	6284.8	6307.7	6200.4	6226.0	446246.0
2018-03-13	FVSA	Futures	388.82	418.55	384.07	410.23	15756.0
2018-03-13	FXXP	Futures	320.0	321.9	315.8	317.3	167914.0
2018-03-13	G	Futures	112.81	113.22	112.8	112.97	167478.0
2018-03-13	GF	Futures	310.748	311.891	307.154	309.931	6362.0
2018-03-13	GSCI	Futures	508.04	508.73	502.27	503.81	2015.0
2018-03-13	HE	Futures	86.9	88.408	86.579	86.964	30588.0

> showing 50 of 111 rows — these rows as CSV

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