PREVIEW / futures_daily / 2018-12-11

all futures daily files

  file:    by_date/futures_daily/2018/2018-12-11.parquet
  size:    9 KB
  rows:    107

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-11	ES	Futures	2867.45	2904.32	2842.78	2864.47	2265284.0
2018-12-11	NQ	Futures	7776.42	7908.54	7725.6	7801.97	734366.0
2018-12-11	YM	Futures	25841.9	26201.6	25581.3	25779.6	7653.0
2018-12-11	CL	Futures	53.84	55.47	53.64	54.65	665262.0
2018-12-11	GC	Futures	1574.8	1581.4	1569.7	1571.5	186386.0
2018-12-11	ZN	Futures	120.133212	120.273264	119.853109	119.930915	1882278.0
2018-12-11	A6	Futures	0.74198	0.74538	0.74136	0.74352	40126.0
2018-12-11	AD	Futures	0.75752	0.75843	0.75595	0.75757	23544.0
2018-12-11	B	Futures	43.99	44.86	43.75	44.2	235332.0
2018-12-11	B6	Futures	1.2966	1.304	1.2879	1.2929	67612.0
2018-12-11	BR	Futures	0.20464	0.20464	0.20276	0.20276	1.0
2018-12-11	BTC	Futures	5157.4	5195.5	4981.9	5065.8	1989.0
2018-12-11	BZ	Futures	43.41	44.28	43.21	43.63	31823.0
2018-12-11	C	Futures	1428.0	1431.0	1382.0	1394.0	21689.0
2018-12-11	CB	Futures	267.581	268.158	267.277	267.277	106.0
2018-12-11	CC	Futures	1518.0	1518.0	1445.0	1458.0	24141.0
2018-12-11	CNH	Futures	6.9451	6.9451	6.9192	6.927	110.0
2018-12-11	CSC	Futures	2.827	2.851	2.819	2.844	127.0
2018-12-11	CT	Futures	87.01	87.86	86.18	87.17	14248.0
2018-12-11	DC	Futures	23.76	23.99	23.7	23.91	205.0
2018-12-11	DX	Futures	92.151	92.504	91.851	92.35	14268.0
2018-12-11	E1	Futures	1.199	1.2037	1.19465	1.19571	8194.0
2018-12-11	E6	Futures	1.26536	1.27061	1.26011	1.26243	179079.0
2018-12-11	E7	Futures	1.2604	1.2645	1.2539	1.2563	3226.0
2018-12-11	EBM	Futures	209.74	210.77	209.48	210.25	24342.0
2018-12-11	ED	Futures	94.9402	94.9451	94.9109	94.9158	317751.0
2018-12-11	ER	Futures	98.396	98.396	98.381	98.386	127637.0
2018-12-11	EW	Futures	1893.1	1913.3	1877.0	1883.4	143.0
2018-12-11	FBON	Futures	129.12	129.34	128.87	129.29	258.0
2018-12-11	FBTP	Futures	108.43	108.43	107.83	108.19	67538.0
2018-12-11	FBTS	Futures	103.894	103.922	103.704	103.894	39284.0
2018-12-11	FCE	Futures	4276.7	4338.0	4262.8	4295.0	116615.0
2018-12-11	FDAX	Futures	11251.9	11445.4	11228.8	11379.7	124272.0
2018-12-11	FDXM	Futures	11185.3	11401.2	11185.3	11336.8	320.0
2018-12-11	FESX	Futures	2578.2	2620.1	2574.8	2604.7	139664.0
2018-12-11	FGBL	Futures	155.21	155.54	154.82	155.44	741273.0
2018-12-11	FGBM	Futures	131.62	131.79	131.47	131.73	433406.0
2018-12-11	FGBS	Futures	112.638	112.693	112.613	112.683	405327.0
2018-12-11	FGBX	Futures	184.33	185.06	183.09	184.91	65572.0
2018-12-11	FMWO	Futures	6515.2	6595.1	6480.4	6545.3	5118.0
2018-12-11	FOAT	Futures	141.29	141.41	140.72	141.21	184587.0
2018-12-11	FTI	Futures	467.67	472.2	466.03	468.61	146.0
2018-12-11	FTUK	Futures	6089.1	6187.0	6084.5	6165.1	7229.0
2018-12-11	FVSA	Futures	406.22	412.27	394.12	403.2	38276.0
2018-12-11	FXXP	Futures	298.9	302.3	298.2	301.0	4155.0
2018-12-11	G	Futures	117.31	117.81	117.17	117.65	260046.0
2018-12-11	GF	Futures	312.396	317.67	311.535	317.078	7476.0
2018-12-11	GSCI	Futures	466.49	466.49	466.03	466.03	2745.0
2018-12-11	HE	Futures	79.971	80.151	78.137	78.407	21334.0
2018-12-11	HG	Futures	3.1496	3.2043	3.1415	3.1888	68725.0

> showing 50 of 107 rows — these rows as CSV

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