PREVIEW / futures_daily / 2020-03-09

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-09.parquet
  size:    10 KB
  rows:    121

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
2020-03-09	ES	Futures	3149.32	3149.32	2932.24	2967.61	2672753.0
2020-03-09	NQ	Futures	9599.4	9606.29	8969.69	9120.52	560913.0
2020-03-09	YM	Futures	26629.0	26629.0	24731.3	25075.7	335681.0
2020-03-09	CL	Futures	33.56	35.61	27.92	31.79	1774383.0
2020-03-09	GC	Futures	2063.7	2078.0	2021.5	2043.1	504155.0
2020-03-09	ZN	Futures	136.821365	139.044094	136.790493	137.762938	3146032.0
2020-03-09	A6	Futures	0.676	0.68543	0.64709	0.67672	212698.0
2020-03-09	AD	Futures	0.74227	0.74544	0.73234	0.73939	211633.0
2020-03-09	ALI	Futures	2008.33	2015.25	2006.22	2008.93	66.0
2020-03-09	B	Futures	32.56	32.61	26.39	29.23	779723.0
2020-03-09	B6	Futures	1.3264	1.3389	1.3219	1.3299	215086.0
2020-03-09	BR	Futures	0.17087	0.17222	0.16915	0.17222	366.0
2020-03-09	BTC	Futures	12068.2	12090.1	11155.6	11462.2	9510.0
2020-03-09	BZ	Futures	32.49	32.49	25.87	28.45	76517.0
2020-03-09	C	Futures	1746.0	1746.0	1705.0	1717.0	1890.0
2020-03-09	CB	Futures	215.118	215.118	213.585	215.09	19.0
2020-03-09	CC	Futures	1661.0	1685.0	1643.0	1667.0	25677.0
2020-03-09	CNH	Futures	6.885	6.9212	6.8731	6.9119	796.0
2020-03-09	CSC	Futures	3.165	3.165	3.135	3.137	267.0
2020-03-09	CT	Futures	59.69	60.17	58.25	58.93	30022.0
2020-03-09	DC	Futures	26.03	26.03	25.72	25.81	240.0
2020-03-09	DX	Futures	92.905	92.963	91.828	92.08	102134.0
2020-03-09	E1	Futures	1.22539	1.24446	1.22447	1.23692	68345.0
2020-03-09	E6	Futures	1.22257	1.23911	1.22209	1.23523	424629.0
2020-03-09	E7	Futures	1.2166	1.2326	1.2159	1.2288	16662.0
2020-03-09	EBM	Futures	200.45	204.36	198.5	199.89	47949.0
2020-03-09	ED	Futures	96.1183	96.3317	96.1183	96.2711	508154.0
2020-03-09	ER	Futures	98.47	98.494	98.455	98.48	79411.0
2020-03-09	ESG	Futures	253.34	254.13	246.61	246.61	90.0
2020-03-09	EW	Futures	1869.5	1869.5	1704.5	1714.5	29181.0
2020-03-09	FBON	Futures	145.55	146.35	144.91	145.82	811.0
2020-03-09	FBTP	Futures	129.44	129.46	126.41	127.41	186680.0
2020-03-09	FBTS	Futures	107.518	107.605	106.595	107.095	119563.0
2020-03-09	FCE	Futures	4333.3	4400.3	4130.3	4256.0	268157.0
2020-03-09	FDAX	Futures	11681.4	11730.0	10945.4	11300.2	172270.0
2020-03-09	FDIV	Futures	125.49	125.49	124.29	124.47	79.0
2020-03-09	FDXM	Futures	11567.1	11582.8	10794.4	11158.3	116290.0
2020-03-09	FESX	Futures	2727.0	2734.0	2527.0	2620.4	4120251.0
2020-03-09	FGBL	Futures	172.26	174.3	172.1	173.25	1000457.0
2020-03-09	FGBM	Futures	136.25	137.05	136.12	136.72	503070.0
2020-03-09	FGBS	Futures	113.268	113.6	113.247	113.514	549581.0
2020-03-09	FGBX	Futures	241.12	254.86	240.99	246.06	80214.0
2020-03-09	FMWO	Futures	6713.4	6803.0	6566.0	6734.9	10695.0
2020-03-09	FOAT	Futures	157.64	158.2	156.59	157.52	197331.0
2020-03-09	FTDX	Futures	2614.3	2697.2	2602.2	2659.0	493.0
2020-03-09	FTI	Futures	475.2	484.99	458.07	470.55	69393.0
2020-03-09	FTUK	Futures	5893.1	5893.6	5444.7	5620.1	334575.0
2020-03-09	FVSA	Futures	366.06	414.46	341.25	345.32	117407.0
2020-03-09	FXXP	Futures	313.4	319.2	301.1	310.5	247063.0
2020-03-09	G	Futures	127.22	128.09	126.83	126.99	317965.0

> showing 50 of 121 rows — these rows as CSV

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