PREVIEW / futures_daily / 2019-11-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-01.parquet
  size:    10 KB
  rows:    120

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-11-01	ES	Futures	3286.67	3318.07	3283.43	3316.17	1279508.0
2019-11-01	NQ	Futures	9327.98	9412.97	9316.75	9404.04	348326.0
2019-11-01	YM	Futures	28336.0	28636.2	28301.3	28616.3	156759.0
2019-11-01	CL	Futures	55.32	57.55	55.24	57.42	538117.0
2019-11-01	GC	Futures	1869.0	1873.8	1857.0	1864.4	380987.0
2019-11-01	ZN	Futures	129.093543	129.310325	128.675464	128.845793	1624270.0
2019-11-01	A6	Futures	0.7082	0.71097	0.70717	0.70963	103851.0
2019-11-01	AD	Futures	0.76534	0.7667	0.76338	0.7663	76017.0
2019-11-01	ALI	Futures	2154.82	2183.66	2154.82	2175.47	70.0
2019-11-01	B	Futures	47.42	49.31	47.38	49.2	236093.0
2019-11-01	B6	Futures	1.3166	1.3208	1.316	1.3169	81345.0
2019-11-01	BR	Futures	0.20047	0.20322	0.19986	0.20208	6475.0
2019-11-01	BTC	Futures	13328.7	13516.4	13169.9	13335.9	2641.0
2019-11-01	BZ	Futures	46.85	48.63	46.73	48.53	28361.0
2019-11-01	C	Futures	1638.0	1677.0	1631.0	1671.0	8675.0
2019-11-01	CB	Futures	246.832	247.983	245.946	247.393	33.0
2019-11-01	CC	Futures	1577.0	1629.0	1566.0	1626.0	34713.0
2019-11-01	CNH	Futures	7.0448	7.0449	7.0312	7.0345	417.0
2019-11-01	CSC	Futures	3.517	3.541	3.51	3.534	93.0
2019-11-01	CT	Futures	62.74	63.18	62.11	62.52	24411.0
2019-11-01	DC	Futures	29.36	29.58	29.3	29.57	468.0
2019-11-01	DX	Futures	93.859	94.009	93.714	93.793	14890.0
2019-11-01	E1	Futures	1.16991	1.17129	1.16255	1.17037	29494.0
2019-11-01	E6	Futures	1.2122	1.21426	1.20943	1.21334	180420.0
2019-11-01	E7	Futures	1.2058	1.208	1.2032	1.2071	2971.0
2019-11-01	EBM	Futures	195.09	195.64	194.54	194.82	13975.0
2019-11-01	ED	Futures	95.3618	95.3666	95.3277	95.3326	324103.0
2019-11-01	ER	Futures	98.406	98.411	98.396	98.401	57526.0
2019-11-01	EW	Futures	2054.4	2084.1	2052.7	2083.5	14499.0
2019-11-01	FBON	Futures	145.16	145.17	144.73	144.78	36.0
2019-11-01	FBTP	Futures	131.49	131.55	130.54	130.81	73769.0
2019-11-01	FBTS	Futures	108.385	108.452	108.279	108.336	28938.0
2019-11-01	FCE	Futures	5229.0	5243.1	5207.2	5227.7	59628.0
2019-11-01	FDAX	Futures	13613.6	13702.8	13599.4	13660.6	75903.0
2019-11-01	FDIV	Futures	158.15	159.27	158.15	158.43	80.0
2019-11-01	FDXM	Futures	13425.5	13523.3	13421.3	13482.2	29440.0
2019-11-01	FESX	Futures	3165.8	3180.7	3157.9	3169.3	725892.0
2019-11-01	FGBL	Futures	166.0	166.14	165.53	165.59	485309.0
2019-11-01	FGBM	Futures	134.21	134.27	134.1	134.12	274276.0
2019-11-01	FGBS	Futures	112.764	112.774	112.739	112.749	169877.0
2019-11-01	FGBX	Futures	217.96	218.6	215.82	216.02	40203.0
2019-11-01	FMWO	Futures	7450.7	7507.5	7450.7	7489.3	2184.0
2019-11-01	FOAT	Futures	153.36	153.51	152.88	152.95	95033.0
2019-11-01	FTDX	Futures	2762.9	2788.1	2762.9	2787.1	89.0
2019-11-01	FTI	Futures	551.55	554.37	550.22	552.82	24815.0
2019-11-01	FTUK	Futures	6717.5	6757.4	6708.7	6734.2	93613.0
2019-11-01	FVSA	Futures	153.97	154.5	147.6	149.19	20795.0
2019-11-01	FXXP	Futures	360.1	361.5	359.1	360.3	38860.0
2019-11-01	G	Futures	121.6	121.81	121.2	121.24	153835.0
2019-11-01	GF	Futures	309.014	312.782	307.6	312.206	2021.0

> showing 50 of 120 rows — these rows as CSV

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