PREVIEW / futures_daily / 2017-09-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-27.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
2017-09-27	ES	Futures	2713.8	2729.3	2711.62	2724.13	1576031.0
2017-09-27	NQ	Futures	6918.17	7004.21	6914.35	6978.37	349282.0
2017-09-27	YM	Futures	23495.9	23576.1	23451.5	23546.6	115420.0
2017-09-27	CL	Futures	52.78	53.04	52.32	52.83	637035.0
2017-09-27	GC	Futures	1650.7	1653.1	1633.9	1638.6	374773.0
2017-09-27	ZN	Futures	124.163776	124.179181	123.547578	123.670818	2014703.0
2017-09-27	A6	Futures	0.81047	0.81078	0.80543	0.8079	113019.0
2017-09-27	AD	Futures	0.82465	0.82521	0.81549	0.81676	106661.0
2017-09-27	B	Futures	41.04	41.2	40.43	40.66	405232.0
2017-09-27	B6	Futures	1.4071	1.4073	1.3969	1.4011	118559.0
2017-09-27	BR	Futures	0.23513	0.23513	0.23392	0.23483	913.0
2017-09-27	BZ	Futures	40.71	40.86	40.11	40.32	37980.0
2017-09-27	C	Futures	1440.0	1467.0	1439.0	1466.0	8952.0
2017-09-27	CB	Futures	311.154	311.154	308.634	308.634	44.0
2017-09-27	CC	Futures	1466.0	1501.0	1463.0	1496.0	21592.0
2017-09-27	CNH	Futures	6.8377	6.863	6.8377	6.847	93.0
2017-09-27	CSC	Futures	3.497	3.52	3.497	3.507	49.0
2017-09-27	CT	Futures	80.93	81.16	80.08	80.63	8948.0
2017-09-27	DC	Futures	28.95	29.06	28.76	28.86	134.0
2017-09-27	DX	Futures	86.867	87.358	86.792	87.13	32504.0
2017-09-27	E1	Futures	1.26869	1.26881	1.25817	1.26563	34049.0
2017-09-27	E6	Futures	1.35167	1.35201	1.34306	1.34768	253130.0
2017-09-27	E7	Futures	1.3446	1.3448	1.3361	1.3406	4984.0
2017-09-27	EBM	Futures	179.09	180.44	178.55	180.17	18793.0
2017-09-27	ED	Futures	95.5085	95.5133	95.4988	95.5036	250017.0
2017-09-27	ER	Futures	98.337	98.342	98.337	98.342	33724.0
2017-09-27	EW	Futures	1885.5	1905.7	1883.2	1903.5	18985.0
2017-09-27	FBON	Futures	125.09	125.09	124.46	124.64	984.0
2017-09-27	FBTP	Futures	108.74	108.83	108.07	108.33	102315.0
2017-09-27	FBTS	Futures	103.228	103.237	103.182	103.219	43596.0
2017-09-27	FCE	Futures	4729.8	4746.0	4720.9	4728.9	80328.0
2017-09-27	FDAX	Futures	13272.9	13341.2	13256.6	13296.5	67667.0
2017-09-27	FDXM	Futures	13162.4	13228.1	13144.7	13184.3	19774.0
2017-09-27	FESX	Futures	2880.5	2902.6	2878.1	2892.8	775958.0
2017-09-27	FGBL	Futures	149.49	149.49	148.54	148.88	1051302.0
2017-09-27	FGBM	Futures	129.71	129.71	129.36	129.53	764567.0
2017-09-27	FGBS	Futures	112.442	112.452	112.382	112.417	320390.0
2017-09-27	FGBX	Futures	167.79	167.79	165.5	166.3	55443.0
2017-09-27	FMWO	Futures	6602.2	6625.8	6598.6	6604.5	305.0
2017-09-27	FOAT	Futures	136.53	136.59	135.67	135.96	136653.0
2017-09-27	FTDX	Futures	2396.2	2403.6	2389.2	2396.6	79.0
2017-09-27	FTI	Futures	487.15	490.37	487.15	488.99	20355.0
2017-09-27	FTUK	Futures	6280.3	6323.6	6274.2	6306.3	98841.0
2017-09-27	FVSA	Futures	410.07	411.49	402.98	407.23	9751.0
2017-09-27	FXXP	Futures	325.7	327.1	325.5	326.5	26345.0
2017-09-27	G	Futures	113.4	113.47	112.95	113.19	238792.0
2017-09-27	GF	Futures	329.505	333.924	329.232	333.269	3244.0
2017-09-27	GSCI	Futures	480.04	480.88	478.85	480.64	86.0
2017-09-27	HE	Futures	85.788	88.224	85.53	88.077	21210.0
2017-09-27	HG	Futures	3.5237	3.5635	3.5182	3.5388	94250.0

> showing 50 of 108 rows — these rows as CSV

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