PREVIEW / futures_daily / 2018-11-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-09.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-09	ES	Futures	3040.97	3048.83	2998.13	3013.86	1724880.0
2018-11-09	NQ	Futures	8299.97	8323.78	8117.9	8166.98	596695.0
2018-11-09	YM	Futures	27571.8	27627.6	27246.4	27350.7	208227.0
2018-11-09	CL	Futures	63.31	63.35	61.76	62.73	821729.0
2018-11-09	GC	Futures	1551.7	1552.1	1530.0	1531.8	322350.0
2018-11-09	ZN	Futures	117.285106	117.736442	117.269543	117.658626	1697861.0
2018-11-09	A6	Futures	0.74681	0.74836	0.74311	0.74393	96493.0
2018-11-09	AD	Futures	0.76905	0.76991	0.76455	0.76592	74167.0
2018-11-09	B	Futures	52.38	52.47	51.1	51.87	292213.0
2018-11-09	B6	Futures	1.3459	1.3462	1.3348	1.3366	115704.0
2018-11-09	BR	Futures	0.2022	0.20418	0.20174	0.2033	3508.0
2018-11-09	BTC	Futures	9264.3	9286.1	9032.7	9170.3	2878.0
2018-11-09	BZ	Futures	52.08	52.1	50.77	51.52	32611.0
2018-11-09	C	Futures	1528.0	1535.0	1509.0	1517.0	5533.0
2018-11-09	CB	Futures	264.718	265.259	264.538	264.658	9.0
2018-11-09	CC	Futures	1583.0	1596.0	1563.0	1576.0	34513.0
2018-11-09	CNH	Futures	6.978	6.996	6.978	6.9897	257.0
2018-11-09	CSC	Futures	2.914	2.914	2.892	2.908	27.0
2018-11-09	CT	Futures	88.69	88.89	86.65	87.65	36792.0
2018-11-09	DC	Futures	24.13	24.19	23.98	24.14	265.0
2018-11-09	DX	Futures	91.649	92.006	91.63	91.896	16027.0
2018-11-09	E1	Futures	1.18229	1.18359	1.17873	1.18241	20644.0
2018-11-09	E6	Futures	1.26716	1.26755	1.26171	1.26382	180120.0
2018-11-09	E7	Futures	1.2609	1.2613	1.2555	1.2576	3164.0
2018-11-09	EBM	Futures	207.42	208.2	207.42	207.42	23628.0
2018-11-09	ED	Futures	94.9597	94.9694	94.9548	94.9646	244332.0
2018-11-09	ER	Futures	98.386	98.386	98.381	98.386	16190.0
2018-11-09	EW	Futures	1999.9	2003.2	1966.9	1980.0	13942.0
2018-11-09	FBON	Futures	127.3	127.42	127.28	127.37	145.0
2018-11-09	FBTP	Futures	104.96	105.17	104.52	105.07	74717.0
2018-11-09	FBTS	Futures	102.743	102.799	102.555	102.743	64184.0
2018-11-09	FCE	Futures	4575.6	4584.2	4540.7	4572.5	79241.0
2018-11-09	FDAX	Futures	12066.3	12143.6	11995.3	12107.9	107604.0
2018-11-09	FDXM	Futures	11858.4	11932.8	11788.1	11898.2	50229.0
2018-11-09	FESX	Futures	2700.8	2714.2	2684.8	2705.0	999196.0
2018-11-09	FEU3	Futures	99.011	99.011	99.011	99.011	100.0
2018-11-09	FGBL	Futures	152.58	153.19	152.58	153.15	578906.0
2018-11-09	FGBM	Futures	130.88	131.08	130.87	131.07	297221.0
2018-11-09	FGBS	Futures	112.643	112.683	112.638	112.683	276584.0
2018-11-09	FGBX	Futures	176.2	177.75	176.2	177.69	37524.0
2018-11-09	FMWO	Futures	6882.5	6889.4	6828.0	6860.5	3346.0
2018-11-09	FOAT	Futures	139.8	140.24	139.8	140.2	117492.0
2018-11-09	FTDX	Futures	2622.1	2623.1	2588.2	2613.2	156.0
2018-11-09	FTI	Futures	490.79	495.09	488.65	492.95	25136.0
2018-11-09	FTUK	Futures	6346.6	6359.1	6300.5	6334.5	89569.0
2018-11-09	FVSA	Futures	315.84	325.35	312.99	321.55	30812.0
2018-11-09	FXXP	Futures	316.7	316.8	314.5	316.1	54412.0
2018-11-09	G	Futures	114.16	114.68	114.15	114.56	237180.0
2018-11-09	GF	Futures	312.256	312.256	308.514	309.813	1683.0
2018-11-09	GSCI	Futures	499.95	501.66	497.26	501.66	3073.0

> showing 50 of 114 rows — these rows as CSV

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