from terra.daily_balances

where currency = 'KRT' and date = CURRENT_DATE - 1 and balance > 0

group by 1,2

order by balance desc

limit 10),

name as (select address, address_name

from terra.daily_balances

where address_name like '%Terraswap %'),

provide as (select msg_value:sender::string as sender, msg_value:contract::string as Terraswap_Pair, sum(msg_value:coins[0]:amount/1e6) as Amount

from terra.msgs

where msg_value like '%provide_liquidity%' and tx_status = 'SUCCEEDED'

and sender in (select address

from krt)

group by 1,2)

select p.sender, p.terraswap_pair, p.amount, n.address_name

from provide p

left join name n on p.terraswap_pair = n.address

group by 1,2,3,4