PREVIEW / futures_daily / 2019-12-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-09.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-12-09	ES	Futures	3406.3	3409.55	3389.79	3393.31	1145426.0
2019-12-09	NQ	Futures	9682.06	9711.74	9619.26	9629.63	292419.0
2019-12-09	YM	Futures	29415.1	29443.5	29266.1	29291.3	109241.0
2019-12-09	CL	Futures	60.36	60.5	59.46	60.27	511561.0
2019-12-09	GC	Futures	1801.2	1808.3	1799.9	1802.2	177222.0
2019-12-09	ZN	Futures	127.746399	128.025152	127.69994	127.823831	1085164.0
2019-12-09	A6	Futures	0.70163	0.70173	0.69989	0.70112	86564.0
2019-12-09	AD	Futures	0.7597	0.76186	0.7594	0.76146	68093.0
2019-12-09	ALI	Futures	2166.37	2172.14	2153.61	2154.52	129.0
2019-12-09	B	Futures	51.85	52.02	51.3	51.82	239772.0
2019-12-09	B6	Futures	1.3356	1.3405	1.3355	1.3372	126550.0
2019-12-09	BR	Futures	0.19449	0.19559	0.19449	0.19559	1271.0
2019-12-09	BTC	Futures	11389.9	11593.1	10968.7	11013.8	3527.0
2019-12-09	BZ	Futures	51.25	51.33	50.62	51.13	32410.0
2019-12-09	C	Futures	1757.0	1760.0	1744.0	1752.0	1402.0
2019-12-09	CB	Futures	243.238	243.238	242.884	242.884	18.0
2019-12-09	CC	Futures	1714.0	1714.0	1690.0	1701.0	11082.0
2019-12-09	CNH	Futures	7.0158	7.0279	7.0148	7.0205	637.0
2019-12-09	CSC	Futures	3.348	3.351	3.335	3.34	42.0
2019-12-09	CT	Futures	62.79	63.02	61.65	62.19	19314.0
2019-12-09	DC	Futures	28.41	28.41	28.04	28.15	77.0
2019-12-09	DX	Futures	94.396	94.43	94.261	94.342	21769.0
2019-12-09	E1	Futures	1.16266	1.16542	1.16128	1.16485	25280.0
2019-12-09	E6	Futures	1.19908	1.20125	1.19854	1.19973	197297.0
2019-12-09	E7	Futures	1.1928	1.195	1.192	1.1935	3589.0
2019-12-09	EBM	Futures	201.1	201.93	201.1	201.38	11817.0
2019-12-09	ED	Futures	95.3447	95.3472	95.3423	95.3472	128591.0
2019-12-09	ER	Futures	98.391	98.396	98.391	98.391	27079.0
2019-12-09	EW	Futures	2126.5	2127.2	2112.5	2114.8	8479.0
2019-12-09	FBON	Futures	142.54	142.79	142.54	142.72	39.0
2019-12-09	FBTP	Futures	127.39	128.16	127.38	128.1	48514.0
2019-12-09	FBTS	Futures	107.903	108.066	107.903	108.066	30503.0
2019-12-09	FCE	Futures	5309.0	5313.1	5270.1	5282.8	53756.0
2019-12-09	FDAX	Futures	13892.7	13906.4	13794.1	13825.7	64696.0
2019-12-09	FDIV	Futures	160.24	160.24	159.17	159.17	85.0
2019-12-09	FDXM	Futures	13716.0	13726.4	13615.0	13645.2	23685.0
2019-12-09	FESX	Futures	3233.4	3236.0	3211.4	3217.6	612727.0
2019-12-09	FGBL	Futures	164.38	164.85	164.31	164.64	374594.0
2019-12-09	FGBM	Futures	133.7	133.85	133.68	133.82	292400.0
2019-12-09	FGBS	Futures	112.684	112.714	112.684	112.709	170672.0
2019-12-09	FGBX	Futures	212.48	213.8	212.38	213.13	30208.0
2019-12-09	FMWO	Futures	7655.4	7663.3	7631.5	7653.1	4247.0
2019-12-09	FOAT	Futures	151.67	152.03	151.65	151.87	78033.0
2019-12-09	FTDX	Futures	3002.8	3015.1	3002.8	3010.2	48.0
2019-12-09	FTI	Futures	576.55	578.32	575.21	576.52	17903.0
2019-12-09	FTUK	Futures	6685.6	6725.4	6682.3	6700.4	75220.0
2019-12-09	FVSA	Futures	137.34	146.97	135.82	140.38	22209.0
2019-12-09	FXXP	Futures	368.3	368.7	366.9	367.5	49541.0
2019-12-09	G	Futures	120.43	120.65	120.25	120.36	128391.0
2019-12-09	GF	Futures	297.014	299.437	295.908	298.12	7356.0

> showing 50 of 120 rows — these rows as CSV

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