PREVIEW / futures_daily / 2019-09-06

all futures daily files

  file:    by_date/futures_daily/2019/2019-09-06.parquet
  size:    10 KB
  rows:    119

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-09-06	ES	Futures	3205.61	3224.49	3205.07	3216.4	1182287.0
2019-09-06	NQ	Futures	9041.93	9089.71	9024.37	9046.82	356484.0
2019-09-06	YM	Futures	28023.1	28213.1	28021.0	28149.1	143551.0
2019-09-06	CL	Futures	57.71	58.49	56.31	58.05	714294.0
2019-09-06	GC	Futures	1881.9	1895.0	1863.5	1869.4	544865.0
2019-09-06	ZN	Futures	130.068787	130.224316	129.633306	130.130999	18686.0
2019-09-06	A6	Futures	0.70162	0.70604	0.70059	0.7047	95853.0
2019-09-06	AD	Futures	0.76211	0.76615	0.7602	0.76519	97847.0
2019-09-06	ALI	Futures	2165.07	2186.32	2165.07	2177.52	140.0
2019-09-06	B	Futures	46.97	47.79	45.88	47.53	287357.0
2019-09-06	B6	Futures	1.2594	1.2604	1.2539	1.2553	125038.0
2019-09-06	BR	Futures	0.19639	0.19808	0.19639	0.19736	3.0
2019-09-06	BTC	Futures	15194.6	15901.8	14615.9	14944.5	6764.0
2019-09-06	BZ	Futures	46.27	47.09	45.21	46.83	37585.0
2019-09-06	C	Futures	1563.0	1576.0	1560.0	1566.0	2269.0
2019-09-06	CB	Futures	262.862	262.892	260.678	261.15	34.0
2019-09-06	CC	Futures	1465.0	1501.0	1463.0	1494.0	20432.0
2019-09-06	CNH	Futures	7.1398	7.1535	7.0992	7.1042	1385.0
2019-09-06	CSC	Futures	2.996	3.008	2.996	3.005	56.0
2019-09-06	CT	Futures	58.75	58.75	57.82	58.0	38.0
2019-09-06	DC	Futures	25.37	25.4	25.29	25.37	50.0
2019-09-06	DX	Futures	94.74	94.817	94.49	94.704	22160.0
2019-09-06	E1	Futures	1.17745	1.17768	1.17014	1.17478	26550.0
2019-09-06	E6	Futures	1.2046	1.20689	1.20285	1.204	197420.0
2019-09-06	E7	Futures	1.1985	1.2005	1.1966	1.1977	2917.0
2019-09-06	EBM	Futures	182.78	183.05	182.23	182.5	14505.0
2019-09-06	ED	Futures	95.3428	95.3452	95.3184	95.3355	293787.0
2019-09-06	ER	Futures	98.538	98.548	98.533	98.538	86433.0
2019-09-06	EW	Futures	2005.3	2018.3	2005.3	2008.0	9573.0
2019-09-06	FBON	Futures	145.13	146.11	145.12	146.07	383.0
2019-09-06	FBTP	Futures	131.31	132.11	131.17	131.95	93027.0
2019-09-06	FBTS	Futures	108.568	108.693	108.519	108.645	62967.0
2019-09-06	FCE	Futures	5064.4	5083.4	5054.9	5076.7	69753.0
2019-09-06	FDAX	Futures	12769.6	12850.1	12751.1	12827.5	78046.0
2019-09-06	FDIV	Futures	145.58	145.58	145.53	145.53	64.0
2019-09-06	FDXM	Futures	12612.3	12692.3	12594.6	12669.5	27007.0
2019-09-06	FESX	Futures	3038.7	3052.7	3034.4	3048.3	858826.0
2019-09-06	FGBL	Futures	168.57	169.38	168.32	169.27	682733.0
2019-09-06	FGBM	Futures	135.72	135.9	135.69	135.86	416607.0
2019-09-06	FGBS	Futures	113.222	113.262	113.212	113.242	261990.0
2019-09-06	FGBX	Futures	222.9	226.61	221.32	226.32	79186.0
2019-09-06	FMWO	Futures	7327.9	7342.9	7319.8	7341.8	11738.0
2019-09-06	FOAT	Futures	155.23	156.07	155.03	155.98	165718.0
2019-09-06	FTDX	Futures	2811.3	2836.5	2811.3	2825.6	237.0
2019-09-06	FTI	Futures	537.93	539.87	537.17	539.36	20627.0
2019-09-06	FTUK	Futures	6706.8	6740.0	6690.6	6724.8	68936.0
2019-09-06	FVSA	Futures	201.92	203.17	190.01	193.77	31346.0
2019-09-06	FXXP	Futures	345.3	347.4	344.7	347.0	39913.0
2019-09-06	G	Futures	121.84	122.91	121.84	122.89	247502.0
2019-09-06	GF	Futures	273.442	273.951	269.118	271.356	1407.0

> showing 50 of 119 rows — these rows as CSV

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