trunc(block_timestamp,'month') as month,

source_chain,

--direction,

sum(amount_usd) AS TOTAL_VOLUME_USD

FROM

near.defi.ez_bridge_activity

WHERE

RECEIPT_SUCCEEDED = TRUE

AND AMOUNT_USD IS NOT NULL --and (source_chain = 'near' or destination_chain='near')

and direction='inbound'

GROUP BY

month,source_chain having source_chain is not null

ORDER BY

month desc, TOTAL_VOLUME_USD DESC