PREVIEW / futures_daily / 2009-09-17

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-17.parquet
  size:    9 KB
  rows:    87

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-17	ES	Futures	1025.54	1033.5	1018.79	1025.06	2477295.0
2009-09-17	NQ	Futures	1938.78	1953.46	1932.86	1941.61	338889.0
2009-09-17	YM	Futures	8827.2	8894.4	8796.3	8839.9	157110.0
2009-09-17	CL	Futures	180.06	182.22	178.63	180.63	147654.0
2009-09-17	GC	Futures	1407.7	1418.1	1397.1	1401.1	118138.0
2009-09-17	ZN	Futures	93.168382	93.666542	92.956663	93.579364	833857.0
2009-09-17	A6	Futures	0.70041	0.70437	0.69734	0.7	75801.0
2009-09-17	AD	Futures	0.92458	0.93119	0.92369	0.92626	60950.0
2009-09-17	B	Futures	67.62	68.16	66.95	67.55	120787.0
2009-09-17	B6	Futures	1.7148	1.7239	1.7089	1.7113	108218.0
2009-09-17	BFX	Futures	2857.0	2857.0	2820.7	2838.2	898.0
2009-09-17	BR	Futures	0.21808	0.21808	0.21705	0.2174	83.0
2009-09-17	BZ	Futures	69.93	70.92	69.93	70.31	78.0
2009-09-17	C	Futures	2067.0	2078.0	2051.0	2055.0	5437.0
2009-09-17	CC	Futures	2698.0	2729.0	2687.0	2697.0	4465.0
2009-09-17	CT	Futures	55.11	55.42	54.97	55.42	63.0
2009-09-17	DC	Futures	23.35	23.45	23.14	23.4	79.0
2009-09-17	DX	Futures	78.134	78.261	77.827	78.032	6669.0
2009-09-17	E1	Futures	1.28088	1.28643	1.27573	1.28563	40569.0
2009-09-17	E6	Futures	1.74311	1.75081	1.74062	1.74773	210889.0
2009-09-17	E7	Futures	1.7263	1.7338	1.7239	1.731	2213.0
2009-09-17	ED	Futures	94.1009	94.1056	94.0678	94.0962	216957.0
2009-09-17	ER	Futures	97.144	97.154	97.095	97.125	146135.0
2009-09-17	EW	Futures	680.9	687.7	675.8	679.1	30097.0
2009-09-17	FCE	Futures	2534.9	2536.5	2511.5	2530.9	87082.0
2009-09-17	FDAX	Futures	6247.3	6256.0	6198.9	6244.0	87256.0
2009-09-17	FESX	Futures	1724.4	1725.0	1706.5	1721.4	1269049.0
2009-09-17	FEU3	Futures	97.717	97.717	97.692	97.697	1296.0
2009-09-17	FGBL	Futures	92.97	93.03	92.67	92.83	792874.0
2009-09-17	FGBM	Futures	98.69	98.71	98.44	98.56	581887.0
2009-09-17	FGBS	Futures	104.648	104.653	104.547	104.59	640592.0
2009-09-17	FGBX	Futures	85.8	85.95	85.47	85.8	2349.0
2009-09-17	FTDX	Futures	680.3	682.5	674.5	681.6	1081.0
2009-09-17	FTI	Futures	259.34	259.63	256.42	258.27	27289.0
2009-09-17	FTUK	Futures	3403.9	3411.9	3381.4	3407.6	103019.0
2009-09-17	G	Futures	76.07	76.16	75.93	76.01	86392.0
2009-09-17	GF	Futures	270.871	271.146	265.57	266.259	2587.0
2009-09-17	GSCI	Futures	945.77	952.37	941.37	946.17	536.0
2009-09-17	HE	Futures	78.621	80.374	78.088	79.307	16580.0
2009-09-17	HG	Futures	4.1109	4.1179	4.0196	4.0356	19090.0
2009-09-17	HO	Futures	1.8247	1.8576	1.8202	1.8423	10388.0
2009-09-17	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-17	J1	Futures	0.0138187	0.013879	0.0137107	0.0137823	94362.0
2009-09-17	J7	Futures	0.013642	0.013692	0.013539	0.013602	42.0
2009-09-17	JB	Futures	117.26	117.26	116.92	116.95	1416.0
2009-09-17	KC	Futures	355.04	361.77	354.25	359.13	8868.0
2009-09-17	KE	Futures	2231.13	2270.68	2190.42	2206.71	5420.0
2009-09-17	L	Futures	97.838	97.878	97.819	97.848	84948.0
2009-09-17	LBS	Futures	728.3	754.4	721.4	741.8	1159.0
2009-09-17	LE	Futures	144.804	144.846	142.712	142.879	16263.0

> showing 50 of 87 rows — these rows as CSV

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