PREVIEW / futures_daily / 2019-07-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-24.parquet
  size:    10 KB
  rows:    118

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-07-24	ES	Futures	3240.41	3260.91	3232.85	3260.37	1068766.0
2019-07-24	NQ	Futures	9146.12	9270.18	9124.54	9254.35	356159.0
2019-07-24	YM	Futures	28672.0	28714.0	28534.4	28599.5	155965.0
2019-07-24	CL	Futures	58.4	58.82	56.46	57.02	745248.0
2019-07-24	GC	Futures	1765.6	1779.8	1763.3	1771.8	318164.0
2019-07-24	ZN	Futures	126.693811	127.082633	126.678258	126.927104	1127865.0
2019-07-24	A6	Futures	0.72188	0.72188	0.71849	0.7188	67493.0
2019-07-24	AD	Futures	0.76846	0.76912	0.76726	0.76761	46956.0
2019-07-24	ALI	Futures	2274.27	2274.27	2274.27	2274.27	0.0
2019-07-24	B	Futures	48.21	48.61	47.05	47.5	301507.0
2019-07-24	B6	Futures	1.2728	1.2813	1.2714	1.2769	76070.0
2019-07-24	BR	Futures	0.21126	0.21222	0.21038	0.21154	1593.0
2019-07-24	BTC	Futures	14208.9	14208.9	13279.5	13451.6	1309.0
2019-07-24	BZ	Futures	47.69	48.0	46.46	46.9	42616.0
2019-07-24	C	Futures	1749.0	1754.0	1729.0	1734.0	3224.0
2019-07-24	CB	Futures	281.855	282.993	281.242	282.701	183.0
2019-07-24	CC	Futures	1650.0	1665.0	1635.0	1641.0	13750.0
2019-07-24	CNH	Futures	6.887	6.8892	6.8752	6.879	433.0
2019-07-24	CSC	Futures	3.115	3.146	3.114	3.129	29.0
2019-07-24	CT	Futures	62.74	63.37	62.74	63.09	17.0
2019-07-24	DC	Futures	26.32	26.51	26.27	26.45	226.0
2019-07-24	DX	Futures	93.811	93.941	93.643	93.828	14318.0
2019-07-24	E1	Futures	1.1829	1.18475	1.18	1.1822	15372.0
2019-07-24	E6	Futures	1.22194	1.22222	1.21862	1.21998	171721.0
2019-07-24	E7	Futures	1.2154	1.2159	1.2125	1.2137	3278.0
2019-07-24	EBM	Futures	200.94	202.96	200.94	201.81	16355.0
2019-07-24	ED	Futures	95.2843	95.3038	95.2843	95.2941	170007.0
2019-07-24	ER	Futures	98.538	98.548	98.533	98.543	153553.0
2019-07-24	EW	Futures	2053.4	2088.4	2050.0	2086.8	14405.0
2019-07-24	FBON	Futures	143.2	144.14	143.17	143.87	362.0
2019-07-24	FBTP	Futures	124.9	126.32	124.89	125.96	97962.0
2019-07-24	FBTS	Futures	107.657	107.945	107.657	107.849	53993.0
2019-07-24	FCE	Futures	5119.8	5130.2	5083.8	5105.2	61978.0
2019-07-24	FDAX	Futures	13172.9	13237.6	13126.5	13183.4	92753.0
2019-07-24	FDIV	Futures	149.57	149.57	149.52	149.52	11.0
2019-07-24	FDXM	Futures	13015.8	13072.0	12964.8	13021.0	32029.0
2019-07-24	FESX	Futures	3083.3	3092.0	3068.4	3080.6	725974.0
2019-07-24	FGBL	Futures	165.24	165.93	165.2	165.74	600428.0
2019-07-24	FGBM	Futures	134.8	135.0	134.76	134.87	400552.0
2019-07-24	FGBS	Futures	113.142	113.192	113.126	113.142	294972.0
2019-07-24	FGBX	Futures	209.98	212.43	209.84	211.96	43617.0
2019-07-24	FMWO	Futures	7443.3	7467.5	7416.8	7443.3	526.0
2019-07-24	FOAT	Futures	152.38	152.9	152.27	152.75	129344.0
2019-07-24	FTDX	Futures	2890.8	2904.6	2886.3	2899.1	13.0
2019-07-24	FTI	Futures	550.01	552.01	548.02	550.34	20300.0
2019-07-24	FTUK	Futures	6927.0	6927.9	6841.6	6872.5	91473.0
2019-07-24	FVSA	Futures	170.65	171.89	166.94	170.65	28110.0
2019-07-24	FXXP	Futures	350.0	351.0	348.6	350.0	38967.0
2019-07-24	G	Futures	121.36	121.66	121.28	121.56	171588.0
2019-07-24	GF	Futures	278.464	280.525	277.581	280.279	2598.0

> showing 50 of 118 rows — these rows as CSV

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