PREVIEW / futures_daily / 2014-06-23

all futures daily files

  file:    by_date/futures_daily/2014/2014-06-23.parquet
  size:    9 KB
  rows:    104

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
2014-06-23	ES	Futures	2028.51	2035.78	2025.65	2028.77	1024411.0
2014-06-23	NQ	Futures	4375.42	4392.72	4367.34	4378.01	161444.0
2014-06-23	YM	Futures	17006.4	17062.9	16959.0	16991.3	95627.0
2014-06-23	CL	Futures	196.22	196.28	193.46	193.94	175473.0
2014-06-23	GC	Futures	1732.5	1738.2	1726.6	1737.1	109392.0
2014-06-23	ZN	Futures	116.127249	116.273138	115.981361	116.025127	659782.0
2014-06-23	A6	Futures	0.90108	0.90746	0.90088	0.90465	56828.0
2014-06-23	AD	Futures	0.94241	0.94577	0.94211	0.94495	51917.0
2014-06-23	ALI	Futures	2809.05	2809.05	2791.55	2791.55	29.0
2014-06-23	B	Futures	120.35	121.05	119.17	119.44	220720.0
2014-06-23	B6	Futures	1.7881	1.7915	1.7861	1.7883	60677.0
2014-06-23	BFX	Futures	3816.1	3816.1	3810.4	3810.4	13.0
2014-06-23	BR	Futures	0.23228	0.23837	0.23197	0.23495	10467.0
2014-06-23	BZ	Futures	121.63	122.1	120.22	120.49	11582.0
2014-06-23	C	Futures	2038.0	2041.0	2020.0	2021.0	4535.0
2014-06-23	CB	Futures	119.336	121.153	119.336	121.153	4.0
2014-06-23	CC	Futures	2282.0	2284.0	2260.0	2263.0	9464.0
2014-06-23	CNH	Futures	7.1703	7.1703	7.1693	7.1693	1.0
2014-06-23	CSC	Futures	4.622	4.689	4.605	4.689	48.0
2014-06-23	CT	Futures	99.2	99.74	94.77	98.55	11712.0
2014-06-23	DC	Futures	36.9	37.64	36.78	37.5	142.0
2014-06-23	DX	Futures	76.361	76.38	76.237	76.259	9911.0
2014-06-23	E1	Futures	1.43237	1.43481	1.43032	1.43468	19195.0
2014-06-23	E6	Futures	1.60436	1.60672	1.602	1.60554	102386.0
2014-06-23	E7	Futures	1.5939	1.5962	1.5917	1.5951	1416.0
2014-06-23	ED	Futures	95.4115	95.4162	95.4067	95.4115	64105.0
2014-06-23	ER	Futures	97.901	97.911	97.901	97.901	28879.0
2014-06-23	EW	Futures	1476.2	1481.3	1472.5	1475.0	10223.0
2014-06-23	FBTP	Futures	90.77	91.13	90.65	91.07	33663.0
2014-06-23	FBTS	Futures	97.876	98.01	97.876	97.992	9318.0
2014-06-23	FCE	Futures	3623.5	3626.7	3581.6	3599.6	104934.0
2014-06-23	FDAX	Futures	11026.8	11035.7	10882.0	10938.7	89708.0
2014-06-23	FESX	Futures	2373.5	2376.3	2347.6	2358.4	774303.0
2014-06-23	FEU3	Futures	98.527	98.527	98.527	98.527	397.0
2014-06-23	FGBL	Futures	126.79	127.18	126.71	127.08	392391.0
2014-06-23	FGBM	Futures	121.13	121.31	121.07	121.25	323038.0
2014-06-23	FGBS	Futures	110.733	110.753	110.723	110.738	146892.0
2014-06-23	FGBX	Futures	130.36	131.01	130.3	130.89	13641.0
2014-06-23	FMWO	Futures	5786.5	5786.5	5780.2	5786.5	51.0
2014-06-23	FOAT	Futures	116.62	116.86	116.55	116.78	41524.0
2014-06-23	FTDX	Futures	1246.4	1247.3	1235.2	1238.4	132.0
2014-06-23	FTI	Futures	361.77	362.33	358.66	359.22	25730.0
2014-06-23	FTUK	Futures	5212.3	5222.7	5181.9	5193.5	70545.0
2014-06-23	FVSA	Futures	1272.17	1302.25	1267.87	1285.06	6283.0
2014-06-23	FXXP	Futures	261.5	261.5	259.5	260.3	5409.0
2014-06-23	G	Futures	93.01	93.35	92.99	93.28	97929.0
2014-06-23	GF	Futures	317.822	319.623	317.4	318.627	2153.0
2014-06-23	GSCI	Futures	1115.25	1115.25	1108.67	1109.08	171.0
2014-06-23	HE	Futures	134.679	135.074	133.68	134.995	6408.0
2014-06-23	HG	Futures	3.9707	4.0327	3.9707	4.0161	30748.0

> showing 50 of 104 rows — these rows as CSV

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