PREVIEW / futures_daily / 2017-01-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-18.parquet
  size:    10 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-01-18	ES	Futures	2452.23	2459.28	2448.17	2457.11	1111992.0
2017-01-18	NQ	Futures	5940.77	5960.52	5933.11	5957.27	159690.0
2017-01-18	YM	Futures	20798.4	20845.8	20717.3	20786.8	121032.0
2017-01-18	CL	Futures	57.07	57.37	55.35	55.53	559512.0
2017-01-18	GC	Futures	1562.6	1563.8	1543.4	1556.6	203645.0
2017-01-18	ZN	Futures	122.485491	122.531337	121.583851	121.981183	1290896.0
2017-01-18	A6	Futures	0.7732	0.77382	0.76737	0.77085	83675.0
2017-01-18	AD	Futures	0.78353	0.78378	0.76994	0.77214	120325.0
2017-01-18	ALI	Futures	2499.53	2513.01	2475.46	2513.01	36.0
2017-01-18	B	Futures	41.33	41.65	40.06	40.17	360148.0
2017-01-18	B6	Futures	1.3027	1.3033	1.2869	1.2903	129125.0
2017-01-18	BFX	Futures	4345.1	4345.7	4328.7	4345.7	26.0
2017-01-18	BR	Futures	0.21867	0.21892	0.2181	0.21839	102.0
2017-01-18	BZ	Futures	41.02	41.33	39.77	39.87	40148.0
2017-01-18	C	Futures	1867.0	1887.0	1851.0	1865.0	10133.0
2017-01-18	CB	Futures	276.491	281.618	276.461	276.491	22.0
2017-01-18	CC	Futures	1705.0	1719.0	1682.0	1700.0	18738.0
2017-01-18	CNH	Futures	7.2419	7.2847	7.2419	7.2847	19.0
2017-01-18	CSC	Futures	4.015	4.041	4.002	4.015	126.0
2017-01-18	CT	Futures	82.85	83.34	82.73	83.01	12254.0
2017-01-18	DC	Futures	33.36	33.51	32.98	33.07	268.0
2017-01-18	DX	Futures	93.416	94.352	93.402	93.964	39873.0
2017-01-18	E1	Futures	1.24111	1.24186	1.23355	1.23789	18565.0
2017-01-18	E6	Futures	1.24009	1.2402	1.23044	1.23495	166779.0
2017-01-18	E7	Futures	1.2335	1.2337	1.2239	1.2286	3001.0
2017-01-18	EBM	Futures	193.99	194.84	193.13	193.42	11686.0
2017-01-18	ED	Futures	95.5713	95.5762	95.5423	95.5617	284227.0
2017-01-18	ER	Futures	98.313	98.318	98.308	98.308	66174.0
2017-01-18	EW	Futures	1777.4	1787.3	1773.6	1786.3	15461.0
2017-01-18	FBON	Futures	122.73	122.87	122.29	122.41	634.0
2017-01-18	FBTP	Futures	106.38	106.51	105.93	106.12	123357.0
2017-01-18	FBTS	Futures	101.864	101.873	101.837	101.855	30703.0
2017-01-18	FCE	Futures	4295.9	4297.7	4249.2	4273.9	191859.0
2017-01-18	FDAX	Futures	12230.9	12272.1	12170.2	12237.3	62497.0
2017-01-18	FDXM	Futures	12178.0	12216.9	12120.2	12188.0	18031.0
2017-01-18	FESX	Futures	2631.1	2635.9	2611.9	2628.7	757567.0
2017-01-18	FGBL	Futures	147.73	147.74	147.04	147.38	784777.0
2017-01-18	FGBM	Futures	129.1	129.1	128.84	128.96	579319.0
2017-01-18	FGBS	Futures	112.152	112.157	112.117	112.132	222395.0
2017-01-18	FGBX	Futures	168.15	168.27	166.39	167.32	41343.0
2017-01-18	FMWO	Futures	5969.6	5969.6	5952.8	5963.6	783.0
2017-01-18	FOAT	Futures	132.97	133.03	132.51	132.71	119376.0
2017-01-18	FTDX	Futures	1804.3	1808.7	1797.5	1803.8	50.0
2017-01-18	FTI	Futures	440.28	442.2	438.09	440.69	25822.0
2017-01-18	FTUK	Futures	6063.1	6098.7	6061.4	6088.5	101819.0
2017-01-18	FVSA	Futures	866.84	873.95	843.16	845.53	9641.0
2017-01-18	FXXP	Futures	300.3	300.3	298.2	299.8	34579.0
2017-01-18	G	Futures	111.85	111.85	111.53	111.69	151935.0
2017-01-18	GF	Futures	295.91	297.05	293.63	295.34	4281.0
2017-01-18	GSCI	Futures	523.87	524.59	520.77	520.77	92.0

> showing 50 of 109 rows — these rows as CSV

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