PREVIEW / futures_daily / 2019-12-31

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-31.parquet
  size:    9 KB
  rows:    101

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-31	ES	Futures	3481.15	3495.19	3470.08	3489.52	1157924.0
2019-12-31	NQ	Futures	10015.48	10061.94	9970.18	10039.0	284519.0
2019-12-31	YM	Futures	29854.2	29986.5	29763.9	29939.2	127526.0
2019-12-31	CL	Futures	63.23	63.44	62.16	62.6	494535.0
2019-12-31	GC	Futures	1867.2	1881.1	1866.9	1873.8	220847.0
2019-12-31	ZN	Futures	127.467646	127.467646	127.111461	127.281811	850930.0
2019-12-31	A6	Futures	0.71885	0.72224	0.71875	0.72152	67485.0
2019-12-31	AD	Futures	0.77184	0.77824	0.77149	0.77678	79730.0
2019-12-31	ALI	Futures	2221.49	2221.49	2215.76	2215.76	5.0
2019-12-31	B	Futures	54.49	54.72	53.66	53.96	171009.0
2019-12-31	B6	Futures	1.3331	1.3499	1.3317	1.3479	87712.0
2019-12-31	BR	Futures	0.2022	0.2031	0.2022	0.2031	689.0
2019-12-31	BTC	Futures	11058.3	11141.6	10853.6	10929.4	2953.0
2019-12-31	BZ	Futures	53.75	53.94	52.91	53.2	30892.0
2019-12-31	C	Futures	1710.0	1738.0	1707.0	1729.0	5822.0
2019-12-31	CB	Futures	246.421	248.485	245.183	245.213	26.0
2019-12-31	CC	Futures	1612.0	1665.0	1612.0	1662.0	18692.0
2019-12-31	CNH	Futures	6.957	6.957	6.9344	6.9352	225.0
2019-12-31	CSC	Futures	3.385	3.39	3.385	3.385	16.0
2019-12-31	CT	Futures	66.16	66.32	65.44	65.68	14440.0
2019-12-31	DC	Futures	28.19	28.22	28.07	28.19	47.0
2019-12-31	DX	Futures	93.58	93.58	93.196	93.233	11498.0
2019-12-31	E1	Futures	1.18564	1.19021	1.18392	1.18792	31284.0
2019-12-31	E6	Futures	1.21266	1.21659	1.21212	1.21541	119988.0
2019-12-31	E7	Futures	1.2064	1.2104	1.2058	1.2091	1823.0
2019-12-31	EBM	Futures	207.97	208.25	207.15	207.42	4719.0
2019-12-31	ED	Futures	95.3083	95.3229	95.3083	95.318	107366.0
2019-12-31	ER	Futures	98.367	98.372	98.362	98.367	11504.0
2019-12-31	EW	Futures	2170.7	2181.8	2165.6	2174.1	17326.0
2019-12-31	FCE	Futures	5410.0	5415.0	5386.9	5405.9	25488.0
2019-12-31	FTI	Futures	580.21	581.36	577.86	579.04	7533.0
2019-12-31	FTUK	Futures	7048.9	7055.0	7010.9	7035.3	35560.0
2019-12-31	G	Futures	119.37	119.93	119.22	119.83	65332.0
2019-12-31	GF	Futures	305.967	307.494	305.44	306.125	2222.0
2019-12-31	GSCI	Futures	485.42	486.87	485.36	485.59	130.0
2019-12-31	HE	Futures	54.124	54.256	53.463	53.916	12234.0
2019-12-31	HG	Futures	3.1967	3.1984	3.169	3.1701	42720.0
2019-12-31	HH	Futures	13.556	13.587	13.308	13.55	5241.0
2019-12-31	HO	Futures	1.3554	1.3576	1.3351	1.3393	27825.0
2019-12-31	HRC	Futures	1344.7	1363.1	1344.7	1349.3	3.0
2019-12-31	J1	Futures	0.0106965	0.0107348	0.0106936	0.0107226	75324.0
2019-12-31	J7	Futures	0.010665	0.010703	0.010665	0.010693	663.0
2019-12-31	JB	Futures	139.57	139.67	139.46	139.46	220.0
2019-12-31	KC	Futures	128.71	131.79	125.82	126.95	17376.0
2019-12-31	KE	Futures	668.08	677.82	664.6	676.43	19826.0
2019-12-31	KRW	Futures	0.000862	0.000862	0.0008619	0.0008619	1.0
2019-12-31	L	Futures	99.36	99.37	99.355	99.37	23952.0
2019-12-31	LBS	Futures	648.3	650.1	634.6	642.4	258.0
2019-12-31	LE	Futures	168.536	169.237	167.901	168.202	15118.0
2019-12-31	M2K	Futures	1793.3	1803.1	1785.7	1796.3	24831.0

> showing 50 of 101 rows — these rows as CSV

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