PREVIEW / futures_daily / 2012-09-13

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-13.parquet
  size:    9 KB
  rows:    99

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-09-13	ES	Futures	1456.54	1482.88	1453.25	1475.79	2603518.0
2012-09-13	NQ	Futures	3209.15	3261.94	3196.81	3245.3	389648.0
2012-09-13	YM	Futures	12961.0	13180.7	12936.6	13128.9	34364.0
2012-09-13	CL	Futures	175.5	178.48	174.74	178.01	118206.0
2012-09-13	GC	Futures	2313.9	2369.9	2296.4	2366.0	260342.0
2012-09-13	ZN	Futures	116.381802	116.876226	115.887379	116.697684	1721338.0
2012-09-13	A6	Futures	0.94289	0.95252	0.93544	0.95052	97785.0
2012-09-13	AD	Futures	1.02607	1.03631	1.02466	1.03299	95669.0
2012-09-13	B	Futures	105.03	106.58	104.3	105.66	233579.0
2012-09-13	B6	Futures	1.682	1.6886	1.6783	1.6865	67730.0
2012-09-13	BFX	Futures	2898.1	2898.1	2884.9	2884.9	26.0
2012-09-13	BR	Futures	0.23692	0.23753	0.23692	0.23753	84.0
2012-09-13	BZ	Futures	110.86	111.65	109.35	110.74	1977.0
2012-09-13	C	Futures	1714.0	1735.0	1703.0	1711.0	9562.0
2012-09-13	CB	Futures	98.215	98.215	98.215	98.215	3.0
2012-09-13	CC	Futures	1995.0	2001.0	1959.0	1971.0	9672.0
2012-09-13	CSC	Futures	4.036	4.055	4.036	4.046	5.0
2012-09-13	CT	Futures	95.64	96.61	95.2	96.1	8.0
2012-09-13	DC	Futures	30.18	30.6	30.12	30.57	101.0
2012-09-13	DX	Futures	77.353	77.445	76.806	76.905	28196.0
2012-09-13	E1	Futures	1.37518	1.37891	1.36784	1.37879	16418.0
2012-09-13	E6	Futures	1.52014	1.53262	1.51178	1.53027	184183.0
2012-09-13	E7	Futures	1.5117	1.5231	1.5041	1.5211	2822.0
2012-09-13	ED	Futures	95.211	95.2349	95.2062	95.2205	239958.0
2012-09-13	ER	Futures	97.832	97.847	97.817	97.842	200257.0
2012-09-13	EW	Futures	1023.7	1035.6	1017.0	1031.7	30568.0
2012-09-13	FBTP	Futures	70.94	71.47	70.77	71.18	22185.0
2012-09-13	FBTS	Futures	89.282	89.366	89.19	89.299	3572.0
2012-09-13	FCE	Futures	2645.5	2649.2	2604.0	2610.4	4734.0
2012-09-13	FDAX	Futures	8013.7	8085.7	7947.6	7985.8	124728.0
2012-09-13	FESX	Futures	1736.9	1752.5	1715.1	1723.9	177452.0
2012-09-13	FEU3	Futures	98.463	98.463	98.463	98.463	18.0
2012-09-13	FGBL	Futures	116.7	117.4	116.57	117.25	754815.0
2012-09-13	FGBM	Futures	115.5	115.81	115.42	115.75	452049.0
2012-09-13	FGBS	Futures	110.253	110.318	110.233	110.293	355210.0
2012-09-13	FGBX	Futures	121.91	123.14	121.43	122.78	9694.0
2012-09-13	FOAT	Futures	102.41	102.99	102.41	102.88	19316.0
2012-09-13	FTDX	Futures	766.5	769.3	756.6	756.6	49.0
2012-09-13	FTI	Futures	286.81	289.2	284.89	285.45	3391.0
2012-09-13	FTUK	Futures	4211.7	4294.7	4201.8	4237.3	27435.0
2012-09-13	FVSA	Futures	6048.97	6183.39	6048.97	6158.95	2420.0
2012-09-13	FXXP	Futures	195.5	196.1	195.5	196.1	594.0
2012-09-13	G	Futures	98.46	98.79	98.12	98.66	172128.0
2012-09-13	GF	Futures	287.345	288.416	285.934	286.226	2840.0
2012-09-13	GSCI	Futures	1108.71	1112.26	1097.26	1110.0	2278.0
2012-09-13	HE	Futures	90.248	91.669	90.093	90.897	24299.0
2012-09-13	HG	Futures	4.7407	4.8184	4.7015	4.7677	49505.0
2012-09-13	HH	Futures	40.712	40.712	40.712	40.712	212.0
2012-09-13	HO	Futures	2.5995	2.6273	2.5741	2.6006	27439.0
2012-09-13	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0

> showing 50 of 99 rows — these rows as CSV

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