PREVIEW / futures_daily / 2017-06-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-16.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-06-16	ES	Futures	2642.34	2648.32	2630.38	2642.07	1336684.0
2017-06-16	NQ	Futures	6711.16	6732.91	6654.74	6681.78	356290.0
2017-06-16	YM	Futures	22531.2	22586.2	22478.3	22551.3	116376.0
2017-06-16	CL	Futures	45.91	46.66	45.91	46.44	393720.0
2017-06-16	GC	Futures	1602.9	1606.7	1599.8	1604.0	149106.0
2017-06-16	ZN	Futures	124.734844	124.965692	124.596335	124.842573	1020120.0
2017-06-16	A6	Futures	0.77773	0.78287	0.77732	0.78236	86077.0
2017-06-16	AD	Futures	0.7675	0.77111	0.76734	0.77055	74778.0
2017-06-16	ALI	Futures	2475.76	2475.76	2475.76	2475.76	0.0
2017-06-16	B	Futures	33.31	33.87	33.3	33.7	227424.0
2017-06-16	B6	Futures	1.3367	1.3422	1.3363	1.3395	103837.0
2017-06-16	BR	Futures	0.222	0.22208	0.222	0.22208	5.0
2017-06-16	BZ	Futures	33.18	33.72	33.17	33.56	19728.0
2017-06-16	C	Futures	1653.0	1663.0	1613.0	1626.0	8703.0
2017-06-16	CB	Futures	327.857	327.857	327.218	327.218	12.0
2017-06-16	CC	Futures	1579.0	1583.0	1529.0	1540.0	21644.0
2017-06-16	CNH	Futures	7.0817	7.0994	7.0817	7.091	7.0
2017-06-16	CSC	Futures	3.604	3.604	3.604	3.604	6.0
2017-06-16	CT	Futures	79.61	80.34	78.52	79.61	18087.0
2017-06-16	DC	Futures	30.29	30.36	29.96	30.12	192.0
2017-06-16	DX	Futures	90.753	90.823	90.398	90.45	34685.0
2017-06-16	E1	Futures	1.26646	1.27026	1.26621	1.26879	23406.0
2017-06-16	E6	Futures	1.28333	1.28975	1.28242	1.28877	188534.0
2017-06-16	E7	Futures	1.2771	1.2828	1.2759	1.282	3669.0
2017-06-16	EBM	Futures	190.68	193.46	190.68	193.18	27782.0
2017-06-16	ED	Futures	95.5838	95.5935	95.5741	95.5886	217925.0
2017-06-16	ER	Futures	98.332	98.337	98.328	98.337	117451.0
2017-06-16	EW	Futures	1863.1	1867.8	1851.4	1863.4	13005.0
2017-06-16	FBON	Futures	124.73	124.86	124.14	124.53	691.0
2017-06-16	FBTP	Futures	109.08	109.38	108.96	109.02	76335.0
2017-06-16	FBTS	Futures	102.854	102.881	102.817	102.836	26440.0
2017-06-16	FCE	Futures	4707.8	4747.0	4707.8	4737.1	101430.0
2017-06-16	FDAX	Futures	13430.7	13476.1	13426.0	13445.7	7275.0
2017-06-16	FDXM	Futures	13302.3	13349.3	13290.7	13325.3	19223.0
2017-06-16	FESX	Futures	2877.3	2893.6	2871.6	2881.4	1072822.0
2017-06-16	FEU3	Futures	99.006	99.006	99.006	99.006	10.0
2017-06-16	FGBL	Futures	149.47	149.67	149.1	149.65	536852.0
2017-06-16	FGBM	Futures	129.47	129.65	129.31	129.61	435223.0
2017-06-16	FGBS	Futures	112.247	112.287	112.197	112.272	267164.0
2017-06-16	FGBX	Futures	170.0	170.0	168.85	169.66	45188.0
2017-06-16	FMWO	Futures	6456.7	6456.7	6456.7	6456.7	0.0
2017-06-16	FOAT	Futures	136.72	136.88	136.48	136.82	96199.0
2017-06-16	FTDX	Futures	2268.7	2283.2	2260.1	2273.7	208.0
2017-06-16	FTI	Futures	478.93	481.1	477.64	479.85	34608.0
2017-06-16	FTUK	Futures	6364.5	6427.1	6364.5	6390.4	136270.0
2017-06-16	FVSA	Futures	489.66	489.66	472.34	480.22	13746.0
2017-06-16	FXXP	Futures	328.2	330.6	328.2	329.2	33376.0
2017-06-16	G	Futures	115.98	116.48	115.79	116.34	160572.0
2017-06-16	GF	Futures	324.558	326.918	322.253	324.613	4179.0
2017-06-16	GSCI	Futures	443.48	443.48	442.87	443.17	271.0

> showing 50 of 110 rows — these rows as CSV

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