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/528840/996534
How to calculate retention for a specific project. e.g. Sandbox?
1
·

complete

https://dune.com/queries/1981607/3275605
How do Bitcoin NFTs and Ordinals work?
1
·

complete

https://dune.com/queries/1630632/2702401
How to get new and old users of a protocol over time?
1
·

complete

https://dune.com/queries/1630659
how do you get all contracts that have integrated with another contract?
2
·

complete

https://dune.com/queries/1920659
Get all NFTs held by an address, with token metadata and acquisition method (gifted, minted, bought)
1
·

complete

https://dune.com/queries/1329279
"I'd be keen to hear your explanation of the logic to get ETH balances. I also think it's a good query to explain the differences between getting ETH and ERC20 balances because that can be confusing, and the way you've put the results into an array is pretty neat" - Denze
2
·

complete

Powered by Canny