PREVIEW / futures_daily / 2016-10-05

all futures daily files

  file:    by_date/futures_daily/2016/2016-10-05.parquet
  size:    9 KB
  rows:    108

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
2016-10-05	ES	Futures	2319.21	2334.08	2315.7	2328.95	1369566.0
2016-10-05	NQ	Futures	5723.62	5761.33	5715.08	5743.66	182962.0
2016-10-05	YM	Futures	18990.1	19146.6	18957.6	19110.9	137416.0
2016-10-05	CL	Futures	54.32	55.1	54.14	54.95	520070.0
2016-10-05	GC	Futures	1630.1	1641.5	1621.9	1627.6	213859.0
2016-10-05	ZN	Futures	126.922082	127.058885	126.557276	126.678878	1209515.0
2016-10-05	A6	Futures	0.7754	0.77877	0.77346	0.77652	100223.0
2016-10-05	AD	Futures	0.77704	0.77868	0.77443	0.77816	60608.0
2016-10-05	ALI	Futures	2199.47	2223.63	2199.47	2223.63	25.0
2016-10-05	B	Futures	39.64	40.31	39.64	40.14	302091.0
2016-10-05	B6	Futures	1.3419	1.3461	1.337	1.3438	104822.0
2016-10-05	BR	Futures	0.20657	0.20931	0.20657	0.20931	53.0
2016-10-05	BZ	Futures	39.54	40.08	39.42	39.91	26124.0
2016-10-05	C	Futures	2444.0	2469.0	2442.0	2465.0	9346.0
2016-10-05	CB	Futures	236.518	236.828	235.588	236.208	27.0
2016-10-05	CC	Futures	2081.0	2106.0	2064.0	2098.0	17032.0
2016-10-05	CNH	Futures	7.2237	7.2285	7.2237	7.2246	6.0
2016-10-05	CSC	Futures	3.718	3.723	3.705	3.705	84.0
2016-10-05	CT	Futures	78.04	78.42	75.65	75.98	17172.0
2016-10-05	DC	Futures	29.13	29.15	28.96	28.98	146.0
2016-10-05	DX	Futures	89.424	89.638	89.293	89.455	23774.0
2016-10-05	E1	Futures	1.27845	1.28506	1.27746	1.28393	22132.0
2016-10-05	E6	Futures	1.30321	1.30616	1.30106	1.30379	147447.0
2016-10-05	E7	Futures	1.2959	1.299	1.2939	1.2967	2210.0
2016-10-05	EBM	Futures	188.58	189.47	186.82	188.88	21253.0
2016-10-05	ED	Futures	95.6393	95.6442	95.62	95.6297	306812.0
2016-10-05	ER	Futures	98.264	98.274	98.264	98.269	75228.0
2016-10-05	EW	Futures	1629.3	1645.4	1626.4	1637.2	19551.0
2016-10-05	FBON	Futures	124.7	124.87	124.13	124.19	1487.0
2016-10-05	FBTP	Futures	108.97	109.15	108.36	108.55	164728.0
2016-10-05	FBTS	Futures	101.257	101.302	101.239	101.257	24988.0
2016-10-05	FCE	Futures	3986.2	3997.8	3943.6	3988.9	76295.0
2016-10-05	FDAX	Futures	11190.9	11216.8	11065.7	11180.9	80774.0
2016-10-05	FDXM	Futures	11160.4	11192.1	11044.4	11156.7	35745.0
2016-10-05	FESX	Futures	2406.2	2420.6	2386.1	2416.6	931746.0
2016-10-05	FEU3	Futures	98.947	98.947	98.947	98.947	5.0
2016-10-05	FGBL	Futures	150.51	150.68	149.87	149.95	1018759.0
2016-10-05	FGBM	Futures	129.12	129.19	128.95	128.98	488826.0
2016-10-05	FGBS	Futures	111.967	111.992	111.932	111.957	443425.0
2016-10-05	FGBX	Futures	185.55	185.73	182.73	183.14	51856.0
2016-10-05	FMWO	Futures	5734.0	5755.8	5734.0	5754.6	1303.0
2016-10-05	FOAT	Futures	137.92	138.06	137.24	137.32	154025.0
2016-10-05	FTDX	Futures	1779.8	1780.8	1767.1	1774.4	189.0
2016-10-05	FTI	Futures	418.34	418.89	414.03	418.16	27026.0
2016-10-05	FTUK	Futures	5917.9	5945.3	5896.3	5905.6	126253.0
2016-10-05	FVSA	Futures	1533.65	1544.37	1494.32	1505.05	10296.0
2016-10-05	FXXP	Futures	282.6	283.5	281.0	283.2	22107.0
2016-10-05	G	Futures	116.01	116.02	115.41	115.54	216677.0
2016-10-05	GF	Futures	263.698	265.348	260.294	262.924	2128.0
2016-10-05	GSCI	Futures	527.93	528.5	525.45	527.29	495.0

> showing 50 of 108 rows — these rows as CSV

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