PREVIEW / futures_daily / 2017-06-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-27.parquet
  size:    9 KB
  rows:    109

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-06-27	ES	Futures	2647.23	2648.86	2626.31	2630.65	1639883.0
2017-06-27	NQ	Futures	6795.51	6799.33	6664.14	6672.96	418001.0
2017-06-27	YM	Futures	22585.1	22610.5	22479.4	22506.9	165483.0
2017-06-27	CL	Futures	44.91	45.89	44.73	45.69	759115.0
2017-06-27	GC	Futures	1589.6	1600.6	1585.3	1591.8	213423.0
2017-06-27	ZN	Futures	124.842573	124.934912	124.257758	124.380877	1626148.0
2017-06-27	A6	Futures	0.77825	0.78246	0.77763	0.77938	68005.0
2017-06-27	AD	Futures	0.76887	0.77477	0.76811	0.77436	78907.0
2017-06-27	ALI	Futures	2487.16	2487.16	2487.16	2487.16	0.0
2017-06-27	B	Futures	32.59	33.44	32.52	33.17	311308.0
2017-06-27	B6	Futures	1.3329	1.3478	1.3324	1.3419	103987.0
2017-06-27	BR	Futures	0.22148	0.22148	0.22007	0.22033	35.0
2017-06-27	BZ	Futures	32.44	33.21	32.34	32.96	24065.0
2017-06-27	C	Futures	1501.0	1551.0	1500.0	1518.0	5291.0
2017-06-27	CC	Futures	1397.0	1442.0	1397.0	1414.0	15405.0
2017-06-27	CNH	Futures	7.0977	7.0977	7.0724	7.0766	8.0
2017-06-27	CSC	Futures	3.53	3.542	3.522	3.522	34.0
2017-06-27	CT	Futures	80.46	81.7	80.46	81.4	41.0
2017-06-27	DC	Futures	29.53	29.6	29.37	29.37	77.0
2017-06-27	DX	Futures	90.687	90.72	89.684	89.728	33761.0
2017-06-27	E1	Futures	1.2699	1.28734	1.26867	1.28672	37043.0
2017-06-27	E6	Futures	1.28717	1.30625	1.2866	1.3059	297212.0
2017-06-27	E7	Futures	1.2803	1.2994	1.2799	1.299	7007.0
2017-06-27	EBM	Futures	191.24	191.24	189.84	190.12	9081.0
2017-06-27	ED	Futures	95.5789	95.5838	95.5644	95.5692	174923.0
2017-06-27	ER	Futures	98.337	98.337	98.328	98.332	197637.0
2017-06-27	EW	Futures	1857.6	1863.1	1844.3	1844.9	20038.0
2017-06-27	FBON	Futures	125.24	125.33	124.14	124.52	1288.0
2017-06-27	FBTP	Futures	110.14	110.17	108.31	108.92	120520.0
2017-06-27	FBTS	Futures	102.9	102.918	102.699	102.781	59028.0
2017-06-27	FCE	Futures	4767.7	4769.1	4708.7	4736.6	92776.0
2017-06-27	FDAX	Futures	13422.5	13426.2	13244.1	13333.6	97317.0
2017-06-27	FDIV	Futures	150.71	150.71	150.44	150.44	50.0
2017-06-27	FDXM	Futures	13336.8	13343.1	13165.2	13251.5	30383.0
2017-06-27	FESX	Futures	2898.5	2900.2	2863.4	2881.4	857340.0
2017-06-27	FEU3	Futures	99.006	99.006	99.006	99.006	36.0
2017-06-27	FGBL	Futures	150.01	150.19	148.19	148.76	1119674.0
2017-06-27	FGBM	Futures	129.5	129.54	128.65	128.91	691733.0
2017-06-27	FGBS	Futures	112.172	112.182	112.011	112.071	650222.0
2017-06-27	FGBX	Futures	171.62	172.1	168.1	169.11	60506.0
2017-06-27	FMWO	Futures	6423.3	6438.8	6423.3	6436.4	611.0
2017-06-27	FOAT	Futures	137.17	137.23	135.7	136.01	145989.0
2017-06-27	FTDX	Futures	2257.1	2266.7	2239.6	2247.6	244.0
2017-06-27	FTI	Futures	480.18	480.73	475.01	478.01	30925.0
2017-06-27	FTUK	Futures	6394.7	6394.7	6344.6	6370.1	82950.0
2017-06-27	FVSA	Futures	462.9	481.79	455.02	477.07	33685.0
2017-06-27	FXXP	Futures	329.6	329.6	325.7	327.3	34938.0
2017-06-27	G	Futures	116.27	116.47	115.49	115.75	194494.0
2017-06-27	GF	Futures	329.717	330.814	317.479	318.027	7588.0
2017-06-27	GSCI	Futures	437.09	438.79	437.03	438.0	93.0

> showing 50 of 109 rows — these rows as CSV

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