PREVIEW / futures_daily / 2018-05-18

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-18.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-05-18	ES	Futures	2956.55	2965.53	2945.68	2950.3	1013073.0
2018-05-18	NQ	Futures	8085.94	8118.42	8031.81	8045.56	314569.0
2018-05-18	YM	Futures	26023.2	26127.5	25971.6	26041.1	154189.0
2018-05-18	CL	Futures	72.11	72.33	71.55	71.83	462168.0
2018-05-18	GC	Futures	1646.9	1651.6	1640.7	1648.6	264426.0
2018-05-18	ZN	Futures	117.58607	118.02031	117.493018	117.958276	1608621.0
2018-05-18	A6	Futures	0.77252	0.77417	0.77005	0.77232	87656.0
2018-05-18	AD	Futures	0.79067	0.79137	0.78399	0.78601	81041.0
2018-05-18	B	Futures	58.23	58.53	57.4	57.53	277277.0
2018-05-18	B6	Futures	1.4015	1.4028	1.3951	1.398	88396.0
2018-05-18	BR	Futures	0.20506	0.20506	0.20159	0.2035	2590.0
2018-05-18	BTC	Futures	11550.2	11620.4	11114.9	11557.2	3390.0
2018-05-18	BZ	Futures	57.67	57.92	56.81	56.95	30828.0
2018-05-18	C	Futures	1685.0	1736.0	1674.0	1712.0	9447.0
2018-05-18	CB	Futures	298.975	299.593	298.975	299.593	8.0
2018-05-18	CC	Futures	1906.0	1990.0	1906.0	1952.0	24684.0
2018-05-18	CNH	Futures	6.4571	6.4677	6.4561	6.4591	94.0
2018-05-18	CSC	Futures	3.475	3.482	3.471	3.48	28.0
2018-05-18	CT	Futures	96.76	99.58	96.68	98.39	20707.0
2018-05-18	DC	Futures	28.27	28.27	28.0	28.03	454.0
2018-05-18	DX	Futures	88.126	88.409	87.938	88.224	19438.0
2018-05-18	E1	Futures	1.20526	1.21309	1.2049	1.20984	22325.0
2018-05-18	E6	Futures	1.33157	1.3345	1.32622	1.32898	257054.0
2018-05-18	E7	Futures	1.3243	1.3274	1.3192	1.3219	3807.0
2018-05-18	EBM	Futures	183.34	185.17	182.56	184.91	19940.0
2018-05-18	ED	Futures	94.9889	95.0059	94.9841	94.9986	265868.0
2018-05-18	ER	Futures	98.332	98.337	98.332	98.332	28902.0
2018-05-18	EW	Futures	2062.3	2069.9	2058.8	2059.5	10997.0
2018-05-18	FBON	Futures	128.05	128.35	127.66	127.87	613.0
2018-05-18	FBTP	Futures	112.42	112.59	111.38	111.51	217974.0
2018-05-18	FBTS	Futures	103.862	103.88	103.668	103.714	146720.0
2018-05-18	FCE	Futures	4991.6	5015.4	4979.9	4989.8	79109.0
2018-05-18	FDAX	Futures	13638.5	13651.5	13557.0	13576.2	79244.0
2018-05-18	FDIV	Futures	157.94	158.03	157.85	157.85	90.0
2018-05-18	FDXM	Futures	13509.4	13530.0	13436.3	13455.3	28433.0
2018-05-18	FESX	Futures	2961.4	2970.5	2946.4	2952.2	1158875.0
2018-05-18	FGBL	Futures	148.52	149.46	148.5	149.32	777910.0
2018-05-18	FGBM	Futures	129.33	129.7	129.33	129.63	564772.0
2018-05-18	FGBS	Futures	112.487	112.547	112.482	112.542	342425.0
2018-05-18	FGBX	Futures	166.58	168.73	166.54	168.34	64852.0
2018-05-18	FMWO	Futures	7070.6	7077.6	7048.4	7050.7	528.0
2018-05-18	FOAT	Futures	137.61	138.22	137.61	138.15	146110.0
2018-05-18	FTDX	Futures	2780.4	2784.4	2768.1	2773.0	110.0
2018-05-18	FTI	Futures	523.97	525.36	520.74	522.54	28487.0
2018-05-18	FTUK	Futures	6860.0	6869.3	6833.9	6857.8	118050.0
2018-05-18	FVSA	Futures	298.57	313.61	297.5	312.53	30198.0
2018-05-18	FXXP	Futures	341.1	341.1	338.8	339.5	35339.0
2018-05-18	G	Futures	112.74	113.21	112.59	113.17	217664.0
2018-05-18	GF	Futures	288.363	289.347	284.53	285.1	5272.0
2018-05-18	GSCI	Futures	550.55	551.44	547.96	549.03	61.0

> showing 50 of 110 rows — these rows as CSV

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