PREVIEW / futures_daily / 2012-08-03

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-03.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-08-03	ES	Futures	1379.58	1408.19	1377.3	1406.67	1945915.0
2012-08-03	NQ	Futures	3006.85	3077.44	3002.55	3065.68	225449.0
2012-08-03	YM	Futures	12446.4	12689.9	12430.9	12665.6	109320.0
2012-08-03	CL	Futures	158.37	166.5	158.32	165.89	301783.0
2012-08-03	GC	Futures	2125.9	2149.4	2120.9	2148.6	126858.0
2012-08-03	ZN	Futures	117.339495	117.407589	116.590462	116.713031	981739.0
2012-08-03	A6	Futures	0.93704	0.94693	0.93569	0.94549	148170.0
2012-08-03	AD	Futures	0.99428	1.00371	0.99408	1.0021	113877.0
2012-08-03	B	Futures	94.55	97.73	94.55	97.55	137978.0
2012-08-03	B6	Futures	1.6213	1.6363	1.6203	1.6349	108187.0
2012-08-03	BFX	Futures	2759.0	2766.8	2759.0	2762.5	22.0
2012-08-03	BR	Futures	0.23171	0.2348	0.23171	0.2342	492.0
2012-08-03	BZ	Futures	101.42	102.81	101.42	102.81	1895.0
2012-08-03	C	Futures	1682.0	1699.0	1666.0	1677.0	5297.0
2012-08-03	CB	Futures	91.499	92.037	91.499	92.037	3.0
2012-08-03	CC	Futures	1783.0	1836.0	1779.0	1807.0	17481.0
2012-08-03	CSC	Futures	3.966	4.021	3.964	4.021	24.0
2012-08-03	CT	Futures	92.75	96.74	92.57	96.45	69.0
2012-08-03	DC	Futures	29.31	29.95	29.15	29.82	376.0
2012-08-03	DX	Futures	80.978	81.017	79.94	80.023	24432.0
2012-08-03	E1	Futures	1.31091	1.33299	1.3091	1.33105	50830.0
2012-08-03	E6	Futures	1.4377	1.46259	1.43593	1.46059	300265.0
2012-08-03	E7	Futures	1.4282	1.4534	1.427	1.4515	4819.0
2012-08-03	ED	Futures	95.1895	95.1943	95.1752	95.1895	112275.0
2012-08-03	ER	Futures	97.803	97.808	97.763	97.783	123020.0
2012-08-03	EW	Futures	938.5	959.1	936.3	955.6	22993.0
2012-08-03	FBTP	Futures	63.86	65.7	63.3	65.04	33788.0
2012-08-03	FBTS	Futures	85.253	86.783	85.162	86.468	4823.0
2012-08-03	FCE	Futures	2408.3	2517.3	2406.1	2509.9	150457.0
2012-08-03	FDAX	Futures	7218.9	7522.9	7212.9	7497.8	173157.0
2012-08-03	FESX	Futures	1529.8	1606.2	1527.1	1600.1	1517471.0
2012-08-03	FGBL	Futures	119.64	119.73	117.85	118.07	804094.0
2012-08-03	FGBM	Futures	116.76	116.8	115.93	116.04	448966.0
2012-08-03	FGBS	Futures	110.557	110.567	110.447	110.467	366449.0
2012-08-03	FGBX	Futures	129.55	129.89	125.91	126.45	6358.0
2012-08-03	FOAT	Futures	102.85	103.32	102.37	102.54	25866.0
2012-08-03	FTDX	Futures	720.3	733.8	720.3	730.5	90.0
2012-08-03	FTI	Futures	272.93	280.64	272.93	280.21	42842.0
2012-08-03	FTUK	Futures	4089.0	4188.0	4088.3	4180.4	107581.0
2012-08-03	FVSA	Futures	7441.04	7441.04	6581.92	6720.49	4427.0
2012-08-03	FXXP	Futures	185.7	189.8	185.7	189.7	1550.0
2012-08-03	G	Futures	100.87	100.94	99.93	100.13	111116.0
2012-08-03	GF	Futures	276.994	278.82	273.787	274.231	2697.0
2012-08-03	GSCI	Futures	1010.72	1034.12	1010.72	1029.82	628.0
2012-08-03	HE	Futures	97.014	97.169	93.677	93.739	22842.0
2012-08-03	HG	Futures	4.2533	4.3467	4.2494	4.3383	55577.0
2012-08-03	HO	Futures	2.322	2.3983	2.3219	2.3924	60250.0
2012-08-03	HRC	Futures	2529.1	2529.1	2529.1	2529.1	0.0
2012-08-03	J1	Futures	0.0160246	0.0160597	0.0159155	0.0159506	107530.0
2012-08-03	J7	Futures	0.01596	0.015995	0.015854	0.015888	329.0

> showing 50 of 97 rows — these rows as CSV

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