PREVIEW / futures_daily / 2017-02-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-22.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-02-22	ES	Futures	2558.48	2562.54	2553.33	2559.56	1301504.0
2017-02-22	NQ	Futures	6300.25	6312.04	6289.35	6306.73	156582.0
2017-02-22	YM	Futures	21795.9	21875.9	21768.5	21854.9	120216.0
2017-02-22	CL	Futures	57.57	57.94	56.61	56.86	499480.0
2017-02-22	GC	Futures	1580.1	1586.5	1573.2	1575.5	201341.0
2017-02-22	ZN	Futures	121.935337	122.240978	121.706107	122.02703	2624783.0
2017-02-22	A6	Futures	0.78549	0.78969	0.78478	0.78908	83539.0
2017-02-22	AD	Futures	0.77699	0.77919	0.77219	0.77622	61178.0
2017-02-22	ALI	Futures	2551.49	2551.49	2551.49	2551.49	0.0
2017-02-22	B	Futures	41.84	42.04	41.03	41.18	245156.0
2017-02-22	B6	Futures	1.3092	1.3127	1.3025	1.3071	109626.0
2017-02-22	BFX	Futures	4385.7	4389.3	4385.7	4389.3	1.0
2017-02-22	BR	Futures	0.22955	0.23013	0.22955	0.22991	1226.0
2017-02-22	BZ	Futures	41.59	41.81	40.78	40.97	36358.0
2017-02-22	C	Futures	1664.0	1673.0	1652.0	1653.0	3511.0
2017-02-22	CB	Futures	272.189	272.189	272.189	272.189	7.0
2017-02-22	CC	Futures	1527.0	1534.0	1517.0	1523.0	10775.0
2017-02-22	CNH	Futures	7.2613	7.2636	7.2534	7.2534	19.0
2017-02-22	CSC	Futures	3.815	3.815	3.799	3.806	60.0
2017-02-22	CT	Futures	84.46	84.94	84.08	84.14	10059.0
2017-02-22	DC	Futures	31.71	31.88	31.6	31.68	76.0
2017-02-22	DX	Futures	94.375	94.706	94.184	94.22	38965.0
2017-02-22	E1	Futures	1.22872	1.23095	1.22339	1.22909	23157.0
2017-02-22	E6	Futures	1.21774	1.22224	1.213	1.2219	241801.0
2017-02-22	E7	Futures	1.2101	1.2159	1.2068	1.2157	5101.0
2017-02-22	EBM	Futures	195.13	197.12	195.13	196.27	14977.0
2017-02-22	ED	Futures	95.5375	95.552	95.5303	95.5472	304617.0
2017-02-22	ER	Futures	98.298	98.308	98.298	98.303	87277.0
2017-02-22	EW	Futures	1860.9	1862.7	1849.4	1854.0	10228.0
2017-02-22	FBON	Futures	120.17	120.56	119.69	120.12	2258.0
2017-02-22	FBTP	Futures	103.6	104.19	103.39	103.95	180851.0
2017-02-22	FBTS	Futures	101.485	101.494	101.376	101.485	91319.0
2017-02-22	FCE	Futures	4309.9	4330.2	4280.0	4306.4	89032.0
2017-02-22	FDAX	Futures	12659.5	12699.1	12630.0	12666.4	73469.0
2017-02-22	FDXM	Futures	12610.1	12649.0	12578.5	12615.3	23704.0
2017-02-22	FESX	Futures	2675.1	2683.1	2657.5	2670.3	961440.0
2017-02-22	FEU3	Futures	98.971	98.971	98.971	98.971	3.0
2017-02-22	FGBL	Futures	148.22	149.28	148.18	148.8	1140720.0
2017-02-22	FGBM	Futures	129.67	130.12	129.66	129.96	751723.0
2017-02-22	FGBS	Futures	112.422	112.527	112.422	112.477	610267.0
2017-02-22	FGBX	Futures	166.97	169.97	166.63	168.61	80857.0
2017-02-22	FMWO	Futures	6166.3	6171.1	6145.7	6161.4	531.0
2017-02-22	FOAT	Futures	130.13	131.0	129.84	130.76	221340.0
2017-02-22	FTDX	Futures	1897.9	1901.4	1872.9	1884.2	207.0
2017-02-22	FTI	Futures	453.98	455.07	451.34	453.34	30599.0
2017-02-22	FTUK	Futures	6150.4	6169.1	6133.0	6157.6	110442.0
2017-02-22	FVSA	Futures	707.29	724.03	696.82	711.47	20983.0
2017-02-22	FXXP	Futures	310.0	310.7	308.3	309.2	24770.0
2017-02-22	G	Futures	112.72	113.52	112.7	113.19	382546.0
2017-02-22	GF	Futures	283.941	285.651	280.863	285.195	5734.0

> showing 50 of 110 rows — these rows as CSV

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