PREVIEW / futures_daily / 2017-10-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-19.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-10-19	ES	Futures	2784.5	2786.13	2765.46	2785.04	1362805.0
2017-10-19	NQ	Futures	7190.09	7190.68	7107.87	7162.49	332212.0
2017-10-19	YM	Futures	24407.2	24418.8	24236.1	24408.3	138863.0
2017-10-19	CL	Futures	52.7	52.83	51.71	51.94	690484.0
2017-10-19	GC	Futures	1632.2	1645.0	1625.6	1641.4	355713.0
2017-10-19	ZN	Futures	123.316504	123.732438	123.316504	123.501364	1499271.0
2017-10-19	A6	Futures	0.80677	0.81068	0.80626	0.80842	119263.0
2017-10-19	AD	Futures	0.81671	0.81752	0.81462	0.81508	58787.0
2017-10-19	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-19	B	Futures	41.13	41.17	40.27	40.42	430668.0
2017-10-19	B6	Futures	1.3786	1.3815	1.371	1.374	100947.0
2017-10-19	BFX	Futures	4811.3	4831.6	4811.3	4831.6	19.0
2017-10-19	BR	Futures	0.23668	0.23668	0.2363	0.23637	16.0
2017-10-19	BZ	Futures	40.77	40.82	39.95	40.09	29999.0
2017-10-19	C	Futures	1529.0	1564.0	1519.0	1562.0	15217.0
2017-10-19	CB	Futures	304.887	304.887	301.737	302.367	28.0
2017-10-19	CC	Futures	1530.0	1598.0	1529.0	1593.0	36489.0
2017-10-19	CNH	Futures	6.8272	6.8312	6.8025	6.8096	49.0
2017-10-19	CSC	Futures	3.474	3.491	3.451	3.454	20.0
2017-10-19	CT	Futures	79.66	79.73	79.0	79.06	12914.0
2017-10-19	DC	Futures	28.1	28.3	27.87	27.87	108.0
2017-10-19	DX	Futures	87.241	87.367	86.886	87.082	18559.0
2017-10-19	E1	Futures	1.25096	1.26025	1.25034	1.2567	31422.0
2017-10-19	E6	Futures	1.34962	1.3572	1.34688	1.3539	224515.0
2017-10-19	E7	Futures	1.3424	1.35	1.3398	1.3469	3825.0
2017-10-19	EBM	Futures	174.24	175.05	173.7	174.24	16562.0
2017-10-19	ED	Futures	95.4988	95.5085	95.4939	95.4988	225125.0
2017-10-19	ER	Futures	98.342	98.342	98.337	98.337	34566.0
2017-10-19	EW	Futures	1936.4	1939.7	1921.5	1938.0	10270.0
2017-10-19	FBON	Futures	124.89	124.94	124.47	124.79	682.0
2017-10-19	FBTP	Futures	110.24	110.48	110.06	110.39	90400.0
2017-10-19	FBTS	Futures	103.448	103.484	103.429	103.466	47667.0
2017-10-19	FCE	Futures	4819.9	4821.2	4784.9	4808.2	83604.0
2017-10-19	FDAX	Futures	13704.3	13709.0	13561.4	13639.1	103317.0
2017-10-19	FDXM	Futures	13587.6	13592.8	13446.9	13524.0	32876.0
2017-10-19	FESX	Futures	2946.6	2948.3	2918.9	2931.1	1044827.0
2017-10-19	FEU3	Futures	99.011	99.011	99.011	99.011	48.0
2017-10-19	FGBL	Futures	149.92	150.31	149.83	150.05	717504.0
2017-10-19	FGBM	Futures	129.8	129.94	129.78	129.89	555678.0
2017-10-19	FGBS	Futures	112.482	112.507	112.472	112.502	245259.0
2017-10-19	FGBX	Futures	168.64	169.56	168.44	168.85	46225.0
2017-10-19	FMWO	Futures	6722.6	6746.2	6722.6	6743.9	1189.0
2017-10-19	FOAT	Futures	137.37	137.62	137.24	137.38	120524.0
2017-10-19	FTDX	Futures	2507.9	2519.4	2480.5	2492.5	265.0
2017-10-19	FTI	Futures	505.89	505.89	500.15	502.83	20078.0
2017-10-19	FTUK	Futures	6515.4	6518.9	6468.1	6498.9	94449.0
2017-10-19	FVSA	Futures	345.32	374.74	345.32	354.27	27436.0
2017-10-19	FXXP	Futures	331.7	331.9	328.8	329.6	29356.0
2017-10-19	G	Futures	113.96	114.41	113.88	114.37	206924.0
2017-10-19	GF	Futures	328.073	330.012	325.648	329.258	4108.0

> showing 50 of 112 rows — these rows as CSV

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