PREVIEW / futures_daily / 2017-01-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-06.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-01-06	ES	Futures	2454.67	2468.5	2448.17	2462.53	1551007.0
2017-01-06	NQ	Futures	5848.84	5913.67	5837.06	5897.76	183315.0
2017-01-06	YM	Futures	20877.4	20986.9	20813.2	20957.5	121917.0
2017-01-06	CL	Futures	57.5	58.13	57.06	57.78	528333.0
2017-01-06	GC	Futures	1516.6	1520.2	1503.9	1506.9	226432.0
2017-01-06	ZN	Futures	122.210414	122.577183	121.583851	121.675543	1540229.0
2017-01-06	A6	Futures	0.75047	0.75211	0.74535	0.74688	90475.0
2017-01-06	AD	Futures	0.7727	0.77566	0.77035	0.77204	67833.0
2017-01-06	ALI	Futures	2314.85	2331.97	2314.85	2331.97	24.0
2017-01-06	B	Futures	42.38	42.82	41.93	42.54	234870.0
2017-01-06	B6	Futures	1.3041	1.3058	1.2879	1.2895	114636.0
2017-01-06	BFX	Futures	4369.6	4392.3	4369.6	4388.1	66.0
2017-01-06	BR	Futures	0.21917	0.21945	0.21775	0.21775	31.0
2017-01-06	BZ	Futures	42.06	42.49	41.63	42.23	24948.0
2017-01-06	C	Futures	1876.0	1916.0	1871.0	1888.0	11554.0
2017-01-06	CB	Futures	276.766	277.071	273.47	274.325	22.0
2017-01-06	CC	Futures	1723.0	1744.0	1709.0	1721.0	14444.0
2017-01-06	CNH	Futures	7.3359	7.3739	7.3359	7.3555	74.0
2017-01-06	CSC	Futures	3.937	3.967	3.937	3.967	49.0
2017-01-06	CT	Futures	84.93	85.23	83.74	85.0	19101.0
2017-01-06	DC	Futures	32.33	32.73	32.29	32.71	197.0
2017-01-06	DX	Futures	94.543	95.25	94.408	95.166	38065.0
2017-01-06	E1	Futures	1.23206	1.23231	1.22116	1.22165	24867.0
2017-01-06	E6	Futures	1.22836	1.23125	1.21907	1.21987	215663.0
2017-01-06	E7	Futures	1.222	1.2243	1.2128	1.2136	4086.0
2017-01-06	EBM	Futures	193.7	195.7	193.13	195.13	23374.0
2017-01-06	ED	Futures	95.5858	95.5858	95.5617	95.5665	304135.0
2017-01-06	ER	Futures	98.298	98.298	98.293	98.293	31949.0
2017-01-06	EW	Futures	1791.5	1797.7	1785.0	1788.2	13697.0
2017-01-06	FBON	Futures	121.86	121.86	121.2	121.41	91.0
2017-01-06	FBTP	Futures	106.15	106.5	105.84	106.08	65610.0
2017-01-06	FBTS	Futures	101.819	101.819	101.737	101.764	24280.0
2017-01-06	FCE	Futures	4303.8	4323.2	4286.2	4317.5	77289.0
2017-01-06	FDAX	Futures	12207.7	12264.2	12183.4	12236.2	57845.0
2017-01-06	FDXM	Futures	12155.9	12213.7	12134.9	12186.9	14301.0
2017-01-06	FESX	Futures	2643.9	2655.9	2632.7	2650.3	755370.0
2017-01-06	FEU3	Futures	98.966	98.966	98.966	98.966	8.0
2017-01-06	FGBL	Futures	147.58	147.6	146.7	146.86	635828.0
2017-01-06	FGBM	Futures	129.04	129.04	128.8	128.86	501530.0
2017-01-06	FGBS	Futures	112.137	112.142	112.077	112.127	354420.0
2017-01-06	FGBX	Futures	169.81	170.41	167.4	167.87	38920.0
2017-01-06	FMWO	Futures	5946.7	5957.6	5946.7	5957.6	1783.0
2017-01-06	FOAT	Futures	132.82	132.99	132.31	132.44	112391.0
2017-01-06	FTDX	Futures	1799.9	1807.8	1799.9	1804.8	83.0
2017-01-06	FTI	Futures	442.47	443.83	441.24	442.97	22973.0
2017-01-06	FTUK	Futures	6046.1	6074.1	6033.4	6052.1	71512.0
2017-01-06	FVSA	Futures	972.88	975.62	918.07	931.77	18278.0
2017-01-06	FXXP	Futures	301.7	302.8	300.8	301.9	13122.0
2017-01-06	G	Futures	111.7	111.9	111.03	111.16	144258.0
2017-01-06	GF	Futures	286.1	287.327	284.985	286.267	1774.0

> showing 50 of 110 rows — these rows as CSV

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