PREVIEW / futures_daily / 2017-10-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-06.parquet
  size:    9 KB
  rows:    111

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-10-06	ES	Futures	2772.26	2773.35	2764.37	2768.18	1169419.0
2017-10-06	NQ	Futures	7120.79	7131.65	7091.72	7123.14	232608.0
2017-10-06	YM	Futures	24002.8	24012.3	23950.0	23964.7	77797.0
2017-10-06	CL	Futures	51.43	51.5	49.75	49.95	743114.0
2017-10-06	GC	Futures	1616.7	1627.7	1606.8	1622.2	373753.0
2017-10-06	ZN	Futures	123.408934	123.455149	122.946786	123.27029	1810859.0
2017-10-06	A6	Futures	0.80111	0.80173	0.79484	0.79916	140194.0
2017-10-06	AD	Futures	0.80994	0.81264	0.80781	0.81234	70308.0
2017-10-06	B	Futures	40.25	40.45	38.93	39.28	395647.0
2017-10-06	B6	Futures	1.3704	1.3707	1.3604	1.3652	131848.0
2017-10-06	BFX	Futures	4788.6	4811.3	4788.6	4811.3	6.0
2017-10-06	BR	Futures	0.23637	0.23728	0.23622	0.23728	10.0
2017-10-06	BZ	Futures	39.91	40.11	38.62	38.96	33642.0
2017-10-06	C	Futures	1546.0	1560.0	1537.0	1559.0	10356.0
2017-10-06	CB	Futures	302.115	302.115	300.478	301.076	18.0
2017-10-06	CC	Futures	1552.0	1554.0	1530.0	1548.0	20958.0
2017-10-06	CNH	Futures	6.8566	6.8566	6.8474	6.8474	10.0
2017-10-06	CSC	Futures	3.528	3.528	3.52	3.528	41.0
2017-10-06	CT	Futures	80.12	81.27	79.64	80.86	11454.0
2017-10-06	DC	Futures	28.94	28.94	28.72	28.94	94.0
2017-10-06	DX	Futures	87.671	87.999	87.531	87.569	27381.0
2017-10-06	E1	Futures	1.25536	1.25695	1.24704	1.25536	24832.0
2017-10-06	E6	Futures	1.34134	1.34448	1.33638	1.34385	241916.0
2017-10-06	E7	Futures	1.3343	1.3373	1.3295	1.3369	5638.0
2017-10-06	EBM	Futures	179.63	179.9	178.01	178.28	16597.0
2017-10-06	ED	Futures	95.4988	95.4988	95.4745	95.4891	341407.0
2017-10-06	ER	Futures	98.342	98.342	98.337	98.337	16735.0
2017-10-06	EW	Futures	1934.0	1935.0	1927.5	1933.2	10876.0
2017-10-06	FBON	Futures	123.91	124.0	123.42	123.81	1074.0
2017-10-06	FBTP	Futures	108.67	108.67	108.1	108.5	90759.0
2017-10-06	FBTS	Futures	103.246	103.246	103.2	103.228	31746.0
2017-10-06	FCE	Futures	4822.1	4823.0	4790.8	4800.2	52303.0
2017-10-06	FDAX	Futures	13633.9	13647.6	13590.8	13606.0	57728.0
2017-10-06	FDIV	Futures	151.74	151.74	151.74	151.74	8.0
2017-10-06	FDXM	Futures	13516.7	13533.4	13476.1	13491.2	14387.0
2017-10-06	FESX	Futures	2940.1	2941.7	2924.6	2930.3	590784.0
2017-10-06	FEU3	Futures	99.011	99.011	99.006	99.006	21.0
2017-10-06	FGBL	Futures	149.12	149.14	148.49	149.01	838265.0
2017-10-06	FGBM	Futures	129.53	129.56	129.29	129.51	577593.0
2017-10-06	FGBS	Futures	112.427	112.437	112.382	112.427	299313.0
2017-10-06	FGBX	Futures	166.85	166.97	165.42	166.62	46705.0
2017-10-06	FMWO	Futures	6700.2	6700.2	6686.0	6690.7	697.0
2017-10-06	FOAT	Futures	136.27	136.37	135.77	136.22	132108.0
2017-10-06	FTDX	Futures	2488.5	2489.0	2472.5	2487.0	238.0
2017-10-06	FTI	Futures	499.54	500.32	496.64	497.33	21214.0
2017-10-06	FTUK	Futures	6485.9	6498.9	6483.3	6493.3	77326.0
2017-10-06	FVSA	Futures	376.02	385.95	373.18	378.85	20476.0
2017-10-06	FXXP	Futures	331.6	331.6	329.5	329.9	38018.0
2017-10-06	G	Futures	113.22	113.47	112.88	113.4	195392.0
2017-10-06	GF	Futures	335.288	337.471	334.524	335.998	1530.0

> showing 50 of 111 rows — these rows as CSV

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