PREVIEW / futures_daily / 2019-07-08

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-08.parquet
  size:    10 KB
  rows:    120

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
2019-07-08	ES	Futures	3227.19	3231.5	3208.31	3213.97	1016611.0
2019-07-08	NQ	Futures	9043.66	9053.44	8954.43	8981.48	342228.0
2019-07-08	YM	Futures	28235.2	28270.9	28079.8	28133.3	147096.0
2019-07-08	CL	Futures	59.1	59.8	58.61	58.98	540861.0
2019-07-08	GC	Futures	1743.7	1754.8	1734.8	1742.5	318692.0
2019-07-08	ZN	Futures	126.880446	127.144845	126.74047	126.911551	1181049.0
2019-07-08	A6	Futures	0.72014	0.72116	0.71839	0.7188	57906.0
2019-07-08	AD	Futures	0.77214	0.77345	0.77028	0.77073	49006.0
2019-07-08	ALI	Futures	2212.28	2213.19	2212.28	2213.19	10.0
2019-07-08	B	Futures	48.37	48.97	47.96	48.2	253820.0
2019-07-08	B6	Futures	1.2833	1.2842	1.2802	1.2815	59044.0
2019-07-08	BR	Futures	0.20878	0.20922	0.20878	0.20902	3472.0
2019-07-08	BTC	Futures	16280.7	17533.6	16098.7	17421.6	3934.0
2019-07-08	BZ	Futures	47.78	48.35	47.36	47.59	29582.0
2019-07-08	C	Futures	1744.0	1809.0	1738.0	1808.0	4561.0
2019-07-08	CB	Futures	283.576	283.576	282.526	282.759	37.0
2019-07-08	CC	Futures	1645.0	1725.0	1642.0	1717.0	33548.0
2019-07-08	CNH	Futures	6.897	6.8998	6.8856	6.8896	587.0
2019-07-08	CSC	Futures	3.154	3.171	3.13	3.142	116.0
2019-07-08	CT	Futures	65.33	65.55	64.32	64.32	26.0
2019-07-08	DC	Futures	26.54	26.57	26.23	26.35	205.0
2019-07-08	DX	Futures	93.238	93.412	93.166	93.377	10670.0
2019-07-08	E1	Futures	1.17733	1.17907	1.17339	1.1742	19066.0
2019-07-08	E6	Futures	1.23176	1.23236	1.22942	1.23007	120331.0
2019-07-08	E7	Futures	1.225	1.2259	1.223	1.2236	2390.0
2019-07-08	EBM	Futures	206.13	206.41	203.25	203.53	10902.0
2019-07-08	ED	Futures	95.3184	95.333	95.3038	95.3184	275106.0
2019-07-08	ER	Futures	98.514	98.519	98.509	98.514	103979.0
2019-07-08	EW	Futures	2068.3	2068.3	2045.3	2048.8	12877.0
2019-07-08	FBON	Futures	143.92	144.15	143.02	143.09	1089.0
2019-07-08	FBTP	Futures	123.6	124.28	123.1	123.65	107347.0
2019-07-08	FBTS	Futures	107.235	107.389	107.226	107.312	55962.0
2019-07-08	FCE	Futures	5095.2	5116.2	5091.1	5107.1	54330.0
2019-07-08	FDAX	Futures	13197.6	13243.9	13130.7	13197.6	93553.0
2019-07-08	FDIV	Futures	148.87	148.87	148.78	148.78	10.0
2019-07-08	FDXM	Futures	13043.9	13080.3	12972.1	13035.0	33049.0
2019-07-08	FESX	Futures	3067.5	3077.2	3058.8	3070.2	631646.0
2019-07-08	FGBL	Futures	164.89	165.16	164.77	164.98	512875.0
2019-07-08	FGBM	Futures	134.56	134.68	134.48	134.54	322225.0
2019-07-08	FGBS	Futures	113.106	113.116	113.066	113.076	194885.0
2019-07-08	FGBX	Futures	210.58	211.71	210.17	210.99	45587.0
2019-07-08	FMWO	Futures	7426.0	7426.0	7387.9	7396.0	4558.0
2019-07-08	FOAT	Futures	152.47	152.69	152.11	152.25	120078.0
2019-07-08	FTDX	Futures	2883.4	2889.3	2867.6	2875.9	137.0
2019-07-08	FTI	Futures	535.47	538.01	534.9	535.95	21894.0
2019-07-08	FTUK	Futures	6918.7	6933.9	6896.5	6915.9	55538.0
2019-07-08	FVSA	Futures	183.43	185.51	182.05	182.74	34924.0
2019-07-08	FXXP	Futures	347.3	349.0	347.3	348.1	36248.0
2019-07-08	G	Futures	121.11	121.38	121.09	121.26	125657.0
2019-07-08	GF	Futures	271.792	274.049	270.566	272.577	6533.0

> showing 50 of 120 rows — these rows as CSV

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