PREVIEW / futures_daily / 2017-11-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-14.parquet
  size:    9 KB
  rows:    108

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-11-14	ES	Futures	2806.52	2808.7	2789.12	2804.08	1582882.0
2017-11-14	NQ	Futures	7412.68	7421.49	7356.3	7392.42	342800.0
2017-11-14	YM	Futures	24708.2	24735.6	24531.8	24683.9	143451.0
2017-11-14	CL	Futures	57.02	57.04	55.05	55.95	350787.0
2017-11-14	GC	Futures	1627.3	1633.5	1615.6	1632.4	355197.0
2017-11-14	ZN	Futures	122.854356	123.070025	122.746522	122.977596	1232433.0
2017-11-14	A6	Futures	0.78321	0.78681	0.7829	0.78516	103535.0
2017-11-14	AD	Futures	0.79911	0.8014	0.79687	0.79952	76041.0
2017-11-14	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-14	B	Futures	44.6	44.68	43.29	44.0	418939.0
2017-11-14	B6	Futures	1.3683	1.3761	1.3644	1.3737	120982.0
2017-11-14	BR	Futures	0.22879	0.23041	0.22698	0.22808	4144.0
2017-11-14	BZ	Futures	44.28	44.31	42.91	43.61	46259.0
2017-11-14	C	Futures	1603.0	1604.0	1569.0	1571.0	11733.0
2017-11-14	CB	Futures	285.959	290.305	285.959	289.549	37.0
2017-11-14	CC	Futures	1638.0	1644.0	1606.0	1608.0	29340.0
2017-11-14	CNH	Futures	6.8357	6.8377	6.824	6.824	123.0
2017-11-14	CSC	Futures	3.42	3.445	3.408	3.437	23.0
2017-11-14	CT	Futures	80.93	81.5	80.55	80.58	19455.0
2017-11-14	DC	Futures	27.7	27.91	27.59	27.89	224.0
2017-11-14	DX	Futures	88.284	88.316	87.568	87.646	27436.0
2017-11-14	E1	Futures	1.22968	1.23995	1.22882	1.23812	24861.0
2017-11-14	E6	Futures	1.33336	1.34939	1.33302	1.34813	291584.0
2017-11-14	E7	Futures	1.3264	1.3423	1.3262	1.3411	5530.0
2017-11-14	EBM	Futures	172.08	172.62	171.81	172.35	27218.0
2017-11-14	ED	Futures	95.4721	95.477	95.4697	95.4721	229786.0
2017-11-14	ER	Futures	98.347	98.347	98.342	98.347	15285.0
2017-11-14	EW	Futures	1941.7	1943.3	1935.4	1941.5	12883.0
2017-11-14	FBON	Futures	125.65	126.14	125.65	125.84	596.0
2017-11-14	FBTP	Futures	112.2	112.64	112.18	112.47	105909.0
2017-11-14	FBTS	Futures	103.686	103.713	103.668	103.695	50657.0
2017-11-14	FCE	Futures	4786.3	4804.2	4745.5	4758.9	130353.0
2017-11-14	FDAX	Futures	13742.7	13806.3	13659.6	13698.0	93537.0
2017-11-14	FDXM	Futures	13632.4	13689.7	13544.9	13582.4	29130.0
2017-11-14	FESX	Futures	2913.2	2925.4	2888.7	2897.7	954611.0
2017-11-14	FGBL	Futures	149.81	150.22	149.71	150.15	634536.0
2017-11-14	FGBM	Futures	129.95	130.05	129.91	130.01	367899.0
2017-11-14	FGBS	Futures	112.527	112.542	112.522	112.537	252145.0
2017-11-14	FGBX	Futures	166.89	167.95	166.52	167.77	45623.0
2017-11-14	FMWO	Futures	6754.5	6754.5	6745.1	6753.3	533.0
2017-11-14	FOAT	Futures	137.88	138.29	137.8	138.23	93344.0
2017-11-14	FTDX	Futures	2485.5	2499.5	2485.5	2487.0	154.0
2017-11-14	FTI	Futures	505.84	506.4	500.32	501.85	39379.0
2017-11-14	FTUK	Futures	6429.1	6438.2	6400.4	6415.6	80091.0
2017-11-14	FVSA	Futures	352.14	361.53	343.92	356.83	30234.0
2017-11-14	FXXP	Futures	327.8	328.5	325.0	325.6	39130.0
2017-11-14	G	Futures	113.85	114.15	113.73	114.05	145300.0
2017-11-14	GF	Futures	338.678	339.164	332.03	332.732	6940.0
2017-11-14	GSCI	Futures	497.48	497.59	490.94	492.52	750.0
2017-11-14	HE	Futures	92.137	92.137	88.446	88.557	25610.0

> showing 50 of 108 rows — these rows as CSV

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