PREVIEW / futures_daily / 2012-12-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-12-27.parquet
  size:    9 KB
  rows:    101

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
2012-12-27	ES	Futures	1446.03	1451.4	1428.38	1443.47	1470310.0
2012-12-27	NQ	Futures	3035.56	3042.48	2991.44	3024.89	211526.0
2012-12-27	YM	Futures	12796.8	12825.2	12643.8	12750.7	126509.0
2012-12-27	CL	Futures	161.51	162.29	159.83	161.28	152771.0
2012-12-27	GC	Futures	2211.9	2220.3	2203.0	2217.1	95883.0
2012-12-27	ZN	Futures	116.900417	117.327664	116.707467	117.244971	564774.0
2012-12-27	A6	Futures	0.94365	0.94511	0.94118	0.94392	55328.0
2012-12-27	AD	Futures	1.007	1.01021	1.0049	1.006	37532.0
2012-12-27	B	Futures	103.19	103.52	102.39	103.02	51283.0
2012-12-27	B6	Futures	1.6861	1.693	1.6788	1.6831	78650.0
2012-12-27	BFX	Futures	3009.8	3009.9	3005.2	3005.2	83.0
2012-12-27	BR	Futures	0.23704	0.23826	0.23704	0.2375	188.0
2012-12-27	BZ	Futures	105.5	105.5	104.94	105.32	520.0
2012-12-27	C	Futures	1554.0	1559.0	1542.0	1544.0	4680.0
2012-12-27	CB	Futures	85.188	85.188	85.084	85.084	18.0
2012-12-27	CC	Futures	1715.0	1727.0	1698.0	1701.0	7108.0
2012-12-27	CSC	Futures	3.873	3.916	3.862	3.873	17.0
2012-12-27	CT	Futures	96.98	97.03	94.92	95.66	11677.0
2012-12-27	DC	Futures	29.01	29.35	28.91	28.99	69.0
2012-12-27	DX	Futures	76.808	77.049	76.596	76.884	15349.0
2012-12-27	E1	Futures	1.41174	1.41766	1.40801	1.41122	18730.0
2012-12-27	E6	Futures	1.56094	1.56802	1.55835	1.56259	154306.0
2012-12-27	E7	Futures	1.55	1.5573	1.5477	1.5519	2764.0
2012-12-27	EBM	Futures	278.68	278.96	275.9	276.17	16350.0
2012-12-27	ED	Futures	95.2056	95.2199	95.2008	95.2056	76501.0
2012-12-27	ER	Futures	97.827	97.842	97.734	97.832	63017.0
2012-12-27	EW	Futures	1028.5	1040.6	1017.9	1026.1	17995.0
2012-12-27	FBTP	Futures	75.38	75.4	75.06	75.1	6751.0
2012-12-27	FBTS	Futures	90.807	90.917	90.748	90.807	587.0
2012-12-27	FCE	Futures	2753.4	2777.1	2753.4	2768.4	53074.0
2012-12-27	FDAX	Futures	8334.9	8393.9	8333.3	8363.3	54830.0
2012-12-27	FESX	Futures	1800.9	1815.9	1798.8	1808.4	396718.0
2012-12-27	FEU3	Futures	98.438	98.438	98.433	98.438	200.0
2012-12-27	FGBL	Futures	119.67	120.37	119.54	120.3	210140.0
2012-12-27	FGBM	Futures	117.24	117.63	117.18	117.52	124127.0
2012-12-27	FGBS	Futures	110.482	110.522	110.472	110.497	83578.0
2012-12-27	FGBX	Futures	127.32	129.11	126.93	128.92	3479.0
2012-12-27	FOAT	Futures	106.18	106.38	106.11	106.32	5278.0
2012-12-27	FTDX	Futures	787.2	787.2	784.3	787.2	34.0
2012-12-27	FTI	Futures	294.49	297.58	294.4	296.68	14649.0
2012-12-27	FTUK	Futures	4349.4	4386.5	4342.7	4352.3	55213.0
2012-12-27	FVSA	Futures	4172.69	4406.2	3959.49	4121.93	6508.0
2012-12-27	FXXP	Futures	201.3	202.3	200.9	201.6	2755.0
2012-12-27	G	Futures	98.15	98.9	98.09	98.88	50481.0
2012-12-27	GF	Futures	289.28	289.328	286.102	287.051	1568.0
2012-12-27	GSCI	Futures	1040.25	1043.55	1036.39	1039.85	606.0
2012-12-27	HE	Futures	100.13	100.245	99.441	99.872	12360.0
2012-12-27	HG	Futures	4.6159	4.6384	4.6095	4.6243	26857.0
2012-12-27	HH	Futures	39.905	40.058	39.905	40.058	1.0
2012-12-27	HO	Futures	2.4356	2.4482	2.4261	2.4411	15553.0

> showing 50 of 101 rows — these rows as CSV

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