PREVIEW / futures_daily / 2018-12-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-24.parquet
  size:    9 KB
  rows:    95

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-24	ES	Futures	2606.8	2635.76	2533.99	2535.34	1292750.0
2018-12-24	NQ	Futures	7004.12	7088.92	6817.72	6821.48	449594.0
2018-12-24	YM	Futures	23604.7	23808.3	22868.5	22888.5	247770.0
2018-12-24	CL	Futures	47.67	48.5	44.43	44.61	415859.0
2018-12-24	GC	Futures	1588.5	1605.1	1587.6	1602.5	137241.0
2018-12-24	ZN	Futures	120.58449	121.06689	120.506683	120.911277	513369.0
2018-12-24	A6	Futures	0.7258	0.72889	0.7257	0.72652	38356.0
2018-12-24	AD	Futures	0.74608	0.74775	0.74512	0.74578	43573.0
2018-12-24	B	Futures	39.27	40.13	36.98	37.06	76222.0
2018-12-24	B6	Futures	1.3041	1.3133	1.3027	1.3113	44100.0
2018-12-24	BTC	Futures	5760.1	6154.8	5738.2	5935.5	584.0
2018-12-24	BZ	Futures	38.84	39.6	36.52	36.58	19160.0
2018-12-24	C	Futures	1470.0	1495.0	1470.0	1492.0	3144.0
2018-12-24	CC	Futures	1568.0	1616.0	1554.0	1595.0	10240.0
2018-12-24	CNH	Futures	6.9358	6.9388	6.9221	6.925	414.0
2018-12-24	CSC	Futures	2.803	2.803	2.79	2.79	56.0
2018-12-24	CT	Futures	80.39	80.61	78.87	79.03	13412.0
2018-12-24	DC	Futures	23.84	23.89	23.73	23.8	67.0
2018-12-24	DX	Futures	91.975	91.975	91.431	91.562	13927.0
2018-12-24	E1	Futures	1.19241	1.2017	1.191	1.1997	17200.0
2018-12-24	E6	Futures	1.26536	1.27304	1.26514	1.26983	70618.0
2018-12-24	E7	Futures	1.2591	1.2667	1.2585	1.2637	1884.0
2018-12-24	EBM	Futures	210.0	211.03	210.0	210.77	1445.0
2018-12-24	ED	Futures	94.95	94.9842	94.9451	94.9793	129398.0
2018-12-24	ER	Futures	98.401	98.401	98.396	98.396	5958.0
2018-12-24	EW	Futures	1708.2	1728.9	1662.0	1669.3	12344.0
2018-12-24	FCE	Futures	4129.9	4142.7	4100.6	4105.4	21254.0
2018-12-24	FTI	Futures	450.12	452.51	447.31	447.42	8017.0
2018-12-24	FTUK	Futures	5992.5	6041.3	5984.3	6022.1	22489.0
2018-12-24	G	Futures	116.39	116.99	116.39	116.95	26938.0
2018-12-24	GF	Futures	316.863	317.509	315.733	317.24	1353.0
2018-12-24	GSCI	Futures	430.53	430.53	424.77	424.77	28.0
2018-12-24	HE	Futures	74.439	74.439	72.425	72.515	14990.0
2018-12-24	HG	Futures	3.0741	3.0897	3.0539	3.0666	38593.0
2018-12-24	HH	Futures	25.299	25.299	22.999	23.046	7303.0
2018-12-24	HO	Futures	1.1326	1.1438	1.0855	1.0865	16069.0
2018-12-24	HRC	Futures	1805.8	1805.8	1805.8	1805.8	0.0
2018-12-24	J1	Futures	0.0107568	0.0108321	0.0107408	0.0108197	88585.0
2018-12-24	J7	Futures	0.010716	0.01079	0.010704	0.010779	891.0
2018-12-24	JB	Futures	139.94	140.01	139.9	139.97	713.0
2018-12-24	KC	Futures	110.3	113.28	110.24	113.06	9092.0
2018-12-24	KE	Futures	779.1	785.69	771.35	779.1	8628.0
2018-12-24	KRW	Futures	0.0008647	0.0008655	0.0008645	0.0008645	4.0
2018-12-24	L	Futures	99.314	99.334	99.314	99.329	6281.0
2018-12-24	LBS	Futures	555.7	561.1	553.9	555.5	184.0
2018-12-24	LE	Futures	170.975	171.954	170.975	171.639	13473.0
2018-12-24	MFC	Futures	4250.9	4250.9	4223.5	4226.7	12.0
2018-12-24	MFS	Futures	1723.8	1742.4	1695.6	1695.8	26263.0
2018-12-24	MGC	Futures	1548.2	1566.0	1548.2	1563.5	7573.0
2018-12-24	MME	Futures	967.1	976.0	957.6	957.8	59702.0

> showing 50 of 95 rows — these rows as CSV

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