PREVIEW / futures_daily / 2017-04-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-17.parquet
  size:    8 KB
  rows:    83

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-04-17	ES	Futures	2523.96	2547.86	2522.61	2546.77	981675.0
2017-04-17	NQ	Futures	6304.41	6359.47	6298.52	6354.47	148626.0
2017-04-17	YM	Futures	21504.3	21716.4	21496.9	21703.8	98949.0
2017-04-17	CL	Futures	55.65	55.96	55.32	55.41	227346.0
2017-04-17	GC	Futures	1652.7	1659.1	1640.8	1652.1	191665.0
2017-04-17	ZN	Futures	124.120178	124.289175	123.705369	123.797549	804493.0
2017-04-17	A6	Futures	0.7764	0.7804	0.77629	0.77804	42007.0
2017-04-17	AD	Futures	0.7661	0.76956	0.7661	0.76701	27464.0
2017-04-17	ALI	Futures	2514.3	2514.3	2514.3	2514.3	0.0
2017-04-17	B	Futures	40.29	40.6	40.1	40.15	158972.0
2017-04-17	B6	Futures	1.3157	1.3228	1.315	1.3192	43980.0
2017-04-17	BR	Futures	0.23053	0.23125	0.23017	0.23125	30.0
2017-04-17	BZ	Futures	40.39	40.48	39.99	40.04	18101.0
2017-04-17	CB	Futures	255.711	255.711	255.101	255.101	38.0
2017-04-17	CC	Futures	1464.0	1476.0	1447.0	1473.0	15035.0
2017-04-17	CNH	Futures	7.1961	7.1961	7.1916	7.1916	1.0
2017-04-17	CSC	Futures	3.464	3.469	3.462	3.469	7.0
2017-04-17	CT	Futures	83.8	86.04	83.8	85.86	11149.0
2017-04-17	DC	Futures	28.48	28.58	28.41	28.54	92.0
2017-04-17	DX	Futures	93.544	93.6	93.083	93.347	14992.0
2017-04-17	E1	Futures	1.23378	1.23897	1.23304	1.23477	9054.0
2017-04-17	E6	Futures	1.2257	1.23284	1.22489	1.22956	80026.0
2017-04-17	E7	Futures	1.2193	1.2264	1.2186	1.2233	1736.0
2017-04-17	ED	Futures	95.5736	95.593	95.5639	95.5736	200982.0
2017-04-17	ER	Futures	98.323	98.323	98.323	98.323	0.0
2017-04-17	EW	Futures	1783.8	1808.4	1781.5	1806.3	15163.0
2017-04-17	GF	Futures	318.141	322.093	317.74	321.119	4948.0
2017-04-17	GSCI	Futures	502.87	502.87	501.49	501.74	330.0
2017-04-17	HE	Futures	81.916	82.006	80.691	80.96	104.0
2017-04-17	HG	Futures	3.1602	3.2168	3.1491	3.1977	67129.0
2017-04-17	HH	Futures	21.869	22.088	21.622	21.663	8459.0
2017-04-17	HO	Futures	1.1099	1.1105	1.0984	1.0995	40549.0
2017-04-17	HRC	Futures	1703.9	1703.9	1703.9	1703.9	0.0
2017-04-17	J1	Futures	0.0113196	0.0113834	0.0112876	0.0113147	115438.0
2017-04-17	J7	Futures	0.011286	0.01136	0.011265	0.011291	1491.0
2017-04-17	JB	Futures	138.33	138.37	138.23	138.28	755.0
2017-04-17	KC	Futures	190.3	193.65	189.54	193.03	12541.0
2017-04-17	KE	Futures	976.72	978.43	950.43	951.57	19661.0
2017-04-17	LBS	Futures	486.8	491.9	481.9	485.3	337.0
2017-04-17	LE	Futures	172.596	174.249	172.596	173.761	17586.0
2017-04-17	MFS	Futures	1828.8	1838.9	1828.8	1837.8	10459.0
2017-04-17	MGC	Futures	1633.6	1640.7	1623.1	1633.9	2893.0
2017-04-17	MME	Futures	964.3	974.1	962.2	973.8	19329.0
2017-04-17	MP	Futures	0.03537	0.03548	0.03527	0.03543	28441.0
2017-04-17	N6	Futures	0.68937	0.69351	0.68878	0.68927	10175.0
2017-04-17	NG	Futures	29.141	29.321	28.5	28.545	147638.0
2017-04-17	NIY	Futures	15765.1	15907.1	15666.1	15902.8	22970.0
2017-04-17	NKD	Futures	16833.3	17003.0	16746.1	16993.8	9043.0
2017-04-17	NOK	Futures	0.122467	0.122467	0.122144	0.122144	20.0
2017-04-17	OJ	Futures	136.24	138.15	130.98	134.88	822.0

> showing 50 of 83 rows — these rows as CSV

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