PREVIEW / futures_daily / 2019-07-01

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-01.parquet
  size:    10 KB
  rows:    118

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-07-01	ES	Futures	3204.8	3217.48	3189.15	3202.37	1457722.0
2019-07-01	NQ	Futures	8959.03	9037.61	8933.13	8968.82	406594.0
2019-07-01	YM	Futures	28157.5	28241.5	27940.1	28035.7	202630.0
2019-07-01	CL	Futures	60.63	61.66	59.68	60.45	674887.0
2019-07-01	GC	Futures	1744.7	1744.8	1723.4	1729.2	389761.0
2019-07-01	ZN	Futures	127.020422	127.378138	126.942657	127.098186	1480141.0
2019-07-01	A6	Futures	0.72477	0.72507	0.71736	0.71746	109077.0
2019-07-01	AD	Futures	0.77124	0.77184	0.76786	0.76811	66144.0
2019-07-01	ALI	Futures	2190.9	2190.9	2190.9	2190.9	0.0
2019-07-01	B	Futures	48.9	50.18	48.28	48.91	361414.0
2019-07-01	B6	Futures	1.3011	1.3014	1.2939	1.2943	90077.0
2019-07-01	BR	Futures	0.20771	0.20779	0.20663	0.20707	52.0
2019-07-01	BTC	Futures	16105.7	16105.7	14208.9	14523.8	9774.0
2019-07-01	BZ	Futures	48.46	49.54	47.67	48.29	46308.0
2019-07-01	C	Futures	1737.0	1757.0	1737.0	1747.0	9909.0
2019-07-01	CC	Futures	1622.0	1670.0	1620.0	1666.0	21377.0
2019-07-01	CNH	Futures	6.8715	6.8715	6.8227	6.8643	1238.0
2019-07-01	CSC	Futures	3.132	3.142	3.119	3.142	100.0
2019-07-01	CT	Futures	66.19	67.01	64.94	65.15	84.0
2019-07-01	DC	Futures	26.17	26.38	26.08	26.35	293.0
2019-07-01	DX	Futures	92.213	92.839	92.213	92.823	21294.0
2019-07-01	E1	Futures	1.19415	1.19415	1.18127	1.18243	29907.0
2019-07-01	E6	Futures	1.24742	1.24796	1.23803	1.23853	214112.0
2019-07-01	E7	Futures	1.2408	1.2413	1.2317	1.2321	6970.0
2019-07-01	EBM	Futures	207.28	208.14	204.69	205.26	18042.0
2019-07-01	ED	Futures	95.3769	95.4109	95.3525	95.3671	334900.0
2019-07-01	ER	Futures	98.504	98.524	98.504	98.519	76452.0
2019-07-01	EW	Futures	2065.6	2077.6	2045.2	2054.2	15585.0
2019-07-01	FBON	Futures	142.58	143.45	142.55	143.35	548.0
2019-07-01	FBTP	Futures	120.71	122.09	120.51	122.05	110971.0
2019-07-01	FBTS	Futures	106.862	107.226	106.823	107.207	71199.0
2019-07-01	FCE	Futures	5102.5	5124.0	5078.3	5082.9	71144.0
2019-07-01	FDAX	Futures	13137.6	13275.0	13114.9	13171.8	109636.0
2019-07-01	FDIV	Futures	149.71	149.71	148.74	148.74	40.0
2019-07-01	FDXM	Futures	12982.5	13111.5	12954.4	13009.6	33600.0
2019-07-01	FESX	Futures	3040.5	3064.1	3035.2	3044.0	835186.0
2019-07-01	FEU3	Futures	99.124	99.144	99.124	99.144	99.0
2019-07-01	FGBL	Futures	164.09	164.81	163.99	164.78	622868.0
2019-07-01	FGBM	Futures	134.39	134.64	134.37	134.62	409228.0
2019-07-01	FGBS	Futures	113.081	113.116	113.066	113.106	214769.0
2019-07-01	FGBX	Futures	208.56	210.39	207.82	210.31	53004.0
2019-07-01	FMWO	Futures	7399.5	7421.4	7369.5	7385.6	2783.0
2019-07-01	FOAT	Futures	151.22	151.99	151.15	151.98	188419.0
2019-07-01	FTDX	Futures	2881.9	2902.1	2865.6	2880.9	119.0
2019-07-01	FTI	Futures	532.88	536.79	532.83	534.28	24824.0
2019-07-01	FTUK	Futures	6855.4	6894.7	6832.8	6867.0	101132.0
2019-07-01	FVSA	Futures	191.74	191.74	185.51	186.2	27954.0
2019-07-01	FXXP	Futures	346.5	348.0	345.8	345.9	73336.0
2019-07-01	G	Futures	119.66	120.32	119.64	120.24	187009.0
2019-07-01	GF	Futures	269.83	273.46	266.984	268.898	6750.0

> showing 50 of 118 rows — these rows as CSV

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