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 :)

You can try to find these events in logs ,Or else simply do : select count(*) as auction_count,
    sum(cast(amount as double) / 1e18) as auction_amount,
    count(distinct winner) as winner_count
from nouns_auctionhouse_ethereum.NounsAuctionHouse_evt_AuctionSettled

Check if there are any more contracts

Building @kiwi 
Writing @ https://kanfa.macbudkowski.com/

Decentralizing the flow of information || Explore more at https://dune.com/blockintel || Connect for tailored analysis and solutions

Hey, thanks for answering. I know how to find one event, but I would like to find a sum of all ETH from these events :) 

I am not sure how I could use the second method you described. Is this a way to use the Etherscan Events filter?

This query let's you select any blockchain and any function call(s) in a multiselect dropdown. 

So that's 200 ETH of nouns auctions in the last 30 days, where settleAuction() and settleCurrentAndCreateNewAuction() were called.
https://dune.com/queries/3489886

headmaster @duneanalytics, previously mirror and consensys

@bytecast answered!

that's a really useful query 🚀

Father, husband, gamer, nerd, workaholic. 

Working at the intersection of Blockchain and AI.

Nice try, Mr. undercover IRS agent... 😂

working on nouns protocol ⌐◨-◨ https://mirror.xyz/verbsteam.eth

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%’