PREVIEW / futures_daily / 2009-10-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-10-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
2009-10-23	ES	Futures	1051.82	1056.41	1033.5	1038.8	2348150.0
2009-10-23	NQ	Futures	1989.3	2007.36	1971.8	1977.73	358585.0
2009-10-23	YM	Futures	9115.9	9140.4	8971.5	9016.0	193028.0
2009-10-23	CL	Futures	199.12	200.39	194.93	197.25	293751.0
2009-10-23	GC	Futures	1466.9	1477.5	1452.1	1460.4	153870.0
2009-10-23	ZN	Futures	94.0028	94.0028	93.554456	93.728812	837447.0
2009-10-23	A6	Futures	0.74526	0.74768	0.73976	0.74098	85397.0
2009-10-23	AD	Futures	0.94164	0.94361	0.93493	0.93671	56196.0
2009-10-23	B	Futures	74.38	74.77	72.81	73.62	126314.0
2009-10-23	B6	Futures	1.7285	1.7365	1.6954	1.6966	180294.0
2009-10-23	BFX	Futures	2917.9	2918.6	2881.8	2881.8	26.0
2009-10-23	BR	Futures	0.22941	0.22941	0.22941	0.22941	116.0
2009-10-23	BZ	Futures	77.69	77.82	76.55	77.22	20.0
2009-10-23	C	Futures	2245.0	2279.0	2242.0	2260.0	5692.0
2009-10-23	CB	Futures	72.618	72.618	72.349	72.618	15.0
2009-10-23	CC	Futures	2977.0	2994.0	2938.0	2953.0	7851.0
2009-10-23	CT	Futures	59.07	59.41	57.57	58.15	10235.0
2009-10-23	DC	Futures	24.9	25.19	24.78	25.07	124.0
2009-10-23	DX	Futures	76.781	77.251	76.679	77.184	14228.0
2009-10-23	E1	Futures	1.31522	1.31707	1.30769	1.30967	42387.0
2009-10-23	E6	Futures	1.78103	1.78471	1.7757	1.77772	232306.0
2009-10-23	E7	Futures	1.764	1.7675	1.7588	1.7607	4463.0
2009-10-23	ED	Futures	94.2049	94.2049	94.1907	94.2001	119668.0
2009-10-23	ER	Futures	97.1	97.105	97.081	97.095	84337.0
2009-10-23	EW	Futures	688.9	691.5	675.9	680.2	47812.0
2009-10-23	FBTP	Futures	62.08	62.2	62.0	62.05	4875.0
2009-10-23	FCE	Futures	2543.5	2552.8	2497.3	2506.2	129207.0
2009-10-23	FDAX	Futures	6345.2	6367.0	6231.5	6257.1	165311.0
2009-10-23	FESX	Futures	1746.5	1753.1	1710.1	1719.6	1125738.0
2009-10-23	FEU3	Futures	97.658	97.672	97.658	97.668	805.0
2009-10-23	FGBL	Futures	93.22	93.36	93.04	93.12	722856.0
2009-10-23	FGBM	Futures	98.81	98.88	98.65	98.76	397312.0
2009-10-23	FGBS	Futures	104.503	104.552	104.44	104.513	494449.0
2009-10-23	FGBX	Futures	86.07	86.16	85.43	85.75	3321.0
2009-10-23	FTDX	Futures	682.5	685.2	673.2	675.4	413.0
2009-10-23	FTI	Futures	264.75	265.48	260.04	261.15	35603.0
2009-10-23	FTUK	Futures	3460.0	3496.8	3445.4	3461.0	103701.0
2009-10-23	G	Futures	76.1	76.89	75.97	76.62	123675.0
2009-10-23	GF	Futures	265.221	266.047	262.676	262.676	1836.0
2009-10-23	GSCI	Futures	1035.61	1035.81	1017.7	1019.28	367.0
2009-10-23	HE	Futures	82.165	82.699	80.451	80.832	9862.0
2009-10-23	HG	Futures	4.2084	4.267	4.1722	4.2286	21416.0
2009-10-23	HO	Futures	2.0579	2.0681	2.0178	2.0388	40831.0
2009-10-23	HRC	Futures	2763.8	2763.8	2763.8	2763.8	0.0
2009-10-23	J1	Futures	0.0137559	0.0137597	0.0136329	0.0136341	92601.0
2009-10-23	J7	Futures	0.013576	0.013576	0.013456	0.013456	68.0
2009-10-23	JB	Futures	116.81	116.81	116.58	116.58	2513.0
2009-10-23	KC	Futures	378.14	378.14	358.87	362.03	16499.0
2009-10-23	KE	Futures	2569.64	2666.19	2552.19	2556.85	18758.0
2009-10-23	L	Futures	97.72	97.779	97.701	97.76	66040.0

> showing 50 of 89 rows — these rows as CSV

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