PREVIEW / futures_daily / 2018-11-02

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-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
2018-11-02	ES	Futures	2954.21	3000.03	2927.64	2954.48	2372699.0
2018-11-02	NQ	Futures	8115.87	8297.07	8027.6	8107.74	793339.0
2018-11-02	YM	Futures	26545.1	27046.4	26362.9	26579.9	304443.0
2018-11-02	CL	Futures	66.18	66.64	65.27	65.8	708906.0
2018-11-02	GC	Futures	1565.6	1569.6	1560.6	1563.1	256023.0
2018-11-02	ZN	Futures	118.203342	118.234468	117.518556	117.580809	2411856.0
2018-11-02	A6	Futures	0.74156	0.74722	0.7394	0.74023	172502.0
2018-11-02	AD	Futures	0.7734	0.77547	0.77128	0.77163	82569.0
2018-11-02	B	Futures	53.77	54.33	53.33	53.83	312874.0
2018-11-02	B6	Futures	1.3394	1.3437	1.3344	1.3355	118515.0
2018-11-02	BR	Futures	0.20536	0.20711	0.20532	0.20609	535.0
2018-11-02	BTC	Futures	9170.3	9228.2	9148.5	9184.7	1647.0
2018-11-02	BZ	Futures	53.34	53.94	52.98	53.46	36090.0
2018-11-02	C	Futures	1547.0	1553.0	1524.0	1551.0	10363.0
2018-11-02	CB	Futures	271.267	271.567	270.966	270.966	17.0
2018-11-02	CC	Futures	1580.0	1588.0	1556.0	1583.0	29777.0
2018-11-02	CNH	Futures	6.9683	6.9754	6.895	6.9345	1962.0
2018-11-02	CSC	Futures	3.082	3.102	3.05	3.06	43.0
2018-11-02	CT	Futures	88.71	89.55	87.89	88.44	16005.0
2018-11-02	DC	Futures	25.44	25.64	25.26	25.33	266.0
2018-11-02	DX	Futures	91.322	91.583	91.004	91.524	31266.0
2018-11-02	E1	Futures	1.18703	1.19343	1.18371	1.18383	28314.0
2018-11-02	E6	Futures	1.27233	1.27794	1.26855	1.26999	269419.0
2018-11-02	E7	Futures	1.2659	1.2715	1.2622	1.2638	4619.0
2018-11-02	EBM	Futures	208.98	209.5	207.94	208.72	16435.0
2018-11-02	ED	Futures	94.9743	94.9743	94.9499	94.9548	252119.0
2018-11-02	ER	Futures	98.381	98.386	98.381	98.386	99732.0
2018-11-02	EW	Futures	1952.0	1976.2	1941.0	1958.4	20239.0
2018-11-02	FBON	Futures	127.59	127.59	127.35	127.41	676.0
2018-11-02	FBTP	Futures	105.46	105.83	105.04	105.63	78694.0
2018-11-02	FBTS	Futures	102.743	103.005	102.508	102.864	84754.0
2018-11-02	FCE	Futures	4593.6	4619.5	4549.2	4565.3	98745.0
2018-11-02	FDAX	Futures	12192.5	12284.5	12066.3	12122.1	125106.0
2018-11-02	FDXM	Futures	11978.3	12072.3	11858.4	11912.1	65872.0
2018-11-02	FESX	Futures	2711.7	2724.3	2683.1	2696.6	1272563.0
2018-11-02	FEU3	Futures	99.006	99.011	99.006	99.011	396.0
2018-11-02	FGBL	Futures	152.86	152.94	152.6	152.77	658295.0
2018-11-02	FGBM	Futures	130.96	131.04	130.89	131.0	444002.0
2018-11-02	FGBS	Futures	112.683	112.708	112.668	112.698	302680.0
2018-11-02	FGBX	Futures	177.13	177.41	176.24	176.77	44335.0
2018-11-02	FMWO	Futures	6860.5	6872.1	6743.4	6770.1	9889.0
2018-11-02	FOAT	Futures	140.2	140.29	140.05	140.14	108742.0
2018-11-02	FTDX	Futures	2669.2	2672.2	2614.7	2619.1	581.0
2018-11-02	FTI	Futures	489.77	492.38	483.98	485.63	33881.0
2018-11-02	FTUK	Futures	6341.2	6408.2	6297.4	6318.4	112543.0
2018-11-02	FVSA	Futures	352.94	366.26	343.43	360.55	32901.0
2018-11-02	FXXP	Futures	317.1	318.1	313.5	314.8	62235.0
2018-11-02	G	Futures	114.65	114.78	114.47	114.57	242718.0
2018-11-02	GF	Futures	319.482	319.534	316.571	317.091	1134.0
2018-11-02	GSCI	Futures	515.72	515.72	513.6	514.92	143.0

> showing 50 of 115 rows — these rows as CSV

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