kenobi9270Total collateral deposited (in USD)
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
(select 'C-Total collateral deposited' as lbl , contract_address as address,sum(event_inputs:share/1e18) as results ,(case
when address='0x63d4026cbc902e538618b9aa51a4d05ef48ef5a4' then ' Kashi Amp/USD'
when address='0xa7c3304462b169c71f8edc894ea9d32879fb4823' then ' Kashi Dai Stablecoin/Rai'
when address='0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' then ' Kashi SushiBar/USD'
when address='0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1' then ' Kashi SushiBar/Dai'
when address='0x17fb5f39c55903de60e63543067031ce2b2659ee' then ' Kashi SushiBar/Tether USD'
else address
end) as name
from ethereum_core.fact_event_logs
where contract_name='KashiPairMediumRiskV1' and event_name='LogAddCollateral'
group by 2
order by 3 desc
limit 5)
Run a query to Download Data