PREVIEW / futures_daily / 2017-03-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-27.parquet
  size:    9 KB
  rows:    109

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-03-27	ES	Futures	2538.08	2542.97	2517.18	2539.71	1614233.0
2017-03-27	NQ	Futures	6312.95	6343.28	6262.6	6335.33	276499.0
2017-03-27	YM	Futures	21659.4	21660.5	21479.0	21627.8	175580.0
2017-03-27	CL	Futures	50.43	50.6	49.34	50.03	466176.0
2017-03-27	GC	Futures	1594.9	1616.7	1594.9	1609.8	70825.0
2017-03-27	ZN	Futures	122.338035	122.82966	122.338035	122.583847	1144030.0
2017-03-27	A6	Futures	0.78225	0.78399	0.77989	0.78143	75076.0
2017-03-27	AD	Futures	0.76426	0.76645	0.76166	0.76344	52555.0
2017-03-27	ALI	Futures	2569.67	2569.67	2569.67	2569.67	0.0
2017-03-27	B	Futures	37.1	37.12	36.36	36.91	236775.0
2017-03-27	B6	Futures	1.3122	1.3254	1.3122	1.3202	96494.0
2017-03-27	BFX	Futures	4515.3	4529.8	4515.3	4529.8	3.0
2017-03-27	BR	Futures	0.22861	0.22861	0.22752	0.22752	32.0
2017-03-27	BZ	Futures	36.93	37.01	36.26	36.81	17998.0
2017-03-27	C	Futures	1776.0	1803.0	1759.0	1783.0	8760.0
2017-03-27	CC	Futures	1642.0	1664.0	1625.0	1641.0	18547.0
2017-03-27	CNH	Futures	7.1935	7.1935	7.1811	7.1811	6.0
2017-03-27	CSC	Futures	3.569	3.574	3.554	3.571	17.0
2017-03-27	CT	Futures	86.35	86.64	85.72	85.76	14721.0
2017-03-27	DC	Futures	29.21	29.42	29.04	29.34	103.0
2017-03-27	DX	Futures	92.547	92.547	91.927	92.21	31745.0
2017-03-27	E1	Futures	1.2559	1.26554	1.25503	1.26084	24711.0
2017-03-27	E6	Futures	1.25237	1.26118	1.25237	1.2568	191949.0
2017-03-27	E7	Futures	1.2455	1.2546	1.2455	1.2504	4485.0
2017-03-27	EBM	Futures	186.5	186.78	185.1	185.66	23514.0
2017-03-27	ED	Futures	95.5542	95.5736	95.5542	95.5639	175956.0
2017-03-27	ER	Futures	98.318	98.328	98.318	98.323	105560.0
2017-03-27	EW	Futures	1799.0	1799.5	1775.9	1796.6	17110.0
2017-03-27	FBON	Futures	121.51	121.76	121.17	121.31	611.0
2017-03-27	FBTP	Futures	104.02	104.42	103.97	104.18	85034.0
2017-03-27	FBTS	Futures	101.737	101.809	101.737	101.764	27674.0
2017-03-27	FCE	Futures	4397.1	4433.2	4379.4	4421.8	80211.0
2017-03-27	FDAX	Futures	12697.5	12733.9	12607.8	12690.1	88317.0
2017-03-27	FDXM	Futures	12588.6	12622.1	12498.6	12578.6	26576.0
2017-03-27	FESX	Futures	2734.5	2752.4	2720.6	2744.3	854603.0
2017-03-27	FEU3	Futures	98.996	98.996	98.996	98.996	13.0
2017-03-27	FGBL	Futures	147.52	147.97	147.26	147.29	710691.0
2017-03-27	FGBM	Futures	128.89	129.17	128.71	128.73	506285.0
2017-03-27	FGBS	Futures	112.252	112.297	112.152	112.162	274867.0
2017-03-27	FGBX	Futures	167.55	169.27	166.95	167.13	48576.0
2017-03-27	FMWO	Futures	6153.1	6176.0	6142.3	6174.8	25.0
2017-03-27	FOAT	Futures	131.47	132.03	131.42	131.44	91529.0
2017-03-27	FTDX	Futures	1946.5	1950.9	1945.5	1950.4	112.0
2017-03-27	FTI	Futures	460.88	462.84	459.15	461.97	26130.0
2017-03-27	FTUK	Futures	6190.6	6193.6	6144.8	6178.6	100313.0
2017-03-27	FVSA	Futures	666.9	672.44	655.81	662.74	12300.0
2017-03-27	FXXP	Futures	310.2	311.7	309.2	311.0	21172.0
2017-03-27	G	Futures	114.69	114.85	114.5	114.58	144953.0
2017-03-27	GF	Futures	310.824	311.458	306.212	306.961	3487.0
2017-03-27	GSCI	Futures	477.31	480.44	477.31	480.44	120.0

> showing 50 of 109 rows — these rows as CSV

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