PREVIEW / futures_daily / 2017-04-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-21.parquet
  size:    10 KB
  rows:    112

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-21	ES	Futures	2555.19	2558.72	2541.88	2549.49	1277783.0
2017-04-21	NQ	Futures	6413.06	6424.55	6392.45	6409.53	193756.0
2017-04-21	YM	Futures	21662.6	21686.9	21570.8	21634.1	117723.0
2017-04-21	CL	Futures	52.91	53.14	51.33	51.77	687474.0
2017-04-21	GC	Futures	1641.1	1649.8	1636.9	1648.5	229598.0
2017-04-21	ZN	Futures	123.905092	124.166268	123.797549	123.951182	1046535.0
2017-04-21	A6	Futures	0.77198	0.77393	0.77075	0.77301	63185.0
2017-04-21	AD	Futures	0.75733	0.75835	0.75457	0.75539	61524.0
2017-04-21	ALI	Futures	2549.75	2549.75	2549.75	2549.75	10.0
2017-04-21	B	Futures	38.44	38.65	37.4	37.68	348477.0
2017-04-21	B6	Futures	1.3444	1.3475	1.3394	1.3434	98990.0
2017-04-21	BFX	Futures	4499.6	4499.6	4479.6	4479.6	6.0
2017-04-21	BR	Futures	0.2268	0.22792	0.22607	0.22687	462.0
2017-04-21	BZ	Futures	38.35	38.53	37.3	37.58	36665.0
2017-04-21	C	Futures	1430.0	1478.0	1417.0	1476.0	4785.0
2017-04-21	CB	Futures	256.931	259.373	256.931	259.373	37.0
2017-04-21	CC	Futures	1375.0	1419.0	1366.0	1414.0	25829.0
2017-04-21	CNH	Futures	7.2003	7.2039	7.2003	7.2039	1.0
2017-04-21	CSC	Futures	3.513	3.585	3.513	3.576	35.0
2017-04-21	CT	Futures	89.17	89.51	87.48	88.05	3819.0
2017-04-21	DC	Futures	29.04	29.7	28.93	29.62	300.0
2017-04-21	DX	Futures	92.933	93.106	92.756	93.055	23079.0
2017-04-21	E1	Futures	1.24156	1.24539	1.23983	1.24181	20098.0
2017-04-21	E6	Futures	1.23687	1.24021	1.23382	1.23526	158925.0
2017-04-21	E7	Futures	1.2308	1.2338	1.2276	1.229	3254.0
2017-04-21	EBM	Futures	182.58	183.14	182.02	182.02	21733.0
2017-04-21	ED	Futures	95.5688	95.5881	95.5688	95.5784	196011.0
2017-04-21	ER	Futures	98.328	98.328	98.313	98.318	137839.0
2017-04-21	EW	Futures	1825.7	1829.8	1818.5	1823.4	11563.0
2017-04-21	FBON	Futures	121.65	121.82	121.5	121.52	949.0
2017-04-21	FBTP	Futures	105.19	105.57	105.15	105.21	85110.0
2017-04-21	FBTS	Futures	101.9	101.918	101.791	101.809	48273.0
2017-04-21	FCE	Futures	4481.2	4483.8	4425.9	4453.5	157945.0
2017-04-21	FDAX	Futures	12743.4	12789.4	12701.2	12758.8	94125.0
2017-04-21	FDIV	Futures	143.33	143.73	143.33	143.73	34.0
2017-04-21	FDXM	Futures	12634.6	12677.5	12589.6	12646.7	28070.0
2017-04-21	FESX	Futures	2757.3	2767.9	2736.1	2756.5	1387749.0
2017-04-21	FEU3	Futures	98.991	98.991	98.991	98.991	6.0
2017-04-21	FGBL	Futures	149.72	149.75	149.34	149.57	527257.0
2017-04-21	FGBM	Futures	129.84	129.84	129.67	129.75	338143.0
2017-04-21	FGBS	Futures	112.482	112.492	112.437	112.457	260487.0
2017-04-21	FGBX	Futures	174.0	174.0	172.92	173.52	33731.0
2017-04-21	FMWO	Futures	6203.7	6204.9	6190.5	6190.5	1456.0
2017-04-21	FOAT	Futures	132.79	133.47	132.45	132.53	153977.0
2017-04-21	FTDX	Futures	1984.7	2017.5	1978.3	1980.8	92.0
2017-04-21	FTI	Futures	465.38	465.84	462.54	464.42	42953.0
2017-04-21	FTUK	Futures	6044.7	6057.6	6030.2	6048.1	111774.0
2017-04-21	FVSA	Futures	690.77	708.67	676.46	678.25	56592.0
2017-04-21	FXXP	Futures	315.5	316.0	314.0	315.0	42492.0
2017-04-21	G	Futures	115.93	116.22	115.81	116.16	122013.0

> showing 50 of 112 rows — these rows as CSV

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