freemartianFarmers!
Updated 2022-07-17
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
27
28
29
30
31
32
33
34
35
36
›
⌄
select count(distinct l.origin_from_address) as KMP_Staker, lending_pool,
'KMP_Stakers' as label
from ethereum.core.fact_event_logs l
inner join ethereum.sushi.ez_lending le on le.LENDING_POOL_ADDRESS = l.contract_address
where l.origin_to_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'
and contract_name = 'KashiPairMediumRiskV1'
and contract_address in (
'0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89',
'0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50',
'0x561770b93d0530390eb70e17acbbd6e5d2f52a31',
'0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1',
'0x0ea032decbfbea581d77d4a9b9c5e9db7c102a7c',
'0x17fb5f39c55903de60e63543067031ce2b2659ee',
'0x668edab8a38a962d30602d6fa7ca489484ee3224',
'0xf678b4a096bb49309b81b2a1c8a966ef5f9756ba',
'0x3485a7c8913d640245e38564ddc05bfb40104635',
'0x5f92e4300024c447a103c161614e6918e794c764',
'0x418bc3ff0ba33ad64931160a91c92fa26b35acb0'
)
group by lending_pool
UNION
select
count(distinct l.origin_from_address),
lending_pool, 'Onsen Depositors' as label
from ethereum.core.fact_event_logs l
inner join ethereum.sushi.ez_lending le on le.lending_pool_address = l.contract_address
where event_name = 'LogAddAsset'
and contract_address in (
'0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89',
'0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50',
'0x561770b93d0530390eb70e17acbbd6e5d2f52a31',
'0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1',
'0x0ea032decbfbea581d77d4a9b9c5e9db7c102a7c',
'0x17fb5f39c55903de60e63543067031ce2b2659ee',
Run a query to Download Data