PREVIEW / futures_daily / 2017-10-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-23.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-10-23	ES	Futures	2798.36	2803.26	2786.13	2788.3	1272965.0
2017-10-23	NQ	Futures	7176.29	7198.02	7118.73	7123.73	247882.0
2017-10-23	YM	Futures	24575.1	24625.8	24513.9	24528.6	103260.0
2017-10-23	CL	Futures	52.51	52.74	52.11	52.34	583563.0
2017-10-23	GC	Futures	1630.6	1634.7	1620.5	1629.8	284480.0
2017-10-23	ZN	Futures	123.023811	123.23948	122.962191	123.162455	931547.0
2017-10-23	A6	Futures	0.80368	0.80554	0.80163	0.80266	89313.0
2017-10-23	AD	Futures	0.80593	0.80689	0.80389	0.80511	65842.0
2017-10-23	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-23	B	Futures	40.93	41.0	40.45	40.52	353071.0
2017-10-23	B6	Futures	1.3773	1.3814	1.3741	1.3784	92706.0
2017-10-23	BFX	Futures	4832.2	4859.0	4832.2	4859.0	6.0
2017-10-23	BR	Futures	0.23445	0.23449	0.23219	0.23339	211.0
2017-10-23	BZ	Futures	40.6	40.65	40.12	40.18	25947.0
2017-10-23	C	Futures	1553.0	1559.0	1532.0	1546.0	13671.0
2017-10-23	CB	Futures	303.595	304.477	300.635	301.517	9.0
2017-10-23	CC	Futures	1584.0	1594.0	1563.0	1577.0	22656.0
2017-10-23	CNH	Futures	6.833	6.8398	6.833	6.8355	7.0
2017-10-23	CSC	Futures	3.404	3.441	3.4	3.441	34.0
2017-10-23	CT	Futures	78.57	81.97	78.57	81.89	33450.0
2017-10-23	DC	Futures	27.59	27.86	27.38	27.82	282.0
2017-10-23	DX	Futures	87.568	87.811	87.494	87.731	16028.0
2017-10-23	E1	Futures	1.24594	1.2479	1.24179	1.24362	24542.0
2017-10-23	E6	Futures	1.34734	1.34779	1.3418	1.34328	175171.0
2017-10-23	E7	Futures	1.3382	1.3406	1.3347	1.3363	3326.0
2017-10-23	EBM	Futures	173.97	174.78	173.16	174.51	11565.0
2017-10-23	ED	Futures	95.4988	95.4988	95.4939	95.4988	174738.0
2017-10-23	ER	Futures	98.337	98.342	98.337	98.342	21578.0
2017-10-23	EW	Futures	1948.9	1952.6	1937.3	1939.0	7854.0
2017-10-23	FBON	Futures	124.71	124.95	124.7	124.82	50.0
2017-10-23	FBTP	Futures	110.09	110.6	110.06	110.51	72992.0
2017-10-23	FBTS	Futures	103.466	103.53	103.466	103.512	36803.0
2017-10-23	FCE	Futures	4816.7	4845.0	4806.4	4824.8	66111.0
2017-10-23	FDAX	Futures	13653.9	13732.7	13626.5	13660.2	70382.0
2017-10-23	FDXM	Futures	13535.5	13614.7	13511.5	13544.9	21109.0
2017-10-23	FESX	Futures	2939.3	2952.3	2927.9	2939.3	656101.0
2017-10-23	FEU3	Futures	99.011	99.011	99.011	99.011	4.0
2017-10-23	FGBL	Futures	149.29	149.59	149.29	149.49	585788.0
2017-10-23	FGBM	Futures	129.64	129.8	129.64	129.75	389100.0
2017-10-23	FGBS	Futures	112.467	112.497	112.467	112.482	159796.0
2017-10-23	FGBX	Futures	166.69	167.54	166.66	167.36	46244.0
2017-10-23	FMWO	Futures	6772.2	6779.3	6768.7	6768.7	1918.0
2017-10-23	FOAT	Futures	136.73	137.07	136.73	136.97	95853.0
2017-10-23	FTDX	Futures	2475.5	2494.0	2475.5	2493.0	152.0
2017-10-23	FTI	Futures	503.44	505.61	502.23	504.27	19834.0
2017-10-23	FTUK	Futures	6512.0	6518.5	6479.8	6503.7	52594.0
2017-10-23	FVSA	Futures	345.32	355.55	341.48	347.88	13617.0
2017-10-23	FXXP	Futures	329.8	332.0	329.8	331.2	21986.0
2017-10-23	G	Futures	113.92	114.13	113.71	114.06	148455.0
2017-10-23	GF	Futures	324.409	329.797	323.277	329.15	3889.0

> showing 50 of 110 rows — these rows as CSV

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