PREVIEW / futures_daily / 2016-12-27

all futures daily files

  file:    by_date/futures_daily/2016/2016-12-27.parquet
  size:    9 KB
  rows:    101

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-12-27	ES	Futures	2448.71	2460.36	2447.63	2451.15	498741.0
2016-12-27	NQ	Futures	5824.68	5886.56	5822.32	5847.37	100365.0
2016-12-27	YM	Futures	20921.6	20983.8	20918.5	20935.3	45577.0
2016-12-27	CL	Futures	57.03	57.9	56.75	57.68	277306.0
2016-12-27	GC	Futures	1458.0	1479.0	1454.7	1462.4	108454.0
2016-12-27	ZN	Futures	120.636365	120.636365	120.391852	120.498826	263382.0
2016-12-27	A6	Futures	0.73429	0.73562	0.73316	0.73449	27283.0
2016-12-27	AD	Futures	0.75631	0.75646	0.75283	0.7534	26537.0
2016-12-27	ALI	Futures	2355.87	2355.87	2355.87	2355.87	0.0
2016-12-27	B	Futures	41.69	43.08	41.55	42.34	109586.0
2016-12-27	B6	Futures	1.2903	1.2917	1.2867	1.2902	31557.0
2016-12-27	BR	Futures	0.21277	0.21344	0.21277	0.21344	107.0
2016-12-27	BZ	Futures	41.54	42.14	41.26	42.03	10139.0
2016-12-27	CB	Futures	280.733	283.174	280.733	281.343	21.0
2016-12-27	CC	Futures	1724.0	1730.0	1679.0	1703.0	7010.0
2016-12-27	CNH	Futures	7.4676	7.4752	7.4654	7.4654	17.0
2016-12-27	CSC	Futures	4.025	4.025	4.025	4.025	13.0
2016-12-27	CT	Futures	80.15	80.69	79.86	80.11	7700.0
2016-12-27	DC	Futures	32.96	33.21	32.9	33.15	145.0
2016-12-27	DX	Futures	95.953	96.032	95.874	95.909	8157.0
2016-12-27	E1	Futures	1.21298	1.21335	1.20963	1.21223	7343.0
2016-12-27	E6	Futures	1.21265	1.21381	1.20982	1.213	55644.0
2016-12-27	E7	Futures	1.2074	1.2076	1.2037	1.2068	1287.0
2016-12-27	EBM	Futures	189.71	191.42	188.58	190.57	8221.0
2016-12-27	ED	Futures	95.5713	95.581	95.5713	95.5713	56807.0
2016-12-27	ER	Futures	98.279	98.288	98.279	98.283	22442.0
2016-12-27	EW	Futures	1779.1	1792.4	1778.0	1787.4	6508.0
2016-12-27	FBON	Futures	122.86	122.97	122.43	122.92	68.0
2016-12-27	FBTP	Futures	107.09	107.09	106.59	106.87	20829.0
2016-12-27	FBTS	Futures	101.927	101.972	101.9	101.936	8171.0
2016-12-27	FCE	Futures	4251.1	4269.5	4251.1	4265.6	26347.0
2016-12-27	FDAX	Futures	12061.5	12122.2	12061.0	12113.8	23655.0
2016-12-27	FDXM	Futures	12022.4	12072.8	12010.8	12065.0	4736.0
2016-12-27	FESX	Futures	2607.9	2619.1	2607.1	2615.9	182762.0
2016-12-27	FGBL	Futures	147.5	148.06	147.5	148.04	148150.0
2016-12-27	FGBM	Futures	129.0	129.34	129.0	129.28	105905.0
2016-12-27	FGBS	Futures	112.157	112.247	112.157	112.237	66817.0
2016-12-27	FGBX	Futures	172.2	174.02	171.87	173.23	11591.0
2016-12-27	FMWO	Futures	5880.4	5893.6	5880.4	5892.4	804.0
2016-12-27	FOAT	Futures	133.75	134.29	133.61	134.28	25691.0
2016-12-27	FTDX	Futures	1756.3	1779.3	1756.3	1774.9	60.0
2016-12-27	FTI	Futures	439.24	440.47	439.06	439.97	7855.0
2016-12-27	FVSA	Futures	1046.87	1068.8	1044.13	1057.84	2543.0
2016-12-27	FXXP	Futures	297.3	298.3	297.0	297.5	5402.0
2016-12-27	GF	Futures	290.115	291.566	288.944	289.892	1375.0
2016-12-27	GSCI	Futures	524.56	528.26	524.42	527.34	94.0
2016-12-27	HE	Futures	84.504	87.715	84.031	87.546	14865.0
2016-12-27	HG	Futures	3.062	3.1421	3.0396	3.1235	39490.0
2016-12-27	HH	Futures	27.992	28.33	27.752	28.247	2238.0
2016-12-27	HO	Futures	1.156	1.181	1.1476	1.1732	18424.0

> showing 50 of 101 rows — these rows as CSV

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