date_trunc('month', block_timestamp::date) as date,

count(distinct (tx_id)) as tx_count,

sum(amount / pow(10, decimal)) as total_amount,

count(distinct (sender)) as senders_count,sum(tx_count) over (order by date) as cum_tx_count,

count(distinct (receiver)) as receivers_count,sum (total_amount) over (order by date asc) as cumulative_amount,

sum (senders_count) over (order by date asc) as cumulative_senders,

sum (receivers_count) over (order by date asc) as cumulative_receivers

from axelar.core.fact_transfers

where

(

currency not like 'factory%'

and currency not like 'gravity%'

and tx_succeeded = 'TRUE'

and transfer_type like 'IBC_TRANSFER_%'

group by date

having total_amount > 0

order by date desc