with

addresses as (

select distinct decoded_log:deployment as addresses

from arbitrum.core.fact_decoded_event_logs x

where x.contract_address=lower('0x7c487845f98938bb955b1d5ad069d9a30e4131fd')

AND event_name ilike '%added%'

trunc(block_timestamp,'day') as "Date",

count(distinct nft_address) as "# of contracts",

count(distinct tokenid) as "Tokens created",

"Tokens created"/"# of contracts" as "Total tokens created per contract"

from arbitrum.nft.ez_nft_transfers

where nft_address in (select * from addresses)

and nft_from_address='0x0000000000000000000000000000000000000000'

and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'

group by 1 order by 1 asc