with addr as (

select

address,

address_name

from terra.labels

where label = 'terraswap' and label_subtype = 'pool' and address_name like '% Pair'

and address != 'terra1zw0kfxrxgrs5l087mjm79hcmj3y8z6tljuhpmc'

and address != 'terra1sndgzq62wp23mv20ndr4sxg6k8xcsudsy87uph'

),

trnx as (

select

addr.address_name,

addr.address,

sum(msgs.msg_value:coins[0].amount)/pow(10,6) swap_volume

from terra.msgs as msgs

join addr on msgs.msg_value:contract::string = addr.address

group by 1, 2

order by 3 desc

limit 5

select *

from trnx