PREVIEW / futures_daily / 2019-11-19

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-19.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-19	ES	Futures	3379.23	3391.14	3369.76	3375.99	1195901.0
2019-11-19	NQ	Futures	9605.43	9656.13	9579.5	9612.92	373942.0
2019-11-19	YM	Futures	29407.8	29528.5	29237.7	29283.9	151389.0
2019-11-19	CL	Futures	58.2	58.42	56.32	56.52	566256.0
2019-11-19	GC	Futures	1815.7	1820.5	1807.3	1818.6	307855.0
2019-11-19	ZN	Futures	128.102541	128.334807	127.99415	128.272869	1255752.0
2019-11-19	A6	Futures	0.69876	0.70184	0.6966	0.70091	90274.0
2019-11-19	AD	Futures	0.76267	0.76373	0.75894	0.7592	78120.0
2019-11-19	ALI	Futures	2141.46	2141.46	2131.44	2132.96	167.0
2019-11-19	B	Futures	49.68	49.91	48.42	48.58	296802.0
2019-11-19	B6	Futures	1.3177	1.3198	1.3137	1.3138	77823.0
2019-11-19	BR	Futures	0.19231	0.19279	0.19142	0.19235	5962.0
2019-11-19	BTC	Futures	11841.3	11863.0	11559.7	11711.3	3007.0
2019-11-19	BZ	Futures	49.04	49.21	47.7	47.92	32258.0
2019-11-19	C	Futures	1797.0	1801.0	1787.0	1793.0	1326.0
2019-11-19	CB	Futures	249.135	249.135	247.983	247.983	14.0
2019-11-19	CC	Futures	1749.0	1752.0	1732.0	1735.0	18763.0
2019-11-19	CNH	Futures	7.0055	7.0218	7.0055	7.0183	519.0
2019-11-19	CSC	Futures	3.326	3.326	3.297	3.308	113.0
2019-11-19	CT	Futures	62.15	62.53	61.62	61.75	8816.0
2019-11-19	DC	Futures	27.69	27.84	27.51	27.6	415.0
2019-11-19	DX	Futures	94.444	94.497	94.367	94.47	7188.0
2019-11-19	E1	Futures	1.16462	1.16519	1.16197	1.16301	23270.0
2019-11-19	E6	Futures	1.20201	1.20331	1.20103	1.20271	112903.0
2019-11-19	E7	Futures	1.1959	1.1972	1.1948	1.1965	1792.0
2019-11-19	EBM	Futures	194.82	197.55	194.27	197.28	31068.0
2019-11-19	ED	Futures	95.3447	95.3545	95.3399	95.352	203213.0
2019-11-19	ER	Futures	98.396	98.401	98.391	98.401	50594.0
2019-11-19	ESG	Futures	277.76	278.67	277.71	278.67	23.0
2019-11-19	EW	Futures	2098.5	2107.9	2093.7	2102.9	10622.0
2019-11-19	FBON	Futures	143.05	143.16	142.81	142.96	277.0
2019-11-19	FBTP	Futures	128.98	129.17	128.37	128.65	73125.0
2019-11-19	FBTS	Futures	108.038	108.095	107.989	108.066	48388.0
2019-11-19	FCE	Futures	5369.2	5393.7	5328.1	5340.7	66902.0
2019-11-19	FDAX	Futures	13927.5	14111.7	13898.0	13946.5	110777.0
2019-11-19	FDIV	Futures	161.35	161.82	160.8	160.98	151.0
2019-11-19	FDXM	Futures	13737.9	13927.4	13719.1	13764.4	46002.0
2019-11-19	FESX	Futures	3243.9	3270.2	3230.7	3236.9	906403.0
2019-11-19	FGBL	Futures	165.03	165.19	164.86	165.1	448047.0
2019-11-19	FGBM	Futures	133.85	133.92	133.8	133.88	248275.0
2019-11-19	FGBS	Futures	112.679	112.719	112.679	112.709	145199.0
2019-11-19	FGBX	Futures	214.63	215.32	214.22	214.94	37960.0
2019-11-19	FMWO	Futures	7622.4	7645.2	7596.2	7607.6	3242.0
2019-11-19	FOAT	Futures	152.46	152.52	152.32	152.46	82855.0
2019-11-19	FTDX	Futures	2978.6	3005.8	2972.7	2977.1	135.0
2019-11-19	FTI	Futures	573.25	576.55	569.95	571.08	25816.0
2019-11-19	FTUK	Futures	6764.8	6857.5	6755.5	6774.5	111106.0
2019-11-19	FVSA	Futures	133.8	137.85	133.29	136.33	45820.0
2019-11-19	FXXP	Futures	367.4	369.8	365.7	366.3	34963.0
2019-11-19	G	Futures	120.45	120.75	120.38	120.67	181038.0

> showing 50 of 120 rows — these rows as CSV

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