PREVIEW / futures_daily / 2017-11-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-01.parquet
  size:    10 KB
  rows:    112

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-01	ES	Futures	2798.36	2812.23	2796.46	2800.54	1290220.0
2017-11-01	NQ	Futures	7341.03	7381.85	7310.2	7330.46	346061.0
2017-11-01	YM	Futures	24640.6	24777.9	24625.8	24680.7	135446.0
2017-11-01	CL	Futures	55.11	55.68	54.34	54.76	671038.0
2017-11-01	GC	Futures	1618.3	1631.1	1614.1	1625.2	384642.0
2017-11-01	ZN	Futures	123.11624	123.378124	122.962191	123.14705	1387569.0
2017-11-01	A6	Futures	0.78753	0.79144	0.7865	0.78856	104039.0
2017-11-01	AD	Futures	0.78965	0.79178	0.78837	0.79021	67054.0
2017-11-01	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-11-01	B	Futures	43.2	43.64	42.44	42.79	337761.0
2017-11-01	B6	Futures	1.3869	1.3906	1.3822	1.3831	120570.0
2017-11-01	BR	Futures	0.22936	0.23072	0.2283	0.23015	1831.0
2017-11-01	BZ	Futures	42.83	43.25	42.06	42.41	30560.0
2017-11-01	C	Futures	1522.0	1541.0	1508.0	1537.0	15849.0
2017-11-01	CB	Futures	292.258	292.258	287.628	289.109	30.0
2017-11-01	CC	Futures	1551.0	1590.0	1549.0	1576.0	32492.0
2017-11-01	CNH	Futures	6.8322	6.8322	6.8043	6.8043	17.0
2017-11-01	CSC	Futures	3.466	3.474	3.445	3.474	76.0
2017-11-01	CT	Futures	80.67	81.1	79.99	80.07	19933.0
2017-11-01	DC	Futures	28.14	28.23	27.94	28.12	327.0
2017-11-01	DX	Futures	88.293	88.611	88.279	88.568	16623.0
2017-11-01	E1	Futures	1.22944	1.22993	1.22161	1.22198	27237.0
2017-11-01	E6	Futures	1.33227	1.33341	1.3276	1.32896	185442.0
2017-11-01	E7	Futures	1.3254	1.3264	1.3206	1.322	3202.0
2017-11-01	EBM	Futures	174.51	174.78	171.81	172.08	22039.0
2017-11-01	ED	Futures	95.4939	95.4939	95.4842	95.4891	301392.0
2017-11-01	ER	Futures	98.347	98.347	98.342	98.347	16780.0
2017-11-01	EW	Futures	1951.3	1961.9	1937.5	1944.1	14195.0
2017-11-01	FBON	Futures	126.42	126.68	126.28	126.43	528.0
2017-11-01	FBTP	Futures	112.42	112.76	112.38	112.64	86050.0
2017-11-01	FBTS	Futures	103.622	103.649	103.603	103.64	54567.0
2017-11-01	FCE	Futures	4948.5	4959.7	4937.3	4939.5	74031.0
2017-11-01	FDAX	Futures	14004.9	14174.1	13990.2	14162.6	92417.0
2017-11-01	FDIV	Futures	156.58	157.98	156.58	157.98	30.0
2017-11-01	FDXM	Futures	13881.5	14055.5	13871.1	14043.0	28943.0
2017-11-01	FESX	Futures	3009.4	3020.9	3006.2	3014.3	1011147.0
2017-11-01	FEU3	Futures	99.011	99.016	99.011	99.016	209.0
2017-11-01	FGBL	Futures	150.35	150.52	150.13	150.37	591765.0
2017-11-01	FGBM	Futures	130.06	130.13	130.02	130.08	383393.0
2017-11-01	FGBS	Futures	112.547	112.557	112.532	112.547	184967.0
2017-11-01	FGBX	Futures	169.11	169.48	168.52	169.05	42419.0
2017-11-01	FMWO	Futures	6805.3	6808.8	6787.6	6793.5	3541.0
2017-11-01	FOAT	Futures	138.02	138.18	137.84	138.04	92494.0
2017-11-01	FTDX	Futures	2564.8	2581.3	2561.8	2570.8	382.0
2017-11-01	FTI	Futures	512.56	514.97	511.87	512.24	23758.0
2017-11-01	FTUK	Futures	6482.0	6511.1	6452.9	6473.3	122026.0
2017-11-01	FVSA	Futures	332.53	335.09	324.86	328.69	20653.0
2017-11-01	FXXP	Futures	336.7	337.6	335.9	336.5	43835.0
2017-11-01	G	Futures	113.73	113.84	113.35	113.66	189320.0
2017-11-01	GF	Futures	344.236	345.853	341.973	344.183	2982.0

> showing 50 of 112 rows — these rows as CSV

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