Paint Canvas Total brushes and painters

freemartianPaint Canvas Total brushes and painters

Updated 2025-03-11

-- forked from Paint Canvas contributors @ https://flipsidecrypto.xyz/edit/queries/83d664e6-a996-46a4-b7c9-51b868ece873

-- select * from base.core.ez_decoded_event_logs

-- where tx_hash = '0xfa59f4d0670c75e9b64bc435b1a6fe7e31da9d5d02f0859455404c1666c87459'

select

count(distinct decoded_log:author) as Contributing_painters,

-- decoded_log:day as nft_ID,

count(distinct decoded_log:tokenId) as Contributing_brushes

from base.core.ez_decoded_event_logs

where contract_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'

and event_name = 'Painted'

--group by nft_ID

Last run: 15 days agoAuto-refreshes every 1 hour

	CONTRIBUTING_PAINTERS	CONTRIBUTING_BRUSHES
1	3984	2960

13B

76s