PREVIEW / futures_daily / 2017-12-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-13.parquet
  size:    9 KB
  rows:    110

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
2017-12-13	ES	Futures	2899.25	2906.86	2889.73	2900.34	758320.0
2017-12-13	NQ	Futures	7499.89	7539.54	7476.99	7515.75	109048.0
2017-12-13	YM	Futures	25883.2	26034.0	25822.0	25991.8	147617.0
2017-12-13	CL	Futures	57.51	57.89	56.61	56.66	658143.0
2017-12-13	GC	Futures	1580.0	1597.0	1575.0	1583.0	324220.0
2017-12-13	ZN	Futures	122.530533	123.070451	122.329992	123.024173	1658239.0
2017-12-13	A6	Futures	0.77662	0.78547	0.77652	0.78506	94870.0
2017-12-13	AD	Futures	0.7899	0.79503	0.7895	0.79447	44477.0
2017-12-13	B	Futures	45.33	45.69	44.3	44.36	354367.0
2017-12-13	B6	Futures	1.3902	1.4025	1.3899	1.4011	140041.0
2017-12-13	BFX	Futures	4762.4	4762.4	4761.8	4761.8	26.0
2017-12-13	BR	Futures	0.22748	0.22748	0.22729	0.22729	1986.0
2017-12-13	BZ	Futures	45.05	45.34	43.96	44.02	34080.0
2017-12-13	C	Futures	1289.0	1299.0	1271.0	1293.0	15992.0
2017-12-13	CB	Futures	280.135	280.166	280.135	280.166	13.0
2017-12-13	CC	Futures	1401.0	1421.0	1382.0	1409.0	21940.0
2017-12-13	CSC	Futures	3.346	3.393	3.338	3.374	139.0
2017-12-13	CT	Futures	85.16	86.7	85.16	86.58	16151.0
2017-12-13	DC	Futures	26.48	26.85	26.44	26.74	91.0
2017-12-13	DX	Futures	87.937	87.994	87.308	87.359	16849.0
2017-12-13	E1	Futures	1.23383	1.24463	1.23273	1.24281	50056.0
2017-12-13	E6	Futures	1.33966	1.35048	1.33892	1.34924	241076.0
2017-12-13	E7	Futures	1.3329	1.3435	1.331	1.3425	8513.0
2017-12-13	EBM	Futures	173.7	173.7	172.89	173.16	17078.0
2017-12-13	ED	Futures	95.3942	95.4184	95.3796	95.4136	437605.0
2017-12-13	ER	Futures	98.332	98.337	98.332	98.337	83996.0
2017-12-13	EW	Futures	2002.9	2013.3	1995.2	2001.9	15727.0
2017-12-13	FBON	Futures	126.46	126.51	126.19	126.33	290.0
2017-12-13	FBTP	Futures	114.19	114.25	112.94	113.32	127975.0
2017-12-13	FBTS	Futures	103.906	103.915	103.75	103.778	69995.0
2017-12-13	FCE	Futures	4837.3	4850.8	4808.3	4823.5	125517.0
2017-12-13	FDAX	Futures	13847.2	13864.1	13735.3	13803.1	100227.0
2017-12-13	FDXM	Futures	13683.6	13701.3	13572.4	13643.1	3211.0
2017-12-13	FESX	Futures	2928.7	2931.9	2902.5	2916.4	1530913.0
2017-12-13	FEU3	Futures	99.011	99.011	99.006	99.006	110.0
2017-12-13	FGBL	Futures	151.41	151.51	150.98	151.32	591064.0
2017-12-13	FGBM	Futures	130.22	130.3	130.04	130.24	462760.0
2017-12-13	FGBS	Futures	112.562	112.582	112.532	112.567	268051.0
2017-12-13	FGBX	Futures	172.18	172.39	170.88	171.77	51263.0
2017-12-13	FMWO	Futures	6932.8	6952.9	6929.3	6951.7	11219.0
2017-12-13	FOAT	Futures	140.12	140.12	139.51	139.8	108934.0
2017-12-13	FTDX	Futures	2517.9	2530.4	2498.5	2528.9	4260.0
2017-12-13	FTI	Futures	511.12	511.63	507.65	509.6	35988.0
2017-12-13	FTUK	Futures	6492.9	6511.7	6476.3	6504.3	230289.0
2017-12-13	FVSA	Futures	298.14	303.41	293.93	297.09	16070.0
2017-12-13	FXXP	Futures	331.3	332.3	331.0	331.7	110792.0
2017-12-13	G	Futures	115.13	115.23	114.81	115.16	165266.0
2017-12-13	GF	Futures	318.517	320.787	314.247	314.896	6513.0
2017-12-13	GSCI	Futures	489.25	489.25	484.36	484.36	1949.0
2017-12-13	HE	Futures	88.708	90.042	88.474	89.108	20175.0

> showing 50 of 110 rows — these rows as CSV

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