PREVIEW / futures_daily / 2019-06-28

all futures daily files

  file:    by_date/futures_daily/2019/2019-06-28.parquet
  size:    10 KB
  rows:    118

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-06-28	ES	Futures	3164.6	3188.88	3161.64	3177.01	1322759.0
2019-06-28	NQ	Futures	8848.22	8895.13	8823.75	8858.0	310126.0
2019-06-28	YM	Futures	27891.8	28006.3	27847.7	27923.3	161238.0
2019-06-28	CL	Futures	60.58	61.17	59.07	59.81	556101.0
2019-06-28	GC	Futures	1759.0	1777.1	1753.2	1759.5	306620.0
2019-06-28	ZN	Futures	127.269268	127.409244	127.098186	127.378138	1360265.0
2019-06-28	A6	Futures	0.7223	0.72435	0.72168	0.72384	82816.0
2019-06-28	AD	Futures	0.77073	0.77295	0.77048	0.77164	91714.0
2019-06-28	ALI	Futures	2223.27	2223.27	2223.27	2223.27	0.0
2019-06-28	B	Futures	49.26	49.55	48.13	48.67	328607.0
2019-06-28	B6	Futures	1.2976	1.3043	1.2971	1.3013	85092.0
2019-06-28	BR	Futures	0.20703	0.20719	0.20695	0.20719	139.0
2019-06-28	BTC	Futures	15146.8	17736.6	15146.8	17624.6	9323.0
2019-06-28	BZ	Futures	48.58	48.92	47.53	48.06	32575.0
2019-06-28	C	Futures	1736.0	1752.0	1715.0	1719.0	10707.0
2019-06-28	CB	Futures	287.748	287.748	287.077	287.077	8.0
2019-06-28	CC	Futures	1639.0	1656.0	1614.0	1615.0	14084.0
2019-06-28	CNH	Futures	6.8776	6.8828	6.8688	6.8753	745.0
2019-06-28	CSC	Futures	3.104	3.112	3.104	3.11	19.0
2019-06-28	CT	Futures	65.37	65.86	64.74	64.93	22.0
2019-06-28	DC	Futures	25.94	26.13	25.94	26.1	107.0
2019-06-28	DX	Futures	92.179	92.28	92.006	92.108	14558.0
2019-06-28	E1	Futures	1.19565	1.19925	1.19484	1.19705	20790.0
2019-06-28	E6	Futures	1.24785	1.25058	1.24578	1.24867	150820.0
2019-06-28	E7	Futures	1.2413	1.244	1.2393	1.2422	6464.0
2019-06-28	EBM	Futures	209.87	211.59	206.99	207.56	20355.0
2019-06-28	ED	Futures	95.4207	95.4304	95.4061	95.4207	182688.0
2019-06-28	ER	Futures	98.504	98.514	98.504	98.509	66315.0
2019-06-28	EW	Futures	2024.3	2059.1	2022.0	2048.1	19097.0
2019-06-28	FBON	Futures	142.75	142.81	142.46	142.72	530.0
2019-06-28	FBTP	Futures	120.26	120.71	120.15	120.63	90156.0
2019-06-28	FBTS	Futures	106.794	106.909	106.785	106.862	50307.0
2019-06-28	FCE	Futures	5015.3	5062.8	5006.6	5055.9	54330.0
2019-06-28	FDAX	Futures	12941.2	13056.5	12901.2	13044.4	83628.0
2019-06-28	FDXM	Futures	12774.5	12894.1	12744.3	12883.7	30145.0
2019-06-28	FESX	Futures	3002.1	3026.5	2993.3	3026.5	843976.0
2019-06-28	FGBL	Futures	164.19	164.35	163.99	164.25	488092.0
2019-06-28	FGBM	Futures	134.39	134.48	134.3	134.44	319517.0
2019-06-28	FGBS	Futures	113.076	113.101	113.051	113.091	201660.0
2019-06-28	FGBX	Futures	209.49	209.59	208.64	209.09	40757.0
2019-06-28	FMWO	Futures	7317.5	7340.6	7314.1	7326.8	1551.0
2019-06-28	FOAT	Futures	151.3	151.42	151.12	151.33	108713.0
2019-06-28	FTDX	Futures	2802.9	2833.0	2802.9	2831.0	172.0
2019-06-28	FTI	Futures	523.84	528.64	523.8	527.97	15444.0
2019-06-28	FTUK	Futures	6788.5	6809.7	6768.6	6803.7	80065.0
2019-06-28	FVSA	Futures	201.43	202.12	197.97	197.97	22896.0
2019-06-28	FXXP	Futures	340.8	343.6	340.5	343.5	33904.0
2019-06-28	G	Futures	119.87	120.05	119.78	119.82	200630.0
2019-06-28	GF	Futures	267.082	274.539	263.746	268.554	9522.0
2019-06-28	GSCI	Futures	487.55	487.55	479.96	480.35	28.0

> showing 50 of 118 rows — these rows as CSV

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