PREVIEW / futures_daily / 2018-10-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-02.parquet
  size:    10 KB
  rows:    116

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
2018-10-02	ES	Futures	3176.8	3184.13	3164.06	3175.99	1132507.0
2018-10-02	NQ	Futures	8914.71	8958.56	8862.73	8888.87	392577.0
2018-10-02	YM	Futures	28100.5	28260.5	27960.4	28228.9	164667.0
2018-10-02	CL	Futures	78.95	79.46	78.44	78.75	463615.0
2018-10-02	GC	Futures	1511.7	1536.5	1511.0	1529.8	365322.0
2018-10-02	ZN	Futures	118.156652	118.452355	118.141088	118.343412	1651670.0
2018-10-02	A6	Futures	0.74362	0.74527	0.73745	0.74002	89052.0
2018-10-02	AD	Futures	0.79029	0.7912	0.78862	0.79018	69614.0
2018-10-02	B	Futures	62.42	62.73	61.95	62.31	268609.0
2018-10-02	B6	Futures	1.3454	1.3466	1.3354	1.3393	87909.0
2018-10-02	BR	Futures	0.18978	0.19336	0.18978	0.19329	44.0
2018-10-02	BTC	Futures	9451.8	9502.3	9285.9	9394.1	1131.0
2018-10-02	BZ	Futures	62.03	62.26	61.49	61.84	25338.0
2018-10-02	C	Futures	1367.0	1434.0	1362.0	1427.0	12304.0
2018-10-02	CB	Futures	271.627	272.108	271.627	272.108	4.0
2018-10-02	CC	Futures	1400.0	1464.0	1398.0	1457.0	34818.0
2018-10-02	CNH	Futures	6.9512	6.9655	6.9434	6.9464	128.0
2018-10-02	CSC	Futures	3.246	3.246	3.226	3.226	30.0
2018-10-02	CT	Futures	85.53	86.22	85.03	85.52	13057.0
2018-10-02	DC	Futures	27.03	27.03	26.79	26.91	56.0
2018-10-02	DX	Futures	90.172	90.619	90.149	90.381	26489.0
2018-10-02	E1	Futures	1.21287	1.21393	1.20978	1.21156	22099.0
2018-10-02	E6	Futures	1.29473	1.29518	1.28673	1.29112	262987.0
2018-10-02	E7	Futures	1.2884	1.2887	1.2804	1.2848	4529.0
2018-10-02	EBM	Futures	210.01	210.27	207.68	207.94	17697.0
2018-10-02	ED	Futures	95.072	95.0818	95.0622	95.0622	435840.0
2018-10-02	ER	Futures	98.367	98.377	98.362	98.372	97048.0
2018-10-02	EW	Futures	2114.1	2118.7	2101.3	2105.0	14857.0
2018-10-02	FBON	Futures	127.74	127.77	127.49	127.67	601.0
2018-10-02	FBTP	Futures	104.79	104.94	103.78	104.19	184792.0
2018-10-02	FBTS	Futures	101.506	101.506	100.663	101.235	136811.0
2018-10-02	FCE	Futures	4945.5	4945.5	4900.9	4925.7	78068.0
2018-10-02	FDAX	Futures	12902.3	12931.7	12815.0	12901.2	84326.0
2018-10-02	FDIV	Futures	144.69	145.14	144.69	145.14	12.0
2018-10-02	FDXM	Futures	12678.8	12708.8	12594.1	12677.8	43405.0
2018-10-02	FESX	Futures	2844.4	2845.3	2820.1	2835.2	972026.0
2018-10-02	FGBL	Futures	152.22	152.91	152.17	152.66	903503.0
2018-10-02	FGBM	Futures	130.55	130.86	130.53	130.72	630588.0
2018-10-02	FGBS	Futures	112.567	112.618	112.562	112.588	735196.0
2018-10-02	FGBX	Futures	175.74	177.27	175.68	176.83	50278.0
2018-10-02	FMWO	Futures	7268.3	7289.2	7248.6	7284.5	634.0
2018-10-02	FOAT	Futures	139.73	140.1	139.6	140.0	172526.0
2018-10-02	FTDX	Futures	2788.6	2794.0	2768.0	2792.5	88.0
2018-10-02	FTI	Futures	511.67	511.67	506.61	509.63	26963.0
2018-10-02	FTUK	Futures	6670.5	6670.5	6620.9	6654.9	95671.0
2018-10-02	FVSA	Futures	259.66	271.74	259.66	265.7	42534.0
2018-10-02	FXXP	Futures	330.2	330.4	328.5	329.5	51626.0
2018-10-02	G	Futures	113.79	114.24	113.79	114.09	257831.0
2018-10-02	GF	Futures	330.296	330.972	327.643	330.92	2029.0
2018-10-02	GSCI	Futures	556.62	558.07	556.06	557.4	340.0

> showing 50 of 116 rows — these rows as CSV

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