PREVIEW / futures_daily / 2017-10-03

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-03.parquet
  size:    9 KB
  rows:    104

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-03	ES	Futures	2748.87	2755.67	2746.97	2754.86	849153.0
2017-10-03	NQ	Futures	7030.64	7053.25	7022.71	7045.32	207901.0
2017-10-03	YM	Futures	23772.6	23888.7	23759.9	23873.9	75523.0
2017-10-03	CL	Futures	51.26	51.41	50.81	51.09	462735.0
2017-10-03	GC	Futures	1619.9	1625.4	1617.2	1621.8	207422.0
2017-10-03	ZN	Futures	123.455149	123.640008	123.285695	123.562983	954985.0
2017-10-03	A6	Futures	0.80492	0.80574	0.80019	0.80533	85465.0
2017-10-03	AD	Futures	0.81345	0.81559	0.81178	0.81493	46837.0
2017-10-03	B	Futures	39.62	39.83	39.34	39.55	275423.0
2017-10-03	B6	Futures	1.3872	1.3885	1.3815	1.384	105483.0
2017-10-03	BR	Futures	0.23671	0.23811	0.23671	0.23811	147.0
2017-10-03	BZ	Futures	39.28	39.5	39.01	39.22	21948.0
2017-10-03	C	Futures	1497.0	1527.0	1486.0	1520.0	16153.0
2017-10-03	CB	Futures	292.888	297.297	292.258	296.793	37.0
2017-10-03	CC	Futures	1517.0	1550.0	1501.0	1546.0	32884.0
2017-10-03	CNH	Futures	6.8957	6.896	6.8674	6.8691	79.0
2017-10-03	CSC	Futures	3.497	3.497	3.474	3.478	8.0
2017-10-03	CT	Futures	79.35	80.56	79.17	79.31	13342.0
2017-10-03	DC	Futures	28.42	28.58	28.35	28.51	33.0
2017-10-03	DX	Futures	87.428	87.695	87.227	87.357	17651.0
2017-10-03	E1	Futures	1.26049	1.26282	1.25536	1.26172	22588.0
2017-10-03	E6	Futures	1.34414	1.34882	1.33986	1.34602	185388.0
2017-10-03	E7	Futures	1.3371	1.3416	1.3329	1.339	3474.0
2017-10-03	EBM	Futures	178.55	180.71	178.28	180.17	15778.0
2017-10-03	ED	Futures	95.5133	95.5133	95.5036	95.5036	299445.0
2017-10-03	ER	Futures	98.337	98.342	98.337	98.337	38223.0
2017-10-03	EW	Futures	1925.5	1932.4	1920.7	1929.9	13544.0
2017-10-03	FBON	Futures	124.1	124.23	123.82	123.9	634.0
2017-10-03	FBTP	Futures	108.24	108.47	108.04	108.3	89761.0
2017-10-03	FBTS	Futures	103.265	103.274	103.246	103.255	34931.0
2017-10-03	FCE	Futures	4805.1	4813.6	4793.9	4805.5	32965.0
2017-10-03	FESX	Futures	2937.6	2938.5	2927.0	2933.6	313014.0
2017-10-03	FGBL	Futures	148.95	149.06	148.54	148.98	534372.0
2017-10-03	FGBM	Futures	129.56	129.62	129.43	129.6	404135.0
2017-10-03	FGBS	Futures	112.437	112.452	112.412	112.442	222318.0
2017-10-03	FGBX	Futures	166.66	166.87	165.64	166.58	39653.0
2017-10-03	FMWO	Futures	6667.1	6684.8	6667.1	6671.9	3859.0
2017-10-03	FOAT	Futures	136.1	136.16	135.69	136.04	96276.0
2017-10-03	FTI	Futures	498.94	500.04	498.11	499.35	15275.0
2017-10-03	FTUK	Futures	6413.9	6446.4	6407.4	6444.3	80120.0
2017-10-03	FVSA	Futures	381.69	384.53	377.43	377.43	7367.0
2017-10-03	FXXP	Futures	331.0	331.3	330.1	331.1	18736.0
2017-10-03	G	Futures	113.6	113.62	113.2	113.42	163372.0
2017-10-03	GF	Futures	329.45	333.761	328.468	332.669	2124.0
2017-10-03	GSCI	Futures	471.97	473.29	470.42	471.37	2460.0
2017-10-03	HE	Futures	91.842	93.688	90.661	91.657	34249.0
2017-10-03	HG	Futures	3.5575	3.5901	3.5346	3.5799	55298.0
2017-10-03	HH	Futures	18.055	18.092	17.857	17.925	1986.0
2017-10-03	HO	Futures	1.1535	1.1548	1.1382	1.1451	43877.0
2017-10-03	HRC	Futures	1502.3	1502.3	1499.8	1499.8	105.0

> showing 50 of 104 rows — these rows as CSV

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