PREVIEW / futures_daily / 2019-11-14

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-14.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-14	ES	Futures	3351.9	3355.69	3336.2	3352.71	1105353.0
2019-11-14	NQ	Futures	9529.37	9548.38	9468.58	9525.33	381593.0
2019-11-14	YM	Futures	29154.8	29190.5	29008.9	29127.5	143715.0
2019-11-14	CL	Futures	58.63	59.07	57.96	58.08	238301.0
2019-11-14	GC	Futures	1805.9	1820.1	1803.1	1817.5	317400.0
2019-11-14	ZN	Futures	127.576071	128.303838	127.529618	128.179963	1644581.0
2019-11-14	A6	Futures	0.70184	0.70245	0.69517	0.69671	118154.0
2019-11-14	AD	Futures	0.76	0.76061	0.75909	0.7599	71105.0
2019-11-14	ALI	Futures	2163.93	2165.45	2143.89	2143.89	110.0
2019-11-14	B	Futures	49.94	50.42	49.57	49.68	234780.0
2019-11-14	B6	Futures	1.3079	1.3116	1.3051	1.3103	74436.0
2019-11-14	BR	Futures	0.19299	0.19388	0.19223	0.19271	4852.0
2019-11-14	BTC	Futures	12715.0	12751.1	12404.5	12527.2	2337.0
2019-11-14	BZ	Futures	49.21	49.72	48.89	49.0	27803.0
2019-11-14	C	Futures	1808.0	1823.0	1808.0	1810.0	5760.0
2019-11-14	CB	Futures	248.574	249.341	248.574	248.603	6.0
2019-11-14	CC	Futures	1750.0	1757.0	1730.0	1746.0	29998.0
2019-11-14	CNH	Futures	7.0239	7.0256	7.01	7.0163	1473.0
2019-11-14	CSC	Futures	3.403	3.405	3.367	3.369	102.0
2019-11-14	CT	Futures	62.47	63.19	62.15	62.56	10324.0
2019-11-14	DC	Futures	28.17	28.35	27.98	28.07	596.0
2019-11-14	DX	Futures	94.923	95.0	94.691	94.738	9437.0
2019-11-14	E1	Futures	1.16485	1.16784	1.16347	1.1668	21816.0
2019-11-14	E6	Futures	1.1954	1.19751	1.19328	1.19686	132498.0
2019-11-14	E7	Futures	1.1892	1.1912	1.1872	1.1907	2430.0
2019-11-14	EBM	Futures	194.54	195.36	194.0	194.27	16605.0
2019-11-14	ED	Futures	95.3229	95.3326	95.318	95.3229	191945.0
2019-11-14	ER	Futures	98.391	98.396	98.386	98.391	89425.0
2019-11-14	EW	Futures	2091.9	2095.2	2082.1	2091.8	12177.0
2019-11-14	FBON	Futures	142.81	143.19	142.49	142.62	680.0
2019-11-14	FBTP	Futures	128.75	128.93	127.57	128.05	112699.0
2019-11-14	FBTS	Futures	108.057	108.105	107.787	107.874	72196.0
2019-11-14	FCE	Futures	5339.4	5348.0	5322.6	5333.0	68928.0
2019-11-14	FDAX	Futures	13971.8	14005.6	13878.5	13911.2	89054.0
2019-11-14	FDIV	Futures	161.26	161.54	161.26	161.54	20.0
2019-11-14	FDXM	Futures	13781.6	13822.2	13697.3	13729.5	35921.0
2019-11-14	FESX	Futures	3240.4	3247.4	3224.6	3230.7	1051101.0
2019-11-14	FEU3	Futures	99.1	99.1	99.085	99.085	99.0
2019-11-14	FGBL	Futures	164.47	165.33	164.47	165.18	620787.0
2019-11-14	FGBM	Futures	133.74	134.01	133.74	133.96	382342.0
2019-11-14	FGBS	Futures	112.699	112.734	112.694	112.729	243246.0
2019-11-14	FGBX	Futures	212.91	215.98	212.83	215.44	50783.0
2019-11-14	FMWO	Futures	7542.8	7558.7	7524.6	7546.2	2531.0
2019-11-14	FOAT	Futures	152.01	152.45	151.96	152.34	122902.0
2019-11-14	FTDX	Futures	2935.7	2951.5	2926.8	2938.1	85.0
2019-11-14	FTI	Futures	570.62	572.72	568.99	569.8	18426.0
2019-11-14	FTUK	Futures	6791.7	6811.1	6744.4	6762.0	76894.0
2019-11-14	FVSA	Futures	142.92	144.94	140.89	142.92	15718.0
2019-11-14	FXXP	Futures	366.7	366.9	364.9	365.7	38711.0
2019-11-14	G	Futures	120.39	120.9	120.38	120.83	162388.0

> showing 50 of 120 rows — these rows as CSV

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