PREVIEW / futures_daily / 2016-11-18

all futures daily files

  file:    by_date/futures_daily/2016/2016-11-18.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-18	ES	Futures	2362.21	2365.99	2354.09	2358.69	1280719.0
2016-11-18	NQ	Futures	5690.92	5704.76	5660.57	5667.05	168797.0
2016-11-18	YM	Futures	19814.4	19834.3	19765.0	19796.5	113076.0
2016-11-18	CL	Futures	49.11	50.12	48.75	50.02	660408.0
2016-11-18	GC	Futures	1560.1	1562.1	1541.3	1550.8	257109.0
2016-11-18	ZN	Futures	122.422809	122.726814	121.906	122.149204	1914268.0
2016-11-18	A6	Futures	0.75499	0.75612	0.74744	0.74867	105201.0
2016-11-18	AD	Futures	0.75778	0.75932	0.75527	0.75855	69064.0
2016-11-18	ALI	Futures	2336.41	2345.39	2330.32	2330.32	20.0
2016-11-18	B	Futures	34.98	35.69	34.75	35.59	249336.0
2016-11-18	B6	Futures	1.3072	1.31	1.2958	1.3023	134701.0
2016-11-18	BFX	Futures	4096.7	4099.1	4081.2	4081.2	4.0
2016-11-18	BR	Futures	0.19965	0.20232	0.19869	0.20136	1700.0
2016-11-18	BZ	Futures	34.84	35.52	34.59	35.42	39532.0
2016-11-18	C	Futures	2162.0	2195.0	2158.0	2194.0	5541.0
2016-11-18	CB	Futures	251.026	252.328	250.933	252.08	22.0
2016-11-18	CC	Futures	1842.0	1857.0	1831.0	1846.0	14861.0
2016-11-18	CNH	Futures	7.4355	7.4439	7.4143	7.4293	47.0
2016-11-18	CSC	Futures	4.029	4.089	4.029	4.066	101.0
2016-11-18	CT	Futures	82.34	82.48	81.41	82.23	5743.0
2016-11-18	DC	Futures	31.96	32.54	31.96	32.4	735.0
2016-11-18	DX	Futures	94.068	94.505	93.9	94.266	57293.0
2016-11-18	E1	Futures	1.23883	1.2402	1.2326	1.23572	25696.0
2016-11-18	E6	Futures	1.23307	1.23505	1.22647	1.23006	246421.0
2016-11-18	E7	Futures	1.2266	1.2283	1.2199	1.2234	4965.0
2016-11-18	EBM	Futures	194.17	197.41	193.88	197.12	31567.0
2016-11-18	ED	Futures	95.6007	95.6055	95.5935	95.6007	295733.0
2016-11-18	ER	Futures	98.274	98.279	98.269	98.274	50775.0
2016-11-18	EW	Futures	1705.9	1710.2	1700.3	1707.2	11896.0
2016-11-18	FBON	Futures	119.5	120.35	119.37	120.09	271.0
2016-11-18	FBTP	Futures	102.52	103.62	102.14	102.99	122676.0
2016-11-18	FBTS	Futures	100.664	100.781	100.601	100.709	32864.0
2016-11-18	FCE	Futures	4006.7	4014.2	3964.7	3972.2	102773.0
2016-11-18	FDAX	Futures	11341.0	11357.4	11248.5	11279.7	88128.0
2016-11-18	FDXM	Futures	11314.4	11334.4	11225.8	11255.3	23562.0
2016-11-18	FESX	Futures	2443.0	2447.8	2412.6	2420.6	1040710.0
2016-11-18	FEU3	Futures	98.956	98.956	98.956	98.956	6.0
2016-11-18	FGBL	Futures	146.23	147.08	146.07	146.75	889644.0
2016-11-18	FGBM	Futures	127.92	128.21	127.85	128.13	607712.0
2016-11-18	FGBS	Futures	111.867	111.972	111.862	111.942	454831.0
2016-11-18	FGBX	Futures	171.51	174.44	171.26	173.22	55953.0
2016-11-18	FMWO	Futures	5684.4	5695.3	5668.7	5675.9	904.0
2016-11-18	FOAT	Futures	132.0	133.0	131.6	132.36	156857.0
2016-11-18	FTDX	Futures	1695.5	1699.9	1690.6	1699.4	129.0
2016-11-18	FTI	Futures	412.64	413.65	409.04	410.68	34892.0
2016-11-18	FTUK	Futures	5739.8	5743.6	5681.9	5718.2	101414.0
2016-11-18	FVSA	Futures	1338.46	1363.6	1325.9	1338.46	18880.0
2016-11-18	FXXP	Futures	282.0	282.2	279.4	280.1	19733.0
2016-11-18	G	Futures	109.86	110.48	109.63	109.95	173421.0
2016-11-18	GF	Futures	277.958	280.467	276.563	278.794	3520.0

> showing 50 of 110 rows — these rows as CSV

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