Nige7777Sushi
Updated 2022-01-22
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
›
⌄
with cte_sushi_pool as (
select distinct pool_name, pool_address from ethereum.dex_liquidity_pools
where platform = 'sushiswap' --and pool_address = '0x9070c706919e40c33875600a2ab2d4058518e400'
)
, cte_current as (
select DISTINCT
coalesce (pool_name, address_name ) as PoolName,
user_address,
--MAX(balance_date) as balance_date,
last_value(amount_usd) OVER(PARTITION by user_address order by balance_date desc ) USD_Balance
from ethereum.erc20_balances b
join cte_sushi_pool p on p.pool_address = b.user_address
where 1= 1--user_address in (select pool_Address from cte_sushi_pool)
and amount_usd > 0
and balance_date > CURRENT_DATE - 3
--group by address_name, user_address
--order by balance_date desc
)
select Pool_name, User_address , USD_Balance from cte_current
order by usd_balance desc
limit 3
-- select *
-- from ethereum.erc20_balances b where user_address = '0x9070c706919e40c33875600a2ab2d4058518e400'
-- and amount_usd > 0
Run a query to Download Data