Retrieving Most Recent Status Value before A given transaction date

I have two tables, one that contains a customer's status as of a given date and another table that contains a customer's transaction history. For a given transaction date, I want to pull back what their status was on that transaction date (based on the most recent insert date (prior to the tran date) in the status table).

I've tried a few times with self-joins and things and I'm running into a wall. I appreciate any help in advance.

Working with Snowflake SQL here.

Status Table

Tran Table

Desired Table

Conceptually same as above answer, here is the snowflake version since you mentioned it is for Snowflake.

1.We join the Tran table with the Status table to get all possible matches where the account numbers are the same, and the status INSERT_DATE is on or before the TRAN_DATE.

2.Then a rank is assigned for the same account and TRAN_DATE, based on the status INSERT_DATE, ordering them from the most recent to the oldest, so recent INSERT_DATE gets a rank of 1.

3.This is then filtered using QUALIFY to fetch the most recent status for each TRAN_DATE.

SELECT T.ACCT, T.TRAN_DATE, S.STATUS
FROM
TRAN T
LEFT JOIN 
STATUS S
ON T.ACCT = S.ACCT
AND S.INSERT_DATE <= T.TRAN_DATE
QUALIFY ROW_NUMBER() OVER (PARTITION BY T.ACCT, T.TRAN_DATE ORDER BY S.INSERT_DATE DESC) = 1
ORDER BY T.TRAN_DATE DESC;

Generates