PREVIEW / futures_daily / 2016-11-04

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-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
2016-11-04	ES	Futures	2254.05	2265.13	2248.37	2249.72	2079129.0
2016-11-04	NQ	Futures	5505.29	5533.87	5481.72	5489.38	264048.0
2016-11-04	YM	Futures	18737.0	18796.9	18689.8	18696.1	196117.0
2016-11-04	CL	Futures	48.7	48.96	47.54	48.09	736685.0
2016-11-04	GC	Futures	1672.0	1678.6	1662.4	1673.7	217452.0
2016-11-04	ZN	Futures	126.481275	126.830881	126.405274	126.709279	1336051.0
2016-11-04	A6	Futures	0.78285	0.78469	0.77999	0.78244	81376.0
2016-11-04	AD	Futures	0.76475	0.76536	0.7608	0.76413	88244.0
2016-11-04	ALI	Futures	2313.41	2317.89	2308.92	2308.92	15.0
2016-11-04	B	Futures	35.27	35.37	34.24	34.62	384560.0
2016-11-04	B6	Futures	1.3135	1.3229	1.3116	1.3176	119868.0
2016-11-04	BFX	Futures	4072.3	4082.4	4072.3	4082.4	1.0
2016-11-04	BR	Futures	0.20698	0.21126	0.20691	0.21126	1534.0
2016-11-04	BZ	Futures	35.06	35.18	34.08	34.46	54210.0
2016-11-04	C	Futures	2331.0	2333.0	2219.0	2243.0	13157.0
2016-11-04	CB	Futures	236.208	238.068	236.208	238.068	32.0
2016-11-04	CC	Futures	2001.0	2016.0	1923.0	1928.0	28299.0
2016-11-04	CNH	Futures	7.2871	7.2883	7.2848	7.2875	16.0
2016-11-04	CSC	Futures	3.96	4.002	3.96	3.983	87.0
2016-11-04	CT	Futures	76.18	77.35	75.84	76.77	14221.0
2016-11-04	DC	Futures	31.29	31.54	31.25	31.46	414.0
2016-11-04	DX	Futures	90.489	90.634	90.224	90.362	18869.0
2016-11-04	E1	Futures	1.28157	1.29004	1.27957	1.28705	25809.0
2016-11-04	E6	Futures	1.28947	1.29405	1.28657	1.29115	154498.0
2016-11-04	E7	Futures	1.2826	1.2869	1.2798	1.2841	2356.0
2016-11-04	EBM	Futures	190.64	191.53	190.35	190.35	10060.0
2016-11-04	ED	Futures	95.649	95.6538	95.6345	95.649	607324.0
2016-11-04	ER	Futures	98.264	98.269	98.264	98.264	40897.0
2016-11-04	EW	Futures	1567.3	1584.5	1564.4	1569.9	19736.0
2016-11-04	FBON	Futures	123.1	123.37	123.01	123.07	166.0
2016-11-04	FBTP	Futures	106.35	106.42	105.89	106.01	115400.0
2016-11-04	FBTS	Futures	101.005	101.032	100.97	100.987	22561.0
2016-11-04	FCE	Futures	3923.9	3928.8	3869.2	3895.4	111939.0
2016-11-04	FDAX	Futures	10900.3	10905.6	10775.1	10840.1	111862.0
2016-11-04	FDXM	Futures	10876.8	10882.1	10752.4	10816.7	26919.0
2016-11-04	FESX	Futures	2374.9	2376.5	2345.3	2362.1	1192036.0
2016-11-04	FEU3	Futures	98.942	98.947	98.942	98.947	9.0
2016-11-04	FGBL	Futures	148.0	148.48	148.0	148.37	596884.0
2016-11-04	FGBM	Futures	128.31	128.5	128.31	128.45	435231.0
2016-11-04	FGBS	Futures	111.837	111.867	111.832	111.852	210277.0
2016-11-04	FGBX	Futures	176.87	179.05	176.87	178.64	49632.0
2016-11-04	FMWO	Futures	5545.3	5563.4	5535.6	5563.4	1901.0
2016-11-04	FOAT	Futures	135.37	135.8	135.37	135.6	115319.0
2016-11-04	FTDX	Futures	1659.2	1660.7	1650.4	1656.3	115.0
2016-11-04	FTI	Futures	405.39	405.39	400.98	403.83	36266.0
2016-11-04	FTUK	Futures	5689.5	5696.7	5595.0	5627.1	131110.0
2016-11-04	FVSA	Futures	1499.54	1515.0	1443.89	1456.25	23530.0
2016-11-04	FXXP	Futures	272.3	272.4	268.6	270.7	33197.0
2016-11-04	G	Futures	112.24	112.98	112.08	112.72	157604.0
2016-11-04	GF	Futures	270.426	270.479	265.647	269.781	1739.0

> showing 50 of 110 rows — these rows as CSV

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