date,

bridge,

sum(deposit_usd) as total_usd

from external.defillama.fact_bridge_volume

where deposit_usd is not null

group by date, bridge