PREVIEW / futures_daily / 2009-10-05

all futures daily files

  file:    by_date/futures_daily/2009/2009-10-05.parquet
  size:    9 KB
  rows:    87

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-05	ES	Futures	985.51	1001.67	983.34	999.74	1675762.0
2009-10-05	NQ	Futures	1876.7	1897.86	1871.62	1889.68	261834.0
2009-10-05	YM	Futures	8563.0	8686.5	8548.5	8666.5	125371.0
2009-10-05	CL	Futures	172.88	175.7	168.52	174.37	346922.0
2009-10-05	GC	Futures	1388.0	1408.6	1384.6	1407.0	103249.0
2009-10-05	ZN	Futures	95.024028	95.285562	94.949304	94.99912	656854.0
2009-10-05	A6	Futures	0.69572	0.70687	0.69475	0.70639	61443.0
2009-10-05	AD	Futures	0.91255	0.92211	0.91077	0.92192	54312.0
2009-10-05	B	Futures	63.5	64.82	62.23	64.21	86805.0
2009-10-05	B6	Futures	1.6565	1.667	1.6541	1.6582	87145.0
2009-10-05	BFX	Futures	2736.9	2790.9	2728.8	2762.5	294.0
2009-10-05	BR	Futures	0.22217	0.2238	0.22174	0.22309	7.0
2009-10-05	C	Futures	2058.0	2219.0	2051.0	2217.0	10581.0
2009-10-05	CB	Futures	71.004	71.004	70.869	70.869	9.0
2009-10-05	CC	Futures	2646.0	2868.0	2604.0	2843.0	17523.0
2009-10-05	CT	Futures	52.43	53.26	52.36	53.15	5862.0
2009-10-05	DC	Futures	24.75	24.93	24.61	24.75	162.0
2009-10-05	DX	Futures	78.828	78.854	78.414	78.445	3363.0
2009-10-05	E1	Futures	1.27744	1.28233	1.27573	1.28141	28040.0
2009-10-05	E6	Futures	1.72877	1.73837	1.7277	1.73742	157196.0
2009-10-05	E7	Futures	1.7109	1.7217	1.7109	1.7208	5194.0
2009-10-05	ED	Futures	94.186	94.2001	94.186	94.1907	77588.0
2009-10-05	ER	Futures	97.164	97.179	97.164	97.169	46916.0
2009-10-05	EW	Futures	641.1	656.4	640.5	655.9	38914.0
2009-10-05	FCE	Futures	2407.5	2441.8	2395.0	2426.3	105956.0
2009-10-05	FDAX	Futures	5951.9	6037.3	5920.9	5993.2	141739.0
2009-10-05	FESX	Futures	1640.8	1670.7	1631.2	1657.5	1056381.0
2009-10-05	FEU3	Futures	97.741	97.746	97.741	97.741	103.0
2009-10-05	FGBL	Futures	94.55	94.64	94.43	94.55	515507.0
2009-10-05	FGBM	Futures	99.53	99.59	99.46	99.52	290150.0
2009-10-05	FGBS	Futures	104.837	104.861	104.803	104.818	267944.0
2009-10-05	FGBX	Futures	89.01	89.15	88.67	89.1	1342.0
2009-10-05	FTDX	Futures	644.2	654.5	638.9	650.5	439.0
2009-10-05	FTI	Futures	247.12	249.39	245.48	247.78	27587.0
2009-10-05	FTUK	Futures	3299.8	3330.6	3279.2	3311.1	99590.0
2009-10-05	G	Futures	77.93	78.16	77.81	78.12	76552.0
2009-10-05	GF	Futures	257.929	257.998	256.415	257.035	1047.0
2009-10-05	GSCI	Futures	901.54	922.16	896.54	915.55	1336.0
2009-10-05	HE	Futures	73.705	73.705	72.295	72.562	13036.0
2009-10-05	HG	Futures	3.7472	3.8183	3.697	3.8001	16426.0
2009-10-05	HO	Futures	1.7593	1.7804	1.7124	1.7651	20664.0
2009-10-05	HRC	Futures	2763.8	2763.8	2763.8	2763.8	0.0
2009-10-05	J1	Futures	0.014041	0.0140523	0.0139606	0.0140347	52688.0
2009-10-05	J7	Futures	0.013837	0.013865	0.01378	0.013852	54.0
2009-10-05	JB	Futures	117.87	118.13	117.65	117.81	1432.0
2009-10-05	KC	Futures	342.37	347.52	340.13	341.71	7905.0
2009-10-05	KE	Futures	2135.75	2193.91	2133.42	2148.54	9414.0
2009-10-05	L	Futures	97.819	97.829	97.77	97.799	88842.0
2009-10-05	LBS	Futures	703.1	708.8	697.8	703.9	951.0
2009-10-05	LE	Futures	140.578	141.373	140.159	140.452	16371.0

> showing 50 of 87 rows — these rows as CSV

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