PREVIEW / futures_daily / 2018-04-11

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-11.parquet
  size:    9 KB
  rows:    109

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-04-11	ES	Futures	2886.68	2894.02	2855.69	2872.0	1637350.0
2018-04-11	NQ	Futures	7754.41	7798.89	7667.22	7716.37	443623.0
2018-04-11	YM	Futures	25660.9	25668.2	25346.9	25457.5	242696.0
2018-04-11	CL	Futures	65.87	67.74	65.43	67.1	963017.0
2018-04-11	GC	Futures	1714.7	1748.3	1713.9	1736.3	492037.0
2018-04-11	ZN	Futures	119.819305	120.20702	119.77278	119.943374	1366675.0
2018-04-11	A6	Futures	0.79833	0.79936	0.79597	0.79782	85391.0
2018-04-11	AD	Futures	0.80402	0.80766	0.80255	0.80529	80251.0
2018-04-11	B	Futures	51.63	53.13	51.3	52.38	495410.0
2018-04-11	B6	Futures	1.4724	1.4771	1.4705	1.4718	85825.0
2018-04-11	BR	Futures	0.22201	0.22452	0.22174	0.22452	672.0
2018-04-11	BTC	Futures	9742.3	9898.5	9635.8	9827.5	1746.0
2018-04-11	BZ	Futures	50.96	52.43	50.62	51.7	50064.0
2018-04-11	C	Futures	1598.0	1634.0	1592.0	1626.0	6623.0
2018-04-11	CB	Futures	294.064	294.064	291.563	294.064	14.0
2018-04-11	CC	Futures	1853.0	1890.0	1833.0	1881.0	31302.0
2018-04-11	CNH	Futures	6.3808	6.3839	6.3617	6.3711	104.0
2018-04-11	CSC	Futures	3.392	3.394	3.367	3.371	86.0
2018-04-11	CT	Futures	96.16	96.6	95.76	96.36	22891.0
2018-04-11	DC	Futures	27.08	27.17	26.89	26.96	148.0
2018-04-11	DX	Futures	84.203	84.283	83.958	84.177	18443.0
2018-04-11	E1	Futures	1.26548	1.26729	1.26187	1.2638	24914.0
2018-04-11	E6	Futures	1.39843	1.40344	1.39769	1.39944	187587.0
2018-04-11	E7	Futures	1.391	1.3958	1.3902	1.392	2328.0
2018-04-11	EBM	Futures	179.89	180.16	178.28	178.81	23684.0
2018-04-11	ED	Futures	94.9889	94.9938	94.9695	94.9695	246741.0
2018-04-11	ER	Futures	98.337	98.342	98.337	98.337	19985.0
2018-04-11	EW	Futures	1997.1	2003.2	1977.7	1993.5	14566.0
2018-04-11	FBON	Futures	129.56	129.83	129.56	129.78	309.0
2018-04-11	FBTP	Futures	115.53	115.79	115.39	115.67	92239.0
2018-04-11	FBTS	Futures	104.195	104.204	104.167	104.176	39648.0
2018-04-11	FCE	Futures	4661.5	4669.5	4634.6	4647.0	63366.0
2018-04-11	FDAX	Futures	12843.1	12882.6	12739.2	12779.7	104585.0
2018-04-11	FDXM	Futures	12728.8	12767.9	12625.8	12665.9	33462.0
2018-04-11	FESX	Futures	2789.8	2795.6	2774.8	2782.3	830461.0
2018-04-11	FGBL	Futures	149.79	150.24	149.79	150.1	665485.0
2018-04-11	FGBM	Futures	129.61	129.71	129.58	129.67	361794.0
2018-04-11	FGBS	Futures	112.492	112.507	112.482	112.497	209336.0
2018-04-11	FGBX	Futures	170.74	171.96	170.74	171.49	53317.0
2018-04-11	FMWO	Futures	6909.4	6937.4	6889.6	6917.6	3677.0
2018-04-11	FOAT	Futures	138.86	139.31	138.86	139.14	116062.0
2018-04-11	FTDX	Futures	2538.0	2554.8	2514.3	2532.1	205.0
2018-04-11	FTI	Futures	496.22	496.27	495.71	495.9	115.0
2018-04-11	FTUK	Futures	6344.0	6364.3	6327.2	6347.9	91655.0
2018-04-11	FVSA	Futures	403.09	413.79	394.77	399.53	24111.0
2018-04-11	FXXP	Futures	320.8	321.5	319.1	320.0	36441.0
2018-04-11	G	Futures	113.87	114.33	113.77	114.07	202821.0
2018-04-11	GF	Futures	292.511	295.039	290.305	291.704	5928.0
2018-04-11	GSCI	Futures	522.74	527.64	521.73	525.84	2609.0
2018-04-11	HE	Futures	78.815	79.977	78.322	78.902	489.0

> showing 50 of 109 rows — these rows as CSV

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