PREVIEW / futures_daily / 2018-04-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-12.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-12	ES	Futures	2873.63	2908.98	2870.64	2897.01	1301132.0
2018-04-12	NQ	Futures	7720.47	7834.59	7712.86	7807.67	357175.0
2018-04-12	YM	Futures	25467.0	25872.6	25430.2	25765.1	231525.0
2018-04-12	CL	Futures	67.03	67.62	66.28	67.36	687468.0
2018-04-12	GC	Futures	1731.6	1732.1	1706.5	1713.2	397621.0
2018-04-12	ZN	Futures	120.005408	120.067443	119.509134	119.571168	1232813.0
2018-04-12	A6	Futures	0.79782	0.79926	0.79576	0.79761	67205.0
2018-04-12	AD	Futures	0.80559	0.8065	0.8026	0.80508	84115.0
2018-04-12	B	Futures	52.4	52.69	51.68	52.35	330212.0
2018-04-12	B6	Futures	1.4724	1.4795	1.4689	1.4773	109246.0
2018-04-12	BR	Futures	0.22452	0.2249	0.22266	0.22323	3466.0
2018-04-12	BTC	Futures	9827.5	11510.4	9458.3	10906.8	4825.0
2018-04-12	BZ	Futures	51.61	51.99	51.0	51.67	38029.0
2018-04-12	C	Futures	1627.0	1634.0	1610.0	1613.0	4504.0
2018-04-12	CB	Futures	294.064	294.064	292.798	292.798	46.0
2018-04-12	CC	Futures	1880.0	1893.0	1863.0	1869.0	28602.0
2018-04-12	CNH	Futures	6.3751	6.3889	6.3751	6.3766	6.0
2018-04-12	CSC	Futures	3.36	3.377	3.36	3.375	29.0
2018-04-12	CT	Futures	96.36	96.52	95.6	96.2	20127.0
2018-04-12	DC	Futures	26.87	27.1	26.8	26.89	116.0
2018-04-12	DX	Futures	84.137	84.575	84.09	84.369	23614.0
2018-04-12	E1	Futures	1.26404	1.265	1.25488	1.25838	23711.0
2018-04-12	E6	Futures	1.39961	1.40113	1.39201	1.39544	200464.0
2018-04-12	E7	Futures	1.3922	1.3936	1.3846	1.388	3045.0
2018-04-12	EBM	Futures	177.74	178.28	177.47	177.74	21407.0
2018-04-12	ED	Futures	94.9695	94.9743	94.9354	94.9403	322721.0
2018-04-12	ER	Futures	98.337	98.342	98.337	98.337	21187.0
2018-04-12	EW	Futures	1995.3	2010.6	1993.8	2002.4	10627.0
2018-04-12	FBON	Futures	129.67	129.96	129.5	129.8	378.0
2018-04-12	FBTP	Futures	115.52	115.64	115.17	115.42	137844.0
2018-04-12	FBTS	Futures	104.204	104.204	104.139	104.158	54842.0
2018-04-12	FCE	Futures	4647.0	4673.3	4639.4	4673.3	8474.0
2018-04-12	FDAX	Futures	12772.5	12929.9	12747.0	12915.3	85504.0
2018-04-12	FDXM	Futures	12656.7	12815.3	12634.0	12800.3	30261.0
2018-04-12	FESX	Futures	2779.8	2806.4	2776.4	2803.1	813839.0
2018-04-12	FGBL	Futures	150.0	150.12	149.77	149.9	659620.0
2018-04-12	FGBM	Futures	129.65	129.73	129.58	129.66	482905.0
2018-04-12	FGBS	Futures	112.497	112.522	112.477	112.512	294138.0
2018-04-12	FGBX	Futures	171.34	171.53	170.14	170.64	49029.0
2018-04-12	FMWO	Futures	6905.9	6949.1	6900.1	6945.6	1340.0
2018-04-12	FOAT	Futures	139.0	139.2	138.86	138.96	149348.0
2018-04-12	FTDX	Futures	2542.5	2578.6	2529.1	2576.6	93.0
2018-04-12	FTI	Futures	496.68	499.36	496.5	499.13	129.0
2018-04-12	FTUK	Futures	6339.6	6364.7	6326.7	6351.9	75201.0
2018-04-12	FVSA	Futures	399.53	399.53	383.45	384.6	20629.0
2018-04-12	FXXP	Futures	320.0	322.5	319.2	322.3	35146.0
2018-04-12	G	Futures	114.09	114.09	113.31	113.52	198710.0
2018-04-12	GF	Futures	293.748	301.388	293.479	301.226	9302.0
2018-04-12	GSCI	Futures	521.79	525.45	521.05	525.45	2332.0
2018-04-12	HE	Futures	78.989	80.732	78.409	80.529	525.0

> showing 50 of 109 rows — these rows as CSV

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