PREVIEW / futures_daily / 2012-11-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-23.parquet
  size:    9 KB
  rows:    97

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-23	ES	Futures	1413.7	1432.53	1411.92	1430.24	913304.0
2012-11-23	NQ	Futures	2989.58	3036.18	2987.28	3031.0	132805.0
2012-11-23	YM	Futures	12501.0	12676.8	12500.1	12656.3	61917.0
2012-11-23	CL	Futures	157.0	158.52	155.26	158.07	104944.0
2012-11-23	GC	Futures	2308.6	2343.2	2306.6	2338.4	165900.0
2012-11-23	ZN	Futures	117.260778	117.384383	117.150906	117.192108	404891.0
2012-11-23	A6	Futures	0.94035	0.95016	0.93889	0.94934	119584.0
2012-11-23	AD	Futures	1.0068	1.01192	1.00489	1.01161	68552.0
2012-11-23	B	Futures	102.01	103.0	101.67	102.85	103820.0
2012-11-23	B6	Futures	1.6662	1.6764	1.6632	1.6756	111477.0
2012-11-23	BFX	Futures	2908.3	2909.9	2903.2	2903.2	38.0
2012-11-23	BR	Futures	0.23177	0.23291	0.22913	0.23274	350.0
2012-11-23	BZ	Futures	105.81	106.2	104.86	106.06	483.0
2012-11-23	C	Futures	1597.0	1622.0	1597.0	1620.0	814.0
2012-11-23	CC	Futures	1863.0	1901.0	1852.0	1898.0	9681.0
2012-11-23	CT	Futures	93.23	93.39	89.68	90.11	4406.0
2012-11-23	DC	Futures	29.32	29.32	29.32	29.32	1.0
2012-11-23	DX	Futures	78.22	78.225	77.639	77.718	20544.0
2012-11-23	E1	Futures	1.37145	1.39487	1.37145	1.38831	40521.0
2012-11-23	E6	Futures	1.51084	1.53015	1.51084	1.52944	308294.0
2012-11-23	E7	Futures	1.5021	1.521	1.5019	1.5203	4886.0
2012-11-23	ED	Futures	95.2205	95.2277	95.2205	95.2229	55013.0
2012-11-23	ER	Futures	97.881	97.881	97.876	97.876	19629.0
2012-11-23	EW	Futures	997.4	1008.5	995.3	1007.9	10524.0
2012-11-23	FBTP	Futures	73.52	73.81	73.35	73.66	13567.0
2012-11-23	FBTS	Futures	90.387	90.538	90.287	90.429	4136.0
2012-11-23	FCE	Futures	2639.1	2663.6	2621.0	2656.8	76195.0
2012-11-23	FDAX	Futures	7951.5	8037.0	7910.4	8004.6	85741.0
2012-11-23	FESX	Futures	1726.0	1744.4	1715.8	1736.9	580230.0
2012-11-23	FGBL	Futures	118.8	119.08	118.69	118.78	477506.0
2012-11-23	FGBM	Futures	116.7	116.85	116.69	116.74	243226.0
2012-11-23	FGBS	Futures	110.467	110.497	110.462	110.477	195397.0
2012-11-23	FGBX	Futures	124.62	125.11	124.32	124.51	11907.0
2012-11-23	FOAT	Futures	104.22	104.54	104.22	104.47	17603.0
2012-11-23	FTDX	Futures	774.9	780.1	774.9	779.2	75.0
2012-11-23	FTI	Futures	281.37	285.14	280.47	284.2	22642.0
2012-11-23	FTUK	Futures	4236.2	4271.7	4229.2	4257.8	51830.0
2012-11-23	FVSA	Futures	4288.9	4415.38	4288.9	4380.89	6252.0
2012-11-23	FXXP	Futures	195.8	197.6	195.6	197.1	3940.0
2012-11-23	G	Futures	98.53	98.82	98.48	98.62	118359.0
2012-11-23	GF	Futures	279.887	280.694	279.46	280.599	1446.0
2012-11-23	GSCI	Futures	1042.15	1050.78	1040.69	1050.78	227.0
2012-11-23	HE	Futures	99.958	101.191	99.814	100.273	9344.0
2012-11-23	HG	Futures	4.5196	4.5466	4.483	4.5446	15744.0
2012-11-23	HO	Futures	2.4648	2.4875	2.4538	2.4808	4739.0
2012-11-23	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-23	J1	Futures	0.0151707	0.0152583	0.0151168	0.0152007	139080.0
2012-11-23	J7	Futures	0.015109	0.015192	0.015055	0.015136	910.0
2012-11-23	JB	Futures	127.21	127.26	127.19	127.23	139.0
2012-11-23	KC	Futures	321.05	322.84	314.03	316.44	6849.0

> showing 50 of 97 rows — these rows as CSV

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