PREVIEW / futures_daily / 2017-01-03

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-03.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-01-03	ES	Futures	2429.2	2449.52	2427.84	2441.93	1810351.0
2017-01-03	NQ	Futures	5747.78	5807.59	5747.78	5782.55	215983.0
2017-01-03	YM	Futures	20810.0	20938.5	20753.1	20853.2	151885.0
2017-01-03	CL	Futures	58.0	59.11	55.77	56.0	727793.0
2017-01-03	GC	Futures	1478.6	1497.4	1472.3	1492.2	229177.0
2017-01-03	ZN	Futures	121.400466	121.50744	120.865595	121.385184	1442195.0
2017-01-03	A6	Futures	0.73593	0.74033	0.73531	0.73818	88958.0
2017-01-03	AD	Futures	0.76014	0.76295	0.75942	0.76121	49355.0
2017-01-03	ALI	Futures	2308.06	2308.06	2308.06	2308.06	0.0
2017-01-03	B	Futures	42.5	43.49	41.2	41.33	340817.0
2017-01-03	B6	Futures	1.2901	1.2928	1.2815	1.2854	122364.0
2017-01-03	BR	Futures	0.2144	0.2154	0.21312	0.21526	1105.0
2017-01-03	BZ	Futures	42.19	43.16	40.89	41.02	42688.0
2017-01-03	C	Futures	1800.0	1830.0	1789.0	1822.0	10290.0
2017-01-03	CB	Futures	273.409	273.409	271.609	271.609	45.0
2017-01-03	CC	Futures	1625.0	1659.0	1613.0	1649.0	17013.0
2017-01-03	CNH	Futures	7.5037	7.5221	7.4712	7.4712	32.0
2017-01-03	CSC	Futures	4.018	4.052	3.995	4.006	83.0
2017-01-03	CT	Futures	81.78	82.54	81.72	82.46	12356.0
2017-01-03	DC	Futures	33.03	33.15	32.79	32.86	326.0
2017-01-03	DX	Futures	95.73	96.661	95.553	96.089	51701.0
2017-01-03	E1	Futures	1.21632	1.2188	1.20393	1.21161	30219.0
2017-01-03	E6	Futures	1.21289	1.2156	1.19822	1.20653	242830.0
2017-01-03	E7	Futures	1.2064	1.2092	1.1921	1.2004	5281.0
2017-01-03	EBM	Futures	191.99	193.13	191.14	192.85	19643.0
2017-01-03	ED	Futures	95.5955	95.5955	95.5762	95.5858	203037.0
2017-01-03	ER	Futures	98.288	98.298	98.288	98.293	48384.0
2017-01-03	EW	Futures	1770.1	1789.1	1764.9	1775.8	19936.0
2017-01-03	FBON	Futures	123.27	123.27	122.16	122.29	189.0
2017-01-03	FBTP	Futures	107.73	107.86	106.5	106.61	105957.0
2017-01-03	FBTS	Futures	101.99	101.999	101.891	101.909	22002.0
2017-01-03	FCE	Futures	4300.3	4335.1	4298.6	4307.8	90432.0
2017-01-03	FDAX	Futures	12255.7	12297.4	12193.5	12223.0	80111.0
2017-01-03	FDXM	Futures	12212.7	12248.4	12145.4	12173.8	21189.0
2017-01-03	FESX	Futures	2642.3	2660.7	2637.5	2644.7	915138.0
2017-01-03	FEU3	Futures	98.961	98.961	98.961	98.961	3.0
2017-01-03	FGBL	Futures	148.25	148.37	146.99	147.19	833008.0
2017-01-03	FGBM	Futures	129.26	129.31	129.0	129.06	504290.0
2017-01-03	FGBS	Futures	112.147	112.187	112.137	112.167	224697.0
2017-01-03	FGBX	Futures	171.71	172.13	168.11	168.88	59527.0
2017-01-03	FMWO	Futures	5888.8	5888.8	5871.9	5873.1	94.0
2017-01-03	FOAT	Futures	134.13	134.2	132.66	132.79	134401.0
2017-01-03	FTDX	Futures	1818.5	1820.0	1799.9	1801.9	164.0
2017-01-03	FTI	Futures	442.65	445.56	442.65	443.79	31748.0
2017-01-03	FTUK	Futures	5994.4	6057.6	5990.2	6030.0	120168.0
2017-01-03	FVSA	Futures	1041.39	1060.58	1003.03	1044.13	13729.0
2017-01-03	FXXP	Futures	300.2	303.4	300.2	302.0	24074.0
2017-01-03	G	Futures	112.47	112.5	111.13	111.5	190469.0
2017-01-03	GF	Futures	292.514	293.685	289.502	290.45	1748.0
2017-01-03	GSCI	Futures	528.4	533.63	517.07	517.07	433.0

> showing 50 of 109 rows — these rows as CSV

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