PREVIEW / futures_daily / 2017-07-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-13.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-07-13	ES	Futures	2653.21	2659.46	2650.76	2657.82	941061.0
2017-07-13	NQ	Futures	6802.56	6832.25	6791.4	6815.2	240958.0
2017-07-13	YM	Futures	22709.9	22747.9	22684.5	22737.3	76753.0
2017-07-13	CL	Futures	46.92	47.79	46.46	47.59	748971.0
2017-07-13	GC	Futures	1556.4	1562.0	1551.8	1554.0	227820.0
2017-07-13	ZN	Futures	123.657553	123.780672	123.380536	123.519044	1260066.0
2017-07-13	A6	Futures	0.78831	0.79448	0.7878	0.79355	98275.0
2017-07-13	AD	Futures	0.79892	0.80024	0.79709	0.79999	74068.0
2017-07-13	ALI	Futures	2539.12	2539.12	2532.46	2532.46	10.0
2017-07-13	B	Futures	33.73	34.31	33.36	34.23	262631.0
2017-07-13	B6	Futures	1.3498	1.3567	1.3496	1.3556	88271.0
2017-07-13	BR	Futures	0.22831	0.2295	0.22831	0.22902	814.0
2017-07-13	BZ	Futures	33.47	34.09	33.14	34.02	22846.0
2017-07-13	C	Futures	1458.0	1516.0	1454.0	1503.0	13634.0
2017-07-13	CB	Futures	321.136	321.319	320.528	320.528	23.0
2017-07-13	CC	Futures	1383.0	1432.0	1382.0	1421.0	25717.0
2017-07-13	CNH	Futures	7.0386	7.0424	7.0367	7.0367	3.0
2017-07-13	CSC	Futures	3.513	3.52	3.509	3.511	30.0
2017-07-13	CT	Futures	79.77	79.77	77.6	77.66	54.0
2017-07-13	DC	Futures	29.51	29.56	29.27	29.49	160.0
2017-07-13	DX	Futures	89.203	89.357	88.937	89.182	18647.0
2017-07-13	E1	Futures	1.27714	1.2823	1.27284	1.2753	27687.0
2017-07-13	E6	Futures	1.31209	1.31696	1.30716	1.31112	243647.0
2017-07-13	E7	Futures	1.3051	1.31	1.3001	1.3043	3666.0
2017-07-13	EBM	Futures	197.36	197.36	194.3	195.13	16580.0
2017-07-13	ED	Futures	95.5983	95.5983	95.5886	95.5935	133746.0
2017-07-13	ER	Futures	98.332	98.342	98.332	98.337	101395.0
2017-07-13	EW	Futures	1865.4	1869.4	1856.9	1868.4	9152.0
2017-07-13	FBON	Futures	123.1	123.36	122.49	122.53	928.0
2017-07-13	FBTP	Futures	106.64	107.19	106.09	106.21	146117.0
2017-07-13	FBTS	Futures	102.745	102.772	102.608	102.644	78379.0
2017-07-13	FCE	Futures	4691.7	4718.7	4691.7	4699.4	2269.0
2017-07-13	FDAX	Futures	13321.5	13342.5	13272.0	13291.4	57619.0
2017-07-13	FDXM	Futures	13237.4	13259.3	13190.3	13209.6	14315.0
2017-07-13	FESX	Futures	2869.2	2884.7	2862.6	2873.2	670964.0
2017-07-13	FEU3	Futures	99.011	99.011	99.011	99.011	8.0
2017-07-13	FGBL	Futures	146.66	147.09	146.28	146.4	785938.0
2017-07-13	FGBM	Futures	128.43	128.59	128.3	128.34	425130.0
2017-07-13	FGBS	Futures	112.131	112.177	112.111	112.121	300701.0
2017-07-13	FGBX	Futures	163.23	164.14	162.24	162.58	41516.0
2017-07-13	FMWO	Futures	6471.0	6473.3	6461.4	6462.6	828.0
2017-07-13	FOAT	Futures	134.3	134.88	134.1	134.19	119722.0
2017-07-13	FTDX	Futures	2265.7	2302.2	2265.7	2290.2	149.0
2017-07-13	FTI	Futures	474.52	476.92	474.52	476.69	175.0
2017-07-13	FTUK	Futures	6352.8	6367.9	6344.6	6353.2	65994.0
2017-07-13	FVSA	Futures	468.71	479.1	465.75	473.16	25953.0
2017-07-13	FXXP	Futures	327.0	328.6	326.7	327.9	23029.0
2017-07-13	G	Futures	113.84	114.29	113.54	113.74	158873.0
2017-07-13	GF	Futures	334.766	339.321	332.241	335.918	9426.0
2017-07-13	GSCI	Futures	449.37	450.95	448.28	449.07	2338.0

> showing 50 of 109 rows — these rows as CSV

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