PREVIEW / futures_daily / 2009-03-18

all futures daily files

  file:    by_date/futures_daily/2009/2009-03-18.parquet
  size:    8 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-03-18	ES	Futures	739.6	762.95	726.02	754.37	3324988.0
2009-03-18	NQ	Futures	1336.98	1377.42	1324.62	1362.54	405034.0
2009-03-18	YM	Futures	6596.4	6745.3	6461.9	6676.3	258503.0
2009-03-18	CL	Futures	138.71	142.05	133.94	137.28	212517.0
2009-03-18	GC	Futures	1270.0	1323.9	1224.9	1233.8	226078.0
2009-03-18	ZN	Futures	93.868959	97.971326	93.796136	97.35233	1030466.0
2009-03-18	A6	Futures	0.52564	0.54024	0.52102	0.5372	46710.0
2009-03-18	AD	Futures	0.77633	0.79316	0.77268	0.78873	60587.0
2009-03-18	B	Futures	46.4	47.9	45.08	46.65	110707.0
2009-03-18	B6	Futures	1.4613	1.4885	1.4411	1.4803	74447.0
2009-03-18	BFX	Futures	1887.8	1887.8	1840.1	1853.8	6553.0
2009-03-18	BR	Futures	0.16347	0.16461	0.16347	0.16461	1.0
2009-03-18	BZ	Futures	48.58	49.85	47.17	48.66	99.0
2009-03-18	C	Futures	1899.0	1953.0	1899.0	1945.0	6331.0
2009-03-18	CB	Futures	76.737	77.158	75.533	75.533	36.0
2009-03-18	CC	Futures	2103.0	2195.0	2081.0	2156.0	7968.0
2009-03-18	CT	Futures	40.63	40.65	39.19	39.36	7996.0
2009-03-18	DC	Futures	29.51	29.82	28.39	28.84	346.0
2009-03-18	DX	Futures	89.826	90.135	86.87	87.509	9169.0
2009-03-18	E1	Futures	1.12413	1.17345	1.12306	1.16152	46796.0
2009-03-18	E6	Futures	1.54304	1.60007	1.53972	1.59082	233081.0
2009-03-18	E7	Futures	1.5255	1.5814	1.5221	1.5724	2057.0
2009-03-18	EBM	Futures	216.34	219.05	214.01	214.01	2663.0
2009-03-18	ED	Futures	92.9832	93.2189	92.9785	93.1576	309232.0
2009-03-18	ER	Futures	96.552	96.655	96.547	96.591	200799.0
2009-03-18	EW	Futures	450.9	466.4	440.6	462.7	41065.0
2009-03-18	FCE	Futures	1791.1	1791.1	1725.7	1751.4	98498.0
2009-03-18	FDAX	Futures	4426.1	4461.5	4308.0	4357.5	50587.0
2009-03-18	FESX	Futures	1187.5	1198.3	1150.3	1165.9	1267487.0
2009-03-18	FEU3	Futures	97.131	97.175	97.131	97.17	161.0
2009-03-18	FGBL	Futures	92.49	93.94	92.16	92.27	856973.0
2009-03-18	FGBM	Futures	97.56	98.4	97.45	97.51	354705.0
2009-03-18	FGBS	Futures	103.589	103.92	103.56	103.623	361978.0
2009-03-18	FGBX	Futures	81.48	84.05	80.86	81.69	5926.0
2009-03-18	FTDX	Futures	393.0	394.8	383.1	386.7	2012.0
2009-03-18	FTI	Futures	176.58	176.58	168.71	170.53	34620.0
2009-03-18	FTUK	Futures	2583.5	2583.5	2480.3	2504.3	204365.0
2009-03-18	G	Futures	78.38	78.52	78.07	78.1	81359.0
2009-03-18	GF	Futures	260.668	261.575	258.155	259.481	762.0
2009-03-18	GSCI	Futures	756.4	757.78	734.71	748.96	177.0
2009-03-18	HE	Futures	120.142	120.926	120.1	120.595	66.0
2009-03-18	HG	Futures	2.4302	2.4929	2.3859	2.4183	11903.0
2009-03-18	HO	Futures	1.4253	1.4617	1.3872	1.4207	8979.0
2009-03-18	HRC	Futures	2833.7	2833.7	2833.7	2833.7	0.0
2009-03-18	J1	Futures	0.0127942	0.013195	0.0127715	0.0131017	76764.0
2009-03-18	J7	Futures	0.012661	0.013002	0.012615	0.012924	142.0
2009-03-18	JB	Futures	115.97	116.42	115.73	116.21	2455.0
2009-03-18	KC	Futures	315.05	321.38	312.66	318.29	8650.0
2009-03-18	KE	Futures	2982.67	3004.85	2859.42	2874.21	7544.0
2009-03-18	L	Futures	96.649	96.708	96.649	96.699	107141.0

> showing 50 of 87 rows — these rows as CSV

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