PREVIEW / futures_daily / 2017-02-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-27.parquet
  size:    9 KB
  rows:    107

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-27	ES	Futures	2561.46	2570.13	2559.56	2567.42	1156575.0
2017-02-27	NQ	Futures	6293.77	6308.5	6274.03	6302.61	153779.0
2017-02-27	YM	Futures	21884.4	21944.4	21853.8	21922.3	122654.0
2017-02-27	CL	Futures	57.32	57.95	57.23	57.35	394380.0
2017-02-27	GC	Futures	1608.2	1615.9	1598.8	1608.1	208488.0
2017-02-27	ZN	Futures	122.882823	122.882823	122.363234	122.393798	1246309.0
2017-02-27	A6	Futures	0.7858	0.78908	0.78406	0.78631	60449.0
2017-02-27	AD	Futures	0.77985	0.78072	0.77495	0.77673	58353.0
2017-02-27	ALI	Futures	2563.35	2563.35	2563.35	2563.35	10.0
2017-02-27	B	Futures	41.13	41.67	41.1	41.2	311469.0
2017-02-27	B6	Futures	1.3068	1.3092	1.299	1.3055	106596.0
2017-02-27	BR	Futures	0.22999	0.22999	0.22781	0.22781	11.0
2017-02-27	BZ	Futures	40.98	41.47	40.97	41.01	23314.0
2017-02-27	C	Futures	1646.0	1660.0	1626.0	1636.0	6098.0
2017-02-27	CB	Futures	277.681	278.902	277.681	278.597	12.0
2017-02-27	CC	Futures	1511.0	1533.0	1502.0	1513.0	19055.0
2017-02-27	CNH	Futures	7.2524	7.2524	7.2486	7.2488	130.0
2017-02-27	CSC	Futures	3.811	3.811	3.766	3.766	216.0
2017-02-27	CT	Futures	85.36	85.98	84.75	84.85	12290.0
2017-02-27	DC	Futures	31.08	31.1	30.5	30.52	230.0
2017-02-27	DX	Futures	94.184	94.301	93.742	94.16	24660.0
2017-02-27	E1	Futures	1.23107	1.23467	1.2281	1.22897	16783.0
2017-02-27	E6	Futures	1.22034	1.22854	1.21941	1.22363	168333.0
2017-02-27	E7	Futures	1.2154	1.2223	1.213	1.2174	2544.0
2017-02-27	EBM	Futures	196.27	196.27	193.7	193.99	13776.0
2017-02-27	ED	Futures	95.5496	95.5496	95.5303	95.5303	283650.0
2017-02-27	ER	Futures	98.303	98.308	98.303	98.303	23737.0
2017-02-27	EW	Futures	1845.7	1860.9	1844.2	1860.1	13656.0
2017-02-27	FBON	Futures	121.13	121.47	120.97	121.3	804.0
2017-02-27	FBTP	Futures	104.18	104.81	104.11	104.66	147097.0
2017-02-27	FBTS	Futures	101.512	101.629	101.494	101.593	56568.0
2017-02-27	FCE	Futures	4280.5	4284.0	4251.9	4262.4	65420.0
2017-02-27	FDAX	Futures	12493.3	12523.9	12446.3	12485.3	62311.0
2017-02-27	FDXM	Futures	12442.9	12472.4	12395.6	12435.0	21921.0
2017-02-27	FESX	Futures	2653.5	2658.3	2641.5	2648.7	794183.0
2017-02-27	FGBL	Futures	149.9	149.99	149.62	149.78	640036.0
2017-02-27	FGBM	Futures	130.32	130.36	130.2	130.27	448145.0
2017-02-27	FGBS	Futures	112.582	112.602	112.522	112.547	375640.0
2017-02-27	FGBX	Futures	172.74	173.04	171.61	172.22	43752.0
2017-02-27	FMWO	Futures	6154.2	6161.4	6147.0	6159.0	219.0
2017-02-27	FOAT	Futures	132.0	132.48	131.9	132.25	144118.0
2017-02-27	FTDX	Futures	1855.8	1863.6	1849.9	1855.8	145.0
2017-02-27	FTI	Futures	450.84	451.75	448.75	449.52	23168.0
2017-02-27	FTUK	Futures	6147.5	6164.4	6125.4	6143.6	84970.0
2017-02-27	FVSA	Futures	726.12	736.58	717.75	721.93	13200.0
2017-02-27	FXXP	Futures	306.9	307.1	304.8	306.1	28865.0
2017-02-27	G	Futures	114.59	114.85	114.54	114.68	175750.0
2017-02-27	GF	Futures	279.667	283.314	278.698	282.345	5585.0
2017-02-27	GSCI	Futures	518.51	518.51	516.19	516.19	86.0
2017-02-27	HE	Futures	87.053	88.009	86.574	86.893	16308.0

> showing 50 of 107 rows — these rows as CSV

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