PREVIEW / futures_daily / 2018-12-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-26.parquet
  size:    9 KB
  rows:    87

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
2018-12-26	ES	Futures	2542.65	2682.58	2508.27	2675.28	2015176.0
2018-12-26	NQ	Futures	6833.06	7305.42	6738.7	7277.06	642440.0
2018-12-26	YM	Futures	22920.2	24227.0	22626.9	24152.1	359441.0
2018-12-26	CL	Futures	44.94	49.3	44.6	48.48	698408.0
2018-12-26	GC	Futures	1604.6	1615.7	1596.9	1604.0	208542.0
2018-12-26	ZN	Futures	121.035768	121.144697	120.382193	120.537806	881047.0
2018-12-26	A6	Futures	0.72621	0.7293	0.72518	0.72766	35987.0
2018-12-26	AD	Futures	0.74562	0.74765	0.74481	0.74689	29584.0
2018-12-26	B	Futures	37.06	40.13	36.26	39.53	178268.0
2018-12-26	B6	Futures	1.3077	1.3115	1.3023	1.3039	31716.0
2018-12-26	BR	Futures	0.20336	0.20336	0.20236	0.20264	726.0
2018-12-26	BTC	Futures	5460.4	5606.6	5380.0	5489.6	817.0
2018-12-26	BZ	Futures	36.58	39.79	36.02	39.2	22320.0
2018-12-26	CB	Futures	275.599	275.599	273.109	273.625	21.0
2018-12-26	CC	Futures	1596.0	1678.0	1591.0	1673.0	18444.0
2018-12-26	CNH	Futures	6.9221	6.9253	6.9026	6.9093	566.0
2018-12-26	CSC	Futures	2.79	2.804	2.79	2.793	102.0
2018-12-26	CT	Futures	79.19	80.11	78.59	80.06	10452.0
2018-12-26	DC	Futures	23.81	23.89	23.76	23.86	41.0
2018-12-26	DX	Futures	91.65	92.175	91.574	92.097	15662.0
2018-12-26	E1	Futures	1.20205	1.203	1.18947	1.191	12300.0
2018-12-26	E6	Futures	1.27011	1.2711	1.26226	1.26326	78854.0
2018-12-26	E7	Futures	1.2638	1.2648	1.2561	1.2571	2413.0
2018-12-26	ED	Futures	94.9695	95.0135	94.9598	94.9695	158720.0
2018-12-26	ER	Futures	98.396	98.396	98.396	98.396	0.0
2018-12-26	EW	Futures	1667.8	1750.5	1648.2	1745.6	18198.0
2018-12-26	GF	Futures	317.24	319.554	316.971	318.8	3103.0
2018-12-26	GSCI	Futures	429.67	434.52	429.67	433.78	31.0
2018-12-26	HE	Futures	73.236	73.747	72.455	72.605	12980.0
2018-12-26	HG	Futures	3.0781	3.1438	3.0447	3.1116	41241.0
2018-12-26	HH	Futures	23.305	23.385	21.902	22.986	4555.0
2018-12-26	HO	Futures	1.0925	1.1496	1.0748	1.1354	21980.0
2018-12-26	HRC	Futures	1810.8	1810.8	1810.8	1810.8	0.0
2018-12-26	J1	Futures	0.0108399	0.0108399	0.0107177	0.010723	120463.0
2018-12-26	J7	Futures	0.010751	0.010799	0.010677	0.010683	1319.0
2018-12-26	JB	Futures	140.08	140.14	139.91	139.99	985.0
2018-12-26	KC	Futures	113.06	115.05	111.01	114.94	12482.0
2018-12-26	KE	Futures	780.27	788.02	766.7	768.25	12351.0
2018-12-26	KRW	Futures	0.0008645	0.0008649	0.0008645	0.0008649	2.0
2018-12-26	LBS	Futures	557.6	557.6	547.8	551.9	146.0
2018-12-26	LE	Futures	172.233	172.653	171.569	171.604	18349.0
2018-12-26	MFS	Futures	1711.6	1744.9	1694.8	1741.6	37202.0
2018-12-26	MGC	Futures	1565.9	1576.4	1558.2	1565.0	12129.0
2018-12-26	MME	Futures	970.4	984.9	956.4	981.1	84762.0
2018-12-26	MP	Futures	0.03615	0.03629	0.03604	0.03615	29503.0
2018-12-26	N6	Futures	0.66847	0.67125	0.66827	0.66877	9958.0
2018-12-26	NG	Futures	29.604	30.927	28.323	30.117	120854.0
2018-12-26	NIY	Futures	17102.9	17901.0	16866.6	17856.4	57144.0
2018-12-26	NKD	Futures	18049.9	18885.7	17805.7	18848.1	19555.0
2018-12-26	NOK	Futures	0.117889	0.11792	0.117037	0.117139	43.0

> showing 50 of 87 rows — these rows as CSV

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