Web3 Data Degens
Create
Roadmap
Web3 SQL Weekly
10
Powered by Canny

Web3 SQL Weekly

This form is for the community to submit requests for topics or queries they'd like to see explained on both a blockchain and SQL level!
All weeks found here https://linktr.ee/andrewhong5297
posts
https://dune.com/queries/1624338/2692648?address_t6c1ea=0x00000000219ab540356cbb839cbe05303d7705fa
how can you get the biggest depositors/withdrawers of ETH for a given address? this was the bonus question for week 1 on ETH balances
0
TVL
How to calculate the total value locked in a contract Bonus - Tvl in a wallet address
1
https://dune.com/queries/256139
Gini Coefficient, concept and calculation, point in time, over time :)
1
https://dune.com/queries/1910280/3145812
Get top trades/traders by token on a chain (defi mochi query)
1
Secret Accumulator
How to find the secret large accumulators for a specific token?
1
https://dune.com/queries/2000490
How to calculate Net Insolvent Value (across multiple accounts) on Aave V2?
2
https://dune.com/queries/1945623/3209802
How do you calculate staked ETH by provider? How does the staking data model work? (hildobby query)
0
https://dune.com/queries/1429065/2424013
How can you figure out trending contracts by chain? (kofi query)
0
https://dune.com/queries/1373693/2337627
How to analyze Lens engagement over time? (kofi query)
0
https://dune.com/queries/1549585
How can you get total NFT trading volume (with USD prices, and wash trading filters)? (hildobby query)
0
Powered by Canny