PREVIEW / futures_daily / 2012-07-26

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-26.parquet
  size:    9 KB
  rows:    98

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-07-26	ES	Futures	1351.73	1376.03	1344.64	1371.98	2275727.0
2012-07-26	NQ	Futures	2918.76	2976.72	2903.55	2952.62	290555.0
2012-07-26	YM	Futures	12259.1	12492.0	12208.7	12442.5	157812.0
2012-07-26	CL	Futures	161.71	164.2	159.84	162.24	233400.0
2012-07-26	GC	Futures	2149.7	2171.2	2142.8	2162.7	64146.0
2012-07-26	ZN	Futures	117.884247	117.952341	117.571015	117.693584	930496.0
2012-07-26	A6	Futures	0.92274	0.93281	0.92122	0.93057	174644.0
2012-07-26	AD	Futures	0.98596	0.99539	0.98506	0.99178	134890.0
2012-07-26	B	Futures	93.77	95.47	93.12	94.59	119583.0
2012-07-26	B6	Futures	1.6195	1.6433	1.6167	1.6399	170260.0
2012-07-26	BR	Futures	0.23305	0.23477	0.23305	0.23477	218.0
2012-07-26	BZ	Futures	100.47	100.47	99.69	99.69	2653.0
2012-07-26	C	Futures	1586.0	1623.0	1585.0	1613.0	5923.0
2012-07-26	CB	Futures	91.391	91.499	91.391	91.499	8.0
2012-07-26	CC	Futures	1680.0	1756.0	1669.0	1745.0	20037.0
2012-07-26	CSC	Futures	4.04	4.04	3.979	4.008	11.0
2012-07-26	CT	Futures	91.68	93.8	91.2	93.11	75.0
2012-07-26	DC	Futures	30.03	30.03	29.47	29.58	451.0
2012-07-26	DX	Futures	81.294	81.386	80.231	80.424	35680.0
2012-07-26	E1	Futures	1.30768	1.32718	1.3042	1.3224	71690.0
2012-07-26	E6	Futures	1.43416	1.45528	1.43015	1.45009	338189.0
2012-07-26	E7	Futures	1.4255	1.4464	1.4214	1.4411	5505.0
2012-07-26	ED	Futures	95.1895	95.1943	95.18	95.1895	117039.0
2012-07-26	ER	Futures	97.744	97.759	97.744	97.749	61353.0
2012-07-26	EW	Futures	925.5	944.4	920.8	939.9	27896.0
2012-07-26	FBTP	Futures	63.29	65.23	62.97	64.94	30819.0
2012-07-26	FBTS	Futures	83.326	84.765	83.186	84.682	6259.0
2012-07-26	FCE	Futures	2301.5	2391.6	2285.5	2386.0	179591.0
2012-07-26	FDAX	Futures	6995.6	7203.0	6903.3	7178.5	210710.0
2012-07-26	FESX	Futures	1458.1	1521.7	1448.0	1517.0	1773120.0
2012-07-26	FEU3	Futures	98.33	98.33	98.325	98.33	300.0
2012-07-26	FGBL	Futures	119.49	119.86	118.75	118.95	798910.0
2012-07-26	FGBM	Futures	116.66	116.76	116.33	116.44	392221.0
2012-07-26	FGBS	Futures	110.542	110.557	110.487	110.517	294361.0
2012-07-26	FGBX	Futures	128.05	129.42	126.75	127.33	7077.0
2012-07-26	FOAT	Futures	101.22	101.94	101.13	101.68	19248.0
2012-07-26	FTDX	Futures	705.8	718.4	704.4	717.5	39.0
2012-07-26	FTI	Futures	265.69	272.33	264.45	271.61	50207.0
2012-07-26	FTUK	Futures	3969.2	4042.0	3955.0	4023.8	106280.0
2012-07-26	FVSA	Futures	7926.02	7981.45	7357.9	7524.18	3019.0
2012-07-26	FXXP	Futures	178.8	183.6	178.6	183.2	10709.0
2012-07-26	G	Futures	100.93	101.0	100.26	100.65	125710.0
2012-07-26	GF	Futures	265.794	268.853	263.771	268.409	3304.0
2012-07-26	GSCI	Futures	1019.71	1021.3	1009.37	1013.11	203.0
2012-07-26	HE	Futures	101.367	103.157	101.287	102.409	8681.0
2012-07-26	HG	Futures	4.3621	4.4291	4.3203	4.3718	67190.0
2012-07-26	HO	Futures	2.3299	2.3653	2.3097	2.346	60358.0
2012-07-26	HRC	Futures	2489.6	2489.6	2489.6	2489.6	2.0
2012-07-26	J1	Futures	0.0160459	0.0161085	0.0160095	0.0160371	78769.0
2012-07-26	J7	Futures	0.01598	0.016073	0.015948	0.015974	309.0

> showing 50 of 98 rows — these rows as CSV

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