PREVIEW / futures_daily / 2011-08-09

all futures daily files

  file:    by_date/futures_daily/2011/2011-08-09.parquet
  size:    9 KB
  rows:    96

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-08-09	ES	Futures	1105.36	1167.43	1069.61	1163.7	6285917.0
2011-08-09	NQ	Futures	2326.48	2461.14	2245.92	2454.02	715540.0
2011-08-09	YM	Futures	10158.4	10620.7	9833.2	10582.9	339510.0
2011-08-09	CL	Futures	155.42	159.16	145.09	151.97	605796.0
2011-08-09	GC	Futures	2322.1	2406.7	2319.2	2353.3	398589.0
2011-08-09	ZN	Futures	109.672887	111.575499	108.847979	110.551016	2193433.0
2011-08-09	A6	Futures	0.88151	0.89839	0.85863	0.87255	304386.0
2011-08-09	AD	Futures	1.00405	1.02051	0.99606	1.00305	197823.0
2011-08-09	B	Futures	88.53	90.59	84.68	87.7	150447.0
2011-08-09	B6	Futures	1.6963	1.7067	1.6819	1.6861	164688.0
2011-08-09	BFX	Futures	2499.5	2598.0	2435.8	2598.0	239.0
2011-08-09	BR	Futures	0.27216	0.27622	0.26969	0.2715	2052.0
2011-08-09	BZ	Futures	92.34	92.34	90.58	90.58	1500.0
2011-08-09	C	Futures	2007.0	2022.0	1997.0	2019.0	4638.0
2011-08-09	CB	Futures	110.409	111.231	110.409	111.231	2.0
2011-08-09	CC	Futures	2309.0	2345.0	2302.0	2308.0	11184.0
2011-08-09	CSC	Futures	4.917	4.917	4.865	4.877	2.0
2011-08-09	CT	Futures	126.88	130.58	123.3	126.22	89.0
2011-08-09	DC	Futures	33.49	33.76	33.23	33.51	447.0
2011-08-09	DX	Futures	74.291	74.375	73.276	74.003	39221.0
2011-08-09	E1	Futures	1.73303	1.85283	1.72401	1.83047	107676.0
2011-08-09	E6	Futures	1.68176	1.70694	1.67998	1.68758	485590.0
2011-08-09	E7	Futures	1.6698	1.6945	1.6677	1.6753	5475.0
2011-08-09	ED	Futures	94.9049	94.9573	94.8858	94.9239	414172.0
2011-08-09	ER	Futures	97.717	97.737	97.623	97.638	198913.0
2011-08-09	EW	Futures	763.9	822.0	740.7	818.0	82764.0
2011-08-09	FBTP	Futures	62.51	63.69	62.5	63.12	14701.0
2011-08-09	FCE	Futures	2142.4	2269.6	2099.0	2239.3	400632.0
2011-08-09	FDAX	Futures	6141.8	6447.9	5874.1	6348.0	394271.0
2011-08-09	FESX	Futures	1427.1	1503.5	1387.4	1475.2	4340429.0
2011-08-09	FEU3	Futures	98.248	98.253	98.178	98.178	250.0
2011-08-09	FGBL	Futures	106.89	107.46	106.07	106.22	1022255.0
2011-08-09	FGBM	Futures	109.08	109.4	108.49	108.63	639023.0
2011-08-09	FGBS	Futures	108.775	108.9	108.611	108.661	789608.0
2011-08-09	FGBX	Futures	105.26	106.18	103.86	104.08	7368.0
2011-08-09	FTDX	Futures	589.5	633.2	568.5	621.6	1150.0
2011-08-09	FTI	Futures	227.91	241.17	219.79	237.48	132365.0
2011-08-09	FTUK	Futures	3420.0	3695.5	3316.7	3643.3	376509.0
2011-08-09	FXXP	Futures	154.5	157.6	146.9	157.4	7312.0
2011-08-09	G	Futures	88.45	89.09	88.35	88.44	126796.0
2011-08-09	GF	Futures	307.643	311.536	305.028	309.618	1310.0
2011-08-09	GSCI	Futures	984.01	1006.51	975.28	978.56	1798.0
2011-08-09	HE	Futures	110.535	111.054	108.153	108.855	20374.0
2011-08-09	HG	Futures	5.2025	5.3665	5.0472	5.2481	64955.0
2011-08-09	HO	Futures	2.2829	2.3134	2.1876	2.2384	79052.0
2011-08-09	HRC	Futures	2890.0	2890.0	2890.0	2890.0	0.0
2011-08-09	J1	Futures	0.0161601	0.0164002	0.0161589	0.016311	179295.0
2011-08-09	J7	Futures	0.016056	0.016291	0.016056	0.016202	785.0
2011-08-09	JB	Futures	123.94	124.29	123.69	123.77	4488.0
2011-08-09	KC	Futures	552.64	563.29	550.27	555.36	12698.0

> showing 50 of 96 rows — these rows as CSV

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