PREVIEW / futures_daily / 2017-02-09

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-09.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-02-09	ES	Futures	2483.13	2501.83	2480.15	2498.04	1354847.0
2017-02-09	NQ	Futures	6116.68	6151.45	6112.56	6143.2	157897.0
2017-02-09	YM	Futures	21076.5	21232.4	21047.0	21209.2	113826.0
2017-02-09	CL	Futures	56.04	56.94	56.04	56.72	610196.0
2017-02-09	GC	Futures	1587.5	1592.0	1566.3	1580.0	246135.0
2017-02-09	ZN	Futures	122.730003	122.730003	122.10344	122.17985	1434680.0
2017-02-09	A6	Futures	0.78201	0.78437	0.77884	0.78058	80184.0
2017-02-09	AD	Futures	0.77725	0.78026	0.77582	0.7777	50945.0
2017-02-09	ALI	Futures	2511.73	2511.73	2503.38	2505.31	34.0
2017-02-09	B	Futures	40.78	41.24	40.73	41.02	263404.0
2017-02-09	B6	Futures	1.3157	1.3205	1.3109	1.3114	93249.0
2017-02-09	BR	Futures	0.22688	0.22863	0.226	0.22656	529.0
2017-02-09	BZ	Futures	40.54	41.03	40.5	40.82	29628.0
2017-02-09	C	Futures	1684.0	1706.0	1678.0	1682.0	5656.0
2017-02-09	CB	Futures	269.137	269.137	265.506	266.116	35.0
2017-02-09	CC	Futures	1533.0	1556.0	1518.0	1524.0	30756.0
2017-02-09	CNH	Futures	7.2545	7.2668	7.2508	7.2668	36.0
2017-02-09	CSC	Futures	3.882	3.9	3.843	3.896	88.0
2017-02-09	CT	Futures	86.65	87.45	86.44	86.82	28631.0
2017-02-09	DC	Futures	32.36	32.59	32.02	32.48	254.0
2017-02-09	DX	Futures	93.332	93.733	93.179	93.711	33566.0
2017-02-09	E1	Futures	1.24768	1.24929	1.23888	1.23938	22133.0
2017-02-09	E6	Futures	1.23656	1.23836	1.23154	1.23246	168986.0
2017-02-09	E7	Futures	1.2305	1.2319	1.2253	1.2261	3194.0
2017-02-09	EBM	Futures	194.84	195.98	193.99	195.7	24366.0
2017-02-09	ED	Futures	95.5858	95.5858	95.5713	95.5762	186736.0
2017-02-09	ER	Futures	98.298	98.303	98.293	98.298	46728.0
2017-02-09	EW	Futures	1804.0	1823.7	1801.3	1820.4	13756.0
2017-02-09	FBON	Futures	120.0	120.7	119.96	120.59	843.0
2017-02-09	FBTP	Futures	103.82	104.37	103.74	104.26	128197.0
2017-02-09	FBTS	Futures	101.566	101.647	101.566	101.611	30781.0
2017-02-09	FCE	Futures	4209.6	4256.3	4198.6	4250.6	93134.0
2017-02-09	FDAX	Futures	12213.5	12306.4	12183.4	12298.5	85689.0
2017-02-09	FDXM	Futures	12167.5	12256.8	12133.8	12248.9	30781.0
2017-02-09	FESX	Futures	2595.1	2624.7	2591.9	2623.1	1138621.0
2017-02-09	FGBL	Futures	148.09	148.32	147.88	148.11	771510.0
2017-02-09	FGBM	Futures	129.4	129.44	129.25	129.36	511810.0
2017-02-09	FGBS	Futures	112.272	112.277	112.222	112.247	239676.0
2017-02-09	FGBX	Futures	167.99	169.08	167.36	168.43	55200.0
2017-02-09	FMWO	Futures	6021.5	6055.3	6019.1	6052.9	545.0
2017-02-09	FOAT	Futures	130.73	131.45	130.71	131.18	156126.0
2017-02-09	FTDX	Futures	1813.6	1825.4	1806.3	1821.0	44.0
2017-02-09	FTI	Futures	440.37	445.89	440.37	444.75	35439.0
2017-02-09	FTUK	Futures	6040.2	6086.0	6033.8	6080.9	98025.0
2017-02-09	FVSA	Futures	810.0	812.37	746.05	750.79	18957.0
2017-02-09	FXXP	Futures	301.7	303.7	301.1	303.7	45922.0
2017-02-09	G	Futures	112.63	112.86	112.44	112.63	215056.0
2017-02-09	GF	Futures	279.325	282.231	277.9	281.832	5961.0
2017-02-09	GSCI	Futures	526.04	526.84	524.92	525.71	3955.0
2017-02-09	HE	Futures	91.995	92.154	90.082	90.273	15038.0

> showing 50 of 108 rows — these rows as CSV

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