PREVIEW / futures_daily / 2012-01-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-01-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-01-23	ES	Futures	1312.16	1322.95	1309.65	1315.68	1609178.0
2012-01-23	NQ	Futures	2778.94	2804.38	2768.36	2784.66	165315.0
2012-01-23	YM	Futures	12217.1	12290.6	12195.8	12233.5	82622.0
2012-01-23	CL	Futures	183.79	187.34	182.03	186.11	238960.0
2012-01-23	GC	Futures	2248.3	2270.7	2245.3	2266.0	131456.0
2012-01-23	ZN	Futures	112.638652	112.827688	112.179563	112.328092	990785.0
2012-01-23	A6	Futures	0.92597	0.93514	0.92482	0.93149	102507.0
2012-01-23	AD	Futures	0.98766	0.9973	0.98696	0.99449	79772.0
2012-01-23	B	Futures	98.07	99.24	97.35	98.55	136461.0
2012-01-23	B6	Futures	1.624	1.6303	1.6214	1.6261	79551.0
2012-01-23	BFX	Futures	2638.7	2656.9	2638.7	2647.4	38.0
2012-01-23	BR	Futures	0.26412	0.26515	0.2641	0.26487	127.0
2012-01-23	BZ	Futures	103.57	105.29	103.57	104.59	363.0
2012-01-23	C	Futures	1523.0	1529.0	1502.0	1512.0	5822.0
2012-01-23	CB	Futures	85.579	85.579	85.444	85.444	20.0
2012-01-23	CC	Futures	1754.0	1781.0	1740.0	1759.0	8216.0
2012-01-23	CSC	Futures	3.842	3.842	3.812	3.812	40.0
2012-01-23	CT	Futures	126.72	128.07	126.3	127.98	9062.0
2012-01-23	DC	Futures	27.96	27.97	27.69	27.76	301.0
2012-01-23	DX	Futures	78.386	78.435	77.627	77.801	24798.0
2012-01-23	E1	Futures	1.40123	1.41987	1.4011	1.41646	31486.0
2012-01-23	E6	Futures	1.54015	1.56058	1.53955	1.55628	270677.0
2012-01-23	E7	Futures	1.5265	1.5463	1.5256	1.5421	3430.0
2012-01-23	EBM	Futures	261.74	264.69	261.74	264.04	9157.0
2012-01-23	ED	Futures	95.0438	95.0629	95.039	95.0486	159846.0
2012-01-23	ER	Futures	97.43	97.479	97.425	97.469	122641.0
2012-01-23	EW	Futures	932.4	943.0	928.3	935.6	17935.0
2012-01-23	FBTP	Futures	61.46	62.58	61.43	62.09	11525.0
2012-01-23	FBTS	Futures	82.522	83.228	82.506	83.004	2008.0
2012-01-23	FCE	Futures	2370.5	2388.6	2358.7	2377.6	62208.0
2012-01-23	FDAX	Futures	7084.7	7156.0	7018.5	7108.5	136830.0
2012-01-23	FESX	Futures	1622.6	1638.0	1613.2	1628.6	809716.0
2012-01-23	FGBL	Futures	111.83	112.04	111.07	111.22	698214.0
2012-01-23	FGBM	Futures	112.9	113.01	112.65	112.73	322816.0
2012-01-23	FGBS	Futures	109.849	109.904	109.835	109.869	316764.0
2012-01-23	FGBX	Futures	116.47	116.9	114.57	114.94	6719.0
2012-01-23	FTDX	Futures	694.4	698.1	691.6	694.4	114.0
2012-01-23	FTI	Futures	268.13	270.26	266.91	269.43	33901.0
2012-01-23	FTUK	Futures	4111.6	4147.3	4098.6	4138.7	98471.0
2012-01-23	FVSA	Futures	10928.38	11062.83	10832.35	10889.97	4610.0
2012-01-23	FXXP	Futures	180.7	181.6	180.1	181.2	1515.0
2012-01-23	G	Futures	93.96	94.09	93.29	93.5	133221.0
2012-01-23	GF	Futures	327.226	327.809	324.469	326.06	2466.0
2012-01-23	GSCI	Futures	1026.27	1034.64	1026.2	1030.19	315.0
2012-01-23	HE	Futures	105.773	107.284	105.773	106.951	12117.0
2012-01-23	HG	Futures	4.9475	5.0379	4.9093	5.0102	37452.0
2012-01-23	HO	Futures	2.4206	2.4523	2.4152	2.4307	42576.0
2012-01-23	HRC	Futures	2876.8	2876.8	2876.8	2876.8	0.0
2012-01-23	J1	Futures	0.0163197	0.0163435	0.0162983	0.0163159	63450.0
2012-01-23	J7	Futures	0.016266	0.016276	0.016232	0.016248	187.0

> showing 50 of 97 rows — these rows as CSV

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