PREVIEW / futures_daily / 2009-09-18

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-18.parquet
  size:    8 KB
  rows:    86

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-09-18	ES	Futures	1025.3	1029.88	1018.55	1023.37	1872677.0
2009-09-18	NQ	Futures	1941.89	1953.46	1933.42	1943.02	237788.0
2009-09-18	YM	Futures	8839.0	8884.4	8790.9	8836.3	127555.0
2009-09-18	CL	Futures	180.46	181.08	177.59	179.52	128927.0
2009-09-18	GC	Futures	1402.5	1409.4	1392.7	1396.7	102954.0
2009-09-18	ZN	Futures	93.579364	93.741266	93.031387	93.131019	653200.0
2009-09-18	A6	Futures	0.6996	0.70009	0.69443	0.69726	59697.0
2009-09-18	AD	Futures	0.92586	0.92616	0.91561	0.92182	50619.0
2009-09-18	B	Futures	67.53	67.77	66.57	67.33	97431.0
2009-09-18	B6	Futures	1.7116	1.7119	1.6886	1.693	131556.0
2009-09-18	BFX	Futures	2824.1	2846.7	2820.7	2846.7	221.0
2009-09-18	BZ	Futures	70.5	70.5	70.08	70.08	114.0
2009-09-18	C	Futures	2055.0	2105.0	2044.0	2097.0	8995.0
2009-09-18	CC	Futures	2674.0	2747.0	2654.0	2731.0	7211.0
2009-09-18	CT	Futures	54.79	56.08	54.54	55.88	218.0
2009-09-18	DC	Futures	23.57	23.96	23.53	23.86	146.0
2009-09-18	DX	Futures	78.118	78.542	78.088	78.277	6789.0
2009-09-18	E1	Futures	1.28537	1.28629	1.27731	1.28471	27675.0
2009-09-18	E6	Futures	1.74714	1.74738	1.73576	1.74453	177035.0
2009-09-18	E7	Futures	1.7303	1.7303	1.7194	1.7278	1644.0
2009-09-18	ED	Futures	94.0962	94.1056	94.0631	94.0725	167842.0
2009-09-18	ER	Futures	97.13	97.149	97.125	97.135	115233.0
2009-09-18	EW	Futures	679.0	683.2	674.6	675.2	27702.0
2009-09-18	FCE	Futures	2516.7	2543.8	2515.4	2525.6	119870.0
2009-09-18	FDAX	Futures	6221.7	6271.2	6204.9	6221.2	159545.0
2009-09-18	FESX	Futures	1715.5	1731.6	1709.5	1719.0	1301459.0
2009-09-18	FEU3	Futures	97.712	97.712	97.702	97.707	545.0
2009-09-18	FGBL	Futures	92.99	93.22	92.54	92.81	589479.0
2009-09-18	FGBM	Futures	98.69	98.83	98.41	98.55	293268.0
2009-09-18	FGBS	Futures	104.653	104.692	104.571	104.605	277205.0
2009-09-18	FGBX	Futures	85.88	86.12	84.97	85.34	2403.0
2009-09-18	FTDX	Futures	681.2	692.8	674.1	689.2	4182.0
2009-09-18	FTI	Futures	257.33	259.63	256.79	258.03	31565.0
2009-09-18	FTUK	Futures	3396.0	3427.8	3388.0	3409.2	137324.0
2009-09-18	G	Futures	76.3	76.3	75.87	75.97	64138.0
2009-09-18	GF	Futures	266.327	267.635	264.813	267.153	954.0
2009-09-18	GSCI	Futures	939.57	946.57	936.06	938.57	162.0
2009-09-18	HE	Futures	79.612	80.26	76.144	76.678	14603.0
2009-09-18	HG	Futures	4.0489	4.0586	3.8761	3.881	25985.0
2009-09-18	HO	Futures	1.8361	1.8498	1.8241	1.8299	7787.0
2009-09-18	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-18	J1	Futures	0.0137948	0.0138024	0.0137245	0.0137496	72465.0
2009-09-18	J7	Futures	0.013589	0.01362	0.013548	0.01357	27.0
2009-09-18	JB	Futures	116.95	117.09	116.81	116.94	1593.0
2009-09-18	KC	Futures	357.68	362.03	353.19	359.13	9131.0
2009-09-18	KE	Futures	2204.38	2222.99	2191.58	2196.24	6878.0
2009-09-18	L	Futures	97.858	97.878	97.848	97.858	62700.0
2009-09-18	LBS	Futures	749.1	759.3	742.2	756.0	407.0
2009-09-18	LE	Futures	142.879	143.382	141.749	142.126	16113.0
2009-09-18	MFS	Futures	1266.8	1267.6	1257.6	1258.8	621.0

> showing 50 of 86 rows — these rows as CSV

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