PREVIEW / futures_daily / 2017-12-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-18.parquet
  size:    9 KB
  rows:    107

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-18	ES	Futures	2916.1	2932.4	2915.55	2928.59	1040769.0
2017-12-18	NQ	Futures	7610.32	7661.86	7609.74	7653.95	220351.0
2017-12-18	YM	Futures	26052.0	26255.5	26041.4	26178.5	114155.0
2017-12-18	CL	Futures	57.39	57.8	56.87	57.21	539953.0
2017-12-18	GC	Futures	1594.6	1606.3	1591.4	1604.4	214218.0
2017-12-18	ZN	Futures	122.823632	122.839058	122.623091	122.653943	752076.0
2017-12-18	A6	Futures	0.78629	0.78938	0.78567	0.78845	58659.0
2017-12-18	AD	Futures	0.79036	0.79219	0.78975	0.79041	51170.0
2017-12-18	B	Futures	45.01	45.4	44.76	45.05	234617.0
2017-12-18	B6	Futures	1.3919	1.4019	1.3909	1.3979	94825.0
2017-12-18	BZ	Futures	44.64	45.06	44.42	44.7	20560.0
2017-12-18	C	Futures	1297.0	1303.0	1287.0	1299.0	8631.0
2017-12-18	CB	Futures	281.432	281.432	278.498	278.498	18.0
2017-12-18	CC	Futures	1414.0	1445.0	1403.0	1434.0	21672.0
2017-12-18	CSC	Futures	3.361	3.361	3.285	3.289	191.0
2017-12-18	CT	Futures	88.74	89.29	87.75	87.83	15719.0
2017-12-18	DC	Futures	26.59	26.59	25.87	25.87	214.0
2017-12-18	DX	Futures	87.801	87.858	87.257	87.561	19526.0
2017-12-18	E1	Futures	1.23553	1.2439	1.23456	1.2416	22328.0
2017-12-18	E6	Futures	1.34164	1.35122	1.34102	1.34538	184992.0
2017-12-18	E7	Futures	1.3346	1.3443	1.3344	1.3386	3714.0
2017-12-18	EBM	Futures	173.43	174.24	172.89	173.97	17424.0
2017-12-18	ED	Futures	95.3942	95.3942	95.3844	95.3942	180573.0
2017-12-18	ER	Futures	98.337	98.342	98.337	98.337	38529.0
2017-12-18	EW	Futures	2007.7	2027.9	2007.3	2024.4	12012.0
2017-12-18	FBON	Futures	126.63	127.08	126.63	126.91	199.0
2017-12-18	FBTP	Futures	113.14	113.39	113.04	113.14	44230.0
2017-12-18	FBTS	Futures	103.741	103.796	103.741	103.778	28595.0
2017-12-18	FCE	Futures	4812.7	4851.7	4810.1	4844.5	78195.0
2017-12-18	FDAX	Futures	13693.1	13831.1	13677.5	13814.0	72800.0
2017-12-18	FDXM	Futures	13710.6	13855.1	13702.3	13837.4	23652.0
2017-12-18	FESX	Futures	2921.3	2943.4	2915.6	2939.3	815351.0
2017-12-18	FGBL	Futures	151.49	151.59	151.32	151.44	386556.0
2017-12-18	FGBM	Futures	130.13	130.14	129.99	130.06	322678.0
2017-12-18	FGBS	Futures	112.512	112.517	112.472	112.487	251086.0
2017-12-18	FGBX	Futures	173.41	173.68	172.59	173.04	39628.0
2017-12-18	FMWO	Futures	6934.0	6965.5	6934.0	6955.0	1839.0
2017-12-18	FOAT	Futures	140.13	140.25	139.89	140.09	69649.0
2017-12-18	FTDX	Futures	2538.4	2574.8	2531.4	2552.8	191.0
2017-12-18	FTI	Futures	510.52	513.16	510.01	512.09	19311.0
2017-12-18	FTUK	Futures	6517.4	6541.4	6491.6	6530.1	86131.0
2017-12-18	FVSA	Futures	286.55	286.55	269.7	270.75	32505.0
2017-12-18	FXXP	Futures	331.7	333.7	331.2	333.4	20685.0
2017-12-18	G	Futures	115.67	115.89	115.65	115.81	98562.0
2017-12-18	GF	Futures	321.057	321.814	317.058	319.22	4553.0
2017-12-18	GSCI	Futures	490.94	492.45	489.78	490.24	12.0
2017-12-18	HE	Futures	91.843	93.277	89.775	89.908	19760.0
2017-12-18	HG	Futures	3.7522	3.7677	3.724	3.7659	92934.0
2017-12-18	HH	Futures	15.375	16.089	15.369	15.926	5974.0
2017-12-18	HO	Futures	1.25	1.269	1.25	1.2597	23954.0

> showing 50 of 107 rows — these rows as CSV

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