date_trunc('week', block_timestamp::date) as TIME,

tx:body:messages[0]:amount[0]:denom as currency_contract,

case

when currency_contract = 'ibc/14ACCAD1750327C74BB35978AD0C3E97B184DAB9F0BF4BD876FBD1F782B57110' then 'USK'

when currency_contract = 'ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4' then 'axlUSDC'

when currency_contract = 'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF' then 'axlUSDT'

when currency_contract = 'uluna' then 'LUNA'

else currency_contract

end as label,

count(tx_id) as transactions_count,

sum(TX:body:messages[0]:amount[0]:amount)/pow(10,6) as volume,

sum(volume) over (order by time) as cumulative_volume,

sum(transactions_count) over (order by TIME) as cumulative_transactions_count

from terra.core.fact_transactions

where TX_SUCCEEDED = 'TRUE'

and currency_contract is not null

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

group by 1,2,3