headitmanagerThe amount that each user lending at the moment
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with adding as (select sum(EVENT_INPUTS:fraction) as adds ,EVENT_INPUTS:to as add_user,contract_address 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,3)
, removing as (
select sum(EVENT_INPUTS:fraction) as remove,EVENT_INPUTS:to as remove_users ,contract_address from ethereum_core.fact_event_logs
where
contract_address in ('0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89','0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50',
'0x4f68e70e3a5308d759961643afcadfc6f74b30f4','0xb7b45754167d65347c93f3b28797887b4b6cd2f3','0x17fb5f39c55903de60e63543067031ce2b2659ee')
and event_name='LogRemoveAsset' and contract_name='KashiPairMediumRiskV1'
group by 2,3)
select ((adds-remove)/1e18) as amount ,add_user,
(case
when adding.contract_address='0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' then 'kmxSUSHI/USDC-LINK'
when adding.contract_address='0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50' then 'kmWETH/USDT-LINK'
when adding.contract_address='0x4f68e70e3a5308d759961643afcadfc6f74b30f4' then 'kmLINK/USDC-LINK'
when adding.contract_address='0xb7b45754167d65347c93f3b28797887b4b6cd2f3' then 'kmWETH/USDC-LINK'
when adding.contract_address='0x17fb5f39c55903de60e63543067031ce2b2659ee' then 'kmxSUSHI/USDT-LINK'
else adding.contract_address
end) as Kashi_pairs from adding left join removing
on add_user=remove_users and adding.contract_address=removing.contract_address
where adds-remove > 0
Run a query to Download Data