PREVIEW / futures_daily / 2018-12-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-17.parquet
  size:    10 KB
  rows:    112

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-12-17	ES	Futures	2810.07	2833.08	2742.94	2767.03	2958828.0
2018-12-17	NQ	Futures	7640.3	7706.01	7436.54	7512.95	632497.0
2018-12-17	YM	Futures	25333.5	25568.7	24761.8	24982.2	269206.0
2018-12-17	CL	Futures	54.04	54.7	51.73	52.65	563280.0
2018-12-17	GC	Futures	1565.9	1577.8	1561.6	1577.3	166877.0
2018-12-17	ZN	Futures	119.899793	120.242141	119.837548	120.164335	1152134.0
2018-12-17	A6	Futures	0.74033	0.74136	0.7395	0.74043	69438.0
2018-12-17	AD	Futures	0.75818	0.75863	0.7559	0.75666	61608.0
2018-12-17	B	Futures	44.24	44.94	43.06	43.77	246028.0
2018-12-17	B6	Futures	1.2986	1.3046	1.2973	1.3029	85547.0
2018-12-17	BTC	Futures	4852.2	5447.3	4829.3	5386.3	4114.0
2018-12-17	BZ	Futures	43.76	44.35	42.5	43.21	32165.0
2018-12-17	C	Futures	1456.0	1470.0	1441.0	1451.0	7085.0
2018-12-17	CB	Futures	268.796	268.796	268.796	268.796	18.0
2018-12-17	CC	Futures	1534.0	1559.0	1518.0	1536.0	14100.0
2018-12-17	CNH	Futures	6.9217	6.9244	6.9115	6.9148	651.0
2018-12-17	CSC	Futures	2.844	2.847	2.819	2.819	150.0
2018-12-17	CT	Futures	86.28	86.93	84.86	85.55	15076.0
2018-12-17	DC	Futures	24.16	24.16	23.91	23.94	240.0
2018-12-17	DX	Futures	92.404	92.452	92.037	92.08	12700.0
2018-12-17	E1	Futures	1.18936	1.19629	1.18853	1.19535	21892.0
2018-12-17	E6	Futures	1.25912	1.26508	1.25906	1.26425	172375.0
2018-12-17	E7	Futures	1.2532	1.2591	1.2529	1.2581	2762.0
2018-12-17	EBM	Futures	213.08	214.11	212.83	213.34	17246.0
2018-12-17	ED	Futures	94.9354	94.9695	94.9256	94.9549	256144.0
2018-12-17	ER	Futures	98.386	98.391	98.386	98.386	60389.0
2018-12-17	EW	Futures	1846.8	1857.8	1799.2	1807.9	56176.0
2018-12-17	FBON	Futures	129.56	129.83	129.47	129.66	560.0
2018-12-17	FBTP	Futures	109.95	110.02	109.53	109.66	38124.0
2018-12-17	FBTS	Futures	104.395	104.424	104.253	104.31	33702.0
2018-12-17	FCE	Futures	4303.4	4316.3	4213.8	4252.8	118490.0
2018-12-17	FDAX	Futures	11410.2	11462.7	11208.4	11322.9	39248.0
2018-12-17	FDXM	Futures	11319.5	11436.9	11180.1	11295.4	2409.0
2018-12-17	FESX	Futures	2615.8	2634.6	2578.2	2605.6	1374184.0
2018-12-17	FEU3	Futures	98.981	98.996	98.981	98.996	981.0
2018-12-17	FGBL	Futures	155.25	155.27	154.94	155.11	399071.0
2018-12-17	FGBM	Futures	131.72	131.78	131.62	131.69	256047.0
2018-12-17	FGBS	Futures	112.698	112.713	112.678	112.688	158881.0
2018-12-17	FGBX	Futures	182.93	183.29	182.24	182.78	27610.0
2018-12-17	FMWO	Futures	6460.7	6482.7	6365.7	6445.7	12144.0
2018-12-17	FOAT	Futures	141.1	141.16	140.83	140.94	84967.0
2018-12-17	FTDX	Futures	2486.7	2487.2	2470.8	2482.7	557.0
2018-12-17	FTI	Futures	472.06	474.78	462.38	467.76	12204.0
2018-12-17	FTUK	Futures	6163.8	6181.1	6036.7	6121.4	259626.0
2018-12-17	FVSA	Futures	399.13	423.51	399.13	407.26	34399.0
2018-12-17	FXXP	Futures	302.2	302.2	297.5	299.6	199978.0
2018-12-17	G	Futures	117.2	117.2	116.74	116.94	125663.0
2018-12-17	GF	Futures	316.271	316.971	312.773	312.934	5776.0
2018-12-17	GSCI	Futures	460.9	460.9	452.41	454.41	58.0
2018-12-17	HE	Futures	77.355	77.445	75.792	76.754	17366.0

> showing 50 of 112 rows — these rows as CSV

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