PREVIEW / futures_daily / 2016-08-09

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-09.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-09	ES	Futures	2349.41	2357.5	2346.98	2351.03	1191826.0
2016-08-09	NQ	Futures	5634.94	5667.07	5631.41	5648.21	134336.0
2016-08-09	YM	Futures	19288.1	19346.6	19263.0	19288.1	87302.0
2016-08-09	CL	Futures	48.55	49.33	48.14	48.48	624703.0
2016-08-09	GC	Futures	1720.8	1730.1	1714.1	1727.8	124480.0
2016-08-09	ZN	Futures	127.471482	127.894022	127.411119	127.818569	924123.0
2016-08-09	A6	Futures	0.77802	0.78118	0.77446	0.77914	75191.0
2016-08-09	AD	Futures	0.77766	0.78083	0.77597	0.77919	61236.0
2016-08-09	ALI	Futures	2152.47	2155.02	2146.43	2150.25	42.0
2016-08-09	B	Futures	35.77	36.18	35.38	35.55	216218.0
2016-08-09	B6	Futures	1.3758	1.376	1.3667	1.3714	75170.0
2016-08-09	BFX	Futures	4006.3	4028.8	4006.3	4028.8	1.0
2016-08-09	BR	Futures	0.20799	0.21125	0.20799	0.21032	1741.0
2016-08-09	BZ	Futures	35.51	35.99	35.19	35.37	18269.0
2016-08-09	C	Futures	2561.0	2582.0	2542.0	2545.0	9064.0
2016-08-09	CB	Futures	272.538	272.538	268.435	268.816	17.0
2016-08-09	CC	Futures	2192.0	2217.0	2177.0	2184.0	31809.0
2016-08-09	CSC	Futures	3.885	3.9	3.847	3.868	40.0
2016-08-09	CT	Futures	84.39	84.39	82.76	82.76	58.0
2016-08-09	DC	Futures	31.05	31.33	30.79	31.12	305.0
2016-08-09	DX	Futures	89.574	89.718	89.299	89.408	12048.0
2016-08-09	E1	Futures	1.27667	1.2788	1.27467	1.2773	9000.0
2016-08-09	E6	Futures	1.29283	1.29696	1.29091	1.29522	102809.0
2016-08-09	E7	Futures	1.2857	1.29	1.2841	1.2884	1168.0
2016-08-09	EBM	Futures	199.38	199.38	197.27	198.48	8625.0
2016-08-09	ED	Futures	95.6171	95.6219	95.5978	95.5978	255960.0
2016-08-09	ER	Futures	98.308	98.313	98.308	98.308	13919.0
2016-08-09	EW	Futures	1653.6	1657.8	1651.4	1653.7	8595.0
2016-08-09	FBON	Futures	124.46	124.48	124.09	124.38	21.0
2016-08-09	FBTP	Futures	110.42	110.72	110.37	110.69	69309.0
2016-08-09	FBTS	Futures	101.329	101.347	101.311	101.338	15185.0
2016-08-09	FCE	Futures	3848.5	3901.3	3846.3	3900.4	73555.0
2016-08-09	FDAX	Futures	11073.4	11386.8	11073.4	11383.1	96697.0
2016-08-09	FDXM	Futures	10797.8	11098.6	10794.7	11095.5	23979.0
2016-08-09	FESX	Futures	2330.6	2372.1	2330.6	2371.3	885934.0
2016-08-09	FEU3	Futures	98.961	98.966	98.961	98.966	2.0
2016-08-09	FGBL	Futures	150.45	150.78	150.19	150.66	438210.0
2016-08-09	FGBM	Futures	128.93	128.96	128.81	128.94	265947.0
2016-08-09	FGBS	Futures	111.872	111.887	111.862	111.882	102185.0
2016-08-09	FGBX	Futures	188.24	189.47	187.44	189.16	28946.0
2016-08-09	FMWO	Futures	5748.9	5785.4	5748.9	5782.9	2966.0
2016-08-09	FOAT	Futures	138.43	138.71	138.19	138.69	64662.0
2016-08-09	FTDX	Futures	1640.4	1667.4	1640.4	1667.4	93.0
2016-08-09	FTI	Futures	402.05	406.9	402.05	406.68	18376.0
2016-08-09	FTUK	Futures	5649.5	5687.4	5641.1	5676.2	77701.0
2016-08-09	FVSA	Futures	1942.41	1961.93	1849.68	1864.32	15859.0
2016-08-09	FXXP	Futures	275.4	278.5	275.1	278.4	19093.0
2016-08-09	G	Futures	116.78	117.1	116.49	117.06	183181.0
2016-08-09	GF	Futures	297.628	301.721	296.28	299.874	2103.0
2016-08-09	GSCI	Futures	493.64	496.58	491.92	492.71	2343.0

> showing 50 of 109 rows — these rows as CSV

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