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





    Auto-refreshes every 3 hours
    QueryRunArchived: QueryRun has been archived