PREVIEW / futures_daily / 2017-02-07

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-07.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-07	ES	Futures	2478.52	2488.01	2476.08	2480.96	1202059.0
2017-02-07	NQ	Futures	6078.08	6119.33	6074.84	6101.36	164423.0
2017-02-07	YM	Futures	21030.1	21156.5	21020.7	21084.9	111316.0
2017-02-07	CL	Futures	56.87	56.97	55.25	55.83	624057.0
2017-02-07	GC	Futures	1580.1	1580.9	1570.3	1579.1	202305.0
2017-02-07	ZN	Futures	122.195132	122.561901	122.011748	122.363234	1410505.0
2017-02-07	A6	Futures	0.78365	0.7859	0.77822	0.78181	81932.0
2017-02-07	AD	Futures	0.78108	0.78154	0.77321	0.77627	52838.0
2017-02-07	ALI	Futures	2477.39	2482.52	2474.5	2482.52	20.0
2017-02-07	B	Futures	41.23	41.28	40.25	40.6	317181.0
2017-02-07	B6	Futures	1.3084	1.3169	1.2958	1.3138	132606.0
2017-02-07	BR	Futures	0.22578	0.22685	0.224	0.22628	512.0
2017-02-07	BZ	Futures	41.04	41.07	40.09	40.39	32659.0
2017-02-07	C	Futures	1739.0	1743.0	1699.0	1701.0	7520.0
2017-02-07	CB	Futures	268.527	269.748	268.527	268.832	12.0
2017-02-07	CC	Futures	1564.0	1568.0	1535.0	1540.0	41351.0
2017-02-07	CNH	Futures	7.2208	7.2473	7.2208	7.24	23.0
2017-02-07	CSC	Futures	3.896	3.898	3.861	3.886	122.0
2017-02-07	CT	Futures	87.02	87.41	86.21	86.26	35725.0
2017-02-07	DC	Futures	32.19	32.27	31.87	32.17	587.0
2017-02-07	DX	Futures	93.072	93.756	93.025	93.337	38828.0
2017-02-07	E1	Futures	1.25264	1.25301	1.24074	1.24582	20153.0
2017-02-07	E6	Futures	1.24298	1.24326	1.23241	1.23691	176874.0
2017-02-07	E7	Futures	1.2367	1.2368	1.226	1.2306	3236.0
2017-02-07	EBM	Futures	192.85	193.7	192.85	193.42	14268.0
2017-02-07	ED	Futures	95.5858	95.5906	95.5713	95.581	299557.0
2017-02-07	ER	Futures	98.298	98.298	98.293	98.298	35222.0
2017-02-07	EW	Futures	1806.9	1814.7	1797.6	1802.2	13651.0
2017-02-07	FBON	Futures	119.28	119.69	119.16	119.49	894.0
2017-02-07	FBTP	Futures	102.9	103.28	102.67	103.02	109510.0
2017-02-07	FBTS	Futures	101.412	101.503	101.376	101.467	32198.0
2017-02-07	FCE	Futures	4195.5	4217.1	4180.1	4187.1	80925.0
2017-02-07	FDAX	Futures	12114.8	12249.4	12097.4	12182.9	81819.0
2017-02-07	FDXM	Futures	12068.6	12200.1	12048.7	12133.8	26773.0
2017-02-07	FESX	Futures	2579.9	2599.9	2571.9	2584.7	896679.0
2017-02-07	FEU3	Futures	98.971	98.971	98.966	98.966	4.0
2017-02-07	FGBL	Futures	147.44	147.67	146.97	147.34	964983.0
2017-02-07	FGBM	Futures	129.19	129.26	129.04	129.14	636850.0
2017-02-07	FGBS	Futures	112.262	112.262	112.212	112.242	365673.0
2017-02-07	FGBX	Futures	166.57	167.06	164.61	165.44	70209.0
2017-02-07	FMWO	Futures	6008.2	6020.3	6004.6	6010.7	526.0
2017-02-07	FOAT	Futures	129.73	130.16	129.44	129.85	223415.0
2017-02-07	FTDX	Futures	1793.5	1803.3	1791.6	1796.0	168.0
2017-02-07	FTI	Futures	437.54	442.01	436.58	440.42	28397.0
2017-02-07	FTUK	Futures	6027.5	6072.4	6016.4	6030.9	92176.0
2017-02-07	FVSA	Futures	800.53	821.84	791.05	821.84	11282.0
2017-02-07	FXXP	Futures	298.7	300.9	298.2	300.2	23128.0
2017-02-07	G	Futures	111.89	112.15	111.67	112.04	171890.0
2017-02-07	GF	Futures	282.687	284.055	281.832	283.2	5052.0
2017-02-07	GSCI	Futures	519.78	520.57	518.59	520.57	1966.0

> showing 50 of 109 rows — these rows as CSV

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