PREVIEW / futures_daily / 2017-12-27

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-27.parquet
  size:    10 KB
  rows:    112

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-12-27	ES	Futures	2920.99	2924.79	2914.47	2918.81	666329.0
2017-12-27	NQ	Futures	7567.28	7583.97	7544.74	7558.79	158481.0
2017-12-27	YM	Futures	26145.8	26176.4	26114.2	26141.6	65184.0
2017-12-27	CL	Futures	59.78	59.92	59.32	59.63	402396.0
2017-12-27	GC	Futures	1632.6	1639.5	1630.4	1637.2	205799.0
2017-12-27	ZN	Futures	121.990615	122.437976	121.959763	122.407124	783811.0
2017-12-27	A6	Futures	0.79473	0.80018	0.79452	0.79987	66718.0
2017-12-27	AD	Futures	0.80173	0.80539	0.80112	0.80437	53255.0
2017-12-27	B	Futures	47.39	47.53	46.87	47.25	228212.0
2017-12-27	B6	Futures	1.3965	1.4019	1.396	1.3978	70513.0
2017-12-27	BFX	Futures	4754.1	4763.6	4754.1	4763.6	7.0
2017-12-27	BR	Futures	0.22524	0.22786	0.22524	0.22786	1.0
2017-12-27	BTC	Futures	20049.5	21189.3	18519.1	18813.6	507.0
2017-12-27	BZ	Futures	46.82	46.87	46.24	46.61	23104.0
2017-12-27	C	Futures	1258.0	1264.0	1231.0	1250.0	10638.0
2017-12-27	CB	Futures	273.649	275.379	273.649	274.298	24.0
2017-12-27	CC	Futures	1393.0	1412.0	1374.0	1392.0	21680.0
2017-12-27	CNH	Futures	6.7111	6.717	6.7069	6.7108	126.0
2017-12-27	CSC	Futures	3.203	3.223	3.201	3.221	19.0
2017-12-27	CT	Futures	90.52	92.26	90.22	92.21	18514.0
2017-12-27	DC	Futures	25.24	25.31	25.09	25.2	128.0
2017-12-27	DX	Futures	87.172	87.21	86.89	86.972	16223.0
2017-12-27	E1	Futures	1.23613	1.24075	1.23516	1.23965	16990.0
2017-12-27	E6	Futures	1.35332	1.35853	1.35258	1.35694	124813.0
2017-12-27	E7	Futures	1.3465	1.3516	1.3458	1.3502	2181.0
2017-12-27	EBM	Futures	172.89	172.89	171.81	172.08	9633.0
2017-12-27	ED	Futures	95.3747	95.4039	95.3747	95.3942	135597.0
2017-12-27	ER	Futures	98.337	98.337	98.332	98.337	50069.0
2017-12-27	EW	Futures	2025.6	2032.6	2023.1	2024.6	8833.0
2017-12-27	FBON	Futures	126.75	126.94	126.57	126.92	121.0
2017-12-27	FBTP	Futures	111.99	112.23	111.74	112.16	37734.0
2017-12-27	FBTS	Futures	103.64	103.65	103.576	103.604	22562.0
2017-12-27	FCE	Futures	4790.4	4819.9	4785.9	4802.0	36459.0
2017-12-27	FDAX	Futures	13539.0	13621.0	13500.1	13566.5	52209.0
2017-12-27	FDXM	Futures	13572.4	13644.1	13523.6	13589.5	15899.0
2017-12-27	FESX	Futures	2891.9	2906.6	2882.9	2892.7	341766.0
2017-12-27	FEU3	Futures	99.011	99.011	99.011	99.011	3.0
2017-12-27	FGBL	Futures	149.8	150.48	149.8	150.41	248658.0
2017-12-27	FGBM	Futures	129.24	129.46	129.2	129.45	189229.0
2017-12-27	FGBS	Futures	112.261	112.372	112.251	112.362	205577.0
2017-12-27	FGBX	Futures	168.95	170.68	168.95	170.53	18308.0
2017-12-27	FMWO	Futures	6949.2	6964.3	6948.0	6959.7	781.0
2017-12-27	FOAT	Futures	138.5	138.97	138.5	138.94	47119.0
2017-12-27	FTDX	Futures	2492.5	2531.4	2492.5	2529.9	34.0
2017-12-27	FTI	Futures	506.4	508.95	505.66	507.7	12579.0
2017-12-27	FTUK	Futures	6576.4	6617.0	6573.3	6604.8	57044.0
2017-12-27	FVSA	Futures	280.23	285.5	277.07	281.29	6686.0
2017-12-27	FXXP	Futures	331.8	332.0	330.6	331.4	13685.0
2017-12-27	G	Futures	114.88	115.67	114.88	115.59	106682.0
2017-12-27	GF	Futures	313.22	315.058	311.977	313.869	2069.0

> showing 50 of 112 rows — these rows as CSV

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