PREVIEW / futures_daily / 2017-06-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-28.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-06-28	ES	Futures	2626.85	2654.56	2623.32	2650.22	1560424.0
2017-06-28	NQ	Futures	6669.73	6781.4	6620.65	6775.23	396603.0
2017-06-28	YM	Futures	22482.6	22661.2	22466.7	22624.2	157387.0
2017-06-28	CL	Futures	45.13	46.37	45.1	46.2	753375.0
2017-06-28	GC	Futures	1592.3	1603.0	1591.5	1594.6	195073.0
2017-06-28	ZN	Futures	124.350097	124.427046	123.98074	124.303927	1802887.0
2017-06-28	A6	Futures	0.77794	0.78462	0.77763	0.7839	103094.0
2017-06-28	AD	Futures	0.77222	0.78265	0.77166	0.78173	123503.0
2017-06-28	ALI	Futures	2503.95	2503.95	2503.95	2503.95	0.0
2017-06-28	B	Futures	32.91	33.73	32.91	33.61	338400.0
2017-06-28	B6	Futures	1.3427	1.3591	1.3405	1.3552	189007.0
2017-06-28	BR	Futures	0.22189	0.22293	0.22067	0.22293	52.0
2017-06-28	BZ	Futures	32.62	33.46	32.62	33.4	24424.0
2017-06-28	C	Futures	1518.0	1537.0	1510.0	1522.0	7309.0
2017-06-28	CB	Futures	325.972	325.972	325.546	325.576	4.0
2017-06-28	CC	Futures	1417.0	1435.0	1417.0	1430.0	16047.0
2017-06-28	CNH	Futures	7.0667	7.0715	7.0667	7.0715	11.0
2017-06-28	CSC	Futures	3.522	3.522	3.499	3.501	78.0
2017-06-28	CT	Futures	81.31	81.31	80.24	81.08	14.0
2017-06-28	DC	Futures	29.34	29.35	29.09	29.22	256.0
2017-06-28	DX	Futures	89.805	89.94	89.333	89.403	39795.0
2017-06-28	E1	Futures	1.28623	1.28893	1.2796	1.28734	46746.0
2017-06-28	E6	Futures	1.30481	1.31083	1.29937	1.30957	382261.0
2017-06-28	E7	Futures	1.2976	1.3039	1.2925	1.3027	8145.0
2017-06-28	EBM	Futures	189.29	189.84	188.17	189.01	16384.0
2017-06-28	ED	Futures	95.5741	95.5789	95.5644	95.5741	164689.0
2017-06-28	ER	Futures	98.328	98.337	98.328	98.332	115678.0
2017-06-28	EW	Futures	1844.5	1871.6	1843.5	1865.4	21360.0
2017-06-28	FBON	Futures	124.3	125.06	123.88	124.87	1402.0
2017-06-28	FBTP	Futures	108.51	109.11	108.0	108.89	138735.0
2017-06-28	FBTS	Futures	102.726	102.827	102.672	102.808	48772.0
2017-06-28	FCE	Futures	4707.8	4751.9	4686.1	4731.2	111001.0
2017-06-28	FDAX	Futures	13240.4	13354.1	13189.3	13311.5	93923.0
2017-06-28	FDIV	Futures	149.4	150.57	149.31	150.44	140.0
2017-06-28	FDXM	Futures	13164.1	13271.9	13108.7	13229.5	27956.0
2017-06-28	FESX	Futures	2862.6	2887.9	2847.1	2879.8	1004552.0
2017-06-28	FEU3	Futures	99.006	99.006	99.006	99.006	519.0
2017-06-28	FGBL	Futures	148.12	149.02	147.88	148.48	1225318.0
2017-06-28	FGBM	Futures	128.55	129.21	128.53	128.94	885280.0
2017-06-28	FGBS	Futures	112.011	112.131	112.001	112.096	612925.0
2017-06-28	FGBX	Futures	168.12	169.98	167.07	168.73	74046.0
2017-06-28	FMWO	Futures	6410.2	6466.2	6400.7	6447.1	805.0
2017-06-28	FOAT	Futures	135.5	136.38	135.29	135.96	183985.0
2017-06-28	FTDX	Futures	2233.1	2233.1	2205.6	2220.6	289.0
2017-06-28	FTI	Futures	475.01	477.6	471.74	475.84	38543.0
2017-06-28	FTUK	Futures	6341.6	6381.3	6323.0	6334.7	115235.0
2017-06-28	FVSA	Futures	486.51	500.68	477.07	478.64	33049.0
2017-06-28	FXXP	Futures	325.7	328.2	324.0	327.3	38319.0
2017-06-28	G	Futures	115.4	115.47	114.6	115.02	285269.0
2017-06-28	GF	Futures	315.613	321.924	313.747	321.375	5535.0

> showing 50 of 111 rows — these rows as CSV

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