PREVIEW / futures_daily / 2018-10-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-12.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-10-12	ES	Futures	2980.78	3020.36	2963.16	3002.47	2853415.0
2018-10-12	NQ	Futures	8178.01	8360.37	8170.46	8330.75	772623.0
2018-10-12	YM	Futures	26546.2	26900.0	26315.6	26658.8	438111.0
2018-10-12	CL	Futures	74.31	75.38	73.95	74.68	626668.0
2018-10-12	GC	Futures	1556.0	1556.5	1545.4	1548.8	318233.0
2018-10-12	ZN	Futures	117.767569	117.969892	117.534119	117.876512	1979954.0
2018-10-12	A6	Futures	0.73323	0.73508	0.73117	0.73158	90896.0
2018-10-12	AD	Futures	0.77694	0.77861	0.77562	0.77588	54204.0
2018-10-12	B	Futures	58.99	59.87	58.21	59.1	373090.0
2018-10-12	B6	Futures	1.3646	1.3674	1.3558	1.3576	108415.0
2018-10-12	BR	Futures	0.2019	0.2019	0.20148	0.20148	1.0
2018-10-12	BTC	Futures	8917.9	8982.8	8795.3	8925.1	1908.0
2018-10-12	BZ	Futures	58.54	59.41	57.77	58.65	37537.0
2018-10-12	C	Futures	1445.0	1480.0	1445.0	1478.0	6387.0
2018-10-12	CB	Futures	270.876	270.876	270.696	270.696	20.0
2018-10-12	CC	Futures	1474.0	1511.0	1474.0	1508.0	16701.0
2018-10-12	CNH	Futures	6.9414	6.9794	6.9414	6.978	451.0
2018-10-12	CSC	Futures	3.184	3.184	3.156	3.162	56.0
2018-10-12	CT	Futures	86.3	88.54	86.3	87.97	18051.0
2018-10-12	DC	Futures	26.34	26.44	26.29	26.36	99.0
2018-10-12	DX	Futures	89.978	90.301	89.906	90.164	16371.0
2018-10-12	E1	Futures	1.20445	1.20611	1.20018	1.20303	22020.0
2018-10-12	E6	Futures	1.2954	1.29735	1.2889	1.29212	208354.0
2018-10-12	E7	Futures	1.2892	1.2909	1.2826	1.2858	3668.0
2018-10-12	EBM	Futures	211.57	213.13	211.05	212.87	15627.0
2018-10-12	ED	Futures	95.0476	95.0622	95.0378	95.0525	272934.0
2018-10-12	ER	Futures	98.377	98.381	98.372	98.381	71483.0
2018-10-12	EW	Futures	1968.3	2000.6	1942.8	1969.8	34528.0
2018-10-12	FBON	Futures	126.53	126.56	126.17	126.2	366.0
2018-10-12	FBTP	Futures	103.06	103.7	103.02	103.21	66523.0
2018-10-12	FBTS	Futures	100.991	101.216	100.879	101.066	54447.0
2018-10-12	FCE	Futures	4602.1	4628.5	4529.1	4559.1	1799.0
2018-10-12	FDAX	Futures	12225.6	12299.2	12000.6	12096.3	143799.0
2018-10-12	FDXM	Futures	12013.4	12086.7	11792.3	11886.8	82183.0
2018-10-12	FESX	Futures	2708.3	2726.0	2652.0	2673.9	1455450.0
2018-10-12	FGBL	Futures	151.36	151.92	151.16	151.72	584329.0
2018-10-12	FGBM	Futures	130.27	130.55	130.2	130.47	447142.0
2018-10-12	FGBS	Futures	112.537	112.603	112.522	112.573	461544.0
2018-10-12	FGBX	Futures	173.9	174.97	173.39	174.59	31728.0
2018-10-12	FMWO	Futures	6917.2	6917.2	6800.2	6852.4	1756.0
2018-10-12	FOAT	Futures	138.82	139.18	138.69	139.1	113420.0
2018-10-12	FTDX	Futures	2528.8	2563.2	2515.5	2534.2	585.0
2018-10-12	FTI	Futures	481.7	486.13	477.4	479.82	515.0
2018-10-12	FTUK	Futures	6203.1	6297.9	6190.6	6229.1	188255.0
2018-10-12	FVSA	Futures	342.48	372.92	334.87	352.94	35984.0
2018-10-12	FXXP	Futures	312.6	313.9	307.6	310.0	92213.0
2018-10-12	G	Futures	112.67	113.43	112.65	113.28	262949.0
2018-10-12	GF	Futures	325.72	327.435	321.145	321.509	8126.0
2018-10-12	GSCI	Futures	550.9	550.9	545.13	548.68	161.0
2018-10-12	HE	Futures	73.284	76.069	72.847	73.82	23070.0

> showing 50 of 114 rows — these rows as CSV

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