PREVIEW / futures_daily / 2012-11-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-11-27.parquet
  size:    9 KB
  rows:    100

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-27	ES	Futures	1428.97	1432.79	1420.32	1422.35	1639215.0
2012-11-27	NQ	Futures	3047.39	3059.19	3033.59	3039.05	266935.0
2012-11-27	YM	Futures	12635.8	12666.1	12543.0	12559.6	125648.0
2012-11-27	CL	Futures	157.25	158.02	155.47	156.1	210470.0
2012-11-27	GC	Futures	2334.9	2337.7	2322.5	2325.2	100103.0
2012-11-27	ZN	Futures	117.370649	117.590393	117.260778	117.535457	1272769.0
2012-11-27	A6	Futures	0.94961	0.9517	0.9468	0.94798	101727.0
2012-11-27	AD	Futures	1.01051	1.01282	1.0084	1.009	69393.0
2012-11-27	B	Futures	102.76	103.05	101.27	101.75	84229.0
2012-11-27	B6	Futures	1.6744	1.677	1.672	1.6728	78234.0
2012-11-27	BFX	Futures	2914.9	2914.9	2899.8	2907.8	25.0
2012-11-27	BR	Futures	0.23326	0.23326	0.23299	0.23326	829.0
2012-11-27	BZ	Futures	106.04	106.15	104.37	104.83	579.0
2012-11-27	C	Futures	1607.0	1614.0	1577.0	1585.0	1721.0
2012-11-27	CB	Futures	90.023	90.127	89.906	89.958	14.0
2012-11-27	CC	Futures	1871.0	1885.0	1833.0	1846.0	11114.0
2012-11-27	CSC	Futures	3.918	3.924	3.918	3.918	11.0
2012-11-27	CT	Futures	91.19	91.77	91.0	91.27	11012.0
2012-11-27	DC	Futures	29.16	29.32	29.02	29.13	36.0
2012-11-27	DX	Futures	77.605	77.978	77.557	77.905	18601.0
2012-11-27	E1	Futures	1.38934	1.39063	1.38072	1.38329	29404.0
2012-11-27	E6	Futures	1.53003	1.53227	1.52108	1.52332	243441.0
2012-11-27	E7	Futures	1.5209	1.523	1.512	1.5142	2999.0
2012-11-27	ED	Futures	95.2229	95.2253	95.2229	95.2229	99413.0
2012-11-27	ER	Futures	97.881	97.886	97.876	97.881	37383.0
2012-11-27	EW	Futures	1007.1	1010.3	1003.4	1005.1	17245.0
2012-11-27	FBTP	Futures	73.73	73.87	73.52	73.83	19189.0
2012-11-27	FBTS	Futures	90.505	90.538	90.454	90.513	3083.0
2012-11-27	FCE	Futures	2654.2	2659.1	2627.8	2636.1	91387.0
2012-11-27	FDAX	Futures	8030.9	8068.7	8004.6	8039.7	107589.0
2012-11-27	FESX	Futures	1743.0	1744.4	1723.3	1728.7	728124.0
2012-11-27	FGBL	Futures	118.78	118.98	118.54	118.87	641010.0
2012-11-27	FGBM	Futures	116.71	116.81	116.51	116.71	368208.0
2012-11-27	FGBS	Futures	110.462	110.467	110.397	110.442	385272.0
2012-11-27	FGBX	Futures	124.71	125.4	124.35	125.26	8154.0
2012-11-27	FOAT	Futures	104.6	104.86	104.48	104.84	19772.0
2012-11-27	FTDX	Futures	784.8	789.1	784.4	787.7	55.0
2012-11-27	FTI	Futures	285.18	286.77	284.8	285.48	25681.0
2012-11-27	FTUK	Futures	4253.8	4261.8	4234.7	4244.2	68131.0
2012-11-27	FVSA	Futures	4346.39	4357.89	4277.4	4323.4	7568.0
2012-11-27	FXXP	Futures	197.3	197.5	196.4	196.8	821.0
2012-11-27	G	Futures	98.37	98.63	98.26	98.5	367903.0
2012-11-27	GF	Futures	279.081	280.314	277.563	278.796	2528.0
2012-11-27	GSCI	Futures	1046.58	1048.44	1038.6	1039.89	193.0
2012-11-27	HE	Futures	99.757	100.331	99.04	99.527	17528.0
2012-11-27	HG	Futures	4.5588	4.578	4.5324	4.56	35295.0
2012-11-27	HH	Futures	45.693	45.693	45.693	45.693	1000.0
2012-11-27	HO	Futures	2.4607	2.4724	2.4321	2.4381	14627.0
2012-11-27	HRC	Futures	2458.3	2458.3	2458.3	2458.3	0.0
2012-11-27	J1	Futures	0.0152571	0.0152971	0.0152095	0.0152395	81108.0

> showing 50 of 100 rows — these rows as CSV

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