Content
@
0 reply
0 recast
0 reaction
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 :)
4 replies
1 recast
11 reactions
Eekeyguy
@eekeyguyy
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
1 reply
0 recast
2 reactions
Mac Budkowski ᵏ
@macbudkowski
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?
3 replies
0 recast
1 reaction
ilemi
@ilemi
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?
1 reply
0 recast
0 reaction
Mac Budkowski ᵏ
@macbudkowski
Yes, I'd need to specify the event e.g., only AuctionsSettled
1 reply
0 recast
0 reaction
ilemi
@ilemi
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?
1 reply
0 recast
0 reaction
