PREVIEW / futures_daily / 2017-01-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-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-01-27	ES	Futures	2486.92	2489.91	2479.34	2481.5	942076.0
2017-01-27	NQ	Futures	6063.05	6090.46	6057.16	6084.56	138335.0
2017-01-27	YM	Futures	21119.7	21142.8	21071.2	21078.6	77803.0
2017-01-27	CL	Futures	57.51	57.87	56.27	56.9	495556.0
2017-01-27	GC	Futures	1522.0	1525.1	1510.7	1521.6	143606.0
2017-01-27	ZN	Futures	121.247646	121.461594	121.079544	121.446312	1076894.0
2017-01-27	A6	Futures	0.77034	0.77484	0.76849	0.77259	71998.0
2017-01-27	AD	Futures	0.78036	0.78087	0.77689	0.77816	47849.0
2017-01-27	ALI	Futures	2466.16	2466.16	2466.16	2466.16	0.0
2017-01-27	B	Futures	41.54	41.83	40.62	41.07	263143.0
2017-01-27	B6	Futures	1.3217	1.3235	1.314	1.3184	78927.0
2017-01-27	BR	Futures	0.2213	0.22418	0.22045	0.22397	27905.0
2017-01-27	BZ	Futures	41.38	41.62	40.41	40.87	28245.0
2017-01-27	C	Futures	1772.0	1777.0	1746.0	1758.0	12429.0
2017-01-27	CB	Futures	272.189	273.409	272.189	272.189	8.0
2017-01-27	CC	Futures	1605.0	1615.0	1580.0	1595.0	22702.0
2017-01-27	CNH	Futures	7.2745	7.3053	7.2745	7.2948	8.0
2017-01-27	CSC	Futures	3.983	3.983	3.956	3.972	31.0
2017-01-27	CT	Futures	85.23	86.12	85.23	85.98	12854.0
2017-01-27	DC	Futures	32.94	32.98	32.61	32.82	206.0
2017-01-27	DX	Futures	93.588	93.863	93.397	93.599	30566.0
2017-01-27	E1	Futures	1.24198	1.24607	1.23851	1.24372	16036.0
2017-01-27	E6	Futures	1.23593	1.24101	1.23327	1.23795	175241.0
2017-01-27	E7	Futures	1.2296	1.2345	1.227	1.2316	4073.0
2017-01-27	EBM	Futures	193.99	194.56	193.13	193.13	10057.0
2017-01-27	ED	Futures	95.5472	95.5568	95.5375	95.552	121008.0
2017-01-27	ER	Futures	98.303	98.308	98.303	98.303	41501.0
2017-01-27	EW	Futures	1813.5	1819.4	1799.9	1804.5	14071.0
2017-01-27	FBON	Futures	121.13	121.24	120.65	120.89	1540.0
2017-01-27	FBTP	Futures	103.95	104.29	103.5	103.97	141375.0
2017-01-27	FBTS	Futures	101.647	101.674	101.476	101.593	68570.0
2017-01-27	FCE	Futures	4284.0	4288.9	4250.1	4261.1	75586.0
2017-01-27	FDAX	Futures	12498.5	12513.8	12456.8	12470.6	55355.0
2017-01-27	FDXM	Futures	12442.9	12463.9	12407.2	12420.3	15848.0
2017-01-27	FESX	Futures	2648.7	2651.1	2628.7	2635.9	760539.0
2017-01-27	FEU3	Futures	98.976	98.976	98.976	98.976	8.0
2017-01-27	FGBL	Futures	145.68	146.04	145.64	145.96	699866.0
2017-01-27	FGBM	Futures	128.28	128.38	128.26	128.32	496703.0
2017-01-27	FGBS	Futures	111.992	112.027	111.992	112.017	235633.0
2017-01-27	FGBX	Futures	163.31	164.87	163.03	164.41	42280.0
2017-01-27	FMWO	Futures	6030.0	6034.8	6025.1	6025.1	284.0
2017-01-27	FOAT	Futures	130.5	130.88	130.36	130.52	133396.0
2017-01-27	FTDX	Futures	1824.4	1826.4	1815.6	1823.0	99.0
2017-01-27	FTI	Futures	442.24	442.65	440.42	441.83	22434.0
2017-01-27	FTUK	Futures	6017.3	6038.9	6008.0	6036.4	74804.0
2017-01-27	FVSA	Futures	812.37	843.16	812.37	840.79	12884.0
2017-01-27	FXXP	Futures	303.7	304.0	301.8	302.7	21129.0
2017-01-27	G	Futures	109.87	110.35	109.8	110.27	152875.0
2017-01-27	GF	Futures	289.299	290.837	287.475	290.552	4555.0
2017-01-27	GSCI	Futures	523.6	524.26	523.47	524.26	107.0

> showing 50 of 109 rows — these rows as CSV

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