PREVIEW / futures_daily / 2011-03-31

all futures daily files

  file:    by_date/futures_daily/2011/2011-03-31.parquet
  size:    9 KB
  rows:    93

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
2011-03-31	ES	Futures	1311.27	1312.51	1307.31	1307.8	1521964.0
2011-03-31	NQ	Futures	2658.44	2666.7	2650.76	2660.72	177992.0
2011-03-31	YM	Futures	11552.9	11583.0	11519.0	11519.0	74358.0
2011-03-31	CL	Futures	201.71	206.59	201.35	206.37	270630.0
2011-03-31	GC	Futures	1927.9	1950.4	1924.3	1948.9	129306.0
2011-03-31	ZN	Futures	100.460353	100.684213	100.091643	100.315503	1327957.0
2011-03-31	A6	Futures	0.87715	0.88169	0.87629	0.88101	75086.0
2011-03-31	AD	Futures	1.02321	1.02659	1.02171	1.0262	60652.0
2011-03-31	B	Futures	97.29	99.7	97.29	99.41	101734.0
2011-03-31	B6	Futures	1.6681	1.6764	1.6621	1.6676	132387.0
2011-03-31	BFX	Futures	3101.4	3118.8	3072.6	3078.9	73.0
2011-03-31	BR	Futures	0.26627	0.26675	0.26622	0.26675	2484.0
2011-03-31	BZ	Futures	103.97	104.84	103.7	104.81	829.0
2011-03-31	C	Futures	2137.0	2145.0	2106.0	2115.0	11634.0
2011-03-31	CC	Futures	2393.0	2418.0	2360.0	2373.0	13589.0
2011-03-31	CSC	Futures	4.407	4.435	4.374	4.374	8.0
2011-03-31	CT	Futures	174.6	179.44	172.2	179.05	15493.0
2011-03-31	DC	Futures	28.74	29.17	28.74	29.1	94.0
2011-03-31	DX	Futures	75.989	76.034	75.506	75.692	23061.0
2011-03-31	E1	Futures	1.42593	1.43536	1.4237	1.4296	37099.0
2011-03-31	E6	Futures	1.67096	1.68364	1.66966	1.67973	313084.0
2011-03-31	E7	Futures	1.6582	1.6711	1.6575	1.6672	5312.0
2011-03-31	EBM	Futures	220.75	229.68	217.23	225.45	14157.0
2011-03-31	ED	Futures	94.8597	94.8788	94.8502	94.8692	386293.0
2011-03-31	ER	Futures	97.291	97.301	97.267	97.277	151708.0
2011-03-31	EW	Futures	976.0	982.4	973.4	981.1	21930.0
2011-03-31	FBTP	Futures	64.02	64.15	63.83	63.86	7851.0
2011-03-31	FCE	Futures	2687.2	2689.2	2653.2	2655.9	119403.0
2011-03-31	FDAX	Futures	7580.5	7582.1	7534.6	7558.6	108021.0
2011-03-31	FESX	Futures	1837.6	1837.6	1812.6	1822.2	1143835.0
2011-03-31	FEU3	Futures	97.835	97.835	97.82	97.82	261.0
2011-03-31	FGBL	Futures	97.22	97.31	96.87	97.04	1039489.0
2011-03-31	FGBM	Futures	102.75	102.79	102.45	102.58	671782.0
2011-03-31	FGBS	Futures	106.335	106.35	106.196	106.251	749956.0
2011-03-31	FGBX	Futures	93.28	93.7	92.76	93.17	6206.0
2011-03-31	FTDX	Futures	829.2	832.8	827.0	831.9	295.0
2011-03-31	FTI	Futures	299.13	299.13	296.48	296.81	25974.0
2011-03-31	FTUK	Futures	4139.2	4152.9	4102.2	4118.9	105379.0
2011-03-31	FXXP	Futures	182.9	183.3	181.3	181.5	597.0
2011-03-31	G	Futures	81.49	81.65	81.17	81.29	141239.0
2011-03-31	GF	Futures	331.546	333.966	330.397	333.482	918.0
2011-03-31	GSCI	Futures	1124.41	1138.89	1124.41	1138.19	1141.0
2011-03-31	HE	Futures	107.637	109.523	107.105	109.523	289.0
2011-03-31	HG	Futures	5.6709	5.7429	5.6556	5.7375	29789.0
2011-03-31	HO	Futures	2.5467	2.6089	2.5467	2.5952	23641.0
2011-03-31	HRC	Futures	3106.0	3106.0	3106.0	3106.0	0.0
2011-03-31	J1	Futures	0.0151611	0.0152202	0.0151008	0.0151259	136459.0
2011-03-31	J7	Futures	0.01504	0.015127	0.015007	0.015033	627.0
2011-03-31	JB	Futures	121.57	121.74	121.45	121.52	29.0
2011-03-31	KC	Futures	643.25	648.1	635.13	640.22	9420.0

> showing 50 of 93 rows — these rows as CSV

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