PREVIEW / futures_daily / 2018-11-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-26.parquet
  size:    10 KB
  rows:    114

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-26	ES	Futures	2856.06	2902.42	2853.89	2895.65	1374735.0
2018-11-26	NQ	Futures	7593.47	7778.16	7585.34	7751.15	503369.0
2018-11-26	YM	Futures	25562.6	25972.3	25557.4	25903.8	189542.0
2018-11-26	CL	Futures	53.56	55.28	53.01	54.63	663108.0
2018-11-26	GC	Futures	1550.3	1555.5	1547.3	1548.2	142172.0
2018-11-26	ZN	Futures	118.857001	118.888127	118.592424	118.670241	2513332.0
2018-11-26	A6	Futures	0.74465	0.74887	0.74249	0.74403	68416.0
2018-11-26	AD	Futures	0.76501	0.76708	0.76278	0.76399	49602.0
2018-11-26	B	Futures	43.46	44.95	43.2	44.47	244619.0
2018-11-26	B6	Futures	1.3195	1.3242	1.3173	1.3187	58631.0
2018-11-26	BR	Futures	0.19957	0.20276	0.19957	0.20276	25.0
2018-11-26	BTC	Futures	6065.3	6141.5	5348.1	5500.7	1470.0
2018-11-26	BZ	Futures	43.16	44.35	42.71	43.9	28861.0
2018-11-26	C	Futures	1421.0	1430.0	1404.0	1417.0	3218.0
2018-11-26	CB	Futures	266.062	266.487	266.062	266.275	52.0
2018-11-26	CC	Futures	1469.0	1476.0	1450.0	1458.0	15768.0
2018-11-26	CNH	Futures	6.9832	6.9907	6.9705	6.98	235.0
2018-11-26	CSC	Futures	2.885	2.894	2.873	2.881	145.0
2018-11-26	CT	Futures	84.1	85.73	84.07	85.6	13771.0
2018-11-26	DC	Futures	23.89	23.96	23.8	23.84	118.0
2018-11-26	DX	Futures	91.963	92.153	91.73	92.128	11229.0
2018-11-26	E1	Futures	1.19023	1.19284	1.18809	1.18845	14762.0
2018-11-26	E6	Futures	1.26249	1.26777	1.26104	1.2616	147894.0
2018-11-26	E7	Futures	1.2563	1.2615	1.2548	1.2554	2431.0
2018-11-26	EBM	Futures	208.72	208.72	206.9	207.42	16259.0
2018-11-26	ED	Futures	94.9597	94.9646	94.9426	94.945	308636.0
2018-11-26	ER	Futures	98.386	98.391	98.381	98.386	38514.0
2018-11-26	EW	Futures	1920.0	1948.3	1917.7	1942.8	18196.0
2018-11-26	FBON	Futures	126.94	127.87	126.94	127.82	2193.0
2018-11-26	FBTP	Futures	105.9	107.47	105.81	106.57	138665.0
2018-11-26	FBTS	Futures	103.492	104.11	103.426	103.642	103785.0
2018-11-26	FCE	Futures	4431.5	4483.4	4431.5	4457.5	75378.0
2018-11-26	FDAX	Futures	11828.7	11974.8	11826.6	11947.5	99205.0
2018-11-26	FDXM	Futures	11623.8	11767.5	11621.8	11740.6	44146.0
2018-11-26	FESX	Futures	2641.1	2668.9	2639.4	2661.3	993765.0
2018-11-26	FGBL	Futures	154.01	154.07	153.74	153.83	628375.0
2018-11-26	FGBM	Futures	131.39	131.41	131.28	131.34	362182.0
2018-11-26	FGBS	Futures	112.703	112.703	112.673	112.683	242661.0
2018-11-26	FGBX	Futures	179.43	179.51	178.68	178.76	48082.0
2018-11-26	FMWO	Futures	6624.1	6663.5	6624.1	6651.9	1212.0
2018-11-26	FOAT	Futures	141.02	141.09	140.84	140.87	138433.0
2018-11-26	FTDX	Futures	2504.7	2527.3	2497.3	2526.8	249.0
2018-11-26	FTI	Futures	478.15	482.83	478.15	481.44	24073.0
2018-11-26	FTUK	Futures	6213.9	6302.8	6213.9	6296.1	108801.0
2018-11-26	FVSA	Futures	350.78	351.79	332.64	335.66	30121.0
2018-11-26	FXXP	Futures	308.1	310.8	307.8	310.2	33209.0
2018-11-26	G	Futures	115.76	115.85	115.58	115.66	361941.0
2018-11-26	GF	Futures	321.437	322.729	319.877	321.06	4036.0
2018-11-26	GSCI	Futures	457.82	461.55	457.82	460.53	21.0
2018-11-26	HE	Futures	81.714	81.744	78.107	78.828	23144.0

> showing 50 of 114 rows — these rows as CSV

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