PREVIEW / futures_daily / 2018-01-09

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-09.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-01-09	ES	Futures	2985.11	2999.79	2981.04	2991.36	1137598.0
2018-01-09	NQ	Futures	7831.97	7855.39	7808.55	7831.68	272445.0
2018-01-09	YM	Futures	26624.6	26802.8	26616.2	26758.5	125138.0
2018-01-09	CL	Futures	61.91	63.46	61.79	62.94	844720.0
2018-01-09	GC	Futures	1675.0	1675.2	1660.2	1665.5	333529.0
2018-01-09	ZN	Futures	121.898058	121.92891	121.419845	121.48155	1686410.0
2018-01-09	A6	Futures	0.80594	0.80882	0.80285	0.8046	114403.0
2018-01-09	AD	Futures	0.81823	0.8195	0.81427	0.81549	62403.0
2018-01-09	B	Futures	48.69	49.61	48.47	49.28	319922.0
2018-01-09	B6	Futures	1.4146	1.4158	1.4074	1.4105	78262.0
2018-01-09	BR	Futures	0.23325	0.23325	0.23192	0.23233	264.0
2018-01-09	BTC	Futures	18794.4	19678.1	18166.9	18890.5	863.0
2018-01-09	BZ	Futures	47.98	48.88	47.81	48.61	25548.0
2018-01-09	C	Futures	1253.0	1276.0	1248.0	1259.0	9316.0
2018-01-09	CB	Futures	271.919	272.259	271.796	271.796	91.0
2018-01-09	CC	Futures	1424.0	1447.0	1411.0	1417.0	20729.0
2018-01-09	CNH	Futures	6.6639	6.6939	6.6639	6.6939	12.0
2018-01-09	CSC	Futures	3.135	3.139	3.097	3.107	115.0
2018-01-09	CT	Futures	91.19	91.92	91.14	91.51	12810.0
2018-01-09	DC	Futures	24.59	24.68	24.18	24.41	345.0
2018-01-09	DX	Futures	86.463	86.735	86.36	86.641	21576.0
2018-01-09	E1	Futures	1.24791	1.24876	1.23905	1.24014	30187.0
2018-01-09	E6	Futures	1.36205	1.36307	1.35632	1.35808	197645.0
2018-01-09	E7	Futures	1.3553	1.3562	1.3495	1.3513	4159.0
2018-01-09	EBM	Futures	173.43	174.24	173.43	174.24	12154.0
2018-01-09	ED	Futures	95.365	95.3699	95.3553	95.3602	283532.0
2018-01-09	ER	Futures	98.337	98.337	98.332	98.337	38654.0
2018-01-09	EW	Futures	2065.5	2070.7	2060.1	2061.7	12279.0
2018-01-09	FBON	Futures	126.42	126.81	126.19	126.28	273.0
2018-01-09	FBTP	Futures	111.29	111.64	110.7	110.85	144093.0
2018-01-09	FBTS	Futures	103.586	103.64	103.558	103.576	61084.0
2018-01-09	FCE	Futures	4910.7	4950.1	4903.1	4939.8	53412.0
2018-01-09	FDAX	Futures	13863.8	13924.5	13854.4	13885.0	64302.0
2018-01-09	FDIV	Futures	154.27	154.27	154.18	154.18	3.0
2018-01-09	FDXM	Futures	13890.4	13947.6	13877.9	13908.6	20085.0
2018-01-09	FESX	Futures	2943.4	2956.4	2941.7	2950.7	778243.0
2018-01-09	FGBL	Futures	149.83	150.14	149.4	149.49	724366.0
2018-01-09	FGBM	Futures	129.46	129.57	129.34	129.38	443707.0
2018-01-09	FGBS	Futures	112.377	112.402	112.362	112.367	311325.0
2018-01-09	FGBX	Futures	168.5	169.01	166.89	167.06	47978.0
2018-01-09	FMWO	Futures	7123.1	7145.3	7120.7	7144.1	483.0
2018-01-09	FOAT	Futures	138.13	138.55	137.86	137.91	101634.0
2018-01-09	FTDX	Futures	2661.1	2679.5	2661.1	2674.5	297.0
2018-01-09	FTI	Futures	518.67	521.63	518.62	521.12	18885.0
2018-01-09	FTUK	Futures	6687.8	6706.5	6681.2	6701.3	75190.0
2018-01-09	FVSA	Futures	250.73	254.95	248.63	249.68	21229.0
2018-01-09	FXXP	Futures	338.4	340.1	338.2	339.8	32801.0
2018-01-09	G	Futures	114.86	115.03	114.52	114.61	182865.0
2018-01-09	GF	Futures	316.463	317.814	311.112	314.517	3447.0
2018-01-09	GSCI	Futures	517.13	522.55	517.13	521.73	2447.0

> showing 50 of 110 rows — these rows as CSV

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