PREVIEW / futures_daily / 2018-11-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-23.parquet
  size:    9 KB
  rows:    109

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-23	ES	Futures	2873.95	2880.73	2847.93	2851.72	872856.0
2018-11-23	NQ	Futures	7647.78	7667.81	7544.11	7585.93	362540.0
2018-11-23	YM	Futures	25776.4	25842.7	25532.1	25546.8	170950.0
2018-11-23	CL	Futures	57.83	58.0	53.06	53.35	1014667.0
2018-11-23	GC	Futures	1554.9	1558.5	1546.6	1550.3	240354.0
2018-11-23	ZN	Futures	118.732494	118.981507	118.654678	118.810311	1247520.0
2018-11-23	A6	Futures	0.74712	0.74805	0.74311	0.74445	83191.0
2018-11-23	AD	Futures	0.7644	0.76738	0.76293	0.76622	82736.0
2018-11-23	B	Futures	46.25	46.41	43.17	43.46	279668.0
2018-11-23	B6	Futures	1.3153	1.3309	1.3147	1.3186	148323.0
2018-11-23	BR	Futures	0.20079	0.20079	0.19885	0.19957	2690.0
2018-11-23	BTC	Futures	6419.9	6608.1	5913.3	6065.3	5146.0
2018-11-23	BZ	Futures	46.62	46.83	42.89	43.16	56080.0
2018-11-23	C	Futures	1436.0	1437.0	1417.0	1420.0	2953.0
2018-11-23	CC	Futures	1470.0	1476.0	1461.0	1462.0	11535.0
2018-11-23	CNH	Futures	6.9698	6.9866	6.961	6.9845	704.0
2018-11-23	CT	Futures	85.76	85.76	84.03	84.1	3703.0
2018-11-23	DX	Futures	91.578	92.02	91.479	91.982	13661.0
2018-11-23	E1	Futures	1.19449	1.19698	1.18975	1.19011	18917.0
2018-11-23	E6	Futures	1.26827	1.2735	1.26193	1.26243	203792.0
2018-11-23	E7	Futures	1.2621	1.2672	1.2557	1.2563	3556.0
2018-11-23	EBM	Futures	208.98	209.5	206.9	207.16	12117.0
2018-11-23	ED	Futures	94.9694	94.9743	94.9548	94.9597	255970.0
2018-11-23	ER	Futures	98.386	98.391	98.381	98.386	93153.0
2018-11-23	EW	Futures	1923.4	1933.9	1903.2	1918.3	7221.0
2018-11-23	FBON	Futures	127.04	127.18	126.75	127.01	443.0
2018-11-23	FBTP	Futures	105.18	105.81	104.93	105.32	95659.0
2018-11-23	FBTS	Futures	103.183	103.529	103.089	103.314	79371.0
2018-11-23	FCE	Futures	4410.0	4434.2	4384.1	4415.0	54940.0
2018-11-23	FDAX	Futures	11723.5	11781.4	11658.3	11767.2	76813.0
2018-11-23	FDXM	Futures	11519.5	11577.3	11455.4	11563.4	37749.0
2018-11-23	FESX	Futures	2621.8	2636.1	2608.4	2628.5	724397.0
2018-11-23	FGBL	Futures	153.75	154.26	153.61	154.18	649263.0
2018-11-23	FGBM	Futures	131.34	131.49	131.27	131.44	341016.0
2018-11-23	FGBS	Futures	112.703	112.724	112.683	112.703	274682.0
2018-11-23	FGBX	Futures	178.08	179.98	177.86	179.83	55471.0
2018-11-23	FMWO	Futures	6585.9	6602.1	6550.0	6589.3	2816.0
2018-11-23	FOAT	Futures	140.78	141.14	140.73	141.08	140070.0
2018-11-23	FTDX	Futures	2453.6	2491.9	2453.6	2491.5	438.0
2018-11-23	FTI	Futures	477.22	478.38	472.44	476.72	21652.0
2018-11-23	FTUK	Futures	6233.5	6246.9	6178.6	6214.8	65168.0
2018-11-23	FVSA	Futures	351.79	359.85	346.75	350.78	17230.0
2018-11-23	FXXP	Futures	305.1	306.6	304.0	306.5	32319.0
2018-11-23	G	Futures	115.34	115.85	115.3	115.76	264594.0
2018-11-23	GF	Futures	319.715	321.76	318.962	321.545	2969.0
2018-11-23	GSCI	Futures	458.5	460.02	457.71	459.12	24.0
2018-11-23	HE	Futures	79.52	82.135	79.49	81.564	14363.0
2018-11-23	HG	Futures	3.2251	3.2441	3.1865	3.2101	35412.0
2018-11-23	HH	Futures	27.364	28.721	26.045	27.194	11806.0
2018-11-23	HO	Futures	1.2872	1.2956	1.223	1.2263	10696.0

> showing 50 of 109 rows — these rows as CSV

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