PREVIEW / futures_daily / 2016-08-02

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-02.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
2016-08-02	ES	Futures	2338.61	2344.01	2312.16	2324.3	1958950.0
2016-08-02	NQ	Futures	5598.11	5610.19	5518.54	5556.85	261263.0
2016-08-02	YM	Futures	19159.6	19193.0	18978.9	19060.4	158889.0
2016-08-02	CL	Futures	45.43	46.37	44.5	44.78	534512.0
2016-08-02	GC	Futures	1745.7	1763.1	1736.8	1761.1	161783.0
2016-08-02	ZN	Futures	128.06002	128.180746	127.682752	128.014748	1420550.0
2016-08-02	A6	Futures	0.76571	0.77599	0.75961	0.77284	109047.0
2016-08-02	AD	Futures	0.77981	0.78707	0.77884	0.78206	80180.0
2016-08-02	ALI	Futures	2122.24	2122.24	2122.24	2122.24	5.0
2016-08-02	B	Futures	33.38	34.13	32.81	33.04	262560.0
2016-08-02	B6	Futures	1.3902	1.4101	1.3896	1.4081	94976.0
2016-08-02	BFX	Futures	3906.0	3906.0	3872.6	3872.6	2.0
2016-08-02	BR	Futures	0.2014	0.20343	0.20137	0.20213	1195.0
2016-08-02	BZ	Futures	33.25	33.95	32.64	32.87	23088.0
2016-08-02	C	Futures	2504.0	2534.0	2465.0	2474.0	19386.0
2016-08-02	CB	Futures	265.974	268.435	263.746	263.893	75.0
2016-08-02	CC	Futures	2142.0	2172.0	2111.0	2123.0	36401.0
2016-08-02	CSC	Futures	3.809	3.83	3.809	3.826	47.0
2016-08-02	CT	Futures	84.1	84.1	82.63	83.45	69.0
2016-08-02	DC	Futures	30.4	30.67	30.4	30.61	245.0
2016-08-02	DX	Futures	89.006	89.109	88.3	88.344	21501.0
2016-08-02	E1	Futures	1.29683	1.30309	1.29595	1.30209	14785.0
2016-08-02	E6	Futures	1.30214	1.31035	1.30197	1.30948	130517.0
2016-08-02	E7	Futures	1.2952	1.3033	1.2951	1.3025	2193.0
2016-08-02	EBM	Futures	199.68	203.89	199.68	202.69	11859.0
2016-08-02	ED	Futures	95.7039	95.7039	95.6702	95.675	284793.0
2016-08-02	ER	Futures	98.308	98.313	98.308	98.313	30688.0
2016-08-02	EW	Futures	1647.2	1651.3	1622.0	1626.2	15058.0
2016-08-02	FBON	Futures	123.55	123.71	123.35	123.45	138.0
2016-08-02	FBTP	Futures	109.78	109.9	109.45	109.63	87243.0
2016-08-02	FBTS	Futures	101.284	101.293	101.257	101.257	15993.0
2016-08-02	FCE	Futures	3835.4	3840.6	3765.6	3777.3	85902.0
2016-08-02	FDAX	Futures	10960.6	10998.9	10759.5	10796.7	89997.0
2016-08-02	FDXM	Futures	10681.6	10720.0	10485.6	10523.9	21505.0
2016-08-02	FESX	Futures	2312.6	2318.1	2267.2	2275.8	1132600.0
2016-08-02	FEU3	Futures	98.961	98.966	98.961	98.966	604.0
2016-08-02	FGBL	Futures	150.58	150.63	149.71	149.9	688028.0
2016-08-02	FGBM	Futures	128.88	128.88	128.61	128.67	454113.0
2016-08-02	FGBS	Futures	111.857	111.862	111.813	111.827	239626.0
2016-08-02	FGBX	Futures	190.93	191.05	187.56	188.24	42118.0
2016-08-02	FMWO	Futures	5733.1	5733.1	5675.9	5682.0	274.0
2016-08-02	FOAT	Futures	138.49	138.54	137.73	137.94	97051.0
2016-08-02	FTDX	Futures	1657.8	1657.8	1632.7	1635.6	425.0
2016-08-02	FTI	Futures	396.56	396.79	390.22	391.43	30629.0
2016-08-02	FTUK	Futures	5528.1	5541.0	5487.2	5501.8	105993.0
2016-08-02	FVSA	Futures	2162.03	2376.76	2162.03	2342.6	22473.0
2016-08-02	FXXP	Futures	273.4	273.8	269.9	270.6	24577.0
2016-08-02	G	Futures	115.03	115.18	114.4	114.71	234215.0
2016-08-02	GF	Futures	289.74	293.285	288.293	290.489	3485.0
2016-08-02	GSCI	Futures	481.73	483.02	474.91	474.91	24.0

> showing 50 of 110 rows — these rows as CSV

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