headitmanagerNumber of unique users who have used the Kashi pair for Loan
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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