PREVIEW / futures_daily / 2009-10-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-10-27.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-10-27	ES	Futures	1028.43	1031.81	1019.51	1022.89	2460527.0
2009-10-27	NQ	Futures	1972.65	1977.45	1933.71	1941.32	442445.0
2009-10-27	YM	Futures	8931.6	8987.0	8885.3	8928.9	191647.0
2009-10-27	CL	Futures	192.79	195.76	190.66	194.93	375672.0
2009-10-27	GC	Futures	1435.7	1443.7	1427.9	1431.4	153185.0
2009-10-27	ZN	Futures	93.280468	94.040162	93.243106	93.990346	960100.0
2009-10-27	A6	Futures	0.73734	0.74162	0.7337	0.73766	109001.0
2009-10-27	AD	Futures	0.92182	0.92783	0.91994	0.92724	79888.0
2009-10-27	B	Futures	72.63	73.55	71.72	73.07	58472.0
2009-10-27	B6	Futures	1.6975	1.71	1.694	1.7045	141978.0
2009-10-27	BFX	Futures	2783.5	2802.0	2755.6	2771.0	287.0
2009-10-27	BR	Futures	0.2275	0.2275	0.2275	0.2275	11.0
2009-10-27	BZ	Futures	77.91	77.98	77.39	77.8	4.0
2009-10-27	C	Futures	2252.0	2271.0	2244.0	2257.0	3567.0
2009-10-27	CB	Futures	72.618	72.618	72.618	72.618	1.0
2009-10-27	CC	Futures	2961.0	2969.0	2909.0	2937.0	6192.0
2009-10-27	CT	Futures	58.17	58.3	57.04	57.86	9699.0
2009-10-27	DC	Futures	25.16	25.29	24.93	25.09	151.0
2009-10-27	DX	Futures	77.817	78.093	77.496	77.878	18997.0
2009-10-27	E1	Futures	1.29712	1.30188	1.28893	1.29356	58977.0
2009-10-27	E6	Futures	1.76231	1.76906	1.7501	1.75472	330482.0
2009-10-27	E7	Futures	1.7454	1.7519	1.7334	1.7379	4325.0
2009-10-27	ED	Futures	94.2001	94.2285	94.2001	94.2238	124768.0
2009-10-27	ER	Futures	97.125	97.149	97.115	97.139	90864.0
2009-10-27	EW	Futures	673.5	676.1	662.2	664.0	50636.0
2009-10-27	FBTP	Futures	62.03	62.56	62.03	62.52	4643.0
2009-10-27	FCE	Futures	2467.5	2483.4	2447.0	2465.2	125717.0
2009-10-27	FDAX	Futures	6153.7	6176.6	6093.3	6136.9	185519.0
2009-10-27	FESX	Futures	1689.2	1698.7	1674.2	1687.4	1392505.0
2009-10-27	FEU3	Futures	97.692	97.717	97.692	97.712	2303.0
2009-10-27	FGBL	Futures	93.07	93.75	93.03	93.64	877977.0
2009-10-27	FGBM	Futures	98.71	99.2	98.68	99.11	478508.0
2009-10-27	FGBS	Futures	104.542	104.74	104.542	104.697	598785.0
2009-10-27	FGBX	Futures	85.48	86.6	85.45	86.46	2013.0
2009-10-27	FTDX	Futures	669.2	673.2	657.1	659.8	662.0
2009-10-27	FTI	Futures	255.09	256.69	251.98	253.86	41012.0
2009-10-27	FTUK	Futures	3438.4	3451.7	3415.9	3437.4	107313.0
2009-10-27	G	Futures	76.46	77.07	76.44	76.96	96622.0
2009-10-27	GF	Futures	263.708	264.258	262.883	263.708	891.0
2009-10-27	GSCI	Futures	1005.7	1009.63	994.68	1002.06	209.0
2009-10-27	HE	Futures	82.089	84.871	81.479	84.49	21114.0
2009-10-27	HG	Futures	4.1576	4.221	4.1025	4.1792	26349.0
2009-10-27	HO	Futures	2.0005	2.0266	1.9817	2.0142	48204.0
2009-10-27	HRC	Futures	2687.7	2713.1	2687.7	2713.1	10.0
2009-10-27	J1	Futures	0.0136165	0.0136956	0.013604	0.0136843	85119.0
2009-10-27	J7	Futures	0.013445	0.013513	0.013429	0.013506	38.0
2009-10-27	JB	Futures	116.43	116.53	116.19	116.19	1508.0
2009-10-27	KC	Futures	360.05	363.49	357.42	359.92	6887.0
2009-10-27	KE	Futures	2474.26	2488.21	2375.38	2375.38	10572.0
2009-10-27	L	Futures	97.779	97.829	97.779	97.819	52726.0

> showing 50 of 89 rows — these rows as CSV

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