PREVIEW / futures_daily / 2017-07-03

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-03.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-03	ES	Futures	2632.28	2648.04	2631.74	2635.54	766228.0
2017-07-03	NQ	Futures	6651.21	6689.71	6560.99	6570.39	232656.0
2017-07-03	YM	Futures	22522.7	22736.3	22522.7	22660.2	93477.0
2017-07-03	CL	Futures	47.79	48.64	47.42	48.61	517621.0
2017-07-03	GC	Futures	1585.1	1586.3	1554.9	1556.4	284449.0
2017-07-03	ZN	Futures	123.626773	123.719113	123.149688	123.226637	1023896.0
2017-07-03	A6	Futures	0.78842	0.78975	0.78451	0.78554	63046.0
2017-07-03	AD	Futures	0.78514	0.78545	0.7826	0.78331	51173.0
2017-07-03	ALI	Futures	2539.43	2539.43	2539.43	2539.43	0.0
2017-07-03	B	Futures	34.61	35.15	34.32	35.13	244518.0
2017-07-03	B6	Futures	1.3634	1.3642	1.3546	1.357	82491.0
2017-07-03	BR	Futures	0.22126	0.22256	0.22126	0.22222	33.0
2017-07-03	BZ	Futures	34.35	34.91	34.1	34.9	17462.0
2017-07-03	C	Futures	1558.0	1597.0	1558.0	1565.0	2483.0
2017-07-03	CB	Futures	324.786	324.786	324.786	324.786	4.0
2017-07-03	CC	Futures	1494.0	1515.0	1481.0	1487.0	25088.0
2017-07-03	CNH	Futures	7.0501	7.0643	7.0501	7.0643	3.0
2017-07-03	CSC	Futures	3.509	3.509	3.493	3.493	3.0
2017-07-03	CT	Futures	82.28	82.31	80.34	80.34	11.0
2017-07-03	DC	Futures	29.18	29.18	28.94	29.02	54.0
2017-07-03	DX	Futures	89.086	89.637	89.067	89.613	19916.0
2017-07-03	E1	Futures	1.28734	1.28746	1.2796	1.2796	20266.0
2017-07-03	E6	Futures	1.31381	1.31438	1.30613	1.3063	167970.0
2017-07-03	E7	Futures	1.3066	1.3077	1.2992	1.2995	3380.0
2017-07-03	EBM	Futures	200.42	202.65	199.03	200.14	20423.0
2017-07-03	ED	Futures	95.5644	95.5741	95.5596	95.5596	124785.0
2017-07-03	ER	Futures	98.332	98.337	98.328	98.337	48846.0
2017-07-03	EW	Futures	1855.7	1873.8	1855.4	1867.4	10607.0
2017-07-03	FBON	Futures	123.86	124.25	123.76	123.88	373.0
2017-07-03	FBTP	Futures	107.3	107.98	107.3	107.57	67858.0
2017-07-03	FBTS	Futures	102.726	102.772	102.681	102.717	38566.0
2017-07-03	FCE	Futures	4647.4	4685.2	4635.6	4679.8	70874.0
2017-07-03	FDAX	Futures	13061.4	13140.9	13031.9	13132.5	68196.0
2017-07-03	FDIV	Futures	148.53	148.53	148.53	148.53	20.0
2017-07-03	FDXM	Futures	12975.8	13058.4	12951.7	13051.6	16346.0
2017-07-03	FESX	Futures	2822.6	2845.5	2814.5	2842.2	685474.0
2017-07-03	FEU3	Futures	99.011	99.011	99.006	99.006	7.0
2017-07-03	FGBL	Futures	146.76	147.46	146.73	146.85	598394.0
2017-07-03	FGBM	Futures	128.42	128.73	128.42	128.48	346141.0
2017-07-03	FGBS	Futures	112.051	112.106	112.046	112.056	222554.0
2017-07-03	FGBX	Futures	164.59	165.98	164.1	164.26	42184.0
2017-07-03	FMWO	Futures	6418.6	6438.8	6418.6	6431.7	797.0
2017-07-03	FOAT	Futures	134.63	135.08	134.57	134.58	74565.0
2017-07-03	FTDX	Futures	2194.5	2210.6	2175.5	2204.6	163.0
2017-07-03	FTI	Futures	470.95	473.44	468.92	472.8	23182.0
2017-07-03	FTUK	Futures	6276.3	6329.9	6269.0	6320.0	89423.0
2017-07-03	FVSA	Futures	525.88	525.88	475.49	478.64	28230.0
2017-07-03	FXXP	Futures	323.3	325.7	322.7	325.2	33914.0
2017-07-03	G	Futures	113.5	114.16	113.46	113.87	204102.0
2017-07-03	GF	Futures	324.778	325.381	318.302	320.717	4764.0

> showing 50 of 109 rows — these rows as CSV

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