PREVIEW / futures_daily / 2016-12-21

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-21.parquet
  size:    9 KB
  rows:    109

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-12-21	ES	Futures	2457.93	2458.74	2447.9	2450.61	667705.0
2016-12-21	NQ	Futures	5841.18	5845.9	5821.44	5833.52	90653.0
2016-12-21	YM	Futures	20977.5	20992.2	20931.1	20951.1	64397.0
2016-12-21	CL	Futures	57.32	57.56	55.99	56.17	471993.0
2016-12-21	GC	Futures	1456.3	1462.4	1452.4	1455.3	114055.0
2016-12-21	ZN	Futures	120.514108	120.666929	120.315442	120.590519	510265.0
2016-12-21	A6	Futures	0.74227	0.74391	0.7393	0.74053	54222.0
2016-12-21	AD	Futures	0.76499	0.7655	0.76146	0.76269	41745.0
2016-12-21	ALI	Futures	2355.87	2355.87	2355.87	2355.87	0.0
2016-12-21	B	Futures	41.36	41.62	40.47	40.57	277727.0
2016-12-21	B6	Futures	1.3006	1.3028	1.2958	1.2984	62417.0
2016-12-21	BFX	Futures	4300.1	4307.9	4294.7	4307.9	6.0
2016-12-21	BR	Futures	0.20854	0.21064	0.20854	0.20975	3.0
2016-12-21	BZ	Futures	41.12	41.31	40.17	40.27	31242.0
2016-12-21	C	Futures	1917.0	1930.0	1906.0	1920.0	7736.0
2016-12-21	CB	Futures	276.461	276.766	276.43	276.43	6.0
2016-12-21	CC	Futures	1717.0	1741.0	1714.0	1735.0	9814.0
2016-12-21	CNH	Futures	7.4518	7.4518	7.4192	7.4192	35.0
2016-12-21	CSC	Futures	4.082	4.082	4.013	4.025	66.0
2016-12-21	CT	Futures	79.65	81.47	79.65	80.56	21474.0
2016-12-21	DC	Futures	33.49	33.49	32.75	32.92	397.0
2016-12-21	DX	Futures	96.167	96.251	95.669	95.929	21098.0
2016-12-21	E1	Futures	1.21198	1.21855	1.21062	1.21446	38845.0
2016-12-21	E6	Futures	1.20555	1.21242	1.20451	1.20954	119956.0
2016-12-21	E7	Futures	1.1995	1.2061	1.1983	1.2034	3061.0
2016-12-21	EBM	Futures	190.85	191.42	190.57	191.42	8070.0
2016-12-21	ED	Futures	95.5713	95.581	95.5713	95.5762	137103.0
2016-12-21	ER	Futures	98.279	98.283	98.279	98.283	34643.0
2016-12-21	EW	Futures	1794.1	1797.0	1785.1	1787.6	9349.0
2016-12-21	FBON	Futures	123.19	123.27	122.66	122.92	223.0
2016-12-21	FBTP	Futures	106.91	107.12	106.65	106.97	51570.0
2016-12-21	FBTS	Futures	101.828	101.909	101.828	101.873	26579.0
2016-12-21	FCE	Futures	4252.8	4267.3	4241.0	4252.4	59286.0
2016-12-21	FDAX	Futures	12083.7	12121.7	12080.5	12108.0	44979.0
2016-12-21	FDXM	Futures	12038.1	12073.9	12031.8	12059.2	10517.0
2016-12-21	FESX	Futures	2609.5	2615.1	2601.5	2607.9	541783.0
2016-12-21	FEU3	Futures	98.947	98.952	98.947	98.952	180.0
2016-12-21	FGBL	Futures	147.12	147.33	147.01	147.25	337082.0
2016-12-21	FGBM	Futures	128.88	128.94	128.84	128.9	248110.0
2016-12-21	FGBS	Futures	112.162	112.182	112.142	112.152	119982.0
2016-12-21	FGBX	Futures	170.35	171.45	169.95	171.2	19432.0
2016-12-21	FMWO	Futures	5894.9	5894.9	5885.2	5888.8	859.0
2016-12-21	FOAT	Futures	133.56	133.88	133.45	133.69	57349.0
2016-12-21	FTDX	Futures	1754.3	1759.2	1748.4	1750.9	76.0
2016-12-21	FTI	Futures	440.15	440.56	438.19	439.6	17230.0
2016-12-21	FTUK	Futures	5911.7	5930.8	5903.7	5913.4	58637.0
2016-12-21	FVSA	Futures	1055.09	1063.32	1033.17	1046.87	14586.0
2016-12-21	FXXP	Futures	297.6	298.2	297.1	297.6	19395.0
2016-12-21	G	Futures	110.77	110.95	110.5	110.9	105826.0
2016-12-21	GF	Futures	289.614	291.956	287.55	290.506	4086.0

> showing 50 of 109 rows — these rows as CSV

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