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

Eekeyguy pfp
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 ᵏ pfp
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

Eekeyguy pfp
Eekeyguy
@eekeyguyy
1 reply
0 recast
1 reaction

ilemi pfp
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

Eekeyguy pfp
Eekeyguy
@eekeyguyy
Yes @ilemi has made this amazing dashboard : https://dune.com/queries/1537319/2577384?contract_t6c1ea=0x830BD73E4184ceF73443C15111a1DF14e495C706
0 reply
0 recast
2 reactions