PREVIEW / futures_daily / 2017-07-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-21.parquet
  size:    9 KB
  rows:    111

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-07-21	ES	Futures	2687.17	2690.16	2676.57	2683.91	1095937.0
2017-07-21	NQ	Futures	6971.84	6972.43	6924.53	6957.73	254484.0
2017-07-21	YM	Futures	22811.3	22823.0	22676.0	22746.9	98870.0
2017-07-21	CL	Futures	48.25	48.56	46.84	47.08	769438.0
2017-07-21	GC	Futures	1588.2	1603.3	1586.5	1602.0	240528.0
2017-07-21	ZN	Futures	124.180808	124.473216	124.134639	124.411656	757684.0
2017-07-21	A6	Futures	0.81697	0.81697	0.80845	0.81287	113649.0
2017-07-21	AD	Futures	0.80863	0.81285	0.80726	0.81214	82700.0
2017-07-21	ALI	Futures	2535.0	2535.0	2535.0	2535.0	0.0
2017-07-21	B	Futures	34.88	35.1	33.8	33.98	338354.0
2017-07-21	B6	Futures	1.3585	1.3632	1.3561	1.3618	92041.0
2017-07-21	BR	Futures	0.23759	0.23789	0.23462	0.23474	39.0
2017-07-21	BZ	Futures	34.61	34.87	33.59	33.76	27053.0
2017-07-21	C	Futures	1556.0	1581.0	1549.0	1573.0	9885.0
2017-07-21	CB	Futures	321.38	321.44	319.312	320.498	52.0
2017-07-21	CC	Futures	1482.0	1501.0	1471.0	1494.0	24319.0
2017-07-21	CNH	Futures	7.0037	7.0097	7.0031	7.0031	61.0
2017-07-21	CSC	Futures	3.46	3.46	3.419	3.427	117.0
2017-07-21	CT	Futures	80.6	81.07	79.97	80.69	22.0
2017-07-21	DC	Futures	28.92	28.95	28.57	28.66	383.0
2017-07-21	DX	Futures	87.881	87.933	87.466	87.474	15570.0
2017-07-21	E1	Futures	1.29581	1.30588	1.29434	1.30564	27425.0
2017-07-21	E6	Futures	1.33678	1.34257	1.33518	1.34199	204805.0
2017-07-21	E7	Futures	1.3298	1.3354	1.3282	1.3349	3345.0
2017-07-21	EBM	Futures	189.29	190.4	189.29	189.84	12094.0
2017-07-21	ED	Futures	95.5789	95.5838	95.5741	95.5789	166547.0
2017-07-21	ER	Futures	98.337	98.342	98.337	98.337	35373.0
2017-07-21	EW	Futures	1889.4	1892.6	1876.8	1883.8	9724.0
2017-07-21	FBON	Futures	124.5	124.99	124.43	124.73	535.0
2017-07-21	FBTP	Futures	108.33	108.73	108.19	108.61	79050.0
2017-07-21	FBTS	Futures	102.854	102.927	102.845	102.89	36349.0
2017-07-21	FCE	Futures	4667.5	4676.9	4572.3	4593.9	126952.0
2017-07-21	FDAX	Futures	13095.1	13116.7	12825.0	12871.3	116970.0
2017-07-21	FDIV	Futures	146.09	146.09	145.65	145.65	60.0
2017-07-21	FDXM	Futures	13016.6	13037.5	12746.6	12792.1	31383.0
2017-07-21	FESX	Futures	2849.6	2858.5	2799.0	2812.0	1298100.0
2017-07-21	FEU3	Futures	99.011	99.016	99.011	99.016	3.0
2017-07-21	FGBL	Futures	147.19	147.68	147.16	147.6	559382.0
2017-07-21	FGBM	Futures	128.67	128.84	128.64	128.8	349640.0
2017-07-21	FGBS	Futures	112.187	112.217	112.167	112.182	341533.0
2017-07-21	FGBX	Futures	164.32	164.97	164.14	164.65	27384.0
2017-07-21	FMWO	Futures	6551.9	6551.9	6521.0	6526.9	274.0
2017-07-21	FOAT	Futures	135.21	135.61	135.17	135.51	95075.0
2017-07-21	FTDX	Futures	2288.2	2291.7	2263.1	2276.2	78.0
2017-07-21	FTI	Futures	483.16	484.18	478.4	479.55	47991.0
2017-07-21	FTUK	Futures	6425.0	6440.1	6367.1	6387.0	105010.0
2017-07-21	FVSA	Futures	443.5	471.68	430.15	464.26	44978.0
2017-07-21	FXXP	Futures	326.0	326.5	321.7	322.7	40073.0
2017-07-21	G	Futures	114.76	114.99	114.62	114.97	96688.0
2017-07-21	GF	Futures	335.589	337.949	333.229	335.754	4611.0

> showing 50 of 111 rows — these rows as CSV

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