adriaparcerisasFourthwall deployed contracts 4: Ethereum
    Updated 2025-03-31
    with
    addresses as (
    select distinct decoded_log:proxy as addresses
    from ethereum.core.fact_decoded_event_logs x
    where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
    AND event_name ilike '%proxydeployed%'
    )
    SELECT
    count(distinct nft_address) as "# of contracts",
    count(distinct tokenid) as "Tokens created",
    "Tokens created"/"# of contracts" as "Total tokens created per contract"
    from ethereum.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'


    Last run: 29 days agoAuto-refreshes every 3 hours
    # of contracts
    Tokens created
    Total tokens created per contract
    1
    1629218.25
    1
    16B
    40s