attributes:burn:amount/pow(10,6) as amount,

case when attributes:burn:currency = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then 'axlUSDC'

when attributes:burn:currency = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF' then 'axlUSDT' end as currency

from terra.core.ez_messages

where message_type = '/ibc.applications.transfer.v1.MsgTransfer' and TX_SUCCEEDED = 'TRUE'

and attributes:burn:currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4', 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF')

select date, currency, count(DISTINCT tx_id) as tx_count, sum(amount) as amountt,

sum (amountt) over (PARTITION BY currency order by date) as "Cumualtive sum",

sum (tx_count) over (PARTITION BY currency order by date) as "Cumualtive txs"

from df

where date >= CURRENT_DATE - {{DaysAgo}}

group by 1,2 order by 3 desc