PREVIEW / futures_daily / 2016-07-18

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-18.parquet
  size:    9 KB
  rows:    108

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
2016-07-18	ES	Futures	2326.19	2335.64	2324.3	2332.13	1205765.0
2016-07-18	NQ	Futures	5398.61	5447.82	5395.07	5431.91	183261.0
2016-07-18	YM	Futures	19245.2	19316.3	19229.6	19272.4	108256.0
2016-07-18	CL	Futures	53.08	53.09	51.62	52.07	334568.0
2016-07-18	GC	Futures	1715.4	1718.8	1702.7	1710.2	163212.0
2016-07-18	ZN	Futures	127.426209	127.728024	127.23003	127.516754	854813.0
2016-07-18	A6	Futures	0.7705	0.77223	0.76897	0.7708	53635.0
2016-07-18	AD	Futures	0.7905	0.79168	0.7859	0.79045	46962.0
2016-07-18	ALI	Futures	2176.03	2176.03	2160.43	2160.43	8.0
2016-07-18	B	Futures	38.26	38.28	37.12	37.49	230495.0
2016-07-18	B6	Futures	1.3921	1.4046	1.391	1.3986	76923.0
2016-07-18	BR	Futures	0.20103	0.20203	0.20103	0.20157	6.0
2016-07-18	BZ	Futures	38.0	38.07	36.99	37.35	22151.0
2016-07-18	C	Futures	2619.0	2633.0	2608.0	2630.0	8376.0
2016-07-18	CC	Futures	2259.0	2272.0	2244.0	2262.0	13150.0
2016-07-18	CNH	Futures	7.2769	7.2783	7.2731	7.2783	5.0
2016-07-18	CSC	Futures	3.693	3.724	3.693	3.703	46.0
2016-07-18	CT	Futures	83.45	84.32	83.32	83.41	31.0
2016-07-18	DC	Futures	29.77	30.13	29.57	29.77	134.0
2016-07-18	DX	Futures	89.857	89.946	89.709	89.831	11294.0
2016-07-18	E1	Futures	1.2778	1.2803	1.27579	1.27842	9576.0
2016-07-18	E6	Futures	1.28986	1.2937	1.28811	1.29178	87018.0
2016-07-18	E7	Futures	1.282	1.2867	1.2813	1.2849	1969.0
2016-07-18	EBM	Futures	192.76	194.87	191.26	193.66	10031.0
2016-07-18	ED	Futures	95.7522	95.757	95.7425	95.7425	105859.0
2016-07-18	ER	Futures	98.313	98.318	98.308	98.318	24124.0
2016-07-18	EW	Futures	1628.4	1638.6	1628.4	1634.5	13216.0
2016-07-18	FBON	Futures	122.27	122.5	121.86	121.89	402.0
2016-07-18	FBTP	Futures	109.31	109.61	109.08	109.18	62162.0
2016-07-18	FBTS	Futures	101.257	101.311	101.257	101.293	15261.0
2016-07-18	FCE	Futures	3816.6	3848.1	3782.6	3803.1	69991.0
2016-07-18	FDAX	Futures	10731.8	10805.8	10641.9	10714.3	73159.0
2016-07-18	FDXM	Futures	10466.9	10533.3	10372.5	10443.6	18541.0
2016-07-18	FESX	Futures	2314.2	2332.2	2289.9	2308.7	875274.0
2016-07-18	FEU3	Futures	98.966	98.971	98.966	98.971	212.0
2016-07-18	FGBL	Futures	149.61	149.97	149.52	149.69	463116.0
2016-07-18	FGBM	Futures	128.91	128.98	128.87	128.91	292032.0
2016-07-18	FGBS	Futures	111.937	111.947	111.917	111.932	197331.0
2016-07-18	FGBX	Futures	185.41	186.02	184.91	185.18	26041.0
2016-07-18	FMWO	Futures	5699.0	5699.0	5680.8	5692.9	123.0
2016-07-18	FOAT	Futures	137.71	137.88	137.59	137.7	73923.0
2016-07-18	FTDX	Futures	1571.0	1587.4	1571.0	1584.0	73.0
2016-07-18	FTI	Futures	400.16	402.63	398.31	400.25	22548.0
2016-07-18	FTUK	Futures	5524.3	5559.0	5515.2	5549.8	92580.0
2016-07-18	FVSA	Futures	2254.75	2342.6	2249.87	2293.8	14334.0
2016-07-18	FXXP	Futures	273.3	274.5	271.7	273.3	26649.0
2016-07-18	G	Futures	114.69	114.86	114.52	114.64	102499.0
2016-07-18	GF	Futures	277.26	282.452	275.213	281.903	3383.0
2016-07-18	GSCI	Futures	511.58	515.38	511.58	515.31	37.0
2016-07-18	HE	Futures	93.509	93.898	92.374	93.001	12689.0

> showing 50 of 108 rows — these rows as CSV

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