PREVIEW / futures_daily / 2019-01-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-01-17.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-01-17	ES	Futures	2830.64	2864.2	2811.15	2853.11	1508869.0
2019-01-17	NQ	Futures	7722.22	7826.41	7655.36	7780.1	472761.0
2019-01-17	YM	Futures	25483.3	25788.1	25325.0	25653.1	201765.0
2019-01-17	CL	Futures	54.7	54.99	53.34	54.45	530183.0
2019-01-17	GC	Futures	1630.3	1631.7	1623.3	1628.3	191979.0
2019-01-17	ZN	Futures	121.269187	121.471484	120.895716	121.020206	1449617.0
2019-01-17	A6	Futures	0.7394	0.74466	0.73693	0.74239	118880.0
2019-01-17	AD	Futures	0.76496	0.76526	0.76116	0.76405	74080.0
2019-01-17	B	Futures	44.07	44.43	43.35	44.17	278415.0
2019-01-17	B6	Futures	1.3263	1.3388	1.3213	1.3375	110283.0
2019-01-17	BFX	Futures	4002.8	4014.5	4002.8	4014.5	41.0
2019-01-17	BR	Futures	0.21293	0.21293	0.21086	0.21225	50.0
2019-01-17	BTC	Futures	5219.2	5328.8	5138.8	5270.3	3564.0
2019-01-17	BZ	Futures	43.8	44.06	42.98	43.8	30131.0
2019-01-17	C	Futures	1475.0	1493.0	1470.0	1475.0	10746.0
2019-01-17	CB	Futures	275.508	276.055	273.352	273.959	73.0
2019-01-17	CC	Futures	1600.0	1631.0	1590.0	1609.0	16570.0
2019-01-17	CNH	Futures	6.7727	6.8081	6.7684	6.7956	765.0
2019-01-17	CSC	Futures	2.758	2.758	2.726	2.736	169.0
2019-01-17	CT	Futures	79.75	81.26	79.75	81.01	13742.0
2019-01-17	DC	Futures	23.67	23.72	23.41	23.46	421.0
2019-01-17	DX	Futures	91.279	91.484	91.197	91.281	17604.0
2019-01-17	E1	Futures	1.19429	1.19465	1.18736	1.18947	17837.0
2019-01-17	E6	Futures	1.26525	1.2663	1.26232	1.26453	156970.0
2019-01-17	E7	Futures	1.2591	1.2601	1.2562	1.2584	3293.0
2019-01-17	EBM	Futures	208.71	210.25	208.46	209.74	14595.0
2019-01-17	ED	Futures	95.0232	95.0281	95.0086	95.0183	269531.0
2019-01-17	ER	Futures	98.401	98.406	98.396	98.401	63732.0
2019-01-17	EW	Futures	1890.3	1918.7	1878.3	1910.9	16991.0
2019-01-17	FBON	Futures	130.23	130.55	130.14	130.36	536.0
2019-01-17	FBTP	Futures	111.66	112.19	111.41	111.57	88525.0
2019-01-17	FBTS	Futures	105.181	105.389	105.162	105.2	68535.0
2019-01-17	FCE	Futures	4282.0	4316.5	4271.3	4291.9	90132.0
2019-01-17	FDAX	Futures	11468.5	11535.7	11364.5	11459.0	99930.0
2019-01-17	FDIV	Futures	132.98	133.38	132.98	133.38	3.0
2019-01-17	FDXM	Futures	11440.0	11506.1	11337.3	11431.1	45795.0
2019-01-17	FESX	Futures	2614.1	2628.7	2598.8	2612.4	901544.0
2019-01-17	FEU3	Futures	99.006	99.006	99.006	99.006	100.0
2019-01-17	FGBL	Futures	156.62	156.78	156.15	156.22	566676.0
2019-01-17	FGBM	Futures	132.34	132.39	132.14	132.16	375825.0
2019-01-17	FGBS	Futures	112.759	112.764	112.708	112.713	260168.0
2019-01-17	FGBX	Futures	185.3	185.73	184.31	184.55	31232.0
2019-01-17	FMWO	Futures	6580.9	6651.9	6559.9	6615.8	1349.0
2019-01-17	FOAT	Futures	142.35	142.53	142.19	142.2	99837.0
2019-01-17	FTDX	Futures	2471.3	2500.6	2471.3	2496.6	80.0
2019-01-17	FTI	Futures	469.14	473.63	468.05	470.9	18582.0
2019-01-17	FTUK	Futures	6189.3	6193.4	6135.5	6168.3	89671.0
2019-01-17	FVSA	Futures	335.76	336.7	317.94	320.76	27722.0
2019-01-17	FXXP	Futures	305.0	308.3	304.3	306.6	36590.0
2019-01-17	G	Futures	116.45	116.54	116.1	116.16	187727.0

> showing 50 of 118 rows — these rows as CSV

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