SELECT 
		t.*,
		s.symbol_id,
		s.symbol,
		s.symbol_name,

		peod.px_date,
		peod.px_close_adj,
		peod.chg_1d,
		peod.return_1d,
		peod.trend_direction,
		peod.trend_days

	FROM 
	(
		SELECT 
	 	COUNT(my.symbol_id) as count_symbol_id,
	 	COUNT(DISTINCT my.reporting_name) as count_owners,
	 	SUM(my.securities_transacted) as total_transaction_amount,
		my.symbol_id
	
		FROM insider_transactions my

		WHERE 1=1 AND my.transaction_type = 'P-Purchase' AND my.transaction_date >= '2025-03-31'
		GROUP BY my.symbol_id
	) as t
	INNER JOIN symbols s ON s.symbol_id = t.symbol_id
	LEFT JOIN prices_eod peod ON peod.symbol_id = t.symbol_id
	WHERE count_symbol_id > 1