PREVIEW / futures_daily / 2018-07-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-16.parquet
  size:    10 KB
  rows:    114

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-07-16	ES	Futures	3046.23	3050.85	3035.64	3037.27	801608.0
2018-07-16	NQ	Futures	8627.09	8643.71	8529.74	8540.23	246001.0
2018-07-16	YM	Futures	26368.7	26437.1	26302.3	26385.5	108198.0
2018-07-16	CL	Futures	71.93	72.2	69.01	69.39	298477.0
2018-07-16	GC	Futures	1584.4	1590.5	1580.9	1582.7	186301.0
2018-07-16	ZN	Futures	119.72762	119.72762	119.339147	119.510075	878760.0
2018-07-16	A6	Futures	0.76234	0.76522	0.76192	0.76264	68296.0
2018-07-16	AD	Futures	0.77037	0.7733	0.77027	0.77133	50661.0
2018-07-16	B	Futures	55.26	55.6	52.76	52.99	330000.0
2018-07-16	B6	Futures	1.3683	1.3751	1.3672	1.3687	85759.0
2018-07-16	BR	Futures	0.19679	0.19694	0.1963	0.1963	63.0
2018-07-16	BTC	Futures	9074.7	9559.1	9003.5	9509.2	3171.0
2018-07-16	BZ	Futures	55.03	55.3	52.48	52.71	27134.0
2018-07-16	C	Futures	1755.0	1796.0	1668.0	1679.0	21896.0
2018-07-16	CB	Futures	273.752	275.431	273.752	275.431	5.0
2018-07-16	CC	Futures	1817.0	1859.0	1712.0	1725.0	39256.0
2018-07-16	CNH	Futures	6.7852	6.8005	6.7717	6.7748	105.0
2018-07-16	CSC	Futures	3.21	3.252	3.21	3.252	56.0
2018-07-16	CT	Futures	99.86	100.22	99.5	99.73	14.0
2018-07-16	DC	Futures	25.48	25.86	25.46	25.85	193.0
2018-07-16	DX	Futures	89.459	89.52	89.17	89.285	12032.0
2018-07-16	E1	Futures	1.19919	1.20564	1.19823	1.20528	21827.0
2018-07-16	E6	Futures	1.31269	1.31733	1.31174	1.31599	150267.0
2018-07-16	E7	Futures	1.3061	1.3106	1.3051	1.3093	2127.0
2018-07-16	EBM	Futures	191.97	192.5	190.4	192.5	17517.0
2018-07-16	ED	Futures	94.9815	94.9913	94.9815	94.9815	137219.0
2018-07-16	ER	Futures	98.362	98.367	98.362	98.367	27922.0
2018-07-16	EW	Futures	2119.7	2121.8	2099.9	2105.7	11451.0
2018-07-16	FBON	Futures	129.78	129.78	129.44	129.44	108.0
2018-07-16	FBTP	Futures	108.86	109.17	108.73	108.81	32345.0
2018-07-16	FBTS	Futures	102.8	102.902	102.689	102.819	22386.0
2018-07-16	FCE	Futures	4870.2	4877.8	4846.4	4850.4	74905.0
2018-07-16	FDAX	Futures	13093.3	13164.4	13057.8	13131.0	69953.0
2018-07-16	FDXM	Futures	12927.6	12995.7	12891.5	12963.2	25527.0
2018-07-16	FESX	Futures	2879.8	2888.1	2868.1	2877.3	664398.0
2018-07-16	FGBL	Futures	153.56	153.56	153.06	153.09	388742.0
2018-07-16	FGBM	Futures	131.27	131.27	131.07	131.08	263766.0
2018-07-16	FGBS	Futures	112.708	112.713	112.683	112.688	170673.0
2018-07-16	FGBX	Futures	178.46	178.46	177.26	177.36	30651.0
2018-07-16	FMWO	Futures	7118.4	7126.5	7100.9	7106.7	1395.0
2018-07-16	FOAT	Futures	141.6	141.63	141.13	141.16	52998.0
2018-07-16	FTDX	Futures	2773.5	2796.1	2773.5	2784.3	98.0
2018-07-16	FTI	Futures	514.64	515.43	511.55	512.7	8294.0
2018-07-16	FTUK	Futures	6787.6	6796.0	6683.8	6715.0	80414.0
2018-07-16	FVSA	Futures	272.29	272.29	265.6	270.38	37603.0
2018-07-16	FXXP	Futures	331.6	332.6	330.3	331.1	35923.0
2018-07-16	G	Futures	115.6	115.61	115.26	115.37	139036.0
2018-07-16	GF	Futures	313.17	317.727	311.305	315.656	6149.0
2018-07-16	GSCI	Futures	518.46	518.46	506.68	509.16	356.0
2018-07-16	HE	Futures	78.114	78.866	76.971	77.111	16033.0

> showing 50 of 114 rows — these rows as CSV

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