PREVIEW / futures_daily / 2017-04-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-13.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-04-13	ES	Futures	2539.98	2546.77	2523.96	2527.77	1587079.0
2017-04-13	NQ	Futures	6323.55	6359.47	6298.23	6311.77	278784.0
2017-04-13	YM	Futures	21628.8	21682.6	21512.8	21540.2	161544.0
2017-04-13	CL	Futures	55.66	56.13	55.55	55.93	262721.0
2017-04-13	GC	Futures	1647.5	1650.6	1641.7	1647.7	235464.0
2017-04-13	ZN	Futures	123.859002	124.135542	123.643916	123.966545	1329353.0
2017-04-13	A6	Futures	0.77219	0.77876	0.77178	0.77753	105995.0
2017-04-13	AD	Futures	0.77028	0.77186	0.76513	0.76814	60503.0
2017-04-13	ALI	Futures	2514.3	2514.3	2514.3	2514.3	0.0
2017-04-13	B	Futures	40.37	40.66	40.29	40.53	325309.0
2017-04-13	B6	Futures	1.3175	1.3203	1.3125	1.3143	73768.0
2017-04-13	BR	Futures	0.22839	0.22937	0.22781	0.22799	40.0
2017-04-13	BZ	Futures	40.26	40.54	40.2	40.42	27171.0
2017-04-13	C	Futures	1613.0	1620.0	1572.0	1579.0	6705.0
2017-04-13	CB	Futures	256.931	256.931	255.711	256.321	16.0
2017-04-13	CC	Futures	1495.0	1506.0	1461.0	1464.0	31984.0
2017-04-13	CNH	Futures	7.1997	7.2003	7.1856	7.1983	45.0
2017-04-13	CSC	Futures	3.531	3.536	3.482	3.493	57.0
2017-04-13	CT	Futures	83.37	84.42	83.22	84.29	19543.0
2017-04-13	DC	Futures	28.99	29.12	28.58	28.71	142.0
2017-04-13	DX	Futures	93.194	93.632	93.101	93.598	22776.0
2017-04-13	E1	Futures	1.2365	1.23922	1.23193	1.2339	16203.0
2017-04-13	E6	Futures	1.23227	1.23359	1.2257	1.2272	146639.0
2017-04-13	E7	Futures	1.226	1.2274	1.2194	1.2209	2474.0
2017-04-13	EBM	Futures	183.98	185.94	183.7	185.66	24395.0
2017-04-13	ED	Futures	95.5784	95.5784	95.5591	95.5591	181514.0
2017-04-13	ER	Futures	98.323	98.323	98.318	98.323	21179.0
2017-04-13	EW	Futures	1803.2	1808.5	1783.9	1784.5	18986.0
2017-04-13	FBON	Futures	121.96	122.14	121.53	121.73	597.0
2017-04-13	FBTP	Futures	105.19	105.4	104.83	105.11	62717.0
2017-04-13	FBTS	Futures	101.773	101.845	101.755	101.782	20710.0
2017-04-13	FCE	Futures	4477.6	4482.5	4442.4	4458.9	10372.0
2017-04-13	FDAX	Futures	12849.0	12858.0	12764.0	12804.7	77626.0
2017-04-13	FDXM	Futures	12740.3	12745.6	12650.3	12692.2	21570.0
2017-04-13	FESX	Futures	2772.8	2773.6	2746.7	2756.5	928384.0
2017-04-13	FEU3	Futures	98.991	98.991	98.991	98.991	15.0
2017-04-13	FGBL	Futures	150.34	150.56	150.18	150.3	489284.0
2017-04-13	FGBM	Futures	130.19	130.3	130.17	130.22	273085.0
2017-04-13	FGBS	Futures	112.577	112.612	112.567	112.597	148230.0
2017-04-13	FGBX	Futures	174.6	175.54	174.24	174.66	36946.0
2017-04-13	FMWO	Futures	6173.6	6182.0	6162.7	6178.4	247.0
2017-04-13	FOAT	Futures	132.32	132.6	132.06	132.34	103525.0
2017-04-13	FTDX	Futures	1985.7	1987.6	1972.9	1985.2	27.0
2017-04-13	FTI	Futures	466.67	467.49	465.75	466.67	4136.0
2017-04-13	FTUK	Futures	6227.4	6238.5	6194.5	6215.0	97005.0
2017-04-13	FVSA	Futures	706.88	715.83	690.77	703.3	22055.0
2017-04-13	FXXP	Futures	317.3	317.3	315.5	316.6	19066.0
2017-04-13	G	Futures	116.13	116.35	116.0	116.08	123120.0
2017-04-13	GF	Futures	315.792	319.115	313.272	317.11	8560.0
2017-04-13	GSCI	Futures	504.5	505.51	502.75	503.88	2756.0

> showing 50 of 109 rows — these rows as CSV

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