PREVIEW / futures_daily / 2012-11-07

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-07.parquet
  size:    9 KB
  rows:    99

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-11-07	ES	Futures	1450.34	1457.21	1408.61	1413.7	3199570.0
2012-11-07	NQ	Futures	3079.9	3092.84	2990.44	3003.1	401571.0
2012-11-07	YM	Futures	12887.7	12939.5	12525.5	12560.6	242828.0
2012-11-07	CL	Futures	159.36	160.04	151.48	152.18	422211.0
2012-11-07	GC	Futures	2290.8	2313.8	2273.7	2288.4	265682.0
2012-11-07	ZN	Futures	116.601546	117.521723	116.587812	117.411851	1582319.0
2012-11-07	A6	Futures	0.94434	0.94925	0.94207	0.94344	135499.0
2012-11-07	AD	Futures	1.01051	1.01553	1.00439	1.00609	105990.0
2012-11-07	B	Futures	101.37	102.22	97.63	97.88	155017.0
2012-11-07	B6	Futures	1.6703	1.6753	1.666	1.6696	113735.0
2012-11-07	BFX	Futures	2897.4	2897.4	2830.1	2830.1	4.0
2012-11-07	BR	Futures	0.23808	0.23808	0.23796	0.23806	55.0
2012-11-07	BZ	Futures	104.73	105.14	100.88	100.93	396.0
2012-11-07	C	Futures	1609.0	1614.0	1570.0	1572.0	2649.0
2012-11-07	CB	Futures	92.327	92.327	92.06	92.06	1.0
2012-11-07	CC	Futures	1860.0	1867.0	1805.0	1810.0	24816.0
2012-11-07	CSC	Futures	4.097	4.097	4.065	4.065	54.0
2012-11-07	CT	Futures	90.43	91.03	90.07	90.11	17959.0
2012-11-07	DC	Futures	31.24	31.35	30.22	30.25	489.0
2012-11-07	DX	Futures	78.249	78.482	77.842	78.329	34744.0
2012-11-07	E1	Futures	1.36579	1.37286	1.35961	1.36308	40253.0
2012-11-07	E6	Futures	1.50931	1.51684	1.50036	1.50412	361792.0
2012-11-07	E7	Futures	1.5004	1.5078	1.4914	1.4951	5127.0
2012-11-07	ED	Futures	95.2349	95.2444	95.2301	95.2396	121789.0
2012-11-07	ER	Futures	97.881	97.901	97.876	97.886	131616.0
2012-11-07	EW	Futures	1019.7	1024.8	993.1	995.6	31747.0
2012-11-07	FBTP	Futures	72.69	72.9	72.51	72.62	23003.0
2012-11-07	FBTS	Futures	89.86	89.893	89.759	89.818	3374.0
2012-11-07	FCE	Futures	2624.2	2642.2	2558.4	2561.0	154382.0
2012-11-07	FDAX	Futures	8125.2	8150.9	7913.7	7921.9	193824.0
2012-11-07	FESX	Futures	1730.7	1741.6	1683.8	1685.1	1387431.0
2012-11-07	FGBL	Futures	118.74	119.41	118.49	119.3	845012.0
2012-11-07	FGBM	Futures	116.68	117.09	116.58	117.0	579489.0
2012-11-07	FGBS	Futures	110.457	110.562	110.442	110.527	525167.0
2012-11-07	FGBX	Futures	126.25	127.48	125.8	127.09	9971.0
2012-11-07	FOAT	Futures	103.85	104.3	103.85	104.19	28765.0
2012-11-07	FTDX	Futures	771.2	775.4	761.8	765.1	123.0
2012-11-07	FTI	Futures	289.39	290.8	284.93	285.27	44852.0
2012-11-07	FTUK	Futures	4295.5	4322.5	4223.0	4226.3	127920.0
2012-11-07	FVSA	Futures	4743.47	5059.7	4641.83	5059.7	6855.0
2012-11-07	FXXP	Futures	198.7	199.2	195.0	195.1	3679.0
2012-11-07	G	Futures	98.67	99.32	98.67	99.27	142121.0
2012-11-07	GF	Futures	278.531	278.531	275.795	276.899	1812.0
2012-11-07	GSCI	Futures	1036.52	1037.09	1013.56	1015.5	1488.0
2012-11-07	HE	Futures	96.518	100.029	96.083	99.563	40386.0
2012-11-07	HG	Futures	4.5184	4.5544	4.4091	4.4226	79021.0
2012-11-07	HH	Futures	41.63	41.63	41.63	41.63	60.0
2012-11-07	HO	Futures	2.4717	2.4837	2.39	2.4009	61756.0
2012-11-07	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-07	J1	Futures	0.0155776	0.0157028	0.0155751	0.015674	150233.0

> showing 50 of 99 rows — these rows as CSV

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