PREVIEW / futures_daily / 2017-01-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-23.parquet
  size:    9 KB
  rows:    108

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-01-23	ES	Futures	2456.57	2458.2	2441.12	2452.23	1474482.0
2017-01-23	NQ	Futures	5962.58	5975.25	5928.69	5967.88	181150.0
2017-01-23	YM	Futures	20798.4	20824.7	20714.1	20786.8	129845.0
2017-01-23	CL	Futures	57.07	57.22	55.87	56.45	455333.0
2017-01-23	GC	Futures	1553.0	1566.0	1552.6	1561.1	237411.0
2017-01-23	ZN	Futures	121.446312	122.240978	121.43103	122.072876	1684165.0
2017-01-23	A6	Futures	0.77341	0.77628	0.77238	0.77484	76301.0
2017-01-23	AD	Futures	0.76672	0.77301	0.76637	0.77137	72343.0
2017-01-23	ALI	Futures	2519.43	2519.43	2519.11	2519.11	2.0
2017-01-23	B	Futures	41.34	41.47	40.63	41.02	215101.0
2017-01-23	B6	Futures	1.2999	1.3171	1.2995	1.3127	106169.0
2017-01-23	BR	Futures	0.22301	0.22304	0.22187	0.22205	132.0
2017-01-23	BZ	Futures	41.04	41.15	40.43	40.82	18824.0
2017-01-23	C	Futures	1806.0	1827.0	1797.0	1810.0	7055.0
2017-01-23	CB	Futures	277.071	277.071	274.02	274.538	15.0
2017-01-23	CC	Futures	1644.0	1661.0	1631.0	1648.0	16275.0
2017-01-23	CNH	Futures	7.2542	7.2736	7.2418	7.2418	23.0
2017-01-23	CSC	Futures	4.036	4.038	3.944	3.962	132.0
2017-01-23	CT	Futures	84.02	86.09	83.89	85.73	25192.0
2017-01-23	DC	Futures	33.4	33.42	32.63	32.82	463.0
2017-01-23	DX	Futures	93.807	93.807	93.034	93.23	40266.0
2017-01-23	E1	Futures	1.24025	1.24719	1.24025	1.24458	19616.0
2017-01-23	E6	Futures	1.23911	1.24661	1.23882	1.24378	195583.0
2017-01-23	E7	Futures	1.2328	1.24	1.2327	1.2374	3373.0
2017-01-23	EBM	Futures	193.7	193.7	192.85	193.7	19098.0
2017-01-23	ED	Futures	95.5423	95.5665	95.5375	95.5568	385666.0
2017-01-23	ER	Futures	98.308	98.308	98.303	98.308	25855.0
2017-01-23	EW	Futures	1781.0	1784.1	1768.2	1777.7	16313.0
2017-01-23	FBON	Futures	122.05	122.46	121.61	122.17	1227.0
2017-01-23	FBTP	Futures	105.66	105.9	105.21	105.63	85478.0
2017-01-23	FBTS	Futures	101.837	101.855	101.8	101.837	19979.0
2017-01-23	FCE	Futures	4250.1	4265.1	4224.6	4245.3	90480.0
2017-01-23	FDAX	Futures	12207.2	12252.6	12146.5	12190.8	91458.0
2017-01-23	FDXM	Futures	12159.1	12202.2	12098.1	12141.7	21202.0
2017-01-23	FESX	Futures	2618.3	2628.7	2603.1	2610.3	971744.0
2017-01-23	FGBL	Futures	146.79	147.34	146.5	147.12	793414.0
2017-01-23	FGBM	Futures	128.71	128.87	128.61	128.81	473051.0
2017-01-23	FGBS	Futures	112.052	112.072	112.032	112.062	206688.0
2017-01-23	FGBX	Futures	164.83	166.61	163.84	166.02	42986.0
2017-01-23	FMWO	Futures	5951.5	5955.2	5943.1	5943.1	526.0
2017-01-23	FOAT	Futures	132.0	132.44	131.59	132.18	100104.0
2017-01-23	FTDX	Futures	1791.1	1798.9	1789.1	1790.1	149.0
2017-01-23	FTI	Futures	440.37	441.47	437.31	438.96	36770.0
2017-01-23	FTUK	Futures	6028.7	6038.5	5991.9	6008.0	92746.0
2017-01-23	FVSA	Futures	843.16	881.05	838.42	873.95	22937.0
2017-01-23	FXXP	Futures	298.4	299.2	297.0	298.2	25153.0
2017-01-23	G	Futures	111.11	111.52	110.8	111.11	149716.0
2017-01-23	GF	Futures	300.184	300.241	297.506	297.905	3888.0
2017-01-23	GSCI	Futures	524.53	526.64	524.39	526.31	41.0
2017-01-23	HE	Futures	87.371	87.467	85.681	86.447	12223.0

> showing 50 of 108 rows — these rows as CSV

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