PREVIEW / futures_daily / 2018-09-11

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-11.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-09-11	ES	Futures	3127.69	3142.08	3114.11	3138.55	1269254.0
2018-09-11	NQ	Futures	8698.21	8773.12	8632.92	8758.26	467702.0
2018-09-11	YM	Futures	27287.5	27438.1	27151.7	27402.3	5871.0
2018-09-11	CL	Futures	70.34	72.92	70.29	72.13	676869.0
2018-09-11	GC	Futures	1521.4	1527.0	1511.7	1523.7	263070.0
2018-09-11	ZN	Futures	119.214957	119.23052	118.810311	118.857001	1388452.0
2018-09-11	A6	Futures	0.7323	0.73385	0.72932	0.73086	69805.0
2018-09-11	AD	Futures	0.76971	0.77663	0.7689	0.77148	33874.0
2018-09-11	B	Futures	56.4	57.97	56.39	57.62	280309.0
2018-09-11	B6	Futures	1.3457	1.3517	1.3388	1.3434	56226.0
2018-09-11	BR	Futures	0.18251	0.18251	0.1819	0.1819	17.0
2018-09-11	BTC	Futures	8952.9	9131.7	8752.7	8910.0	1857.0
2018-09-11	BZ	Futures	56.14	57.71	56.14	57.38	29921.0
2018-09-11	C	Futures	1531.0	1536.0	1514.0	1522.0	11221.0
2018-09-11	CB	Futures	265.86	265.86	264.718	264.718	12.0
2018-09-11	CC	Futures	1613.0	1616.0	1580.0	1595.0	12142.0
2018-09-11	CNH	Futures	6.947	6.9611	6.9395	6.9512	316.0
2018-09-11	CSC	Futures	3.313	3.331	3.266	3.268	67.0
2018-09-11	CT	Futures	94.12	94.13	92.84	93.16	9.0
2018-09-11	DC	Futures	27.36	27.45	26.91	26.94	103.0
2018-09-11	DX	Futures	90.02	90.196	89.75	90.087	15860.0
2018-09-11	E1	Futures	1.22638	1.22982	1.22496	1.22792	15683.0
2018-09-11	E6	Futures	1.2989	1.30429	1.29557	1.29773	160854.0
2018-09-11	E7	Futures	1.2923	1.2978	1.2892	1.2913	4450.0
2018-09-11	EBM	Futures	210.79	211.57	207.42	209.24	20175.0
2018-09-11	ED	Futures	95.072	95.072	95.0573	95.0622	289471.0
2018-09-11	ER	Futures	98.372	98.381	98.372	98.377	109278.0
2018-09-11	EW	Futures	2148.3	2151.0	2135.1	2145.8	243.0
2018-09-11	FBON	Futures	128.38	128.62	128.36	128.39	945.0
2018-09-11	FBTP	Futures	108.29	108.82	107.93	108.01	83284.0
2018-09-11	FBTS	Futures	103.164	103.37	103.052	103.099	50694.0
2018-09-11	FCE	Futures	4756.7	4773.8	4720.6	4761.2	67873.0
2018-09-11	FDAX	Futures	12550.3	12567.0	12396.6	12506.4	96185.0
2018-09-11	FDXM	Futures	12386.4	12400.9	12251.0	12346.6	219.0
2018-09-11	FESX	Futures	2769.7	2773.0	2745.3	2766.3	169102.0
2018-09-11	FEU3	Futures	98.996	99.001	98.996	99.001	55.0
2018-09-11	FGBL	Futures	152.81	152.81	152.39	152.45	614329.0
2018-09-11	FGBM	Futures	130.82	130.84	130.7	130.73	360030.0
2018-09-11	FGBS	Futures	112.552	112.552	112.532	112.542	298146.0
2018-09-11	FGBX	Futures	176.1	176.14	175.11	175.29	37845.0
2018-09-11	FMWO	Futures	7154.5	7158.0	7106.7	7141.6	2133.0
2018-09-11	FOAT	Futures	140.72	140.72	140.41	140.42	118142.0
2018-09-11	FTDX	Futures	2867.6	2872.1	2833.8	2839.7	26.0
2018-09-11	FTI	Futures	501.55	501.55	497.42	500.62	269.0
2018-09-11	FTUK	Futures	6470.4	6484.2	6420.3	6462.3	11501.0
2018-09-11	FVSA	Futures	270.01	276.11	266.53	270.01	24484.0
2018-09-11	FXXP	Futures	324.2	324.2	321.9	323.3	4535.0
2018-09-11	G	Futures	114.46	114.59	114.36	114.43	275441.0
2018-09-11	GF	Futures	317.242	317.814	315.994	317.138	4672.0
2018-09-11	GSCI	Futures	517.45	523.56	517.45	523.56	2722.0

> showing 50 of 110 rows — these rows as CSV

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