Content pfp
Content
@
0 reply
0 recast
0 reaction

Mac Budkowski ᡏ pfp
Mac Budkowski ᡏ
@macbudkowski
Hey, what would be the easiest way to check the all-time revenue generated by the contract? For example, I want to check how much ETH Nouns DAO (their contract: https://etherscan.io/address/0x830bd73e4184cef73443c15111a1df14e495c706) generated via auctions :)
5 replies
2 recasts
12 reactions

Yulia  pfp
Yulia
@yulia
HeyπŸ‘‹πŸ» To filter by the method_id - find it on etherscan in the transaction details. There is a column in ethereum.transactions table on Dune that is responsible for method_id. So, you can write smth like that: select * from ethereum.transactions where CAST(data AS VARCHAR) LIKE '0xf25efffc%’
0 reply
0 recast
0 reaction