PREVIEW / futures_daily / 2019-10-31

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-31.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-10-31	ES	Futures	3303.73	3304.0	3269.62	3286.4	1766536.0
2019-10-31	NQ	Futures	9367.45	9379.55	9272.38	9323.37	448458.0
2019-10-31	YM	Futures	28524.9	28533.3	28183.7	28325.5	197544.0
2019-10-31	CL	Futures	56.09	56.79	54.87	55.35	677419.0
2019-10-31	GC	Futures	1848.8	1870.9	1845.4	1868.6	390013.0
2019-10-31	ZN	Futures	128.551589	129.232903	128.365776	129.124512	2201732.0
2019-10-31	A6	Futures	0.70892	0.71189	0.70717	0.70758	135722.0
2019-10-31	AD	Futures	0.76539	0.76695	0.76453	0.76534	92262.0
2019-10-31	ALI	Futures	2134.79	2134.79	2134.79	2134.79	0.0
2019-10-31	B	Futures	48.03	48.5	47.22	47.55	327505.0
2019-10-31	B6	Futures	1.3135	1.3212	1.3134	1.3174	109914.0
2019-10-31	BR	Futures	0.20265	0.20342	0.19986	0.20067	8289.0
2019-10-31	BTC	Futures	13321.5	13733.0	12996.6	13437.0	2086.0
2019-10-31	BZ	Futures	47.35	47.83	46.58	46.9	36213.0
2019-10-31	C	Futures	1673.0	1673.0	1632.0	1639.0	12801.0
2019-10-31	CB	Futures	247.393	247.983	247.098	247.865	30.0
2019-10-31	CC	Futures	1618.0	1624.0	1570.0	1577.0	32799.0
2019-10-31	CNH	Futures	7.0357	7.0473	7.0233	7.0448	1103.0
2019-10-31	CSC	Futures	3.502	3.566	3.498	3.498	205.0
2019-10-31	CT	Futures	63.85	64.2	62.32	62.72	35383.0
2019-10-31	DC	Futures	29.12	29.79	29.03	29.22	1493.0
2019-10-31	DX	Futures	94.0	94.0	93.768	93.902	17251.0
2019-10-31	E1	Futures	1.16657	1.17037	1.16634	1.16922	37084.0
2019-10-31	E6	Futures	1.21236	1.21474	1.20998	1.21138	208008.0
2019-10-31	E7	Futures	1.2061	1.2085	1.2038	1.2052	3077.0
2019-10-31	EBM	Futures	195.64	195.91	194.27	194.82	23741.0
2019-10-31	ED	Futures	95.3423	95.3666	95.3375	95.3618	354665.0
2019-10-31	ER	Futures	98.406	98.416	98.401	98.406	104734.0
2019-10-31	EW	Futures	2070.8	2071.0	2043.5	2053.5	15756.0
2019-10-31	FBON	Futures	144.64	145.36	144.64	145.13	333.0
2019-10-31	FBTP	Futures	131.1	131.57	131.03	131.42	90352.0
2019-10-31	FBTS	Futures	108.365	108.433	108.327	108.404	34602.0
2019-10-31	FCE	Futures	5237.2	5246.7	5186.8	5199.1	92596.0
2019-10-31	FDAX	Futures	13657.9	13661.6	13491.8	13604.7	109388.0
2019-10-31	FDIV	Futures	157.83	157.97	156.81	157.87	128.0
2019-10-31	FDXM	Futures	13461.9	13483.8	13316.1	13427.0	43714.0
2019-10-31	FESX	Futures	3176.4	3179.0	3144.8	3165.0	1044499.0
2019-10-31	FGBL	Futures	165.42	166.18	165.35	165.92	728516.0
2019-10-31	FGBM	Futures	133.99	134.25	133.98	134.17	440364.0
2019-10-31	FGBS	Futures	112.729	112.774	112.724	112.764	353291.0
2019-10-31	FGBX	Futures	215.67	218.79	215.44	217.98	57839.0
2019-10-31	FMWO	Futures	7460.9	7473.4	7409.7	7421.1	2866.0
2019-10-31	FOAT	Futures	153.05	153.64	153.01	153.37	146433.0
2019-10-31	FTDX	Futures	2773.8	2773.8	2744.7	2759.5	28.0
2019-10-31	FTI	Futures	553.6	554.8	547.64	548.84	32196.0
2019-10-31	FTUK	Futures	6782.9	6782.9	6688.8	6715.7	118825.0
2019-10-31	FVSA	Futures	154.5	161.93	152.91	157.16	31377.0
2019-10-31	FXXP	Futures	360.7	361.0	357.2	359.0	64967.0
2019-10-31	G	Futures	121.44	121.89	121.37	121.74	219584.0
2019-10-31	GF	Futures	308.857	309.903	306.763	309.014	2205.0

> showing 50 of 119 rows — these rows as CSV

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