PREVIEW / futures_daily / 2019-12-19

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-19.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-19	ES	Futures	3455.5	3470.89	3450.1	3468.73	1137443.0
2019-12-19	NQ	Futures	9892.75	9958.99	9874.4	9948.67	283145.0
2019-12-19	YM	Futures	29710.3	29850.0	29672.5	29826.9	139569.0
2019-12-19	CL	Futures	62.34	62.95	62.22	62.72	426341.0
2019-12-19	GC	Futures	1820.1	1827.9	1817.2	1826.2	201186.0
2019-12-19	ZN	Futures	127.095975	127.266324	126.786249	127.173407	1205409.0
2019-12-19	A6	Futures	0.70378	0.70768	0.70368	0.70747	86759.0
2019-12-19	AD	Futures	0.76872	0.76917	0.76736	0.76847	58096.0
2019-12-19	ALI	Futures	2188.32	2188.32	2184.7	2187.71	48.0
2019-12-19	B	Futures	53.38	53.86	53.25	53.67	249537.0
2019-12-19	B6	Futures	1.3304	1.3356	1.3209	1.3234	138976.0
2019-12-19	BR	Futures	0.19961	0.19961	0.19944	0.19944	66.0
2019-12-19	BTC	Futures	10953.6	11194.3	10615.1	10780.6	4596.0
2019-12-19	BZ	Futures	52.62	53.14	52.55	52.95	29280.0
2019-12-19	C	Futures	1692.0	1700.0	1666.0	1667.0	11341.0
2019-12-19	CB	Futures	246.127	247.335	246.127	247.335	15.0
2019-12-19	CC	Futures	1639.0	1646.0	1587.0	1593.0	28035.0
2019-12-19	CNH	Futures	6.9805	6.9856	6.9736	6.9806	255.0
2019-12-19	CSC	Futures	3.353	3.377	3.338	3.346	87.0
2019-12-19	CT	Futures	63.48	64.57	63.43	64.28	16097.0
2019-12-19	DC	Futures	28.14	28.28	27.85	27.93	164.0
2019-12-19	DX	Futures	94.123	94.211	93.958	94.104	10317.0
2019-12-19	E1	Futures	1.17296	1.17673	1.1717	1.17593	27370.0
2019-12-19	E6	Futures	1.2048	1.2076	1.20361	1.20533	149558.0
2019-12-19	E7	Futures	1.1984	1.2012	1.1974	1.1991	1923.0
2019-12-19	EBM	Futures	203.85	205.22	203.58	204.4	13991.0
2019-12-19	ED	Futures	95.3035	95.3035	95.2841	95.2938	219081.0
2019-12-19	ER	Futures	98.377	98.382	98.372	98.377	71308.0
2019-12-19	EW	Futures	2159.6	2168.3	2155.6	2166.8	12601.0
2019-12-19	FBON	Futures	143.02	143.02	142.68	142.93	362.0
2019-12-19	FBTP	Futures	128.39	128.5	127.58	127.93	75852.0
2019-12-19	FBTS	Futures	108.163	108.191	107.999	108.095	61272.0
2019-12-19	FCE	Futures	5400.1	5403.2	5373.8	5401.4	43630.0
2019-12-19	FDAX	Futures	13978.9	14020.1	13904.3	13972.0	50582.0
2019-12-19	FDIV	Futures	160.24	160.38	159.96	160.38	100.0
2019-12-19	FDXM	Futures	13811.2	13843.6	13729.8	13796.6	5036.0
2019-12-19	FESX	Futures	3288.9	3290.7	3268.7	3281.9	1001435.0
2019-12-19	FGBL	Futures	163.9	163.96	163.24	163.6	562470.0
2019-12-19	FGBM	Futures	133.57	133.58	133.33	133.48	380558.0
2019-12-19	FGBS	Futures	112.684	112.684	112.649	112.669	203718.0
2019-12-19	FGBX	Futures	211.19	211.44	209.26	210.29	44026.0
2019-12-19	FMWO	Futures	7796.4	7815.7	7786.2	7806.6	11676.0
2019-12-19	FOAT	Futures	151.28	151.31	150.89	151.16	102323.0
2019-12-19	FTDX	Futures	3049.4	3062.4	3044.4	3062.4	786.0
2019-12-19	FTI	Futures	581.26	581.84	578.73	580.6	13488.0
2019-12-19	FTUK	Futures	7052.2	7066.3	7008.1	7058.8	119370.0
2019-12-19	FVSA	Futures	128.79	130.2	125.51	126.45	16113.0
2019-12-19	FXXP	Futures	376.8	377.4	375.7	376.8	87556.0
2019-12-19	G	Futures	120.07	120.19	119.7	119.86	197049.0
2019-12-19	GF	Futures	304.334	306.388	303.966	304.861	3736.0

> showing 50 of 118 rows — these rows as CSV

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