block_timestamp::date as Myday, count(distinct tx_hash) as Lending_number,

count(distinct origin_from_address) as count_of_Wallet,symbol,

sum(amount) as amount_of_lending, blockchain

from crosschain.ez_lending

where symbol in ('UST','DAI','USDT','USDC','TUSD', 'sUSD')

and lending_pool ilike 'km%'

and action = 'Deposit'

group by Myday, blockchain, symbol

order by Myday