PREVIEW / futures_daily / 2019-06-10

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-10.parquet
  size:    9 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
2019-06-10	ES	Futures	3125.22	3138.72	3111.44	3120.9	1416247.0
2019-06-10	NQ	Futures	8605.82	8731.98	8562.32	8659.39	463884.0
2019-06-10	YM	Futures	27451.9	27607.3	27354.2	27395.2	1792.0
2019-06-10	CL	Futures	55.67	56.28	54.45	54.66	687146.0
2019-06-10	GC	Futures	1669.3	1669.9	1654.1	1654.5	228033.0
2019-06-10	ZN	Futures	126.196119	126.444965	126.102801	126.165013	1290528.0
2019-06-10	A6	Futures	0.72209	0.7223	0.71756	0.71767	73416.0
2019-06-10	AD	Futures	0.76191	0.76206	0.76045	0.76106	16910.0
2019-06-10	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2019-06-10	B	Futures	47.33	47.71	46.19	46.37	278494.0
2019-06-10	B6	Futures	1.3055	1.3056	1.2973	1.3011	62057.0
2019-06-10	BR	Futures	0.20387	0.20467	0.20387	0.20467	41.0
2019-06-10	BTC	Futures	11793.8	12469.9	11547.9	12308.6	3256.0
2019-06-10	BZ	Futures	46.8	47.13	45.6	45.77	34096.0
2019-06-10	C	Futures	1747.0	1780.0	1742.0	1779.0	11379.0
2019-06-10	CB	Futures	285.91	285.91	285.91	285.91	22.0
2019-06-10	CC	Futures	1643.0	1669.0	1630.0	1667.0	40829.0
2019-06-10	CNH	Futures	6.9536	6.9699	6.9495	6.9547	413.0
2019-06-10	CSC	Futures	3.001	3.015	3.001	3.01	35.0
2019-06-10	CT	Futures	68.72	69.61	67.88	69.08	32585.0
2019-06-10	DC	Futures	25.44	25.45	25.22	25.41	77.0
2019-06-10	DX	Futures	92.487	92.815	92.478	92.627	11759.0
2019-06-10	E1	Futures	1.18336	1.18371	1.17953	1.18232	8100.0
2019-06-10	E6	Futures	1.24529	1.24578	1.24131	1.24403	67780.0
2019-06-10	E7	Futures	1.2392	1.2392	1.2348	1.2375	524.0
2019-06-10	EBM	Futures	205.26	205.26	203.53	204.11	9427.0
2019-06-10	ED	Futures	95.2941	95.3282	95.2795	95.3038	357939.0
2019-06-10	ER	Futures	98.43	98.435	98.426	98.43	45702.0
2019-06-10	EW	Futures	2007.6	2008.2	2002.0	2002.3	108.0
2019-06-10	FBON	Futures	141.23	141.23	140.52	140.7	355.0
2019-06-10	FBTP	Futures	118.01	118.05	117.18	117.91	72688.0
2019-06-10	FBTS	Futures	106.411	106.411	106.124	106.287	53492.0
2019-06-10	FCE	Futures	4873.8	4890.6	4864.3	4876.6	48251.0
2019-06-10	FDAX	Futures	12737.4	12767.4	12684.3	12753.8	48420.0
2019-06-10	FDXM	Futures	12556.1	12595.6	12537.4	12584.7	86.0
2019-06-10	FESX	Futures	2947.0	2951.4	2937.4	2945.3	145779.0
2019-06-10	FGBL	Futures	163.12	163.22	162.65	162.7	488915.0
2019-06-10	FGBM	Futures	134.04	134.07	133.96	134.01	350658.0
2019-06-10	FGBS	Futures	112.905	112.925	112.9	112.915	206628.0
2019-06-10	FGBX	Futures	205.9	206.17	203.18	203.41	47349.0
2019-06-10	FMWO	Futures	7180.2	7211.5	7171.0	7205.7	2255.0
2019-06-10	FOAT	Futures	150.03	150.08	149.45	149.57	115510.0
2019-06-10	FTI	Futures	519.09	520.5	518.71	519.92	18.0
2019-06-10	FTUK	Futures	6716.9	6746.9	6716.9	6742.8	3332.0
2019-06-10	FVSA	Futures	216.7	220.26	215.27	217.41	24494.0
2019-06-10	FXXP	Futures	337.0	337.5	336.9	337.5	6235.0
2019-06-10	G	Futures	119.83	119.96	119.66	119.86	138960.0
2019-06-10	GF	Futures	269.928	276.845	269.192	274.392	8827.0
2019-06-10	GSCI	Futures	460.35	463.24	460.29	460.35	2027.0
2019-06-10	HE	Futures	75.209	78.208	75.119	77.734	37146.0

> showing 50 of 110 rows — these rows as CSV

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