'LP action' as actions,

case

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

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

end as stable_coins,

count(distinct tx_id) as no_txn,

count(distinct LIQUIDITY_PROVIDER_ADDRESS) as no_users,

sum(AMOUNT/1e6) as volume,

avg(AMOUNT/1e6) as avg_volume

from terra.core.fact_lp_actions

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

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

and TX_SUCCEEDED='TRUE'

group by 1,2

union all

select

'Swap' as actions,

case

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

when TO_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(TO_AMOUNT/1e6) as volume,

avg(TO_AMOUNT/1e6) as avg_volume

from terra.core.ez_swaps

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

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

and TX_SUCCEEDED='TRUE'

group by 1,2

union all

select

'Transfer' as actions,