PREVIEW / futures_daily / 2019-03-06

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-06.parquet
  size:    10 KB
  rows:    116

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
2019-03-06	ES	Futures	3016.86	3023.63	2997.37	3000.62	1509846.0
2019-03-06	NQ	Futures	8284.88	8302.54	8228.15	8233.07	444302.0
2019-03-06	YM	Futures	27202.5	27246.8	27028.5	27071.7	198158.0
2019-03-06	CL	Futures	58.18	58.3	57.29	58.12	637677.0
2019-03-06	GC	Futures	1611.0	1614.7	1605.4	1609.5	192932.0
2019-03-06	ZN	Futures	121.238064	121.54929	121.191381	121.440361	45404.0
2019-03-06	A6	Futures	0.7293	0.73085	0.72343	0.72405	104488.0
2019-03-06	AD	Futures	0.75813	0.75833	0.75251	0.75453	98331.0
2019-03-06	B	Futures	47.5	48.0	47.31	47.86	283198.0
2019-03-06	B6	Futures	1.3507	1.3543	1.3484	1.3533	93347.0
2019-03-06	BR	Futures	0.21057	0.21057	0.20561	0.20765	1804.0
2019-03-06	BTC	Futures	5895.7	5995.6	5857.3	5903.4	4104.0
2019-03-06	BZ	Futures	47.22	47.61	46.94	47.48	41210.0
2019-03-06	C	Futures	1440.0	1506.0	1432.0	1502.0	4415.0
2019-03-06	CB	Futures	277.975	277.975	274.177	275.613	58.0
2019-03-06	CC	Futures	1461.0	1532.0	1455.0	1515.0	27442.0
2019-03-06	CNH	Futures	6.7168	6.7385	6.7146	6.7292	985.0
2019-03-06	CSC	Futures	2.796	2.81	2.796	2.805	13.0
2019-03-06	CT	Futures	79.2	79.52	78.62	78.79	16693.0
2019-03-06	DC	Futures	23.82	23.86	23.82	23.85	26.0
2019-03-06	DX	Futures	92.347	92.452	92.227	92.317	14732.0
2019-03-06	E1	Futures	1.17196	1.17325	1.17043	1.17113	17800.0
2019-03-06	E6	Futures	1.24994	1.25249	1.24812	1.25055	149341.0
2019-03-06	E7	Futures	1.2438	1.2463	1.2421	1.2444	3357.0
2019-03-06	EBM	Futures	198.45	199.51	197.13	197.66	17147.0
2019-03-06	ED	Futures	95.0989	95.1062	95.0965	95.1038	190604.0
2019-03-06	ER	Futures	98.411	98.411	98.406	98.406	30555.0
2019-03-06	EW	Futures	2027.9	2032.4	2002.8	2003.9	16912.0
2019-03-06	FBON	Futures	133.07	133.37	133.0	133.32	741.0
2019-03-06	FBTP	Futures	112.42	113.91	112.42	113.4	162706.0
2019-03-06	FBTS	Futures	105.493	105.789	105.408	105.636	124940.0
2019-03-06	FCE	Futures	4720.4	4741.0	4707.1	4716.9	67864.0
2019-03-06	FDAX	Futures	12189.9	12246.1	12148.4	12178.9	98994.0
2019-03-06	FDIV	Futures	143.25	143.25	143.07	143.07	9.0
2019-03-06	FDXM	Futures	12165.5	12216.8	12119.3	12149.2	44852.0
2019-03-06	FESX	Futures	2838.0	2854.3	2833.8	2841.4	1107140.0
2019-03-06	FGBL	Futures	157.56	157.99	157.38	157.85	973692.0
2019-03-06	FGBM	Futures	132.14	132.33	132.07	132.28	656863.0
2019-03-06	FGBS	Futures	112.582	112.638	112.582	112.623	481788.0
2019-03-06	FGBX	Futures	187.25	188.05	186.8	187.58	83053.0
2019-03-06	FMWO	Futures	7006.2	7024.9	6980.6	6998.1	3089.0
2019-03-06	FOAT	Futures	143.49	144.06	143.41	143.97	258176.0
2019-03-06	FTDX	Futures	2643.7	2644.7	2617.9	2625.8	118.0
2019-03-06	FTI	Futures	507.95	508.23	504.62	506.04	20656.0
2019-03-06	FTUK	Futures	6515.8	6555.9	6512.2	6542.7	116405.0
2019-03-06	FVSA	Futures	252.53	256.9	247.29	251.66	17374.0
2019-03-06	FXXP	Futures	330.0	330.9	328.9	329.6	66674.0
2019-03-06	G	Futures	116.42	116.91	116.31	116.81	178571.0
2019-03-06	GF	Futures	308.347	308.784	307.472	307.582	1997.0
2019-03-06	GSCI	Futures	483.79	483.79	482.3	483.04	51.0

> showing 50 of 116 rows — these rows as CSV

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