PREVIEW / futures_daily / 2016-08-25

all futures daily files

  file:    by_date/futures_daily/2016/2016-08-25.parquet
  size:    9 KB
  rows:    107

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-08-25	ES	Futures	2348.33	2350.76	2340.23	2346.71	1501328.0
2016-08-25	NQ	Futures	5642.02	5650.86	5620.51	5637.01	194394.0
2016-08-25	YM	Futures	19292.2	19307.9	19225.4	19269.3	116870.0
2016-08-25	CL	Futures	52.02	52.75	51.6	52.61	458816.0
2016-08-25	GC	Futures	1703.1	1706.7	1694.9	1699.5	167657.0
2016-08-25	ZN	Futures	127.667661	127.773296	127.486572	127.546935	2063603.0
2016-08-25	A6	Futures	0.77426	0.7767	0.77294	0.77436	60465.0
2016-08-25	AD	Futures	0.79158	0.79347	0.79096	0.79163	37049.0
2016-08-25	ALI	Futures	2125.83	2127.41	2125.83	2127.41	2.0
2016-08-25	B	Futures	38.77	39.33	38.48	39.25	192513.0
2016-08-25	B6	Futures	1.3954	1.3988	1.3887	1.3889	56190.0
2016-08-25	BR	Futures	0.20623	0.20623	0.20623	0.20623	8.0
2016-08-25	BZ	Futures	38.57	39.16	38.32	39.08	21610.0
2016-08-25	C	Futures	2571.0	2602.0	2561.0	2583.0	5688.0
2016-08-25	CB	Futures	258.527	260.356	258.527	260.356	3.0
2016-08-25	CC	Futures	2231.0	2265.0	2225.0	2240.0	16606.0
2016-08-25	CSC	Futures	3.919	3.919	3.893	3.903	38.0
2016-08-25	CT	Futures	75.99	77.12	75.99	76.75	5.0
2016-08-25	DC	Futures	31.39	31.56	31.14	31.18	86.0
2016-08-25	DX	Futures	88.132	88.169	87.942	88.116	7782.0
2016-08-25	E1	Futures	1.29645	1.30034	1.29407	1.29508	16650.0
2016-08-25	E6	Futures	1.3125	1.31646	1.31198	1.31425	103635.0
2016-08-25	E7	Futures	1.3054	1.3093	1.305	1.3072	1315.0
2016-08-25	EBM	Futures	191.26	192.76	190.36	192.46	9081.0
2016-08-25	ED	Futures	95.6364	95.6412	95.6243	95.6267	165727.0
2016-08-25	ER	Futures	98.303	98.303	98.298	98.303	29001.0
2016-08-25	EW	Futures	1653.2	1662.2	1648.3	1657.5	15715.0
2016-08-25	FBON	Futures	124.94	125.09	124.77	125.07	183.0
2016-08-25	FBTP	Futures	110.67	110.69	110.33	110.63	52386.0
2016-08-25	FBTS	Futures	101.347	101.356	101.347	101.356	8206.0
2016-08-25	FCE	Futures	3874.2	3874.6	3822.7	3848.9	77689.0
2016-08-25	FDAX	Futures	11300.1	11300.1	11137.3	11203.8	84812.0
2016-08-25	FDXM	Futures	11006.3	11015.6	10855.9	10920.7	24329.0
2016-08-25	FESX	Futures	2352.5	2353.3	2325.9	2340.0	905292.0
2016-08-25	FGBL	Futures	150.81	150.84	150.38	150.69	455930.0
2016-08-25	FGBM	Futures	128.91	128.91	128.79	128.85	292809.0
2016-08-25	FGBS	Futures	111.867	111.872	111.847	111.857	196624.0
2016-08-25	FGBX	Futures	189.31	189.49	187.54	188.71	20525.0
2016-08-25	FMWO	Futures	5778.1	5789.0	5775.6	5787.8	46.0
2016-08-25	FOAT	Futures	138.63	138.66	138.19	138.51	68545.0
2016-08-25	FTDX	Futures	1654.9	1661.6	1642.8	1657.3	255.0
2016-08-25	FTI	Futures	407.22	407.4	404.06	405.96	23147.0
2016-08-25	FTUK	Futures	5691.6	5696.2	5654.1	5687.8	84962.0
2016-08-25	FVSA	Futures	1934.21	1964.5	1908.24	1938.53	7022.0
2016-08-25	FXXP	Futures	278.3	278.3	275.7	276.7	14563.0
2016-08-25	G	Futures	117.08	117.21	116.81	117.06	345840.0
2016-08-25	GF	Futures	287.298	287.75	283.776	285.336	3187.0
2016-08-25	GSCI	Futures	512.85	515.54	512.85	515.54	36.0
2016-08-25	HE	Futures	83.29	83.325	80.765	81.215	14870.0
2016-08-25	HG	Futures	2.6041	2.6165	2.5929	2.5947	36085.0

> showing 50 of 107 rows — these rows as CSV

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