zakkisyed5.Sushiswap top 10 LP : WETH-USDT
Updated 2022-01-27
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
›
⌄
⌄
select distinct (from_address), sum(amount_usd)
from
(
select *
from ethereum.udm_events
where
to_address = '0x06da0fd433c1a5d7a4faa01111c044910a184553'
and amount_usd > 0
)
--or to_address = '0x6a091a3406e0073c3cd6340122143009adac0eda'
--or to_address = '0x06da0fd433c1a5d7a4faa01111c044910a184553'
/* where origin_function_name ='addLiquidityETH'
or origin_function_name ='addLiquidityUSDC'
and amount_usd != 0
-- or origin_function_name = 'removeLiquidityETH'
*/
group by 1
order by 2 Desc
Run a query to Download Data