PREVIEW / futures_daily / 2017-08-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-14.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-08-14	ES	Futures	2653.48	2680.65	2653.48	2677.39	1470477.0
2017-08-14	NQ	Futures	6861.93	6955.38	6861.93	6947.45	261541.0
2017-08-14	YM	Futures	23098.9	23243.7	23098.9	23205.6	104805.0
2017-08-14	CL	Futures	50.22	50.61	48.82	48.99	158995.0
2017-08-14	GC	Futures	1649.6	1649.6	1634.0	1641.9	238069.0
2017-08-14	ZN	Futures	124.842573	124.888742	124.534775	124.642504	945523.0
2017-08-14	A6	Futures	0.81061	0.81317	0.80547	0.80691	76691.0
2017-08-14	AD	Futures	0.80284	0.80289	0.79918	0.80014	44625.0
2017-08-14	ALI	Futures	2666.27	2666.27	2652.32	2654.85	4.0
2017-08-14	B	Futures	36.39	36.64	35.36	35.49	281573.0
2017-08-14	B6	Futures	1.3615	1.3623	1.3554	1.3569	70763.0
2017-08-14	BR	Futures	0.23247	0.23303	0.23084	0.23232	1857.0
2017-08-14	BZ	Futures	36.07	36.33	35.08	35.18	29797.0
2017-08-14	C	Futures	1541.0	1546.0	1499.0	1503.0	8851.0
2017-08-14	CB	Futures	327.644	328.465	324.786	327.127	50.0
2017-08-14	CC	Futures	1458.0	1462.0	1418.0	1426.0	31458.0
2017-08-14	CNH	Futures	6.904	6.9166	6.904	6.9166	36.0
2017-08-14	CSC	Futures	3.573	3.61	3.573	3.608	96.0
2017-08-14	CT	Futures	80.81	80.81	79.83	79.95	11.0
2017-08-14	DC	Futures	29.77	30.12	29.75	29.93	597.0
2017-08-14	DX	Futures	86.822	87.204	86.789	87.125	13439.0
2017-08-14	E1	Futures	1.27972	1.27972	1.26449	1.26609	29912.0
2017-08-14	E6	Futures	1.35723	1.35884	1.35099	1.35253	143809.0
2017-08-14	E7	Futures	1.3498	1.3515	1.344	1.3454	2556.0
2017-08-14	EBM	Futures	178.15	178.15	175.93	177.04	8559.0
2017-08-14	ED	Futures	95.5983	95.5983	95.5886	95.591	189365.0
2017-08-14	ER	Futures	98.337	98.342	98.337	98.342	25973.0
2017-08-14	EW	Futures	1817.5	1841.4	1817.2	1837.8	14482.0
2017-08-14	FBON	Futures	124.76	125.21	124.76	125.18	108.0
2017-08-14	FBTP	Futures	109.27	109.49	108.97	109.43	44309.0
2017-08-14	FBTS	Futures	103.009	103.091	103.0	103.073	20268.0
2017-08-14	FCE	Futures	4543.6	4594.6	4542.2	4580.7	74406.0
2017-08-14	FDAX	Futures	12691.8	12836.1	12690.8	12821.3	73093.0
2017-08-14	FDXM	Futures	12609.5	12758.1	12609.5	12742.4	22036.0
2017-08-14	FESX	Futures	2790.0	2823.4	2790.0	2819.4	869946.0
2017-08-14	FEU3	Futures	99.016	99.016	99.016	99.016	32.0
2017-08-14	FGBL	Futures	149.37	149.38	148.86	149.17	392549.0
2017-08-14	FGBM	Futures	129.55	129.56	129.42	129.53	235111.0
2017-08-14	FGBS	Futures	112.362	112.387	112.352	112.382	153277.0
2017-08-14	FGBX	Futures	169.64	169.66	168.14	168.85	28088.0
2017-08-14	FMWO	Futures	6503.1	6529.3	6503.1	6526.9	785.0
2017-08-14	FOAT	Futures	136.3	136.44	135.97	136.25	55024.0
2017-08-14	FTDX	Futures	2230.6	2263.1	2230.6	2262.1	158.0
2017-08-14	FTI	Futures	479.73	482.65	479.64	481.81	4830.0
2017-08-14	FTUK	Futures	6306.1	6362.3	6304.0	6349.8	74033.0
2017-08-14	FVSA	Futures	563.64	563.64	511.69	513.26	27758.0
2017-08-14	FXXP	Futures	317.5	320.5	317.5	320.1	36837.0
2017-08-14	G	Futures	115.97	116.1	115.75	115.99	95767.0
2017-08-14	GF	Futures	312.099	313.743	309.248	313.03	4102.0
2017-08-14	GSCI	Futures	457.44	457.44	451.7	451.82	322.0

> showing 50 of 110 rows — these rows as CSV

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