PREVIEW / futures_daily / 2017-01-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-12.parquet
  size:    9 KB
  rows:    107

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-01-12	ES	Futures	2461.45	2461.45	2437.6	2453.86	1752976.0
2017-01-12	NQ	Futures	5945.49	5945.78	5881.55	5934.0	212324.0
2017-01-12	YM	Futures	20939.6	20941.7	20741.5	20858.4	151822.0
2017-01-12	CL	Futures	56.04	57.25	55.78	56.73	660703.0
2017-01-12	GC	Futures	1529.6	1550.3	1529.1	1540.8	269319.0
2017-01-12	ZN	Futures	122.02703	122.577183	122.011748	122.149286	1409184.0
2017-01-12	A6	Futures	0.76091	0.7689	0.75979	0.76614	101179.0
2017-01-12	AD	Futures	0.77556	0.78445	0.77536	0.77852	78094.0
2017-01-12	ALI	Futures	2451.15	2453.73	2439.84	2439.84	18.0
2017-01-12	B	Futures	41.12	42.04	40.98	41.73	331632.0
2017-01-12	B6	Futures	1.2814	1.2935	1.2762	1.2774	122493.0
2017-01-12	BR	Futures	0.22066	0.22137	0.22041	0.22137	24.0
2017-01-12	BZ	Futures	40.84	41.73	40.69	41.42	36424.0
2017-01-12	C	Futures	1822.0	1881.0	1813.0	1878.0	10136.0
2017-01-12	CB	Futures	274.63	274.66	272.189	273.409	36.0
2017-01-12	CC	Futures	1645.0	1700.0	1638.0	1698.0	26940.0
2017-01-12	CNH	Futures	7.3463	7.3463	7.308	7.3148	24.0
2017-01-12	CSC	Futures	4.027	4.078	3.99	4.061	44.0
2017-01-12	CT	Futures	84.15	84.78	83.0	83.1	21149.0
2017-01-12	DC	Futures	33.45	33.84	33.24	33.74	133.0
2017-01-12	DX	Futures	94.71	94.757	93.761	94.391	54031.0
2017-01-12	E1	Futures	1.2255	1.23628	1.225	1.23045	23513.0
2017-01-12	E6	Futures	1.22553	1.23714	1.22409	1.23027	251202.0
2017-01-12	E7	Futures	1.2193	1.2308	1.2178	1.2239	5491.0
2017-01-12	EBM	Futures	192.28	193.99	191.99	193.42	17255.0
2017-01-12	ED	Futures	95.5665	95.581	95.5665	95.5762	307214.0
2017-01-12	ER	Futures	98.308	98.308	98.303	98.308	35879.0
2017-01-12	EW	Futures	1794.8	1795.4	1765.6	1785.7	19704.0
2017-01-12	FBON	Futures	122.77	122.98	122.45	122.66	376.0
2017-01-12	FBTP	Futures	106.89	107.03	106.45	106.64	118563.0
2017-01-12	FBTS	Futures	101.864	101.891	101.8	101.809	42339.0
2017-01-12	FCE	Futures	4299.0	4303.8	4275.7	4281.8	1278.0
2017-01-12	FDAX	Futures	12264.2	12272.1	12127.0	12167.1	86390.0
2017-01-12	FDXM	Futures	12215.8	12224.2	12078.1	12118.0	22706.0
2017-01-12	FESX	Futures	2633.5	2638.3	2616.7	2624.7	885357.0
2017-01-12	FGBL	Futures	147.78	148.07	147.47	147.8	821553.0
2017-01-12	FGBM	Futures	129.03	129.08	128.91	129.0	551336.0
2017-01-12	FGBS	Futures	112.132	112.132	112.097	112.107	296795.0
2017-01-12	FGBX	Futures	169.79	171.32	167.8	169.12	65415.0
2017-01-12	FMWO	Futures	5958.8	5968.4	5931.0	5939.5	1564.0
2017-01-12	FOAT	Futures	133.26	133.51	132.96	133.16	112645.0
2017-01-12	FTDX	Futures	1803.3	1809.7	1789.1	1795.5	161.0
2017-01-12	FTI	Futures	442.15	442.15	439.05	439.19	200.0
2017-01-12	FTUK	Futures	6133.9	6160.6	6103.8	6131.3	128834.0
2017-01-12	FVSA	Futures	907.11	923.69	895.27	916.58	7578.0
2017-01-12	FXXP	Futures	300.4	300.8	298.8	299.5	17875.0
2017-01-12	G	Futures	111.72	112.03	111.67	111.95	174859.0
2017-01-12	GF	Futures	293.288	293.63	286.107	291.236	5572.0
2017-01-12	GSCI	Futures	529.67	529.8	527.63	529.67	4294.0
2017-01-12	HE	Futures	89.101	89.54	87.749	89.169	25278.0

> showing 50 of 107 rows — these rows as CSV

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