concat('https://etherscan.io/tx/',tx_hash) as link_to_etherscan

from

ethereum.core.fact_transactions

where block_timestamp > current_date - 1 limit 50;