Content
@
0 reply
0 recast
0 reaction
binji 🔴
@binji.eth
without knowing sql I want to query what the top used bridges on the superchain are with daily, weekly, and monthly breakdowns bonus if I see what apps those who bridged from the various bridges use the most how can I do this?
4 replies
0 recast
18 reactions
binji 🔴
@binji.eth
App breakdown is important, I care less about the bridge that gets 100M a month of people who just go and park it on a chain. I care more about the bridge that’s bringing 10m but thousands of users who then interact across various consumer apps and protocols the latter is a better signal of mass adoption
1 reply
0 recast
0 reaction
ilemi
@ilemi
Here's a list of top apps that users who deposit through the native bridge use first, along with what percent of bridged ETH they spent and average eth bridged and eth spent values :) To take this further, you could add other bridges and coinbase CEX transfers. hope this helps! https://dune.com/queries/3454747
1 reply
0 recast
0 reaction
ilemi
@ilemi
What are you really trying to analyze here? Is it which bridges are the most popular? Which apps are the most cross-chain? Which tokens get bridged the most? User personas even? This is a pretty complex question that needs to be broken down into smaller pieces first.
1 reply
0 recast
0 reaction
Liam
@liam.eth
You should actually try to write this query in dune, really useful to know sql, and separately dune has an AI query writer to help get started
1 reply
0 recast
5 reactions
