PREVIEW / futures_daily / 2017-03-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-06.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
2017-03-06	ES	Futures	2580.43	2580.97	2566.06	2575.28	1376883.0
2017-03-06	NQ	Futures	6327.95	6334.43	6292.59	6318.52	166727.0
2017-03-06	YM	Futures	22092.9	22098.2	22007.6	22074.0	117681.0
2017-03-06	CL	Futures	56.44	56.83	55.98	56.45	503692.0
2017-03-06	GC	Futures	1576.3	1580.6	1564.9	1565.6	156981.0
2017-03-06	ZN	Futures	121.415748	121.706107	121.385184	121.461594	13581.0
2017-03-06	A6	Futures	0.77689	0.77914	0.77505	0.77648	75057.0
2017-03-06	AD	Futures	0.76356	0.76381	0.76085	0.76152	53976.0
2017-03-06	ALI	Futures	2515.27	2516.87	2513.03	2516.87	31.0
2017-03-06	B	Futures	40.75	41.08	40.4	40.9	224195.0
2017-03-06	B6	Futures	1.2897	1.2905	1.2823	1.284	118655.0
2017-03-06	BR	Futures	0.2289	0.2289	0.22741	0.22741	1.0
2017-03-06	BZ	Futures	40.56	40.88	40.21	40.71	25402.0
2017-03-06	C	Futures	1659.0	1659.0	1629.0	1635.0	6314.0
2017-03-06	CB	Futures	272.189	272.189	269.137	269.259	41.0
2017-03-06	CC	Futures	1500.0	1506.0	1476.0	1477.0	15260.0
2017-03-06	CNH	Futures	7.281	7.288	7.2778	7.2873	6.0
2017-03-06	CSC	Futures	3.703	3.706	3.683	3.683	118.0
2017-03-06	CT	Futures	87.11	88.57	86.94	88.18	16701.0
2017-03-06	DC	Futures	30.43	30.43	30.07	30.16	147.0
2017-03-06	DX	Futures	94.45	94.729	94.249	94.64	38657.0
2017-03-06	E1	Futures	1.22996	1.23083	1.22401	1.2255	19167.0
2017-03-06	E6	Futures	1.22605	1.22929	1.22172	1.22317	207698.0
2017-03-06	E7	Futures	1.2196	1.2231	1.2155	1.2169	3885.0
2017-03-06	EBM	Futures	198.26	198.54	196.3	196.86	16941.0
2017-03-06	ED	Futures	95.494	95.5109	95.4868	95.5085	276440.0
2017-03-06	ER	Futures	98.303	98.308	98.303	98.303	40440.0
2017-03-06	EW	Futures	1847.3	1847.4	1832.3	1839.3	12697.0
2017-03-06	FBON	Futures	121.06	121.16	120.83	120.95	1299.0
2017-03-06	FBTP	Futures	104.92	105.1	104.37	104.54	207434.0
2017-03-06	FBTS	Futures	101.864	101.891	101.8	101.818	71223.0
2017-03-06	FCE	Futures	4390.5	4394.4	4364.1	4374.6	71806.0
2017-03-06	FDAX	Futures	12660.6	12668.5	12579.8	12624.7	67803.0
2017-03-06	FDXM	Futures	12611.1	12616.4	12530.2	12573.8	20953.0
2017-03-06	FESX	Futures	2716.7	2719.1	2702.3	2710.3	819331.0
2017-03-06	FEU3	Futures	98.971	98.976	98.971	98.976	78.0
2017-03-06	FGBL	Futures	147.88	148.23	147.79	147.86	1067346.0
2017-03-06	FGBM	Futures	129.37	129.48	129.33	129.41	847517.0
2017-03-06	FGBS	Futures	112.337	112.412	112.337	112.382	645803.0
2017-03-06	FGBX	Futures	166.51	167.79	166.07	166.37	96048.0
2017-03-06	FMWO	Futures	6172.3	6179.5	6161.4	6167.5	193.0
2017-03-06	FOAT	Futures	131.67	131.89	131.11	131.41	259538.0
2017-03-06	FTDX	Futures	1882.3	1894.0	1863.6	1890.6	119.0
2017-03-06	FTI	Futures	458.75	459.2	455.57	457.61	21056.0
2017-03-06	FTUK	Futures	6221.6	6235.6	6211.0	6221.6	71396.0
2017-03-06	FVSA	Futures	690.54	692.64	677.99	684.27	13675.0
2017-03-06	FXXP	Futures	310.5	310.5	308.7	309.6	26556.0
2017-03-06	G	Futures	114.71	114.91	114.05	114.16	208839.0
2017-03-06	GF	Futures	284.397	285.138	282.231	282.858	1263.0
2017-03-06	GSCI	Futures	512.52	516.06	512.27	513.42	786.0

> showing 50 of 109 rows — these rows as CSV

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