PREVIEW / futures_daily / 2018-10-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-26.parquet
  size:    10 KB
  rows:    116

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-26	ES	Futures	2904.32	2920.32	2849.28	2895.1	3509803.0
2018-10-26	NQ	Futures	7993.62	8115.0	7822.01	8006.69	1069548.0
2018-10-26	YM	Futures	26119.7	26205.0	25710.1	26058.6	430291.0
2018-10-26	CL	Futures	69.77	70.74	68.99	70.44	595211.0
2018-10-26	GC	Futures	1564.9	1579.2	1562.1	1566.3	315690.0
2018-10-26	ZN	Futures	118.218905	118.716931	118.203342	118.561298	2768692.0
2018-10-26	A6	Futures	0.7285	0.73138	0.72273	0.73004	134210.0
2018-10-26	AD	Futures	0.77406	0.77441	0.7689	0.7731	95060.0
2018-10-26	B	Futures	56.65	57.61	56.02	57.4	211478.0
2018-10-26	B6	Futures	1.3209	1.3236	1.3169	1.3225	92362.0
2018-10-26	BR	Futures	0.2049	0.20845	0.20399	0.20769	2807.0
2018-10-26	BTC	Futures	9257.1	9351.2	9220.9	9249.9	2434.0
2018-10-26	BZ	Futures	56.21	57.18	55.69	57.01	25910.0
2018-10-26	C	Futures	1552.0	1589.0	1549.0	1578.0	13353.0
2018-10-26	CB	Futures	270.726	270.726	269.404	269.404	35.0
2018-10-26	CC	Futures	1547.0	1593.0	1541.0	1572.0	24453.0
2018-10-26	CNH	Futures	7.0084	7.0265	7.0018	7.0037	478.0
2018-10-26	CSC	Futures	3.062	3.088	3.062	3.074	161.0
2018-10-26	CT	Futures	87.43	88.37	86.55	88.15	15186.0
2018-10-26	DC	Futures	25.41	25.68	25.31	25.48	562.0
2018-10-26	DX	Futures	91.531	91.787	91.246	91.32	28671.0
2018-10-26	E1	Futures	1.19094	1.19473	1.18726	1.19402	30024.0
2018-10-26	E6	Futures	1.26938	1.27483	1.26527	1.27355	246652.0
2018-10-26	E7	Futures	1.2631	1.2686	1.259	1.2673	4161.0
2018-10-26	EBM	Futures	208.2	211.05	207.16	210.53	15744.0
2018-10-26	ED	Futures	94.9792	95.0232	94.9743	94.9987	499241.0
2018-10-26	ER	Futures	98.377	98.381	98.372	98.377	157029.0
2018-10-26	EW	Futures	1899.2	1910.4	1859.3	1887.6	24728.0
2018-10-26	FBON	Futures	127.08	127.48	127.08	127.45	540.0
2018-10-26	FBTP	Futures	104.25	104.69	103.72	104.44	92996.0
2018-10-26	FBTS	Futures	101.9	102.171	101.75	101.984	65939.0
2018-10-26	FCE	Futures	4456.1	4478.5	4380.9	4444.5	148538.0
2018-10-26	FDAX	Futures	11745.6	11861.8	11603.7	11721.4	171733.0
2018-10-26	FDIV	Futures	134.86	135.31	134.86	135.31	1.0
2018-10-26	FDXM	Futures	11542.2	11655.9	11406.8	11518.4	99352.0
2018-10-26	FESX	Futures	2621.0	2644.5	2587.4	2611.7	1913783.0
2018-10-26	FEU3	Futures	99.006	99.006	98.996	99.001	129.0
2018-10-26	FGBL	Futures	153.43	153.98	153.33	153.96	865941.0
2018-10-26	FGBM	Futures	131.16	131.37	131.11	131.36	484405.0
2018-10-26	FGBS	Futures	112.713	112.769	112.708	112.764	529300.0
2018-10-26	FGBX	Futures	178.76	179.93	178.48	179.87	60902.0
2018-10-26	FMWO	Futures	6613.7	6649.6	6527.9	6576.6	5928.0
2018-10-26	FOAT	Futures	140.42	140.79	140.3	140.76	130756.0
2018-10-26	FTDX	Futures	2463.5	2467.9	2421.7	2445.3	563.0
2018-10-26	FTI	Futures	474.0	475.07	464.99	471.8	52104.0
2018-10-26	FTUK	Futures	6166.5	6215.2	6098.6	6144.2	186631.0
2018-10-26	FVSA	Futures	385.29	405.27	377.68	392.9	60757.0
2018-10-26	FXXP	Futures	303.5	306.1	300.7	303.0	120434.0
2018-10-26	G	Futures	115.27	115.8	115.19	115.75	275161.0
2018-10-26	GF	Futures	320.106	324.004	318.702	321.873	3316.0

> showing 50 of 116 rows — these rows as CSV

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