Analyst Estimates

Reset Filters

  
SELECT * FROM 
(
	SELECT 

		ae.id,
		ae.year_qtr,
		ae.category,
		ae.label_year,
		ae.label_value,

		s.symbol_id,
		s.symbol,
		s.symbol_name,

		a.full_name as analyst_full_name,

		af.analyst_firm_id, 
		af.firm_code as analyst_firm_code,

		aec.title as category_title
		
	FROM analyst_estimates ae
	INNER JOIN symbols s ON s.symbol_id = ae.symbol_id
	INNER JOIN analysts a ON a.analyst_id = ae.analyst_id
	INNER JOIN analyst_firms af ON af.analyst_firm_id = a.firm_id 
	INNER JOIN analyst_estimates_categories aec ON aec.code = ae.category 
	INNER JOIN stats_pricing st ON s.symbol_id = st.symbol_id
	LEFT JOIN companies c on c.symbol_id = s.symbol_id
	
	WHERE 1=1
	AND s.is_enable = 'Y'
	 AND s.symbol_market = 'EQUITY'

 ) as t