PREVIEW / futures_daily / 2017-03-29

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-29.parquet
  size:    9 KB
  rows:    110

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-03-29	ES	Futures	2555.46	2562.79	2550.84	2559.8	1154538.0
2017-03-29	NQ	Futures	6370.66	6404.23	6365.66	6402.46	173940.0
2017-03-29	YM	Futures	21773.4	21802.9	21697.4	21737.5	103586.0
2017-03-29	CL	Futures	50.8	52.02	50.71	51.89	548615.0
2017-03-29	GC	Futures	1602.4	1608.1	1598.5	1607.2	166685.0
2017-03-29	ZN	Futures	122.199765	122.568484	122.122948	122.491668	1207851.0
2017-03-29	A6	Futures	0.78276	0.78676	0.78225	0.78625	65563.0
2017-03-29	AD	Futures	0.76283	0.7664	0.76186	0.76594	55301.0
2017-03-29	ALI	Futures	2601.03	2601.03	2601.03	2601.03	0.0
2017-03-29	B	Futures	37.34	38.15	37.31	38.1	345028.0
2017-03-29	B6	Futures	1.3088	1.3106	1.3002	1.3063	145626.0
2017-03-29	BFX	Futures	4580.7	4588.0	4580.7	4588.0	13.0
2017-03-29	BR	Futures	0.22774	0.23006	0.22774	0.22894	456.0
2017-03-29	BZ	Futures	37.2	38.02	37.2	38.0	25178.0
2017-03-29	C	Futures	1762.0	1771.0	1738.0	1749.0	14436.0
2017-03-29	CB	Futures	263.034	263.645	263.034	263.034	14.0
2017-03-29	CC	Futures	1611.0	1618.0	1590.0	1593.0	20006.0
2017-03-29	CNH	Futures	7.2147	7.215	7.2027	7.2027	5.0
2017-03-29	CSC	Futures	3.614	3.632	3.598	3.621	34.0
2017-03-29	CT	Futures	85.82	85.92	84.82	84.87	17565.0
2017-03-29	DC	Futures	29.79	29.94	29.57	29.88	118.0
2017-03-29	DX	Futures	92.756	93.134	92.696	93.014	25954.0
2017-03-29	E1	Futures	1.25182	1.25244	1.24465	1.24601	21625.0
2017-03-29	E6	Futures	1.25035	1.25191	1.242	1.24396	202516.0
2017-03-29	E7	Futures	1.2442	1.2455	1.2356	1.2377	3923.0
2017-03-29	EBM	Futures	186.78	187.34	185.94	186.22	14731.0
2017-03-29	ED	Futures	95.5542	95.5688	95.5494	95.5591	209300.0
2017-03-29	ER	Futures	98.318	98.328	98.318	98.328	105835.0
2017-03-29	EW	Futures	1809.5	1817.8	1803.0	1816.9	11164.0
2017-03-29	FBON	Futures	121.38	121.92	121.32	121.9	377.0
2017-03-29	FBTP	Futures	104.52	105.07	104.46	104.91	92808.0
2017-03-29	FBTS	Futures	101.791	101.882	101.782	101.836	28668.0
2017-03-29	FCE	Futures	4461.9	4472.1	4445.2	4467.2	77124.0
2017-03-29	FDAX	Futures	12874.4	12948.8	12870.7	12913.9	66854.0
2017-03-29	FDIV	Futures	145.8	145.8	145.76	145.76	4.0
2017-03-29	FDXM	Futures	12766.5	12835.5	12759.2	12800.5	19108.0
2017-03-29	FESX	Futures	2772.8	2784.3	2765.5	2774.5	821392.0
2017-03-29	FGBL	Futures	147.27	148.19	147.21	148.1	791126.0
2017-03-29	FGBM	Futures	128.76	129.29	128.74	129.25	507455.0
2017-03-29	FGBS	Futures	112.172	112.312	112.167	112.292	343919.0
2017-03-29	FGBX	Futures	166.67	168.79	166.43	168.17	54121.0
2017-03-29	FMWO	Futures	6226.6	6227.8	6215.7	6225.4	226.0
2017-03-29	FOAT	Futures	131.51	132.14	131.43	131.99	106565.0
2017-03-29	FTDX	Futures	1988.1	1992.1	1981.8	1985.7	134.0
2017-03-29	FTI	Futures	465.66	466.97	464.11	465.84	24100.0
2017-03-29	FTUK	Futures	6230.4	6255.2	6193.6	6242.0	88166.0
2017-03-29	FVSA	Futures	635.01	643.33	626.69	640.55	11669.0
2017-03-29	FXXP	Futures	313.5	314.7	312.6	314.1	32594.0
2017-03-29	G	Futures	114.17	114.93	114.05	114.82	192524.0
2017-03-29	GF	Futures	307.307	312.438	306.615	309.959	3575.0

> showing 50 of 110 rows — these rows as CSV

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