PREVIEW / futures_daily / 2017-02-01

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-01.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-02-01	ES	Futures	2468.5	2477.17	2459.01	2465.78	1565006.0
2017-02-01	NQ	Futures	6048.62	6079.56	6038.01	6068.06	237364.0
2017-02-01	YM	Futures	20870.0	20956.4	20827.9	20872.1	133901.0
2017-02-01	CL	Futures	56.46	57.69	56.33	57.66	577243.0
2017-02-01	GC	Futures	1548.6	1552.1	1532.6	1543.6	217088.0
2017-02-01	ZN	Futures	121.721389	121.736671	121.186518	121.599133	1496441.0
2017-02-01	A6	Futures	0.77556	0.7773	0.77259	0.77648	76514.0
2017-02-01	AD	Futures	0.78353	0.78409	0.77985	0.78327	58924.0
2017-02-01	ALI	Futures	2454.6	2465.52	2454.6	2465.52	20.0
2017-02-01	B	Futures	40.96	41.91	40.82	41.89	301235.0
2017-02-01	B6	Futures	1.3207	1.3311	1.3166	1.3306	103516.0
2017-02-01	BFX	Futures	4320.8	4335.4	4320.8	4335.4	3.0
2017-02-01	BR	Futures	0.22472	0.22589	0.22336	0.22425	613.0
2017-02-01	BZ	Futures	40.76	41.69	40.62	41.67	34772.0
2017-02-01	C	Futures	1742.0	1771.0	1738.0	1748.0	8059.0
2017-02-01	CB	Futures	277.071	277.071	276.766	276.766	7.0
2017-02-01	CC	Futures	1597.0	1637.0	1595.0	1606.0	21728.0
2017-02-01	CNH	Futures	7.2622	7.2628	7.2478	7.2478	33.0
2017-02-01	CSC	Futures	3.949	3.976	3.93	3.965	60.0
2017-02-01	CT	Futures	86.16	87.95	86.05	87.81	24671.0
2017-02-01	DC	Futures	32.65	32.9	32.48	32.82	231.0
2017-02-01	DX	Futures	92.718	93.165	92.625	92.744	42195.0
2017-02-01	E1	Futures	1.25562	1.25661	1.24706	1.25214	24337.0
2017-02-01	E6	Futures	1.24904	1.25025	1.2413	1.24667	213569.0
2017-02-01	E7	Futures	1.2427	1.2437	1.2351	1.2403	4141.0
2017-02-01	EBM	Futures	188.86	193.42	188.29	192.56	34674.0
2017-02-01	ED	Futures	95.5617	95.5762	95.5375	95.5665	337233.0
2017-02-01	ER	Futures	98.303	98.308	98.298	98.303	78639.0
2017-02-01	EW	Futures	1795.8	1811.3	1782.9	1790.0	21520.0
2017-02-01	FBON	Futures	120.55	120.61	119.91	120.0	1272.0
2017-02-01	FBTP	Futures	103.57	103.61	103.03	103.17	116110.0
2017-02-01	FBTS	Futures	101.485	101.485	101.403	101.421	36117.0
2017-02-01	FCE	Futures	4214.9	4248.8	4207.0	4222.4	92526.0
2017-02-01	FDAX	Futures	12287.4	12377.1	12257.3	12296.9	83366.0
2017-02-01	FDXM	Futures	12233.7	12327.3	12208.5	12247.4	25880.0
2017-02-01	FESX	Futures	2603.9	2614.3	2597.5	2599.1	957953.0
2017-02-01	FGBL	Futures	146.01	146.12	145.66	145.75	737846.0
2017-02-01	FGBM	Futures	128.47	128.54	128.38	128.46	532602.0
2017-02-01	FGBS	Futures	112.082	112.132	112.072	112.107	226992.0
2017-02-01	FGBX	Futures	164.65	164.93	163.07	163.35	48430.0
2017-02-01	FMWO	Futures	5998.6	6016.7	5988.9	5988.9	687.0
2017-02-01	FOAT	Futures	130.26	130.26	129.51	129.8	177541.0
2017-02-01	FTDX	Futures	1809.2	1821.5	1809.2	1813.1	181.0
2017-02-01	FTI	Futures	436.77	438.77	435.58	436.17	29956.0
2017-02-01	FTUK	Futures	5991.0	6024.9	5963.9	5967.3	98069.0
2017-02-01	FVSA	Futures	836.05	855.0	821.84	843.16	22514.0
2017-02-01	FXXP	Futures	300.0	301.5	299.0	300.0	26415.0
2017-02-01	G	Futures	110.42	110.57	110.19	110.31	198356.0
2017-02-01	GF	Futures	278.356	281.946	276.019	278.299	7195.0
2017-02-01	GSCI	Futures	525.38	529.34	524.26	529.01	350.0

> showing 50 of 109 rows — these rows as CSV

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