PREVIEW / futures_daily / 2018-06-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-26.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-06-26	ES	Futures	2956.09	2970.75	2948.48	2963.42	1399067.0
2018-06-26	NQ	Futures	8236.22	8312.88	8208.53	8282.57	399009.0
2018-06-26	YM	Futures	25586.8	25683.8	25516.2	25607.9	197417.0
2018-06-26	CL	Futures	69.09	71.83	68.6	71.44	848537.0
2018-06-26	GC	Futures	1617.9	1620.6	1604.0	1608.5	254014.0
2018-06-26	ZN	Futures	119.29253	119.447919	119.168218	119.339147	1058281.0
2018-06-26	A6	Futures	0.76295	0.76367	0.75925	0.76069	91483.0
2018-06-26	AD	Futures	0.76313	0.76373	0.761	0.76282	72450.0
2018-06-26	B	Futures	55.01	56.47	54.56	56.16	325471.0
2018-06-26	B6	Futures	1.3755	1.3765	1.3661	1.3703	102962.0
2018-06-26	BR	Futures	0.19991	0.20064	0.19984	0.19984	635.0
2018-06-26	BTC	Futures	8918.0	8918.0	8732.8	8782.7	629.0
2018-06-26	BZ	Futures	54.75	56.16	54.28	55.86	32506.0
2018-06-26	C	Futures	1674.0	1678.0	1643.0	1662.0	4404.0
2018-06-26	CB	Futures	276.45	277.71	276.27	276.42	27.0
2018-06-26	CC	Futures	1782.0	1790.0	1738.0	1772.0	19223.0
2018-06-26	CNH	Futures	6.6328	6.6862	6.6274	6.6733	145.0
2018-06-26	CSC	Futures	3.28	3.29	3.25	3.284	210.0
2018-06-26	CT	Futures	96.66	96.78	96.04	96.04	12.0
2018-06-26	DC	Futures	25.76	26.06	25.66	25.95	301.0
2018-06-26	DX	Futures	88.98	89.459	88.867	89.355	15302.0
2018-06-26	E1	Futures	1.21926	1.2207	1.21281	1.21436	18042.0
2018-06-26	E6	Futures	1.31694	1.31906	1.30933	1.31106	248560.0
2018-06-26	E7	Futures	1.3102	1.3126	1.3026	1.3044	3641.0
2018-06-26	EBM	Futures	182.3	182.82	180.99	180.99	8866.0
2018-06-26	ED	Futures	94.9864	94.9961	94.9767	94.9864	167690.0
2018-06-26	ER	Futures	98.357	98.362	98.357	98.362	83792.0
2018-06-26	EW	Futures	2084.1	2091.4	2074.5	2084.3	17602.0
2018-06-26	FBON	Futures	128.5	128.58	128.18	128.3	748.0
2018-06-26	FBTP	Futures	106.32	106.47	105.23	105.64	75763.0
2018-06-26	FBTS	Futures	102.058	102.095	101.687	101.863	40291.0
2018-06-26	FCE	Futures	4753.0	4775.0	4740.9	4743.6	68468.0
2018-06-26	FDAX	Futures	12857.6	12901.0	12721.7	12784.4	98439.0
2018-06-26	FDXM	Futures	12693.4	12735.7	12560.2	12621.1	39583.0
2018-06-26	FESX	Futures	2813.8	2825.5	2799.6	2809.6	882872.0
2018-06-26	FEU3	Futures	99.006	99.011	99.006	99.011	4.0
2018-06-26	FGBL	Futures	152.7	153.0	152.41	152.73	598515.0
2018-06-26	FGBM	Futures	131.2	131.28	131.06	131.16	372185.0
2018-06-26	FGBS	Futures	112.789	112.804	112.764	112.779	281759.0
2018-06-26	FGBX	Futures	174.67	175.37	173.97	174.63	44263.0
2018-06-26	FMWO	Futures	6957.6	6980.9	6946.0	6960.0	1100.0
2018-06-26	FOAT	Futures	140.24	140.42	140.01	140.2	139115.0
2018-06-26	FTDX	Futures	2699.5	2699.5	2682.8	2689.2	121.0
2018-06-26	FTI	Futures	505.64	508.09	504.63	505.0	23424.0
2018-06-26	FTUK	Futures	6618.7	6696.7	6617.4	6674.9	96094.0
2018-06-26	FVSA	Futures	319.75	326.55	307.11	317.8	35367.0
2018-06-26	FXXP	Futures	324.9	326.3	324.2	325.1	58149.0
2018-06-26	G	Futures	115.08	115.46	115.0	115.27	183630.0
2018-06-26	GF	Futures	301.828	303.692	300.844	302.656	4267.0
2018-06-26	GSCI	Futures	524.12	530.96	524.12	530.8	293.0

> showing 50 of 114 rows — these rows as CSV

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