from terra.labels

where address_name like '%Terraswap m%'),

vol as (select date_trunc('day', block_timestamp) as dt, msg_value:contract::string as trswap_address, sum(msg_value:execute_msg:swap:offer_asset:amount/1e6) as volume_ust

from terra.msgs

where msg_value:contract::string in (select address from label)

and dt >= CURRENT_DATE - 90 and tx_status = 'SUCCEEDED'

group by 1,2),

final as (select dt, trswap_address, volume_ust

from vol

where volume_ust is not null)

select a.dt, a.trswap_address, a.volume_ust, b.address_name

from final a

left outer join label b on a.trswap_address = b.address