PREVIEW / futures_daily / 2019-12-24

all futures daily files

  file:    by_date/futures_daily/2019/2019-12-24.parquet
  size:    9 KB
  rows:    100

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-24	ES	Futures	3486.55	3489.79	3480.34	3483.85	297971.0
2019-12-24	NQ	Futures	10011.47	10020.36	9987.1	10012.9	106029.0
2019-12-24	YM	Futures	29993.9	30023.3	29929.8	29939.2	44128.0
2019-12-24	CL	Futures	62.16	62.7	61.99	62.65	204535.0
2019-12-24	GC	Futures	1832.9	1851.6	1830.8	1851.3	183683.0
2019-12-24	ZN	Futures	127.003057	127.250838	126.863681	127.173407	398672.0
2019-12-24	A6	Futures	0.71045	0.71188	0.71004	0.71127	30160.0
2019-12-24	AD	Futures	0.76705	0.7671	0.76579	0.76645	24876.0
2019-12-24	ALI	Futures	2206.71	2206.71	2206.71	2206.71	0.0
2019-12-24	B	Futures	53.59	54.25	53.52	54.2	106430.0
2019-12-24	B6	Futures	1.316	1.3191	1.314	1.3186	34748.0
2019-12-24	BR	Futures	0.19896	0.19896	0.19896	0.19896	3.0
2019-12-24	BTC	Futures	11149.2	11331.1	11005.2	11027.9	640.0
2019-12-24	BZ	Futures	52.93	53.52	52.81	53.48	18562.0
2019-12-24	C	Futures	1677.0	1686.0	1673.0	1676.0	3662.0
2019-12-24	CB	Futures	246.451	246.746	246.451	246.746	2.0
2019-12-24	CC	Futures	1586.0	1603.0	1572.0	1598.0	13235.0
2019-12-24	CNH	Futures	6.9855	6.9888	6.9793	6.9803	151.0
2019-12-24	CSC	Futures	3.374	3.374	3.359	3.359	41.0
2019-12-24	CT	Futures	65.16	65.38	64.89	65.35	9396.0
2019-12-24	DC	Futures	28.2	28.27	28.09	28.11	36.0
2019-12-24	DX	Futures	94.4	94.526	94.342	94.391	4040.0
2019-12-24	E1	Futures	1.17079	1.17307	1.16885	1.17284	8323.0
2019-12-24	E6	Futures	1.20135	1.20183	1.19903	1.20119	46420.0
2019-12-24	E7	Futures	1.1952	1.1955	1.1929	1.1949	777.0
2019-12-24	EBM	Futures	205.22	206.05	204.95	205.77	3280.0
2019-12-24	ED	Futures	95.2792	95.2841	95.2744	95.2792	64661.0
2019-12-24	ER	Futures	98.367	98.372	98.362	98.362	4704.0
2019-12-24	EW	Futures	2176.9	2178.5	2172.8	2174.4	5120.0
2019-12-24	FCE	Futures	5460.3	5460.3	5449.0	5453.5	9548.0
2019-12-24	FTI	Futures	584.18	584.9	583.23	583.79	4129.0
2019-12-24	FTUK	Futures	7099.1	7113.7	7086.9	7109.4	17852.0
2019-12-24	G	Futures	120.11	120.55	119.82	120.39	38512.0
2019-12-24	GF	Futures	302.333	303.123	301.491	302.439	2077.0
2019-12-24	GSCI	Futures	484.47	485.14	484.47	485.14	4.0
2019-12-24	HE	Futures	52.935	53.539	52.557	53.369	8952.0
2019-12-24	HG	Futures	3.1843	3.2103	3.1775	3.2047	39233.0
2019-12-24	HH	Futures	13.698	13.698	13.395	13.444	4210.0
2019-12-24	HO	Futures	1.3409	1.3518	1.337	1.3484	11304.0
2019-12-24	HRC	Futures	1342.4	1342.4	1342.4	1342.4	0.0
2019-12-24	J1	Futures	0.0106536	0.0106641	0.0106507	0.0106554	37906.0
2019-12-24	J7	Futures	0.010627	0.010634	0.010623	0.010626	36.0
2019-12-24	JB	Futures	139.3	139.42	139.21	139.36	479.0
2019-12-24	KC	Futures	123.38	127.88	122.69	126.66	15731.0
2019-12-24	KE	Futures	638.85	649.64	638.15	640.94	11794.0
2019-12-24	L	Futures	99.355	99.37	99.355	99.365	9891.0
2019-12-24	LBS	Futures	636.9	638.4	634.0	634.4	48.0
2019-12-24	LE	Futures	168.068	168.135	167.601	168.068	8804.0
2019-12-24	M2K	Futures	1803.4	1807.8	1800.2	1806.6	8792.0
2019-12-24	MES	Futures	3446.28	3450.02	3440.94	3444.41	40939.0

> showing 50 of 100 rows — these rows as CSV

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