PREVIEW / futures_daily / 2017-03-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-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
2017-03-23	ES	Futures	2543.78	2558.72	2539.44	2541.34	1631527.0
2017-03-23	NQ	Futures	6319.43	6334.74	6297.94	6306.47	269772.0
2017-03-23	YM	Futures	21724.9	21844.1	21695.3	21723.8	187184.0
2017-03-23	CL	Futures	50.47	50.81	49.87	49.99	499878.0
2017-03-23	GC	Futures	1595.1	1601.1	1587.5	1593.3	234768.0
2017-03-23	ZN	Futures	122.368761	122.537758	122.107585	122.322671	1533329.0
2017-03-23	A6	Futures	0.78676	0.78687	0.78132	0.78245	75488.0
2017-03-23	AD	Futures	0.76589	0.76686	0.76441	0.76538	44112.0
2017-03-23	ALI	Futures	2565.82	2565.82	2565.82	2565.82	0.0
2017-03-23	B	Futures	37.12	37.31	36.69	36.92	320211.0
2017-03-23	B6	Futures	1.3113	1.3167	1.3095	1.3149	96068.0
2017-03-23	BFX	Futures	4541.3	4573.5	4541.3	4557.7	3.0
2017-03-23	BR	Futures	0.2293	0.2293	0.22814	0.22814	749.0
2017-03-23	BZ	Futures	36.9	37.14	36.53	36.75	35569.0
2017-03-23	C	Futures	1809.0	1820.0	1792.0	1816.0	7950.0
2017-03-23	CB	Futures	263.034	263.034	261.814	261.814	21.0
2017-03-23	CC	Futures	1660.0	1667.0	1635.0	1661.0	15850.0
2017-03-23	CNH	Futures	7.212	7.2128	7.2035	7.2042	45.0
2017-03-23	CSC	Futures	3.652	3.652	3.612	3.612	59.0
2017-03-23	CT	Futures	86.51	86.91	86.08	86.13	10692.0
2017-03-23	DC	Futures	29.79	29.81	29.34	29.49	236.0
2017-03-23	DX	Futures	92.78	92.854	92.64	92.759	23583.0
2017-03-23	E1	Futures	1.25281	1.25318	1.24935	1.25058	14806.0
2017-03-23	E6	Futures	1.24862	1.24983	1.24563	1.24753	157681.0
2017-03-23	E7	Futures	1.2421	1.2434	1.2394	1.2412	2303.0
2017-03-23	EBM	Futures	189.02	189.58	187.06	187.34	31029.0
2017-03-23	ED	Futures	95.5446	95.5591	95.5349	95.5591	363612.0
2017-03-23	ER	Futures	98.308	98.318	98.308	98.318	63891.0
2017-03-23	EW	Futures	1794.4	1813.1	1790.7	1801.1	18967.0
2017-03-23	FBON	Futures	120.87	121.33	120.85	121.06	1457.0
2017-03-23	FBTP	Futures	103.63	104.21	103.51	103.67	108081.0
2017-03-23	FBTS	Futures	101.646	101.719	101.628	101.664	32959.0
2017-03-23	FCE	Futures	4407.6	4434.6	4386.5	4433.2	84805.0
2017-03-23	FDAX	Futures	12640.0	12747.7	12586.7	12744.5	91460.0
2017-03-23	FDXM	Futures	12526.8	12635.7	12476.6	12632.5	28277.0
2017-03-23	FESX	Futures	2736.9	2757.3	2723.9	2755.7	992343.0
2017-03-23	FGBL	Futures	147.16	147.48	146.94	147.08	745046.0
2017-03-23	FGBM	Futures	128.86	128.99	128.73	128.8	489151.0
2017-03-23	FGBS	Futures	112.267	112.297	112.212	112.232	286574.0
2017-03-23	FGBX	Futures	166.99	167.69	165.87	166.27	49385.0
2017-03-23	FMWO	Futures	6172.4	6203.7	6167.6	6203.7	77.0
2017-03-23	FOAT	Futures	130.72	131.28	130.69	130.86	112087.0
2017-03-23	FTDX	Futures	1921.5	1942.6	1917.1	1940.6	84.0
2017-03-23	FTI	Futures	462.47	464.88	460.38	464.52	28579.0
2017-03-23	FTUK	Futures	6218.4	6224.9	6190.6	6221.0	90006.0
2017-03-23	FVSA	Futures	650.26	659.96	641.94	648.87	10368.0
2017-03-23	FXXP	Futures	310.6	312.8	309.7	312.8	28496.0
2017-03-23	G	Futures	114.35	114.63	113.94	114.05	182024.0
2017-03-23	GF	Futures	316.532	316.936	311.977	312.15	7140.0
2017-03-23	GSCI	Futures	482.92	483.31	479.67	481.46	83.0

> showing 50 of 109 rows — these rows as CSV

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