PREVIEW / futures_daily / 2017-04-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-12.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-04-12	ES	Futures	2554.1	2559.26	2538.63	2542.16	1534596.0
2017-04-12	NQ	Futures	6363.3	6375.08	6323.55	6327.97	251108.0
2017-04-12	YM	Futures	21732.2	21777.6	21620.4	21647.8	157299.0
2017-04-12	CL	Futures	55.97	56.35	55.24	55.66	629805.0
2017-04-12	GC	Futures	1633.3	1648.4	1629.0	1634.4	251097.0
2017-04-12	ZN	Futures	123.38274	123.889729	123.259833	123.367376	1370086.0
2017-04-12	A6	Futures	0.76859	0.77188	0.76623	0.76654	93464.0
2017-04-12	AD	Futures	0.76615	0.77125	0.76528	0.76625	105724.0
2017-04-12	ALI	Futures	2501.5	2501.5	2501.5	2501.5	0.0
2017-04-12	B	Futures	40.82	41.08	40.25	40.51	373526.0
2017-04-12	B6	Futures	1.3116	1.3177	1.3104	1.3117	80411.0
2017-04-12	BR	Futures	0.22814	0.22894	0.22687	0.22687	42.0
2017-04-12	BZ	Futures	40.7	40.96	40.15	40.4	33978.0
2017-04-12	C	Futures	1639.0	1644.0	1611.0	1627.0	7129.0
2017-04-12	CB	Futures	257.542	257.847	257.542	257.816	8.0
2017-04-12	CC	Futures	1506.0	1513.0	1488.0	1504.0	33252.0
2017-04-12	CNH	Futures	7.2179	7.2207	7.2162	7.2162	24.0
2017-04-12	CSC	Futures	3.507	3.56	3.507	3.56	88.0
2017-04-12	CT	Futures	83.46	83.78	83.13	83.3	23162.0
2017-04-12	DC	Futures	28.56	29.08	28.56	29.03	395.0
2017-04-12	DX	Futures	93.721	93.874	93.176	93.829	22388.0
2017-04-12	E1	Futures	1.23143	1.23749	1.22921	1.2297	20875.0
2017-04-12	E6	Futures	1.22524	1.2333	1.22334	1.22409	161555.0
2017-04-12	E7	Futures	1.219	1.2271	1.2172	1.2178	3118.0
2017-04-12	EBM	Futures	183.14	185.1	182.3	184.54	24141.0
2017-04-12	ED	Futures	95.5591	95.5784	95.5542	95.5542	217208.0
2017-04-12	ER	Futures	98.323	98.328	98.318	98.323	47537.0
2017-04-12	EW	Futures	1827.4	1833.9	1803.3	1805.3	21215.0
2017-04-12	FBON	Futures	122.04	122.09	121.68	121.9	534.0
2017-04-12	FBTP	Futures	105.26	105.28	104.82	105.15	104668.0
2017-04-12	FBTS	Futures	101.782	101.782	101.709	101.755	47697.0
2017-04-12	FCE	Futures	4497.2	4522.6	4479.8	4484.7	3047.0
2017-04-12	FDAX	Futures	12879.6	12951.4	12820.5	12865.4	91313.0
2017-04-12	FDIV	Futures	146.42	146.42	145.54	145.54	21.0
2017-04-12	FDXM	Futures	12762.3	12837.6	12708.9	12752.4	24511.0
2017-04-12	FESX	Futures	2785.1	2799.8	2767.1	2776.1	803530.0
2017-04-12	FGBL	Futures	150.04	150.29	149.81	150.03	535637.0
2017-04-12	FGBM	Futures	130.18	130.19	130.08	130.12	338374.0
2017-04-12	FGBS	Futures	112.592	112.597	112.537	112.557	146689.0
2017-04-12	FGBX	Futures	173.44	174.56	172.9	173.74	34981.0
2017-04-12	FMWO	Futures	6215.7	6215.7	6182.0	6185.6	1353.0
2017-04-12	FOAT	Futures	131.92	132.28	131.62	132.16	118273.0
2017-04-12	FTDX	Futures	1975.4	1990.1	1973.9	1987.2	100.0
2017-04-12	FTI	Futures	471.35	471.35	468.5	468.55	20.0
2017-04-12	FTUK	Futures	6268.1	6283.0	6226.6	6238.5	87653.0
2017-04-12	FVSA	Futures	714.04	714.04	697.93	703.3	10120.0
2017-04-12	FXXP	Futures	318.2	319.6	317.1	318.0	22256.0
2017-04-12	G	Futures	115.98	116.03	115.71	115.95	161877.0
2017-04-12	GF	Futures	315.391	320.26	313.444	315.792	10142.0
2017-04-12	GSCI	Futures	506.01	506.39	502.37	502.62	2500.0

> showing 50 of 110 rows — these rows as CSV

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