Data

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/eekeyguy_eth || 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?

You would need to generalize a way to select events you are interested in though right? Otherwise you would just want a sum of all ETH into a contract, regardless of function/event?

headmaster @duneanalytics, previously mirror and consensys

Okay, so you could imagine having a query that tracks a certain ETH transfer pattern and shows you a list of all events, and its up to you to multiselect the events that matter? Also would you scope this down to just auction contracts?

Yes, I'd need to specify the event e.g., only AuctionsSettled