PREVIEW / futures_daily / 2009-05-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-05-27.parquet
  size:    8 KB
  rows:    84

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-05-27	ES	Futures	865.41	871.13	848.73	850.64	2404322.0
2009-05-27	NQ	Futures	1584.43	1605.22	1570.39	1577.41	301025.0
2009-05-27	YM	Futures	7574.2	7628.0	7420.8	7442.3	168653.0
2009-05-27	CL	Futures	167.37	169.9	165.56	168.92	261888.0
2009-05-27	GC	Futures	1322.9	1331.2	1312.5	1322.4	100682.0
2009-05-27	ZN	Futures	91.902736	92.194028	90.992447	91.283739	1502078.0
2009-05-27	A6	Futures	0.62661	0.62852	0.61775	0.62334	51920.0
2009-05-27	AD	Futures	0.88246	0.88729	0.87774	0.88335	75170.0
2009-05-27	B	Futures	59.53	60.67	59.08	60.45	48516.0
2009-05-27	B6	Futures	1.6578	1.6735	1.657	1.6694	99703.0
2009-05-27	BFX	Futures	2369.6	2369.6	2338.5	2361.8	205.0
2009-05-27	BR	Futures	0.19188	0.19188	0.19013	0.19091	5.0
2009-05-27	BZ	Futures	65.54	65.96	65.54	65.96	4.0
2009-05-27	C	Futures	1737.0	1782.0	1737.0	1770.0	4556.0
2009-05-27	CC	Futures	2125.0	2232.0	2125.0	2214.0	12750.0
2009-05-27	CT	Futures	50.98	51.58	50.66	51.42	11640.0
2009-05-27	DC	Futures	24.21	24.63	24.19	24.51	109.0
2009-05-27	DX	Futures	82.545	83.39	82.417	82.808	7236.0
2009-05-27	E1	Futures	1.22357	1.22662	1.20991	1.21999	39173.0
2009-05-27	E6	Futures	1.65792	1.65958	1.63895	1.64974	240582.0
2009-05-27	E7	Futures	1.6385	1.6402	1.6202	1.6306	3033.0
2009-05-27	ED	Futures	93.5653	93.629	93.5559	93.6007	275474.0
2009-05-27	ER	Futures	96.743	96.758	96.723	96.743	92437.0
2009-05-27	EW	Futures	550.5	556.6	542.1	543.1	28593.0
2009-05-27	FCE	Futures	2114.4	2140.1	2096.2	2135.9	116013.0
2009-05-27	FDAX	Futures	5431.9	5486.4	5366.6	5448.8	138627.0
2009-05-27	FESX	Futures	1479.7	1493.5	1458.1	1486.9	1051357.0
2009-05-27	FEU3	Futures	97.318	97.328	97.318	97.323	326.0
2009-05-27	FGBL	Futures	90.05	90.2	89.64	90.11	695105.0
2009-05-27	FGBM	Futures	96.73	96.83	96.54	96.75	444120.0
2009-05-27	FGBS	Futures	103.613	103.695	103.603	103.671	498400.0
2009-05-27	FGBX	Futures	78.65	79.51	78.65	79.37	1365.0
2009-05-27	FTDX	Futures	576.5	581.0	572.9	579.2	1414.0
2009-05-27	FTI	Futures	217.58	219.02	215.85	217.71	31140.0
2009-05-27	FTUK	Futures	2946.1	2946.7	2881.2	2930.4	80210.0
2009-05-27	G	Futures	75.55	75.68	75.17	75.29	146848.0
2009-05-27	GF	Futures	282.521	284.313	281.97	282.383	1561.0
2009-05-27	GSCI	Futures	907.71	913.68	902.38	908.78	267.0
2009-05-27	HE	Futures	98.204	98.542	97.231	97.792	4999.0
2009-05-27	HG	Futures	3.0108	3.0375	2.944	2.9841	14094.0
2009-05-27	HO	Futures	1.6891	1.6981	1.6609	1.6881	8542.0
2009-05-27	HRC	Futures	2495.0	2495.0	2495.0	2495.0	0.0
2009-05-27	J1	Futures	0.0132794	0.0133185	0.0131975	0.0132403	75468.0
2009-05-27	J7	Futures	0.013059	0.013129	0.013026	0.013061	33.0
2009-05-27	JB	Futures	114.65	114.67	114.13	114.28	3415.0
2009-05-27	KC	Futures	378.78	381.82	371.57	375.45	9381.0
2009-05-27	KE	Futures	3226.54	3308.21	3222.88	3291.14	9901.0
2009-05-27	L	Futures	97.101	97.141	97.052	97.111	77781.0
2009-05-27	LBS	Futures	799.5	845.1	792.7	845.1	431.0
2009-05-27	LE	Futures	147.594	148.387	146.184	146.448	6031.0

> showing 50 of 84 rows — these rows as CSV

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