PREVIEW / futures_daily / 2019-03-20

all futures daily files

  file:    by_date/futures_daily/2019/2019-03-20.parquet
  size:    10 KB
  rows:    114

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-03-20	ES	Futures	3064.73	3077.69	3043.12	3053.65	1693207.0
2019-03-20	NQ	Futures	8500.97	8593.14	8468.13	8537.26	550615.0
2019-03-20	YM	Futures	27352.6	27409.6	27123.6	27158.4	235252.0
2019-03-20	CL	Futures	60.88	61.9	60.13	61.85	786342.0
2019-03-20	GC	Futures	1632.5	1646.5	1622.6	1627.1	370397.0
2019-03-20	ZN	Futures	122.078156	122.85513	122.047077	122.730814	1540615.0
2019-03-20	A6	Futures	0.73178	0.73827	0.72848	0.73735	112278.0
2019-03-20	AD	Futures	0.7604	0.76429	0.75913	0.76343	68999.0
2019-03-20	B	Futures	49.08	49.74	48.74	49.69	235485.0
2019-03-20	B6	Futures	1.365	1.3655	1.3524	1.3628	137186.0
2019-03-20	BTC	Futures	6134.0	6180.1	6095.6	6164.7	2560.0
2019-03-20	BZ	Futures	48.58	49.34	48.35	49.29	35132.0
2019-03-20	C	Futures	1469.0	1473.0	1434.0	1436.0	11180.0
2019-03-20	CB	Futures	278.185	278.723	278.185	278.723	27.0
2019-03-20	CC	Futures	1478.0	1486.0	1442.0	1446.0	21731.0
2019-03-20	CNH	Futures	6.726	6.7327	6.6917	6.6917	654.0
2019-03-20	CSC	Futures	2.84	2.845	2.822	2.843	41.0
2019-03-20	CT	Futures	80.19	80.56	79.78	80.16	11184.0
2019-03-20	DC	Futures	23.8	23.89	23.66	23.89	191.0
2019-03-20	DX	Futures	91.864	92.046	91.222	91.252	25782.0
2019-03-20	E1	Futures	1.17741	1.1892	1.17543	1.18885	30667.0
2019-03-20	E6	Futures	1.25478	1.26592	1.25336	1.26565	201422.0
2019-03-20	E7	Futures	1.2488	1.2596	1.2471	1.2594	6275.0
2019-03-20	EBM	Futures	200.57	200.84	199.25	200.04	10634.0
2019-03-20	ED	Futures	95.1013	95.1257	95.1013	95.1111	274620.0
2019-03-20	ER	Futures	98.406	98.406	98.401	98.406	72636.0
2019-03-20	EW	Futures	2020.1	2025.3	1993.3	2004.4	18634.0
2019-03-20	FBON	Futures	133.99	134.17	133.94	134.16	312.0
2019-03-20	FBTP	Futures	114.57	114.7	114.09	114.55	82417.0
2019-03-20	FBTS	Futures	105.922	105.95	105.808	105.874	42574.0
2019-03-20	FCE	Futures	4809.1	4829.2	4786.4	4788.2	81334.0
2019-03-20	FDAX	Futures	12363.2	12369.0	12196.9	12248.0	131534.0
2019-03-20	FDIV	Futures	143.21	143.31	142.84	142.84	26.0
2019-03-20	FDXM	Futures	12251.9	12258.2	12091.2	12141.8	63222.0
2019-03-20	FESX	Futures	2896.4	2900.7	2872.8	2879.7	1044808.0
2019-03-20	FGBL	Futures	158.18	158.79	158.13	158.52	566885.0
2019-03-20	FGBM	Futures	132.36	132.52	132.31	132.43	364103.0
2019-03-20	FGBS	Futures	112.633	112.668	112.628	112.648	218763.0
2019-03-20	FGBX	Futures	188.76	190.32	188.56	189.7	31279.0
2019-03-20	FMWO	Futures	7101.6	7137.4	7064.5	7077.3	6109.0
2019-03-20	FOAT	Futures	145.23	145.51	145.17	145.47	106537.0
2019-03-20	FTDX	Futures	2665.2	2683.0	2635.6	2642.0	2623.0
2019-03-20	FTI	Futures	514.93	515.86	511.08	511.5	23674.0
2019-03-20	FTUK	Futures	6607.8	6657.8	6594.5	6618.8	103428.0
2019-03-20	FVSA	Futures	237.87	244.38	236.24	241.94	21677.0
2019-03-20	FXXP	Futures	335.9	336.7	333.2	334.5	47498.0
2019-03-20	G	Futures	117.29	117.78	117.27	117.73	186014.0
2019-03-20	GF	Futures	315.439	317.844	314.904	317.203	4226.0
2019-03-20	GSCI	Futures	492.37	497.18	492.37	497.18	3.0
2019-03-20	HE	Futures	78.011	81.121	78.011	81.121	447.0

> showing 50 of 114 rows — these rows as CSV

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