PREVIEW / futures_daily / 2009-11-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-11-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-11-23	ES	Futures	1051.1	1072.08	1050.38	1064.6	1545064.0
2009-11-23	NQ	Futures	1990.15	2033.89	1989.3	2022.04	261423.0
2009-11-23	YM	Futures	9354.7	9519.9	9345.6	9461.8	113135.0
2009-11-23	CL	Futures	189.33	194.49	187.75	188.75	382888.0
2009-11-23	GC	Futures	1592.6	1623.0	1592.0	1610.1	227820.0
2009-11-23	ZN	Futures	95.260654	95.397648	94.949304	95.347832	859730.0
2009-11-23	A6	Futures	0.73572	0.74857	0.73548	0.74599	73699.0
2009-11-23	AD	Futures	0.92044	0.93552	0.92044	0.93424	66916.0
2009-11-23	B	Futures	72.04	73.93	71.64	71.96	146798.0
2009-11-23	B6	Futures	1.7142	1.7327	1.7138	1.7291	76332.0
2009-11-23	BFX	Futures	2834.5	2860.4	2829.0	2852.8	206.0
2009-11-23	BR	Futures	0.22881	0.22881	0.22881	0.22881	741.0
2009-11-23	BZ	Futures	78.45	78.45	76.4	76.61	12.0
2009-11-23	C	Futures	2224.0	2239.0	2214.0	2228.0	2718.0
2009-11-23	CB	Futures	80.686	80.686	80.439	80.686	17.0
2009-11-23	CC	Futures	2827.0	2848.0	2814.0	2829.0	4148.0
2009-11-23	CT	Futures	60.66	62.14	60.66	60.74	427.0
2009-11-23	DC	Futures	24.93	25.28	24.93	25.1	77.0
2009-11-23	DX	Futures	76.806	77.434	76.597	76.745	16267.0
2009-11-23	E1	Futures	1.29699	1.31165	1.29699	1.30875	45935.0
2009-11-23	E6	Futures	1.76018	1.7776	1.7597	1.7744	201592.0
2009-11-23	E7	Futures	1.7433	1.7607	1.7431	1.7574	2162.0
2009-11-23	ED	Futures	94.2829	94.2852	94.2805	94.2829	65997.0
2009-11-23	ER	Futures	97.164	97.169	97.154	97.164	90446.0
2009-11-23	EW	Futures	664.8	681.7	664.8	672.3	29003.0
2009-11-23	FBTP	Futures	62.87	62.93	62.76	62.91	2840.0
2009-11-23	FCE	Futures	2497.2	2539.4	2495.2	2527.7	94389.0
2009-11-23	FDAX	Futures	6213.6	6339.8	6213.6	6306.6	128700.0
2009-11-23	FESX	Futures	1704.7	1736.4	1704.7	1727.4	978964.0
2009-11-23	FEU3	Futures	97.736	97.736	97.736	97.736	695.0
2009-11-23	FGBL	Futures	94.45	94.47	94.22	94.36	470352.0
2009-11-23	FGBM	Futures	99.64	99.65	99.4	99.57	369851.0
2009-11-23	FGBS	Futures	105.002	105.011	104.886	104.948	578871.0
2009-11-23	FGBX	Futures	88.33	88.4	87.76	87.96	2505.0
2009-11-23	FTDX	Futures	684.3	694.5	684.3	693.2	364.0
2009-11-23	FTI	Futures	255.46	260.16	255.38	259.05	28931.0
2009-11-23	FTUK	Futures	3511.7	3568.4	3511.7	3549.2	74425.0
2009-11-23	G	Futures	77.04	77.13	76.82	76.91	63730.0
2009-11-23	GF	Futures	251.44	252.525	250.423	251.915	1200.0
2009-11-23	GSCI	Futures	996.18	1007.88	982.16	987.0	225.0
2009-11-23	HE	Futures	86.71	88.717	86.71	87.68	10103.0
2009-11-23	HG	Futures	4.3525	4.4201	4.3359	4.3621	14186.0
2009-11-23	HO	Futures	1.9442	1.9822	1.9198	1.9272	5654.0
2009-11-23	HRC	Futures	2637.0	2637.0	2637.0	2637.0	0.0
2009-11-23	J1	Futures	0.0141376	0.0141778	0.0140774	0.01411	68310.0
2009-11-23	J7	Futures	0.013938	0.013989	0.013899	0.013926	21.0
2009-11-23	JB	Futures	117.38	117.45	117.37	117.41	0.0
2009-11-23	KC	Futures	356.73	362.85	356.73	357.64	6756.0
2009-11-23	KE	Futures	2589.42	2682.48	2575.46	2577.79	8923.0
2009-11-23	L	Futures	97.789	97.789	97.77	97.779	17472.0

> showing 50 of 89 rows — these rows as CSV

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