Date_trunc('day', Block_timestamp) Date,

FOREIGN_CHAIN,

COUNT(DISTINCT TX_ID) txn_count,

COUNT(DISTINCT SENDER) ACTIVE_USERS,

SUM(CAST(AMOUNT AS DECIMAL) / POWER(10, DECIMAL)) AS Total_Transfer_Volume,

sum(Total_Transfer_Volume)over(partition by FOREIGN_CHAIN order by date) CUM_VOLUME

FROM

axelar.core.fact_transfers

WHERE

Block_timestamp ::Date >= '2024-01-01'

AND TX_SUCCEEDED = 'TRUE'

AND transfer_type != 'AXELAR'

GROUP BY 1, 2

ORDER BY 1 DESC