PREVIEW / futures_daily / 2019-12-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-23.parquet
  size:    10 KB
  rows:    118

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-12-23	ES	Futures	3485.2	3493.03	3482.23	3485.47	665895.0
2019-12-23	NQ	Futures	9991.4	10028.68	9987.67	10009.46	194915.0
2019-12-23	YM	Futures	29921.4	30018.0	29904.6	29983.4	93613.0
2019-12-23	CL	Futures	61.93	62.3	61.61	62.04	314711.0
2019-12-23	GC	Futures	1823.8	1833.2	1822.3	1831.5	162446.0
2019-12-23	ZN	Futures	127.080489	127.250838	126.91014	126.956599	620132.0
2019-12-23	A6	Futures	0.7084	0.71178	0.70829	0.71127	54036.0
2019-12-23	AD	Futures	0.7667	0.76736	0.76529	0.76675	52607.0
2019-12-23	ALI	Futures	2200.38	2203.7	2195.86	2200.98	56.0
2019-12-23	B	Futures	53.35	53.73	53.08	53.55	131417.0
2019-12-23	B6	Futures	1.3212	1.3252	1.3122	1.3158	82971.0
2019-12-23	BR	Futures	0.19575	0.19952	0.19575	0.19855	27.0
2019-12-23	BTC	Futures	11164.3	11608.1	10968.7	11149.2	7852.0
2019-12-23	BZ	Futures	52.69	53.0	52.37	52.83	21599.0
2019-12-23	C	Futures	1660.0	1687.0	1657.0	1681.0	7853.0
2019-12-23	CB	Futures	248.19	248.219	247.6	248.219	14.0
2019-12-23	CC	Futures	1576.0	1588.0	1562.0	1588.0	22919.0
2019-12-23	CNH	Futures	6.9826	6.9905	6.979	6.9855	106.0
2019-12-23	CSC	Futures	3.381	3.381	3.37	3.377	45.0
2019-12-23	CT	Futures	64.65	65.39	64.27	65.26	16399.0
2019-12-23	DC	Futures	28.25	28.27	28.12	28.2	123.0
2019-12-23	DX	Futures	94.434	94.541	94.313	94.376	6525.0
2019-12-23	E1	Futures	1.16987	1.17273	1.16953	1.1709	17590.0
2019-12-23	E6	Futures	1.20016	1.20216	1.1993	1.20189	105834.0
2019-12-23	E7	Futures	1.1938	1.1959	1.193	1.1957	1957.0
2019-12-23	EBM	Futures	204.95	205.5	204.68	205.5	5520.0
2019-12-23	ED	Futures	95.2841	95.2889	95.2744	95.2792	227390.0
2019-12-23	ER	Futures	98.367	98.377	98.367	98.367	25307.0
2019-12-23	EW	Futures	2178.3	2183.7	2170.1	2175.6	10593.0
2019-12-23	FBON	Futures	142.84	143.22	142.84	143.06	54.0
2019-12-23	FBTP	Futures	127.88	127.96	127.32	127.59	33021.0
2019-12-23	FBTS	Futures	108.124	108.143	107.941	107.999	26517.0
2019-12-23	FCE	Futures	5439.0	5459.4	5430.4	5453.0	42895.0
2019-12-23	FDAX	Futures	14079.8	14102.6	14046.0	14064.0	56093.0
2019-12-23	FDXM	Futures	13896.8	13924.0	13868.7	13887.5	20675.0
2019-12-23	FESX	Futures	3314.5	3319.8	3307.4	3317.1	490596.0
2019-12-23	FGBL	Futures	163.87	164.17	163.62	163.74	193933.0
2019-12-23	FGBM	Futures	133.56	133.65	133.5	133.52	91346.0
2019-12-23	FGBS	Futures	112.689	112.699	112.674	112.679	72613.0
2019-12-23	FGBX	Futures	210.85	211.9	209.99	210.33	18624.0
2019-12-23	FMWO	Futures	7849.7	7854.2	7841.7	7849.7	4154.0
2019-12-23	FOAT	Futures	151.47	151.72	151.24	151.28	40325.0
2019-12-23	FTDX	Futures	3069.0	3078.5	3069.0	3074.5	71.0
2019-12-23	FTI	Futures	583.27	584.47	581.93	583.85	14357.0
2019-12-23	FTUK	Futures	7056.9	7104.7	7036.3	7096.3	61852.0
2019-12-23	FVSA	Futures	125.04	126.92	124.58	126.45	17185.0
2019-12-23	FXXP	Futures	379.9	380.5	379.0	379.9	34040.0
2019-12-23	G	Futures	120.4	120.63	120.13	120.23	90202.0
2019-12-23	GF	Futures	301.859	303.176	301.754	302.333	3142.0
2019-12-23	GSCI	Futures	480.91	483.86	480.91	482.24	72.0

> showing 50 of 118 rows — these rows as CSV

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