PREVIEW / futures_daily / 2016-08-23

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-23.parquet
  size:    9 KB
  rows:    109

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
2016-08-23	ES	Futures	2354.54	2366.14	2352.92	2359.39	1125503.0
2016-08-23	NQ	Futures	5668.83	5701.25	5667.07	5677.97	160448.0
2016-08-23	YM	Futures	19343.4	19443.7	19329.8	19352.8	110672.0
2016-08-23	CL	Futures	52.67	53.71	51.78	53.46	623904.0
2016-08-23	GC	Futures	1723.9	1730.5	1717.8	1727.1	132030.0
2016-08-23	ZN	Futures	127.743115	127.894022	127.531844	127.697843	1052529.0
2016-08-23	A6	Futures	0.7763	0.77833	0.77406	0.77507	67143.0
2016-08-23	AD	Futures	0.79091	0.79593	0.79055	0.79281	49910.0
2016-08-23	ALI	Futures	2156.69	2158.89	2156.69	2158.89	2.0
2016-08-23	B	Futures	38.76	39.69	38.32	39.49	314178.0
2016-08-23	B6	Futures	1.3856	1.3935	1.3847	1.3915	67287.0
2016-08-23	BFX	Futures	4062.9	4085.9	4062.9	4085.9	26.0
2016-08-23	BR	Futures	0.20719	0.20832	0.20523	0.20566	680.0
2016-08-23	BZ	Futures	38.72	39.48	38.13	39.29	36665.0
2016-08-23	C	Futures	2578.0	2598.0	2535.0	2592.0	7768.0
2016-08-23	CB	Futures	258.527	258.527	257.907	257.907	9.0
2016-08-23	CC	Futures	2234.0	2254.0	2206.0	2249.0	15200.0
2016-08-23	CNH	Futures	7.1979	7.2057	7.1979	7.2057	2.0
2016-08-23	CSC	Futures	3.999	4.007	3.984	3.984	26.0
2016-08-23	CT	Futures	77.67	77.8	77.17	77.17	13.0
2016-08-23	DC	Futures	32.11	32.14	31.84	31.93	413.0
2016-08-23	DX	Futures	87.932	87.951	87.607	87.885	15637.0
2016-08-23	E1	Futures	1.30347	1.30697	1.30146	1.30234	13618.0
2016-08-23	E6	Futures	1.31937	1.32327	1.31728	1.31757	108149.0
2016-08-23	E7	Futures	1.3122	1.3163	1.3104	1.3106	1562.0
2016-08-23	EBM	Futures	189.75	189.75	187.05	187.65	13084.0
2016-08-23	ED	Futures	95.6219	95.6292	95.6147	95.6171	160318.0
2016-08-23	ER	Futures	98.303	98.308	98.303	98.308	27335.0
2016-08-23	EW	Futures	1654.9	1669.4	1654.9	1663.5	15455.0
2016-08-23	FBON	Futures	124.91	124.92	124.57	124.81	614.0
2016-08-23	FBTP	Futures	110.76	110.82	110.34	110.56	75735.0
2016-08-23	FBTS	Futures	101.365	101.365	101.338	101.356	9382.0
2016-08-23	FCE	Futures	3846.7	3875.5	3842.7	3862.0	57264.0
2016-08-23	FDAX	Futures	11194.2	11306.5	11183.6	11274.5	67840.0
2016-08-23	FDXM	Futures	10917.1	11020.8	10899.4	10989.7	20561.0
2016-08-23	FESX	Futures	2325.1	2351.0	2321.2	2343.9	735675.0
2016-08-23	FGBL	Futures	150.72	151.02	150.6	150.87	476583.0
2016-08-23	FGBM	Futures	128.93	128.97	128.88	128.94	307842.0
2016-08-23	FGBS	Futures	111.872	111.882	111.862	111.872	134395.0
2016-08-23	FGBX	Futures	189.68	190.44	188.98	190.01	22660.0
2016-08-23	FMWO	Futures	5813.3	5831.6	5813.3	5823.0	2005.0
2016-08-23	FOAT	Futures	138.6	138.87	138.45	138.7	66975.0
2016-08-23	FTDX	Futures	1655.8	1666.4	1655.8	1666.4	180.0
2016-08-23	FTI	Futures	404.74	409.03	404.42	407.94	20116.0
2016-08-23	FTUK	Futures	5708.7	5742.9	5704.1	5734.6	82301.0
2016-08-23	FVSA	Futures	1964.5	1981.8	1921.23	1925.55	9678.0
2016-08-23	FXXP	Futures	276.1	278.5	276.0	277.9	15240.0
2016-08-23	G	Futures	117.05	117.44	116.9	117.27	157475.0
2016-08-23	GF	Futures	289.662	291.725	288.807	289.612	2029.0
2016-08-23	GSCI	Futures	514.62	520.58	512.64	520.58	65.0

> showing 50 of 109 rows — these rows as CSV

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