PREVIEW / futures_daily / 2019-04-02

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-02.parquet
  size:    10 KB
  rows:    115

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-04-02	ES	Futures	3098.48	3104.15	3091.73	3096.86	859942.0
2019-04-02	NQ	Futures	8636.06	8678.98	8622.81	8663.72	359192.0
2019-04-02	YM	Futures	27692.5	27740.0	27577.5	27606.0	155142.0
2019-04-02	CL	Futures	63.47	64.43	63.25	64.26	793227.0
2019-04-02	GC	Futures	1608.3	1614.4	1604.9	1612.3	196403.0
2019-04-02	ZN	Futures	122.948367	123.181459	122.932828	123.088223	1346910.0
2019-04-02	A6	Futures	0.73395	0.73611	0.72807	0.7292	119596.0
2019-04-02	AD	Futures	0.7611	0.76115	0.75731	0.75888	58537.0
2019-04-02	B	Futures	50.42	50.68	50.03	50.53	299300.0
2019-04-02	B6	Futures	1.3426	1.3521	1.3381	1.3483	131177.0
2019-04-02	BR	Futures	0.20629	0.20681	0.20577	0.20681	169.0
2019-04-02	BTC	Futures	6389.0	7872.3	6381.3	7377.9	10442.0
2019-04-02	BZ	Futures	50.27	50.5	49.9	50.39	46166.0
2019-04-02	C	Futures	1557.0	1577.0	1550.0	1575.0	12588.0
2019-04-02	CB	Futures	279.411	279.56	277.228	278.095	44.0
2019-04-02	CC	Futures	1573.0	1602.0	1558.0	1590.0	30704.0
2019-04-02	CNH	Futures	6.7307	6.7423	6.7302	6.7371	565.0
2019-04-02	CSC	Futures	2.856	2.868	2.849	2.868	56.0
2019-04-02	CT	Futures	82.04	82.14	81.19	82.04	15142.0
2019-04-02	DC	Futures	24.09	24.28	24.09	24.28	125.0
2019-04-02	DX	Futures	92.876	93.067	92.808	92.902	13999.0
2019-04-02	E1	Futures	1.17683	1.17858	1.17519	1.17706	22715.0
2019-04-02	E6	Futures	1.23766	1.23881	1.23525	1.23684	168709.0
2019-04-02	E7	Futures	1.2317	1.2326	1.229	1.2307	4270.0
2019-04-02	EBM	Futures	197.92	198.72	197.4	198.19	13023.0
2019-04-02	ED	Futures	95.1453	95.1599	95.1453	95.1502	194863.0
2019-04-02	ER	Futures	98.411	98.421	98.411	98.416	30674.0
2019-04-02	EW	Futures	2041.6	2046.0	2028.0	2036.6	11472.0
2019-04-02	FBON	Futures	134.62	134.9	134.46	134.85	515.0
2019-04-02	FBTP	Futures	114.55	114.68	114.2	114.46	54533.0
2019-04-02	FBTS	Futures	105.722	105.722	105.57	105.617	52432.0
2019-04-02	FCE	Futures	4814.9	4847.4	4809.6	4827.4	57727.0
2019-04-02	FDAX	Futures	12336.4	12452.2	12289.5	12396.9	98286.0
2019-04-02	FDIV	Futures	142.89	143.96	142.89	143.96	35.0
2019-04-02	FDXM	Futures	12224.8	12343.7	12183.0	12289.5	40162.0
2019-04-02	FESX	Futures	2898.1	2915.6	2888.5	2902.5	739243.0
2019-04-02	FEU3	Futures	99.006	99.011	99.006	99.011	199.0
2019-04-02	FGBL	Futures	159.92	160.38	159.92	160.32	573934.0
2019-04-02	FGBM	Futures	133.0	133.2	132.99	133.18	461082.0
2019-04-02	FGBS	Futures	112.794	112.829	112.789	112.829	330933.0
2019-04-02	FGBX	Futures	193.98	195.33	193.98	195.18	42406.0
2019-04-02	FMWO	Futures	7159.4	7171.0	7139.7	7153.6	1210.0
2019-04-02	FOAT	Futures	146.72	146.86	146.54	146.82	145540.0
2019-04-02	FTDX	Futures	2684.4	2686.9	2672.6	2682.5	87.0
2019-04-02	FTI	Futures	519.14	522.52	518.77	520.4	17675.0
2019-04-02	FTUK	Futures	6654.1	6723.3	6654.1	6715.1	102190.0
2019-04-02	FVSA	Futures	246.01	248.46	241.94	244.38	25033.0
2019-04-02	FXXP	Futures	337.5	340.0	337.0	338.7	50442.0
2019-04-02	G	Futures	119.06	119.35	118.94	119.27	215659.0
2019-04-02	GF	Futures	312.338	312.872	308.007	309.771	2257.0

> showing 50 of 115 rows — these rows as CSV

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