msg_value:execute_msg:auto_stake:assets[0]:info:token:contract_addr::string as massets,

sum((msg_value:coins[0]:amount/1e6)*2) as amount_usd,

count(distinct tx_id) as tx_count

from terra.msgs

where msg_value:contract::string = 'terra17f7zu97865jmknk7p2glqvxzhduk78772ezac5' and block_timestamp >= CURRENT_DATE - 30

group by 1,2),

labels as (select address, address_name

from terra.labels

where address in (select massets from raw)

)

select a.dt, a.amount_usd, a.tx_count, b.address_name, concat(b.address_name,'-UST') as LP_Pair

from raw a

join labels b on a.massets = b.address

where massets is not null and amount_usd > 0