PREVIEW / futures_daily / 2010-09-23

all futures daily files

  file:    by_date/futures_daily/2010/2010-09-23.parquet
  size:    9 KB
  rows:    89

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
2010-09-23	ES	Futures	1107.58	1111.99	1095.08	1098.27	2190002.0
2010-09-23	NQ	Futures	2244.54	2268.07	2225.26	2246.81	378087.0
2010-09-23	YM	Futures	9931.1	9967.4	9838.1	9868.8	154195.0
2010-09-23	CL	Futures	155.93	157.54	153.31	156.64	295903.0
2010-09-23	GC	Futures	1757.1	1763.6	1751.0	1762.0	106549.0
2010-09-23	ZN	Futures	103.670844	104.122484	103.515996	103.709556	1189115.0
2010-09-23	A6	Futures	0.79414	0.79573	0.78683	0.79137	82949.0
2010-09-23	AD	Futures	0.96003	0.96151	0.9528	0.95815	68146.0
2010-09-23	B	Futures	67.2	67.68	66.18	67.36	157896.0
2010-09-23	B6	Futures	1.6243	1.6334	1.6199	1.6283	99515.0
2010-09-23	BFX	Futures	2966.2	2966.2	2914.3	2936.7	100.0
2010-09-23	BR	Futures	0.24473	0.24537	0.24452	0.24537	165.0
2010-09-23	BZ	Futures	70.43	71.82	70.19	71.49	516.0
2010-09-23	C	Futures	2061.0	2071.0	2043.0	2051.0	3014.0
2010-09-23	CB	Futures	96.784	97.215	96.784	97.215	6.0
2010-09-23	CC	Futures	2282.0	2317.0	2278.0	2302.0	2956.0
2010-09-23	CT	Futures	84.46	84.46	82.04	82.25	23.0
2010-09-23	DC	Futures	25.07	25.3	24.86	25.29	130.0
2010-09-23	DX	Futures	80.3	80.651	80.17	80.503	27878.0
2010-09-23	E1	Futures	1.33104	1.33997	1.32684	1.33328	37636.0
2010-09-23	E6	Futures	1.58457	1.58646	1.57333	1.57688	342300.0
2010-09-23	E7	Futures	1.5727	1.5743	1.5614	1.5649	4537.0
2010-09-23	ED	Futures	94.7031	94.7078	94.6841	94.6983	211943.0
2010-09-23	ER	Futures	97.33	97.35	97.316	97.34	138738.0
2010-09-23	EW	Futures	767.9	771.7	758.7	761.7	29182.0
2010-09-23	FBTP	Futures	66.85	67.06	66.8	67.03	3914.0
2010-09-23	FCE	Futures	2466.8	2475.4	2405.8	2437.6	174946.0
2010-09-23	FDAX	Futures	6736.9	6748.2	6600.3	6653.6	179326.0
2010-09-23	FESX	Futures	1725.0	1728.8	1683.2	1700.1	1552751.0
2010-09-23	FEU3	Futures	97.894	97.904	97.894	97.904	11.0
2010-09-23	FGBL	Futures	103.28	104.05	103.17	103.9	1172616.0
2010-09-23	FGBM	Futures	106.26	106.77	106.22	106.67	572034.0
2010-09-23	FGBS	Futures	107.563	107.735	107.558	107.716	489277.0
2010-09-23	FGBX	Futures	106.25	107.9	105.98	107.52	3412.0
2010-09-23	FTDX	Futures	680.0	685.3	671.7	677.4	936.0
2010-09-23	FTI	Futures	269.73	270.29	264.16	267.08	43388.0
2010-09-23	FTUK	Futures	3845.1	3849.9	3756.3	3813.6	129537.0
2010-09-23	G	Futures	84.0	84.59	83.98	84.42	123672.0
2010-09-23	GF	Futures	275.252	276.32	273.931	274.874	1049.0
2010-09-23	GSCI	Futures	871.85	882.2	869.01	878.02	243.0
2010-09-23	HE	Futures	103.387	104.47	102.609	102.88	13536.0
2010-09-23	HG	Futures	4.7648	4.8042	4.7502	4.7922	20440.0
2010-09-23	HH	Futures	37.422	37.581	37.422	37.581	39.0
2010-09-23	HO	Futures	1.8046	1.8247	1.7821	1.8144	15373.0
2010-09-23	HRC	Futures	2685.2	2685.2	2685.2	2685.2	0.0
2010-09-23	J1	Futures	0.0148685	0.0149225	0.0148459	0.0149024	82428.0
2010-09-23	J7	Futures	0.014758	0.01482	0.014747	0.0148	164.0
2010-09-23	KC	Futures	448.86	454.44	445.39	450.47	7879.0
2010-09-23	KE	Futures	3160.34	3160.34	3053.95	3075.85	15337.0
2010-09-23	L	Futures	98.145	98.175	98.135	98.145	54725.0

> showing 50 of 89 rows — these rows as CSV

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