headitmanagerNumber of unique users who have used the Kashi pair for Loan
    Updated 2022-05-15
    select count(distinct EVENT_INPUTS:to) as user_count , (case
    when contract_address='0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' then 'kmxSUSHI/USDC-LINK'
    when contract_address='0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50' then 'kmWETH/USDT-LINK'
    when contract_address='0x4f68e70e3a5308d759961643afcadfc6f74b30f4' then 'kmLINK/USDC-LINK'
    when contract_address='0xb7b45754167d65347c93f3b28797887b4b6cd2f3' then 'kmWETH/USDC-LINK'
    when contract_address='0x17fb5f39c55903de60e63543067031ce2b2659ee' then 'kmxSUSHI/USDT-LINK'
    else contract_address
    end) as Kashi_pairs from ethereum_core.fact_event_logs
    where
    contract_address in ('0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89','0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50',
    '0x4f68e70e3a5308d759961643afcadfc6f74b30f4','0xb7b45754167d65347c93f3b28797887b4b6cd2f3','0x17fb5f39c55903de60e63543067031ce2b2659ee')
    and event_name='LogAddAsset' and contract_name='KashiPairMediumRiskV1'
    group by 2
    Run a query to Download Data