PREVIEW / futures_daily / 2009-11-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-11-27.parquet
  size:    9 KB
  rows:    88

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-11-27	ES	Futures	1069.43	1071.84	1029.16	1050.86	1704981.0
2009-11-27	NQ	Futures	2025.42	2028.81	1944.15	1985.91	256664.0
2009-11-27	YM	Futures	9480.8	9502.6	9184.0	9343.8	140037.0
2009-11-27	CL	Futures	189.33	189.67	176.17	185.07	301347.0
2009-11-27	GC	Futures	1644.3	1647.3	1563.3	1618.0	275926.0
2009-11-27	ZN	Futures	96.05771	96.979306	96.05771	96.506054	705831.0
2009-11-27	A6	Futures	0.75213	0.75213	0.72191	0.73152	174371.0
2009-11-27	AD	Futures	0.94341	0.94341	0.91709	0.92783	117732.0
2009-11-27	B	Futures	71.43	71.81	68.44	71.63	47619.0
2009-11-27	B6	Futures	1.7377	1.7404	1.6929	1.7159	172834.0
2009-11-27	BFX	Futures	2692.1	2783.5	2688.4	2778.4	454.0
2009-11-27	BR	Futures	0.22668	0.2272	0.22587	0.2272	235.0
2009-11-27	C	Futures	2227.0	2243.0	2196.0	2239.0	2147.0
2009-11-27	CB	Futures	80.439	80.439	80.439	80.439	14.0
2009-11-27	CC	Futures	2809.0	2825.0	2749.0	2811.0	7386.0
2009-11-27	CT	Futures	60.94	60.94	59.35	60.2	9721.0
2009-11-27	DC	Futures	25.39	25.39	25.39	25.39	98.0
2009-11-27	DX	Futures	76.592	77.251	76.541	76.613	18152.0
2009-11-27	E1	Futures	1.32579	1.33279	1.29792	1.31231	117014.0
2009-11-27	E6	Futures	1.79395	1.79443	1.75721	1.77298	453052.0
2009-11-27	E7	Futures	1.7769	1.7771	1.7405	1.756	4843.0
2009-11-27	ED	Futures	94.2852	94.2876	94.219	94.245	266412.0
2009-11-27	ER	Futures	97.164	97.169	97.11	97.144	124583.0
2009-11-27	EW	Futures	675.6	676.6	644.0	660.1	24338.0
2009-11-27	FBTP	Futures	63.11	63.15	62.86	63.05	10373.0
2009-11-27	FCE	Futures	2415.5	2485.6	2379.3	2467.3	149400.0
2009-11-27	FDAX	Futures	6050.4	6226.1	5994.3	6196.2	190927.0
2009-11-27	FESX	Futures	1651.6	1701.7	1631.8	1692.2	1768474.0
2009-11-27	FEU3	Futures	97.712	97.722	97.712	97.717	790.0
2009-11-27	FGBL	Futures	95.37	95.6	95.02	95.16	891244.0
2009-11-27	FGBM	Futures	100.16	100.43	100.01	100.08	576989.0
2009-11-27	FGBS	Futures	105.128	105.278	105.074	105.089	683426.0
2009-11-27	FGBX	Futures	88.76	88.97	88.15	88.4	2329.0
2009-11-27	FTDX	Futures	679.0	701.2	666.5	695.9	1480.0
2009-11-27	FTI	Futures	248.32	254.52	245.09	252.89	43449.0
2009-11-27	FTUK	Futures	3383.4	3496.8	3370.1	3477.9	127997.0
2009-11-27	G	Futures	78.11	78.11	77.5	77.61	79289.0
2009-11-27	GF	Futures	253.068	253.068	249.202	250.898	1412.0
2009-11-27	GSCI	Futures	966.7	986.03	944.08	986.03	770.0
2009-11-27	HE	Futures	90.524	91.092	89.319	90.089	8640.0
2009-11-27	HG	Futures	4.4249	4.4559	4.1676	4.3118	27272.0
2009-11-27	HO	Futures	1.9434	1.9434	1.8412	1.9264	4730.0
2009-11-27	J1	Futures	0.01438	0.0148044	0.0143536	0.0144691	190246.0
2009-11-27	J7	Futures	0.014202	0.014512	0.01417	0.01428	201.0
2009-11-27	JB	Futures	117.8	118.1	117.71	118.04	1548.0
2009-11-27	KC	Futures	353.74	360.51	348.79	359.33	7179.0
2009-11-27	KE	Futures	2509.95	2537.08	2464.72	2528.04	7268.0
2009-11-27	KRW	Futures	0.0008365	0.0008365	0.0008365	0.0008365	21.0
2009-11-27	L	Futures	97.75	97.76	97.661	97.701	104976.0
2009-11-27	LBS	Futures	841.3	848.6	831.8	842.0	319.0

> showing 50 of 88 rows — these rows as CSV

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