PREVIEW / futures_daily / 2017-09-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-18.parquet
  size:    10 KB
  rows:    110

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-09-18	ES	Futures	2718.15	2725.76	2716.79	2722.23	1090827.0
2017-09-18	NQ	Futures	7046.79	7069.11	7009.2	7032.11	235721.0
2017-09-18	YM	Futures	23471.6	23563.5	23467.4	23547.6	106599.0
2017-09-18	CL	Futures	51.06	51.53	50.34	51.02	551173.0
2017-09-18	GC	Futures	1684.7	1684.7	1664.4	1667.9	271326.0
2017-09-18	ZN	Futures	124.487279	124.502684	124.256205	124.30242	793121.0
2017-09-18	A6	Futures	0.8222	0.82581	0.81593	0.81747	90936.0
2017-09-18	AD	Futures	0.83513	0.83625	0.82495	0.82709	87823.0
2017-09-18	B	Futures	38.98	39.24	38.44	38.91	278120.0
2017-09-18	B6	Futures	1.4206	1.4237	1.4076	1.4102	156007.0
2017-09-18	BR	Futures	0.23924	0.23924	0.23852	0.23852	1.0
2017-09-18	BZ	Futures	38.61	38.89	38.11	38.57	23767.0
2017-09-18	C	Futures	1447.0	1466.0	1439.0	1442.0	7061.0
2017-09-18	CB	Futures	314.933	314.965	314.303	314.965	11.0
2017-09-18	CC	Futures	1485.0	1501.0	1454.0	1466.0	20771.0
2017-09-18	CNH	Futures	6.752	6.7846	6.752	6.7825	57.0
2017-09-18	CSC	Futures	3.404	3.404	3.379	3.379	43.0
2017-09-18	CT	Futures	81.08	82.79	81.08	82.17	45.0
2017-09-18	DC	Futures	27.55	27.55	27.45	27.54	166.0
2017-09-18	DX	Futures	85.712	86.03	85.647	85.87	18269.0
2017-09-18	E1	Futures	1.28018	1.28372	1.27553	1.2792	24140.0
2017-09-18	E6	Futures	1.36867	1.37232	1.36605	1.37033	161099.0
2017-09-18	E7	Futures	1.3614	1.365	1.3591	1.3632	3603.0
2017-09-18	EBM	Futures	176.13	176.13	173.97	174.24	12920.0
2017-09-18	ED	Futures	95.5473	95.5521	95.5327	95.5327	299706.0
2017-09-18	ER	Futures	98.337	98.342	98.337	98.337	44189.0
2017-09-18	EW	Futures	1865.2	1875.6	1865.2	1873.0	10122.0
2017-09-18	FBON	Futures	124.88	125.3	124.77	124.9	354.0
2017-09-18	FBTP	Futures	109.01	109.57	108.91	108.96	83875.0
2017-09-18	FBTS	Futures	103.182	103.274	103.182	103.219	41237.0
2017-09-18	FCE	Futures	4683.7	4686.4	4668.5	4675.6	48492.0
2017-09-18	FDAX	Futures	13208.2	13247.6	13161.5	13194.0	54533.0
2017-09-18	FDXM	Futures	13098.8	13136.4	13050.9	13082.7	17098.0
2017-09-18	FESX	Futures	2866.7	2874.8	2861.8	2867.5	519931.0
2017-09-18	FEU3	Futures	99.011	99.011	99.006	99.006	1126.0
2017-09-18	FGBL	Futures	149.11	149.25	148.74	148.81	553549.0
2017-09-18	FGBM	Futures	129.54	129.62	129.41	129.46	374017.0
2017-09-18	FGBS	Futures	112.427	112.447	112.392	112.402	192871.0
2017-09-18	FGBX	Futures	167.03	167.44	166.05	166.32	33740.0
2017-09-18	FMWO	Futures	6629.3	6632.9	6621.1	6628.2	527.0
2017-09-18	FOAT	Futures	136.48	136.67	136.1	136.19	95868.0
2017-09-18	FTDX	Futures	2374.7	2381.7	2374.7	2377.7	49.0
2017-09-18	FTI	Futures	487.01	487.98	486.18	487.24	16209.0
2017-09-18	FTUK	Futures	6222.1	6266.8	6222.1	6259.9	85890.0
2017-09-18	FVSA	Futures	439.87	442.71	424.26	425.68	20110.0
2017-09-18	FXXP	Futures	323.7	324.3	322.7	323.2	23086.0
2017-09-18	G	Futures	113.56	113.94	113.54	113.91	189907.0
2017-09-18	GF	Futures	328.795	332.724	328.686	331.633	5081.0
2017-09-18	GSCI	Futures	472.15	472.87	471.43	472.27	635.0
2017-09-18	HE	Futures	85.345	86.711	84.865	85.714	19689.0

> showing 50 of 110 rows — these rows as CSV

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