PREVIEW / futures_daily / 2009-06-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-23.parquet
  size:    8 KB
  rows:    85

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-06-23	ES	Futures	852.7	858.22	848.38	854.14	1834657.0
2009-06-23	NQ	Futures	1607.88	1615.2	1590.14	1603.66	259634.0
2009-06-23	YM	Futures	7473.3	7512.1	7423.7	7449.9	136598.0
2009-06-23	CL	Futures	176.68	183.34	174.63	182.18	279901.0
2009-06-23	GC	Futures	1277.2	1284.0	1264.3	1279.7	91901.0
2009-06-23	ZN	Futures	90.793454	91.088958	90.497951	91.002769	701532.0
2009-06-23	A6	Futures	0.62844	0.63752	0.62201	0.63503	88055.0
2009-06-23	AD	Futures	0.85654	0.86208	0.85299	0.85812	73003.0
2009-06-23	B	Futures	63.98	66.24	63.04	65.81	132938.0
2009-06-23	B6	Futures	1.7014	1.7158	1.6879	1.7136	108692.0
2009-06-23	BFX	Futures	2210.1	2240.2	2210.1	2228.0	169.0
2009-06-23	BR	Futures	0.19091	0.1935	0.19048	0.1935	24.0
2009-06-23	BZ	Futures	70.05	72.15	70.03	71.82	56.0
2009-06-23	C	Futures	1688.0	1705.0	1683.0	1696.0	1281.0
2009-06-23	CC	Futures	2201.0	2223.0	2193.0	2214.0	5213.0
2009-06-23	CT	Futures	46.78	47.71	46.4	47.28	3543.0
2009-06-23	DC	Futures	20.45	20.67	20.29	20.58	172.0
2009-06-23	DX	Futures	83.106	83.198	81.924	82.062	8566.0
2009-06-23	E1	Futures	1.21987	1.24542	1.21776	1.24198	60550.0
2009-06-23	E6	Futures	1.6439	1.67417	1.64069	1.67096	277272.0
2009-06-23	E7	Futures	1.6269	1.6569	1.6239	1.6538	3273.0
2009-06-23	ED	Futures	93.7158	93.7441	93.7064	93.7394	192877.0
2009-06-23	ER	Futures	96.831	96.855	96.816	96.841	134053.0
2009-06-23	EW	Futures	538.4	541.5	530.7	532.9	29168.0
2009-06-23	FCE	Futures	2025.5	2049.3	2018.6	2031.0	123961.0
2009-06-23	FDAX	Futures	5139.1	5219.2	5127.1	5164.9	147351.0
2009-06-23	FESX	Futures	1398.0	1415.3	1393.2	1401.0	1023339.0
2009-06-23	FEU3	Futures	97.421	97.426	97.397	97.416	1130.0
2009-06-23	FGBL	Futures	91.44	91.45	91.1	91.38	688619.0
2009-06-23	FGBM	Futures	97.48	97.53	97.23	97.43	350852.0
2009-06-23	FGBS	Futures	103.805	103.815	103.661	103.743	562173.0
2009-06-23	FGBX	Futures	81.92	82.05	81.52	81.98	4948.0
2009-06-23	FTDX	Futures	522.0	533.6	517.5	528.2	1021.0
2009-06-23	FTI	Futures	201.79	203.62	200.57	202.12	31327.0
2009-06-23	FTUK	Futures	2780.7	2809.3	2776.1	2783.4	87502.0
2009-06-23	G	Futures	75.47	75.57	75.17	75.52	79892.0
2009-06-23	GF	Futures	272.323	275.355	272.185	274.803	2824.0
2009-06-23	GSCI	Futures	932.96	944.85	919.19	938.8	262.0
2009-06-23	HE	Futures	88.496	88.788	86.632	87.911	3841.0
2009-06-23	HG	Futures	3.0006	3.1101	2.9816	3.1059	10206.0
2009-06-23	HO	Futures	1.8301	1.8867	1.8184	1.8792	8155.0
2009-06-23	HRC	Futures	2409.0	2409.0	2328.7	2328.7	10.0
2009-06-23	J1	Futures	0.0131406	0.0132828	0.0131343	0.0132299	105501.0
2009-06-23	J7	Futures	0.012987	0.013097	0.012963	0.013048	98.0
2009-06-23	JB	Futures	115.56	115.77	115.47	115.7	2332.0
2009-06-23	KC	Futures	326.02	327.24	319.77	322.76	9395.0
2009-06-23	KE	Futures	2944.96	2973.0	2930.33	2944.96	12267.0
2009-06-23	L	Futures	97.003	97.043	97.003	97.043	49980.0
2009-06-23	LBS	Futures	957.9	958.8	916.8	916.8	544.0
2009-06-23	LE	Futures	145.964	147.329	145.523	146.845	16271.0

> showing 50 of 85 rows — these rows as CSV

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