date_trunc('day',BLOCK_TIMESTAMP) as date,

case

when FROM_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6') then 'USDC'

when FROM_currency in ('ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') then 'USDT'

end as stable_coins,

count(distinct tx_id) as no_txn,

count(distinct TRADER) as no_users,

sum(FROM_AMOUNT/1e6) as volume,

avg(FROM_AMOUNT/1e6) as avg_volume,

sum(volume) over (partition by stable_coins order by date) as total_volume

from terra.core.ez_swaps

where FROM_currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6' --usdc

,'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') --usdt

and TX_SUCCEEDED='TRUE'

and block_timestamp>='2022-12-25'

group by 1,2