adriaparcerisasFourthwall deployed contracts 2: all
    Updated 2025-03-31
    with
    eth as (
    select
    trunc(block_timestamp,'day') as "Date",
    count(distinct decoded_log:proxy) as "# of contracts deployed"
    from ethereum.core.fact_decoded_event_logs x
    where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
    AND event_name ilike '%proxydeployed%'
    and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
    group by 1 order by 1 asc
    ),

    poly as (
    select
    trunc(block_timestamp,'day') as "Date",
    count(distinct decoded_log:proxy) as "# of contracts deployed"
    from polygon.core.fact_decoded_event_logs x
    where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
    AND event_name ilike '%proxydeployed%'
    and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
    group by 1 order by 1 asc
    ),

    avax as (
    select
    trunc(block_timestamp,'day') as "Date",
    count(distinct decoded_log:proxy) as "# of contracts deployed"
    from avalanche.core.fact_decoded_event_logs x
    where x.contract_address=lower('0x5DBC7B840baa9daBcBe9D2492E45D7244B54A2A0')
    AND event_name ilike '%proxydeployed%'
    and block_timestamp >=current_date-INTERVAL '{{number_of_months}} MONTHS'
    group by 1 order by 1 asc
    ),

    arb as (
    select
    Last run: 29 days agoAuto-refreshes every 3 hours
    No Data to Display
    0
    2B
    15s