SELECT

tx_from,

MAX(block_timestamp) AS last_transaction_time

FROM

cosmos.core.fact_transactions

GROUP BY

tx_from

and BLOCK_TIMESTAMP_HOUR >= current_date - {{Past_Days}}