PREVIEW / futures_daily / 2017-07-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-11.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
2017-07-11	ES	Futures	2634.19	2638.53	2619.51	2635.0	1132273.0
2017-07-11	NQ	Futures	6691.18	6727.03	6662.38	6724.1	283454.0
2017-07-11	YM	Futures	22571.4	22610.5	22438.2	22587.2	131431.0
2017-07-11	CL	Futures	46.04	47.31	45.26	46.51	1010691.0
2017-07-11	GC	Futures	1549.5	1553.7	1541.3	1550.7	217241.0
2017-07-11	ZN	Futures	123.149688	123.349756	122.995789	123.288196	1078017.0
2017-07-11	A6	Futures	0.78082	0.78441	0.7803	0.7839	61010.0
2017-07-11	AD	Futures	0.78987	0.79017	0.78667	0.7885	69123.0
2017-07-11	ALI	Futures	2504.27	2504.27	2499.83	2499.83	20.0
2017-07-11	B	Futures	33.22	34.09	32.73	33.6	283386.0
2017-07-11	B6	Futures	1.3488	1.3539	1.3438	1.3458	105444.0
2017-07-11	BR	Futures	0.22505	0.22612	0.22505	0.22579	156.0
2017-07-11	BZ	Futures	33.03	33.84	32.53	33.38	22689.0
2017-07-11	C	Futures	1474.0	1483.0	1435.0	1463.0	27760.0
2017-07-11	CB	Futures	320.163	321.41	320.163	321.41	10.0
2017-07-11	CC	Futures	1395.0	1401.0	1360.0	1380.0	21526.0
2017-07-11	CNH	Futures	7.0629	7.0629	7.0541	7.0541	1.0
2017-07-11	CSC	Futures	3.462	3.53	3.462	3.526	126.0
2017-07-11	CT	Futures	78.85	79.7	78.16	79.54	57.0
2017-07-11	DC	Futures	28.81	29.62	28.81	29.58	439.0
2017-07-11	DX	Futures	89.483	89.604	89.086	89.102	16456.0
2017-07-11	E1	Futures	1.2769	1.28169	1.27186	1.28107	24375.0
2017-07-11	E6	Futures	1.31071	1.32	1.30882	1.31965	188681.0
2017-07-11	E7	Futures	1.3038	1.313	1.302	1.3127	2663.0
2017-07-11	EBM	Futures	201.54	202.65	200.42	202.37	8290.0
2017-07-11	ED	Futures	95.5789	95.5886	95.5789	95.5886	121653.0
2017-07-11	ER	Futures	98.332	98.337	98.332	98.337	27735.0
2017-07-11	EW	Futures	1850.0	1856.2	1839.7	1854.2	14776.0
2017-07-11	FBON	Futures	122.62	122.74	122.32	122.49	419.0
2017-07-11	FBTP	Futures	106.2	106.21	105.8	105.91	77537.0
2017-07-11	FBTS	Futures	102.681	102.681	102.608	102.626	32174.0
2017-07-11	FCE	Futures	4663.1	4675.3	4628.4	4633.4	58661.0
2017-07-11	FDAX	Futures	13127.2	13196.7	13062.4	13075.6	76795.0
2017-07-11	FDXM	Futures	13043.8	13113.9	12982.0	12995.1	19442.0
2017-07-11	FESX	Futures	2839.0	2847.1	2818.5	2820.2	621934.0
2017-07-11	FGBL	Futures	146.06	146.21	145.79	145.98	584656.0
2017-07-11	FGBM	Futures	128.34	128.34	128.18	128.21	315926.0
2017-07-11	FGBS	Futures	112.106	112.106	112.066	112.076	219963.0
2017-07-11	FGBX	Futures	161.86	162.3	161.29	161.8	53033.0
2017-07-11	FMWO	Futures	6415.0	6415.0	6379.3	6381.6	812.0
2017-07-11	FOAT	Futures	133.79	133.91	133.53	133.7	75679.0
2017-07-11	FTDX	Futures	2257.6	2263.1	2229.1	2232.6	143.0
2017-07-11	FTI	Futures	471.0	471.46	469.11	469.11	79.0
2017-07-11	FTUK	Futures	6307.4	6329.0	6257.8	6274.2	82312.0
2017-07-11	FVSA	Futures	477.07	488.09	470.77	486.51	23492.0
2017-07-11	FXXP	Futures	324.8	325.0	321.4	321.6	25258.0
2017-07-11	G	Futures	113.69	113.94	113.52	113.85	195345.0
2017-07-11	GF	Futures	317.643	324.887	316.271	323.241	6257.0
2017-07-11	GSCI	Futures	443.85	449.19	443.85	449.19	3570.0
2017-07-11	HE	Futures	94.392	95.426	94.191	94.478	28509.0

> showing 50 of 108 rows — these rows as CSV

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