PREVIEW / futures_daily / 2019-08-28

all futures daily files

  file:    by_date/futures_daily/2019/2019-08-28.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-08-28	ES	Futures	3092.85	3119.01	3077.2	3118.2	1489617.0
2019-08-28	NQ	Futures	8708.62	8756.69	8639.83	8749.2	480975.0
2019-08-28	YM	Futures	27044.5	27346.9	26901.7	27339.5	210924.0
2019-08-28	CL	Futures	57.22	58.29	56.84	57.29	674048.0
2019-08-28	GC	Futures	1914.2	1920.1	1901.4	1910.9	353912.0
2019-08-28	ZN	Futures	130.644244	130.908643	130.519821	130.753114	2277729.0
2019-08-28	A6	Futures	0.69514	0.69617	0.69298	0.69359	62110.0
2019-08-28	AD	Futures	0.75884	0.75914	0.75707	0.75763	60120.0
2019-08-28	ALI	Futures	2149.89	2151.71	2139.87	2139.87	35.0
2019-08-28	B	Futures	46.02	46.71	45.82	46.29	282151.0
2019-08-28	B6	Futures	1.2556	1.2556	1.2417	1.2482	142699.0
2019-08-28	BR	Futures	0.19299	0.19299	0.19299	0.19299	36.0
2019-08-28	BTC	Futures	14708.8	14930.3	13758.7	13923.0	2059.0
2019-08-28	BZ	Futures	45.37	46.15	45.15	45.6	28148.0
2019-08-28	C	Futures	1548.0	1550.0	1532.0	1544.0	3064.0
2019-08-28	CB	Futures	264.516	265.46	262.803	262.803	66.0
2019-08-28	CC	Futures	1466.0	1479.0	1451.0	1472.0	18565.0
2019-08-28	CNH	Futures	7.1716	7.1809	7.166	7.1731	473.0
2019-08-28	CSC	Futures	2.998	2.998	2.991	2.998	40.0
2019-08-28	CT	Futures	57.31	57.62	57.31	57.62	4.0
2019-08-28	DC	Futures	25.44	25.49	25.38	25.49	79.0
2019-08-28	DX	Futures	94.297	94.529	94.278	94.471	10397.0
2019-08-28	E1	Futures	1.18371	1.18522	1.18197	1.18336	20287.0
2019-08-28	E6	Futures	1.21164	1.2124	1.20967	1.21038	132449.0
2019-08-28	E7	Futures	1.2053	1.2061	1.2033	1.2041	2057.0
2019-08-28	EBM	Futures	192.31	192.31	190.58	191.16	7990.0
2019-08-28	ED	Futures	95.3817	95.4085	95.3793	95.389	341539.0
2019-08-28	ER	Futures	98.548	98.553	98.543	98.548	61726.0
2019-08-28	EW	Futures	1924.3	1948.6	1914.7	1942.8	12411.0
2019-08-28	FBON	Futures	146.85	147.19	146.72	147.05	177.0
2019-08-28	FBTP	Futures	129.67	131.44	129.42	130.72	155242.0
2019-08-28	FBTS	Futures	108.012	108.424	107.945	108.232	100543.0
2019-08-28	FCE	Futures	4870.1	4872.8	4819.8	4862.4	70206.0
2019-08-28	FDAX	Futures	12340.5	12353.6	12178.3	12321.5	110058.0
2019-08-28	FDIV	Futures	139.78	140.99	139.78	140.99	30.0
2019-08-28	FDXM	Futures	12187.9	12206.7	12028.8	12169.7	46268.0
2019-08-28	FESX	Futures	2936.6	2941.8	2908.6	2939.2	899822.0
2019-08-28	FEU3	Futures	99.174	99.174	99.164	99.174	248.0
2019-08-28	FGBL	Futures	170.2	170.64	170.09	170.49	709958.0
2019-08-28	FGBM	Futures	136.07	136.14	136.01	136.07	469895.0
2019-08-28	FGBS	Futures	113.353	113.363	113.318	113.328	300102.0
2019-08-28	FGBX	Futures	231.33	234.2	230.84	233.39	62492.0
2019-08-28	FMWO	Futures	7078.7	7107.5	7036.0	7106.4	1301.0
2019-08-28	FOAT	Futures	156.44	156.94	156.4	156.77	120768.0
2019-08-28	FTDX	Futures	2694.8	2694.8	2665.7	2691.9	33.0
2019-08-28	FTI	Futures	517.24	519.61	514.31	518.93	26224.0
2019-08-28	FTUK	Futures	6529.5	6579.4	6500.9	6573.3	96317.0
2019-08-28	FVSA	Futures	230.14	240.17	228.26	230.77	18833.0
2019-08-28	FXXP	Futures	334.7	334.7	331.2	334.3	47675.0
2019-08-28	G	Futures	122.92	123.6	122.88	123.55	215794.0

> showing 50 of 120 rows — these rows as CSV

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