PREVIEW / futures_daily / 2017-12-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-04.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-12-04	ES	Futures	2887.28	2898.98	2864.71	2869.61	1756938.0
2017-12-04	NQ	Futures	7483.45	7507.82	7342.2	7359.24	520744.0
2017-12-04	YM	Futures	25709.2	25909.9	25623.7	25665.9	196164.0
2017-12-04	CL	Futures	58.38	58.4	57.41	57.53	529965.0
2017-12-04	GC	Futures	1619.7	1623.4	1614.5	1619.8	262068.0
2017-12-04	ZN	Futures	122.453828	122.823547	122.453828	122.746522	66535.0
2017-12-04	A6	Futures	0.78136	0.78341	0.77981	0.78125	75480.0
2017-12-04	AD	Futures	0.80089	0.80404	0.79957	0.8014	74216.0
2017-12-04	B	Futures	45.11	45.24	44.27	44.37	250521.0
2017-12-04	B6	Futures	1.4053	1.4122	1.3991	1.4049	223258.0
2017-12-04	BFX	Futures	4774.9	4774.9	4764.2	4764.2	5.0
2017-12-04	BR	Futures	0.2323	0.2323	0.23188	0.23199	3.0
2017-12-04	BZ	Futures	44.76	44.87	43.94	44.03	27437.0
2017-12-04	C	Futures	1409.0	1412.0	1371.0	1376.0	11912.0
2017-12-04	CB	Futures	280.938	281.556	280.197	280.413	83.0
2017-12-04	CC	Futures	1517.0	1521.0	1488.0	1494.0	23724.0
2017-12-04	CNH	Futures	6.7926	6.7976	6.7923	6.7928	27.0
2017-12-04	CSC	Futures	3.404	3.404	3.361	3.368	69.0
2017-12-04	CT	Futures	85.65	85.67	84.68	84.77	15864.0
2017-12-04	DC	Futures	27.18	27.18	26.68	26.78	96.0
2017-12-04	DX	Futures	87.007	87.292	86.975	87.105	30067.0
2017-12-04	E1	Futures	1.24876	1.24949	1.2402	1.24142	26513.0
2017-12-04	E6	Futures	1.35538	1.35641	1.35076	1.35395	170174.0
2017-12-04	E7	Futures	1.3483	1.3494	1.3437	1.3469	4242.0
2017-12-04	EBM	Futures	172.35	174.78	172.35	174.51	17594.0
2017-12-04	ED	Futures	95.4576	95.4576	95.443	95.4455	275279.0
2017-12-04	ER	Futures	98.337	98.342	98.337	98.337	25597.0
2017-12-04	EW	Futures	2023.3	2037.9	2010.1	2013.7	15726.0
2017-12-04	FBON	Futures	126.75	127.11	126.69	127.01	2517.0
2017-12-04	FBTP	Futures	113.67	113.86	113.54	113.83	228562.0
2017-12-04	FBTS	Futures	103.906	103.961	103.869	103.924	137251.0
2017-12-04	FCE	Futures	4812.3	4842.3	4790.7	4826.6	101833.0
2017-12-04	FDAX	Futures	13676.5	13787.9	13633.4	13715.3	104404.0
2017-12-04	FDXM	Futures	13565.7	13671.0	13517.8	13599.6	40948.0
2017-12-04	FESX	Futures	2907.5	2924.6	2896.0	2912.4	1021799.0
2017-12-04	FEU3	Futures	99.011	99.011	99.006	99.006	41.0
2017-12-04	FGBL	Futures	150.99	151.09	150.82	150.97	1649196.0
2017-12-04	FGBM	Futures	129.97	130.09	129.93	130.04	1397022.0
2017-12-04	FGBS	Futures	112.522	112.542	112.502	112.527	956913.0
2017-12-04	FGBX	Futures	172.22	172.42	171.4	171.79	141957.0
2017-12-04	FMWO	Futures	6931.6	6931.6	6905.7	6911.6	656.0
2017-12-04	FOAT	Futures	139.75	139.81	139.45	139.63	306897.0
2017-12-04	FTDX	Futures	2520.9	2520.9	2479.0	2485.0	693.0
2017-12-04	FTI	Futures	501.75	504.63	501.01	502.78	30541.0
2017-12-04	FTUK	Futures	6388.3	6395.7	6345.3	6369.2	111650.0
2017-12-04	FVSA	Futures	315.75	320.44	306.36	309.88	23732.0
2017-12-04	FXXP	Futures	328.5	330.6	328.0	329.0	37433.0
2017-12-04	G	Futures	114.48	114.73	114.28	114.44	200741.0
2017-12-04	GF	Futures	324.355	326.192	321.76	324.192	5648.0
2017-12-04	GSCI	Futures	497.71	497.77	493.33	493.74	401.0

> showing 50 of 110 rows — these rows as CSV

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