PREVIEW / futures_daily / 2018-03-05

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-05.parquet
  size:    9 KB
  rows:    110

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-03-05	ES	Futures	2916.37	2964.73	2895.17	2954.68	1781823.0
2018-03-05	NQ	Futures	7959.04	8086.41	7896.68	8054.79	467865.0
2018-03-05	YM	Futures	25819.9	26317.7	25638.5	26221.7	309960.0
2018-03-05	CL	Futures	61.99	63.23	61.53	63.01	599266.0
2018-03-05	GC	Futures	1692.3	1697.5	1683.9	1686.0	221216.0
2018-03-05	ZN	Futures	119.244747	119.676681	118.997927	119.121337	47984.0
2018-03-05	A6	Futures	0.79874	0.79936	0.79473	0.79833	88105.0
2018-03-05	AD	Futures	0.78838	0.78863	0.78102	0.78132	82355.0
2018-03-05	B	Futures	46.66	47.55	46.26	47.3	261060.0
2018-03-05	B6	Futures	1.4368	1.444	1.4324	1.439	131197.0
2018-03-05	BTC	Futures	15744.6	16230.1	15730.7	16112.2	990.0
2018-03-05	BZ	Futures	46.12	46.96	45.7	46.72	31209.0
2018-03-05	C	Futures	1499.0	1585.0	1496.0	1582.0	12546.0
2018-03-05	CB	Futures	284.15	284.15	283.532	283.532	1.0
2018-03-05	CC	Futures	1715.0	1804.0	1710.0	1795.0	45926.0
2018-03-05	CNH	Futures	6.4668	6.4733	6.4626	6.4626	2.0
2018-03-05	CSC	Futures	3.337	3.346	3.337	3.346	38.0
2018-03-05	CT	Futures	94.83	98.05	94.53	97.97	25348.0
2018-03-05	DC	Futures	26.42	26.47	26.33	26.46	19.0
2018-03-05	DX	Futures	84.359	84.698	84.19	84.558	24449.0
2018-03-05	E1	Futures	1.29804	1.29914	1.29149	1.29197	22265.0
2018-03-05	E6	Futures	1.40076	1.40121	1.39203	1.39844	212186.0
2018-03-05	E7	Futures	1.3936	1.3942	1.3851	1.3915	3505.0
2018-03-05	EBM	Futures	176.4	178.54	176.13	178.01	21058.0
2018-03-05	ED	Futures	95.1125	95.1222	95.0809	95.0882	294132.0
2018-03-05	ER	Futures	98.332	98.337	98.332	98.337	69389.0
2018-03-05	EW	Futures	1985.7	2017.3	1971.7	2012.0	17776.0
2018-03-05	FBON	Futures	126.71	126.98	126.45	126.82	2648.0
2018-03-05	FBTP	Futures	112.09	112.42	111.8	112.25	200135.0
2018-03-05	FBTS	Futures	103.677	103.779	103.64	103.751	72919.0
2018-03-05	FCE	Futures	4547.2	4588.7	4506.1	4563.5	81114.0
2018-03-05	FDAX	Futures	12372.9	12635.4	12164.4	12560.2	130036.0
2018-03-05	FDXM	Futures	12402.2	12656.8	12188.1	12581.5	47576.0
2018-03-05	FESX	Futures	2716.3	2754.7	2686.9	2744.0	1267501.0
2018-03-05	FEU3	Futures	99.006	99.011	99.006	99.011	175.0
2018-03-05	FGBL	Futures	148.07	148.39	147.48	147.92	1067163.0
2018-03-05	FGBM	Futures	128.95	129.13	128.83	128.95	889795.0
2018-03-05	FGBS	Futures	112.412	112.437	112.402	112.412	842762.0
2018-03-05	FGBX	Futures	166.85	167.8	165.01	166.31	124907.0
2018-03-05	FMWO	Futures	6868.6	6969.0	6853.5	6939.8	1317.0
2018-03-05	FOAT	Futures	137.0	137.18	136.63	136.99	202569.0
2018-03-05	FTDX	Futures	2465.6	2541.4	2432.1	2529.9	361.0
2018-03-05	FTI	Futures	477.29	486.25	474.31	483.31	29797.0
2018-03-05	FTUK	Futures	6205.9	6240.4	6159.6	6208.1	113953.0
2018-03-05	FVSA	Futures	497.37	497.37	432.12	443.2	37520.0
2018-03-05	FXXP	Futures	314.1	317.2	310.8	315.9	50391.0
2018-03-05	G	Futures	113.4	113.48	112.65	112.91	162341.0
2018-03-05	GF	Futures	315.506	319.294	313.474	318.745	2904.0
2018-03-05	GSCI	Futures	503.42	509.05	501.77	509.05	366.0
2018-03-05	HE	Futures	87.221	88.729	86.867	88.344	17955.0

> showing 50 of 110 rows — these rows as CSV

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