PREVIEW / futures_daily / 2019-08-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-29.parquet
  size:    10 KB
  rows:    119

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-08-29	ES	Futures	3111.19	3162.45	3102.56	3158.13	1489670.0
2019-08-29	NQ	Futures	8729.63	8900.03	8690.77	8879.02	447668.0
2019-08-29	YM	Futures	27292.3	27728.0	27227.2	27697.6	187180.0
2019-08-29	CL	Futures	57.39	58.43	56.93	58.24	630760.0
2019-08-29	GC	Futures	1911.3	1924.1	1885.6	1895.8	455595.0
2019-08-29	ZN	Futures	130.706456	130.924196	130.208763	130.348739	1120486.0
2019-08-29	A6	Futures	0.69329	0.69514	0.69143	0.69246	67898.0
2019-08-29	AD	Futures	0.75758	0.75964	0.75697	0.75798	67139.0
2019-08-29	ALI	Futures	2138.66	2143.52	2130.46	2141.39	58.0
2019-08-29	B	Futures	46.26	46.8	45.89	46.72	367177.0
2019-08-29	B6	Futures	1.2479	1.2494	1.2432	1.2438	92884.0
2019-08-29	BTC	Futures	14023.0	14044.4	13430.1	13673.0	1611.0
2019-08-29	BZ	Futures	45.65	46.1	45.22	46.03	35170.0
2019-08-29	C	Futures	1543.0	1546.0	1522.0	1523.0	2372.0
2019-08-29	CB	Futures	264.516	264.516	263.925	263.925	2.0
2019-08-29	CC	Futures	1467.0	1472.0	1429.0	1434.0	21164.0
2019-08-29	CNH	Futures	7.1743	7.182	7.1464	7.1495	812.0
2019-08-29	CSC	Futures	2.996	3.013	2.996	3.01	11.0
2019-08-29	CT	Futures	57.63	58.15	57.0	58.15	40.0
2019-08-29	DC	Futures	25.41	25.56	25.41	25.49	99.0
2019-08-29	DX	Futures	94.485	94.822	94.451	94.793	19953.0
2019-08-29	E1	Futures	1.18336	1.18475	1.17582	1.17617	27724.0
2019-08-29	E6	Futures	1.21022	1.21158	1.20591	1.20705	186886.0
2019-08-29	E7	Futures	1.2039	1.2052	1.1995	1.2007	3375.0
2019-08-29	EBM	Futures	191.44	191.44	190.58	190.87	8203.0
2019-08-29	ED	Futures	95.3939	95.4036	95.372	95.3744	301104.0
2019-08-29	ER	Futures	98.548	98.558	98.538	98.553	110621.0
2019-08-29	EW	Futures	1938.2	1975.3	1933.1	1972.0	10767.0
2019-08-29	FBON	Futures	146.97	147.05	146.55	146.62	260.0
2019-08-29	FBTP	Futures	131.36	132.18	130.39	131.09	201389.0
2019-08-29	FBTS	Futures	108.385	108.433	108.232	108.357	91607.0
2019-08-29	FCE	Futures	4849.7	4944.8	4847.9	4936.2	79521.0
2019-08-29	FDAX	Futures	12295.7	12497.9	12242.0	12462.6	115482.0
2019-08-29	FDIV	Futures	141.78	142.57	141.78	142.57	110.0
2019-08-29	FDXM	Futures	12139.1	12342.9	12091.2	12309.1	48794.0
2019-08-29	FESX	Futures	2931.3	2984.6	2920.8	2978.5	989970.0
2019-08-29	FGBL	Futures	170.39	170.55	169.8	170.15	743838.0
2019-08-29	FGBM	Futures	136.06	136.21	135.95	136.14	676264.0
2019-08-29	FGBS	Futures	113.333	113.383	113.318	113.363	420245.0
2019-08-29	FGBX	Futures	233.35	233.74	229.5	231.02	87566.0
2019-08-29	FMWO	Futures	7101.8	7186.0	7101.8	7180.2	1109.0
2019-08-29	FOAT	Futures	156.73	156.74	156.06	156.42	140729.0
2019-08-29	FTDX	Futures	2700.2	2723.4	2699.3	2723.4	62.0
2019-08-29	FTI	Futures	517.81	526.05	517.53	524.48	28495.0
2019-08-29	FTUK	Futures	6554.4	6642.6	6536.9	6626.4	84451.0
2019-08-29	FVSA	Futures	230.14	230.77	213.21	214.46	21938.0
2019-08-29	FXXP	Futures	333.3	338.1	333.1	337.5	66367.0
2019-08-29	G	Futures	123.54	123.63	123.29	123.57	189088.0
2019-08-29	GF	Futures	270.644	275.629	269.728	271.458	1549.0
2019-08-29	GSCI	Futures	453.04	454.51	452.87	454.11	42.0

> showing 50 of 119 rows — these rows as CSV

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