date_trunc('day', block_timestamp) as date,

platform,

sum(AMOUNT_USD) as Volume,

count(DISTINCT tx_hash) as n_swaps

from near.defi.ez_bridge_activity

where block_timestamp::date >= '2024-01-01'

group by 1 , 2