date_trunc('day', block_timestamp) as day,

destination_chain,

COUNT(DISTINCT TX_HASH) as total_txs

ethereum.defi.ez_bridge_activity

TOKEN_SYMBOL != ''

AND amount_usd > 0

AND block_timestamp > '{{starting_date}}'

AND Destination_chain in (

'near',

'solana',

'sui',

'osmosis',

'aptos',

'manta',

'telos',

'sei',

'injective'

)

GROUP BY

destination_chain,

day

ORDER BY

total_txs DESC