SELECT
date_trunc(day,t.block_timestamp) as Date
,platform
,bridge_address
,sum(t.tx_fee) as "Total Fees in ETH"
FROM
ethereum.defi.ez_bridge_activity b
LEFT JOIN ethereum.core.fact_transactions t
ON b.tx_hash = t.tx_hash
WHERE 1=1
AND bridge_address = lower('0x5c7bcd6e7de5423a257d81b442095a1a6ced35c5')
-- AND t.block_timestamp >= current_date - 90
group by 1,2,3
order by 1 DESC