zakkisyedSushi LP vs Sushi Token holders
Updated 2022-02-09
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
›
⌄
with
pools as(
select pool_address, pool_name
from ethereum.dex_liquidity_pools
where platform = 'sushiswap'
),
pools_holding as (
select count(contract_address) as holders, avg(balance) as avg_holdings, contract_address, pool_name
from ethereum.erc20_balances
join pools
on pools.pool_address = erc20_balances.contract_address
where contract_address IN (select pool_address from pools)
and balance_date = '2022-01-05'
and balance is not null
group by contract_address, pool_name
order by holders desc
limit 20
),
sushi_holder_addresses as (
select contract_address, balance, user_address, 'SUSHI' as pool_name
from ethereum.erc20_balances
join (
select user_address as lp_user
from ethereum.erc20_balances
join pools
on pools.pool_address = erc20_balances.contract_address
where contract_address IN (select pool_address from pools)
and balance_date = '2022-01-05'
and balance is not null
) lps
on user_address = lps.lp_user
where contract_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2'
and balance_date = '2022-01-05'
),
Run a query to Download Data