PREVIEW / futures_daily / 2019-11-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-20.parquet
  size:    10 KB
  rows:    121

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-20	ES	Futures	3373.82	3375.99	3345.95	3365.7	1693828.0
2019-11-20	NQ	Futures	9603.12	9620.41	9485.57	9555.58	526978.0
2019-11-20	YM	Futures	29272.4	29272.4	29019.4	29184.2	189292.0
2019-11-20	CL	Futures	56.43	58.58	56.01	58.21	674891.0
2019-11-20	GC	Futures	1816.6	1824.7	1808.5	1818.5	369970.0
2019-11-20	ZN	Futures	128.288354	128.721917	128.272869	128.629011	2142632.0
2019-11-20	A6	Futures	0.70081	0.70132	0.69712	0.69773	84487.0
2019-11-20	AD	Futures	0.75945	0.75955	0.75587	0.75678	95071.0
2019-11-20	ALI	Futures	2143.29	2150.88	2141.46	2148.45	251.0
2019-11-20	B	Futures	48.61	50.09	48.1	49.77	343310.0
2019-11-20	B6	Futures	1.3154	1.3157	1.3113	1.3148	79453.0
2019-11-20	BR	Futures	0.19206	0.19255	0.19142	0.19166	1543.0
2019-11-20	BTC	Futures	11761.9	11949.6	11617.5	11711.3	3885.0
2019-11-20	BZ	Futures	47.79	49.41	47.44	49.09	39331.0
2019-11-20	C	Futures	1793.0	1800.0	1780.0	1792.0	9179.0
2019-11-20	CB	Futures	247.983	248.042	247.629	248.042	38.0
2019-11-20	CC	Futures	1739.0	1739.0	1709.0	1719.0	19159.0
2019-11-20	CNH	Futures	7.0233	7.0388	7.0208	7.0292	707.0
2019-11-20	CSC	Futures	3.299	3.316	3.292	3.316	33.0
2019-11-20	CT	Futures	61.66	62.1	60.5	60.58	13229.0
2019-11-20	DC	Futures	27.6	27.75	27.42	27.68	499.0
2019-11-20	DX	Futures	94.459	94.652	94.459	94.54	10121.0
2019-11-20	E1	Futures	1.16324	1.16416	1.15967	1.1622	31949.0
2019-11-20	E6	Futures	1.2025	1.20298	1.1999	1.20168	157999.0
2019-11-20	E7	Futures	1.1963	1.1966	1.1936	1.1955	2336.0
2019-11-20	EBM	Futures	197.01	197.28	196.46	197.01	21956.0
2019-11-20	ED	Futures	95.352	95.3593	95.335	95.3423	346695.0
2019-11-20	ER	Futures	98.401	98.406	98.401	98.406	30439.0
2019-11-20	ESG	Futures	277.29	277.35	275.36	276.63	74.0
2019-11-20	EW	Futures	2101.2	2106.4	2081.0	2095.3	15159.0
2019-11-20	FBON	Futures	143.06	143.35	142.82	142.85	524.0
2019-11-20	FBTP	Futures	128.78	129.2	128.69	129.04	85265.0
2019-11-20	FBTS	Futures	108.076	108.124	108.038	108.105	76814.0
2019-11-20	FCE	Futures	5322.2	5335.7	5294.6	5327.6	75738.0
2019-11-20	FDAX	Futures	13926.5	13931.8	13786.7	13894.8	115284.0
2019-11-20	FDIV	Futures	160.94	160.94	159.54	160.52	120.0
2019-11-20	FDXM	Futures	13737.9	13748.3	13607.7	13713.4	48915.0
2019-11-20	FESX	Futures	3234.2	3236.9	3207.1	3229.0	1010686.0
2019-11-20	FGBL	Futures	165.19	165.73	165.14	165.28	703989.0
2019-11-20	FGBM	Futures	133.93	134.08	133.88	133.92	388236.0
2019-11-20	FGBS	Futures	112.719	112.739	112.709	112.724	249813.0
2019-11-20	FGBX	Futures	215.11	217.15	215.03	215.48	56419.0
2019-11-20	FMWO	Futures	7591.7	7599.7	7543.9	7596.2	3389.0
2019-11-20	FOAT	Futures	152.79	153.04	152.51	152.62	111402.0
2019-11-20	FTDX	Futures	2941.6	2966.3	2934.7	2962.3	93.0
2019-11-20	FTI	Futures	569.85	570.28	564.97	568.75	27131.0
2019-11-20	FTUK	Futures	6779.6	6780.1	6682.3	6726.8	150149.0
2019-11-20	FVSA	Futures	138.86	143.42	137.34	138.86	34209.0
2019-11-20	FXXP	Futures	365.9	365.9	363.1	365.1	42026.0
2019-11-20	G	Futures	121.12	121.22	120.63	120.74	193319.0

> showing 50 of 121 rows — these rows as CSV

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