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

sum(usd_volume) over (order by week) as cumu_usd_volume,

avg(usd_volume) over (order by week rows between 6 preceding and current row) as ma_usd_volume,

count(distinct(tx_id)) as tx_count,

sum(tx_count) over (order by week) as cumu_tx_count,

count(distinct(sender)) as wallet_count,

tx_count/wallet_count as avg_tx,

usd_volume/tx_count as avg_usd_vol

from axelar.core.fact_transfers

where tx_succeeded = 'TRUE'

and amount/pow(10, decimal) < 999999

group by 1

order by 1 desc