PREVIEW / futures_daily / 2011-03-23

all futures daily files

  file:    by_date/futures_daily/2011/2011-03-23.parquet
  size:    9 KB
  rows:    92

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-23	ES	Futures	1274.88	1283.05	1266.22	1279.09	1939892.0
2011-03-23	NQ	Futures	2569.33	2590.68	2541.99	2579.58	277187.0
2011-03-23	YM	Futures	11235.1	11333.8	11194.7	11301.9	115366.0
2011-03-23	CL	Futures	202.76	205.64	201.85	204.5	254571.0
2011-03-23	GC	Futures	1939.2	1955.9	1935.0	1951.5	138329.0
2011-03-23	ZN	Futures	101.197774	101.513811	101.026587	101.105596	1195563.0
2011-03-23	A6	Futures	0.85854	0.86231	0.85442	0.86171	95732.0
2011-03-23	AD	Futures	1.01385	1.01504	1.00977	1.01365	66365.0
2011-03-23	B	Futures	98.3	98.73	97.6	98.01	128225.0
2011-03-23	B6	Futures	1.6989	1.7013	1.6832	1.686	100696.0
2011-03-23	BFX	Futures	3005.6	3032.1	3004.4	3004.9	650.0
2011-03-23	BR	Futures	0.26035	0.26121	0.26035	0.26121	95.0
2011-03-23	BZ	Futures	103.37	103.94	102.83	103.24	818.0
2011-03-23	C	Futures	2307.0	2339.0	2293.0	2307.0	4175.0
2011-03-23	CB	Futures	116.895	116.895	116.162	116.602	40.0
2011-03-23	CC	Futures	2616.0	2644.0	2598.0	2613.0	6333.0
2011-03-23	CT	Futures	187.61	187.76	177.91	180.52	11922.0
2011-03-23	DC	Futures	28.46	28.64	28.27	28.36	142.0
2011-03-23	DX	Futures	75.452	75.81	75.292	75.666	25016.0
2011-03-23	E1	Futures	1.45042	1.45932	1.44125	1.44308	47285.0
2011-03-23	E6	Futures	1.67997	1.68151	1.66611	1.67049	310573.0
2011-03-23	E7	Futures	1.6677	1.669	1.6538	1.6581	6062.0
2011-03-23	EBM	Futures	211.83	213.71	210.19	210.89	5975.0
2011-03-23	ED	Futures	94.8502	94.8597	94.8407	94.8502	189505.0
2011-03-23	ER	Futures	97.252	97.277	97.232	97.267	122777.0
2011-03-23	EW	Futures	948.0	951.0	936.1	944.7	25270.0
2011-03-23	FBTP	Futures	64.42	64.42	63.9	64.09	10899.0
2011-03-23	FCE	Futures	2586.3	2613.3	2579.0	2606.6	118715.0
2011-03-23	FDAX	Futures	7248.4	7304.0	7195.6	7284.8	162786.0
2011-03-23	FESX	Futures	1775.4	1791.4	1766.5	1785.7	1349739.0
2011-03-23	FGBL	Futures	97.73	98.07	97.66	97.86	1118502.0
2011-03-23	FGBM	Futures	103.07	103.28	103.02	103.14	557160.0
2011-03-23	FGBS	Futures	106.394	106.489	106.38	106.424	629018.0
2011-03-23	FGBX	Futures	94.5	94.94	94.21	94.6	2642.0
2011-03-23	FTDX	Futures	790.4	797.1	785.9	795.3	381.0
2011-03-23	FTI	Futures	288.21	292.57	287.35	291.76	41615.0
2011-03-23	FTUK	Futures	3986.3	4038.5	3979.3	4020.6	104940.0
2011-03-23	FXXP	Futures	178.0	179.3	177.8	179.2	265.0
2011-03-23	G	Futures	81.97	82.24	81.84	82.06	122519.0
2011-03-23	GF	Futures	318.539	319.446	315.574	318.236	1376.0
2011-03-23	GSCI	Futures	1122.38	1125.43	1118.54	1121.75	73.0
2011-03-23	HE	Futures	106.255	106.388	104.901	105.724	364.0
2011-03-23	HG	Futures	5.7382	5.9154	5.7142	5.8987	34670.0
2011-03-23	HO	Futures	2.5761	2.5965	2.5555	2.5653	21043.0
2011-03-23	HRC	Futures	3106.0	3106.0	3106.0	3106.0	0.0
2011-03-23	J1	Futures	0.0155229	0.0155757	0.0155028	0.0155481	109905.0
2011-03-23	J7	Futures	0.015419	0.015478	0.015412	0.015453	753.0
2011-03-23	JB	Futures	121.73	121.73	121.73	121.73	2206.0
2011-03-23	KC	Futures	664.7	667.49	650.52	651.0	8288.0
2011-03-23	KE	Futures	3396.06	3414.13	3308.75	3331.84	9305.0

> showing 50 of 92 rows — these rows as CSV

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