PREVIEW / futures_daily / 2017-07-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-12.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-07-12	ES	Futures	2635.54	2655.92	2632.83	2651.85	1163339.0
2017-07-12	NQ	Futures	6723.51	6806.38	6715.57	6801.39	262329.0
2017-07-12	YM	Futures	22602.0	22760.6	22578.8	22709.9	120415.0
2017-07-12	CL	Futures	47.23	48.0	46.58	46.98	963505.0
2017-07-12	GC	Futures	1553.0	1564.1	1547.8	1556.3	262766.0
2017-07-12	ZN	Futures	123.288196	123.842232	123.257417	123.626773	1622688.0
2017-07-12	A6	Futures	0.7839	0.78883	0.78369	0.78852	84258.0
2017-07-12	AD	Futures	0.78809	0.80284	0.78687	0.80029	139977.0
2017-07-12	ALI	Futures	2494.13	2494.13	2483.04	2483.04	20.0
2017-07-12	B	Futures	34.09	34.5	33.48	33.75	333698.0
2017-07-12	B6	Futures	1.3454	1.3522	1.3418	1.3496	116797.0
2017-07-12	BR	Futures	0.22731	0.22924	0.22731	0.22872	1894.0
2017-07-12	BZ	Futures	33.87	34.25	33.26	33.54	31345.0
2017-07-12	C	Futures	1460.0	1468.0	1445.0	1465.0	9109.0
2017-07-12	CB	Futures	321.41	321.41	317.487	318.703	107.0
2017-07-12	CC	Futures	1369.0	1388.0	1367.0	1383.0	16837.0
2017-07-12	CNH	Futures	7.0504	7.0504	7.039	7.039	5.0
2017-07-12	CSC	Futures	3.544	3.559	3.499	3.505	51.0
2017-07-12	CT	Futures	79.25	79.9	78.7	79.51	65.0
2017-07-12	DC	Futures	29.65	29.82	29.32	29.44	340.0
2017-07-12	DX	Futures	89.1	89.404	88.965	89.186	20845.0
2017-07-12	E1	Futures	1.27984	1.28427	1.27653	1.27788	25521.0
2017-07-12	E6	Futures	1.31822	1.32103	1.30974	1.31243	242103.0
2017-07-12	E7	Futures	1.3113	1.3141	1.3028	1.3055	5070.0
2017-07-12	EBM	Futures	202.09	202.09	199.31	199.87	9471.0
2017-07-12	ED	Futures	95.5838	95.5983	95.5838	95.5935	282055.0
2017-07-12	ER	Futures	98.337	98.337	98.332	98.337	34193.0
2017-07-12	EW	Futures	1855.7	1877.2	1853.7	1865.9	15073.0
2017-07-12	FBON	Futures	122.63	123.31	122.6	123.07	417.0
2017-07-12	FBTP	Futures	106.02	106.81	105.97	106.72	88853.0
2017-07-12	FBTS	Futures	102.635	102.754	102.626	102.745	47886.0
2017-07-12	FCE	Futures	4633.4	4703.4	4632.9	4688.2	135.0
2017-07-12	FDAX	Futures	13118.8	13318.3	13103.5	13298.3	82859.0
2017-07-12	FDXM	Futures	13039.6	13236.3	13022.9	13216.4	21045.0
2017-07-12	FESX	Futures	2832.4	2872.4	2827.5	2867.5	829286.0
2017-07-12	FEU3	Futures	99.006	99.006	99.006	99.006	4.0
2017-07-12	FGBL	Futures	146.23	146.66	146.1	146.64	697693.0
2017-07-12	FGBM	Futures	128.3	128.45	128.21	128.43	372546.0
2017-07-12	FGBS	Futures	112.106	112.141	112.081	112.136	234482.0
2017-07-12	FGBX	Futures	162.3	163.45	162.1	163.05	44111.0
2017-07-12	FMWO	Futures	6410.2	6459.1	6410.2	6459.1	542.0
2017-07-12	FOAT	Futures	133.9	134.39	133.82	134.34	76789.0
2017-07-12	FTDX	Futures	2249.1	2274.7	2241.1	2274.7	226.0
2017-07-12	FTI	Futures	469.98	475.3	469.98	474.28	46.0
2017-07-12	FTUK	Futures	6301.8	6376.6	6296.2	6358.9	95216.0
2017-07-12	FVSA	Futures	486.51	486.51	465.75	473.16	13376.0
2017-07-12	FXXP	Futures	322.1	327.4	322.0	326.8	33800.0
2017-07-12	G	Futures	114.1	114.18	113.74	114.02	163754.0
2017-07-12	GF	Futures	324.887	333.119	323.131	333.119	6674.0
2017-07-12	GSCI	Futures	453.02	453.02	448.95	448.95	2635.0

> showing 50 of 108 rows — these rows as CSV

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