PREVIEW / futures_daily / 2017-02-02

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-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
2017-02-02	ES	Futures	2466.33	2471.48	2454.94	2466.87	1414426.0
2017-02-02	NQ	Futures	6067.18	6078.67	6033.88	6047.44	209875.0
2017-02-02	YM	Futures	20882.7	20909.0	20786.8	20877.4	130390.0
2017-02-02	CL	Futures	57.33	58.15	57.09	57.3	492553.0
2017-02-02	GC	Futures	1547.3	1568.1	1546.0	1557.8	232060.0
2017-02-02	ZN	Futures	121.583851	121.965901	121.50744	121.644979	1373958.0
2017-02-02	A6	Futures	0.77576	0.78754	0.77535	0.78385	101791.0
2017-02-02	AD	Futures	0.78322	0.7872	0.78291	0.78419	53818.0
2017-02-02	ALI	Futures	2477.71	2477.71	2477.71	2477.71	0.0
2017-02-02	B	Futures	41.69	42.37	41.54	41.71	297350.0
2017-02-02	B6	Futures	1.3285	1.3337	1.3139	1.3145	134927.0
2017-02-02	BFX	Futures	4327.5	4348.7	4327.5	4348.7	2.0
2017-02-02	BR	Futures	0.22578	0.22735	0.22564	0.22667	519.0
2017-02-02	BZ	Futures	41.48	42.14	41.34	41.5	31371.0
2017-02-02	C	Futures	1751.0	1753.0	1724.0	1749.0	7464.0
2017-02-02	CB	Futures	270.663	270.663	270.663	270.663	5.0
2017-02-02	CC	Futures	1606.0	1612.0	1590.0	1600.0	19792.0
2017-02-02	CNH	Futures	7.245	7.245	7.2172	7.2267	129.0
2017-02-02	CSC	Futures	3.965	4.031	3.956	4.015	69.0
2017-02-02	CT	Futures	87.72	88.91	86.98	88.35	30523.0
2017-02-02	DC	Futures	32.75	33.53	32.75	33.3	596.0
2017-02-02	DX	Futures	92.699	92.96	92.359	92.911	40684.0
2017-02-02	E1	Futures	1.25029	1.25822	1.24954	1.25103	17750.0
2017-02-02	E6	Futures	1.24557	1.25256	1.24413	1.245	191364.0
2017-02-02	E7	Futures	1.2392	1.246	1.2377	1.2386	3452.0
2017-02-02	EBM	Futures	191.99	193.99	191.42	193.7	26429.0
2017-02-02	ED	Futures	95.5762	95.581	95.5665	95.5713	194213.0
2017-02-02	ER	Futures	98.298	98.308	98.298	98.303	51912.0
2017-02-02	EW	Futures	1787.5	1799.3	1779.3	1791.2	19914.0
2017-02-02	FBON	Futures	120.05	120.6	119.72	120.42	1190.0
2017-02-02	FBTP	Futures	103.32	104.07	103.05	103.93	136834.0
2017-02-02	FBTS	Futures	101.449	101.566	101.403	101.557	34446.0
2017-02-02	FCE	Futures	4210.5	4237.3	4202.5	4221.0	81710.0
2017-02-02	FDAX	Futures	12263.1	12322.3	12238.9	12278.4	74564.0
2017-02-02	FDXM	Futures	12216.9	12271.5	12194.8	12229.0	24475.0
2017-02-02	FESX	Futures	2594.3	2611.1	2590.3	2603.1	813761.0
2017-02-02	FEU3	Futures	98.971	98.971	98.971	98.971	32.0
2017-02-02	FGBL	Futures	146.04	146.6	145.76	146.43	856354.0
2017-02-02	FGBM	Futures	128.54	128.79	128.49	128.73	535248.0
2017-02-02	FGBS	Futures	112.132	112.177	112.117	112.157	316387.0
2017-02-02	FGBX	Futures	164.08	165.62	163.03	165.09	44815.0
2017-02-02	FMWO	Futures	5981.7	6007.0	5981.7	6005.8	328.0
2017-02-02	FOAT	Futures	129.98	130.66	129.73	130.45	202226.0
2017-02-02	FTDX	Futures	1813.6	1828.3	1813.6	1822.5	104.0
2017-02-02	FTI	Futures	435.21	440.42	434.67	438.5	37820.0
2017-02-02	FTUK	Futures	5970.2	6019.0	5956.7	6001.6	113483.0
2017-02-02	FVSA	Futures	843.16	845.53	819.48	826.58	19758.0
2017-02-02	FXXP	Futures	299.6	300.6	298.8	299.5	30113.0
2017-02-02	G	Futures	110.27	111.28	110.12	111.05	215026.0
2017-02-02	GF	Futures	279.097	282.459	277.729	282.117	5888.0

> showing 50 of 110 rows — these rows as CSV

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