from terra.daily_balances

where currency = 'KRT' and date = CURRENT_DATE - 1

group by 1,2

order by balance desc

limit 10),

swaps as (select trader, concat(token_0_currency,'-',token_1_currency) as swap_pair, sum(token_0_amount_usd) as Pair1, sum(token_1_amount_usd) as Pair2

from terra.swaps

where trader in (select address

from krt)

and tx_status = 'SUCCEEDED'

group by 1,2)

select a.address, a.KRT, b.swap_pair, b.pair1, b.pair2

from krt a

join swaps b on a.address = b.trader

where b.swap_pair is not null