PREVIEW / futures_daily / 2011-06-24

all futures daily files

  file:    by_date/futures_daily/2011/2011-06-24.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-06-24	ES	Futures	1268.73	1277.17	1252.59	1255.32	2499136.0
2011-06-24	NQ	Futures	2547.97	2571.88	2512.95	2514.09	316081.0
2011-06-24	YM	Futures	11324.1	11399.7	11205.9	11232.4	130086.0
2011-06-24	CL	Futures	177.09	177.18	172.35	174.92	337767.0
2011-06-24	GC	Futures	2060.9	2066.0	2028.1	2031.4	182170.0
2011-06-24	ZN	Futures	105.787836	106.386559	105.641481	106.213595	1330856.0
2011-06-24	A6	Futures	0.90656	0.91248	0.90239	0.90317	112715.0
2011-06-24	AD	Futures	1.01842	1.01952	1.00744	1.00774	93707.0
2011-06-24	B	Futures	92.91	93.0	88.65	89.94	252475.0
2011-06-24	B6	Futures	1.6647	1.6676	1.6577	1.6599	104017.0
2011-06-24	BFX	Futures	3024.3	3026.7	2982.4	2983.1	40.0
2011-06-24	BR	Futures	0.27524	0.27573	0.2735	0.2739	209.0
2011-06-24	BZ	Futures	96.76	96.76	92.54	93.79	850.0
2011-06-24	C	Futures	2053.0	2075.0	2030.0	2032.0	1600.0
2011-06-24	CB	Futures	112.326	112.326	110.683	111.231	19.0
2011-06-24	CC	Futures	2373.0	2393.0	2339.0	2350.0	5580.0
2011-06-24	CT	Futures	162.87	165.85	162.35	164.71	47.0
2011-06-24	DC	Futures	30.15	30.47	30.15	30.4	208.0
2011-06-24	DX	Futures	74.975	75.544	74.747	75.475	38741.0
2011-06-24	E1	Futures	1.56105	1.57622	1.5587	1.56236	35983.0
2011-06-24	E6	Futures	1.69008	1.69518	1.67571	1.67915	310735.0
2011-06-24	E7	Futures	1.6778	1.6829	1.6636	1.6669	5937.0
2011-06-24	ED	Futures	94.9096	94.9191	94.8429	94.8715	365478.0
2011-06-24	ER	Futures	97.336	97.361	97.306	97.336	106397.0
2011-06-24	EW	Futures	941.4	949.1	933.3	934.8	21849.0
2011-06-24	FBTP	Futures	64.46	64.71	64.23	64.33	10175.0
2011-06-24	FCE	Futures	2666.3	2685.7	2619.7	2630.1	181145.0
2011-06-24	FDAX	Futures	7756.3	7798.0	7608.9	7642.0	190850.0
2011-06-24	FESX	Futures	1778.0	1785.7	1736.3	1744.6	1793769.0
2011-06-24	FEU3	Futures	97.85	97.875	97.85	97.875	35.0
2011-06-24	FGBL	Futures	101.78	102.31	101.66	102.24	964505.0
2011-06-24	FGBM	Futures	105.96	106.29	105.83	106.2	578918.0
2011-06-24	FGBS	Futures	107.398	107.547	107.363	107.492	666906.0
2011-06-24	FGBX	Futures	96.65	97.01	96.27	97.0	5962.0
2011-06-24	FTDX	Futures	779.2	782.8	768.1	773.0	243.0
2011-06-24	FTI	Futures	273.03	273.69	269.46	270.16	47171.0
2011-06-24	FTUK	Futures	4014.0	4045.8	3978.7	3992.5	109621.0
2011-06-24	FXXP	Futures	180.5	180.9	178.3	178.4	1109.0
2011-06-24	G	Futures	85.39	85.6	85.13	85.54	116636.0
2011-06-24	GF	Futures	319.902	323.039	317.462	322.11	2909.0
2011-06-24	GSCI	Futures	1025.72	1027.93	1009.55	1014.29	358.0
2011-06-24	HE	Futures	103.919	104.666	101.945	102.425	6941.0
2011-06-24	HG	Futures	5.4114	5.496	5.3909	5.4405	13290.0
2011-06-24	HO	Futures	2.3061	2.3202	2.2426	2.2582	12068.0
2011-06-24	HRC	Futures	3064.5	3064.5	3064.5	3064.5	0.0
2011-06-24	J1	Futures	0.0156373	0.0156951	0.0156008	0.0156322	99970.0
2011-06-24	J7	Futures	0.015528	0.015593	0.0155	0.015528	195.0
2011-06-24	KC	Futures	593.57	597.0	581.03	592.62	8497.0
2011-06-24	KE	Futures	3001.75	3026.71	2919.17	2947.01	11582.0
2011-06-24	L	Futures	98.433	98.453	98.423	98.433	40186.0

> showing 50 of 93 rows — these rows as CSV

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