SELECT

direction,

count(distinct tx_hash) as count,

sum(zeroifnull(amount_usd)) as vol,

avg(amount_usd) as avg_size

FROM crosschain.defi.ez_bridge_activity

WHERE platform = 'mayan finance'--,'allbridge')

AND (destination_chain = 'solana' or source_chain = 'solana')

AND block_timestamp >= current_date - 90

GROUP BY 1