rajsArbitrum Contracts
    Updated 2023-04-13
    with new_contracts as
    (
    SELECT
    contract_address,
    min(block_timestamp) as joined_date
    from arbitrum.core.fact_event_logs
    group by 1
    )
    ,

    new_contracts_sum as
    (
    SELECT
    date_trunc('hour', joined_date) as date,
    date_trunc('day', joined_date) as date_d,
    date_trunc('month', joined_date) as date_m,
    count(contract_address) as no_of_new_contracts,
    sum(count(contract_address)) over (order by date) as cum_no_of_contracts
    FROM new_contracts
    group by 1,2,3
    )
    ,

    active_contracts as
    (
    SELECT
    date_trunc('hour', block_timestamp) as date,
    date_trunc('day', block_timestamp) as date_d,
    date_trunc('month', block_timestamp) as date_m,
    count(distinct contract_address) as no_of_active_contracts
    from arbitrum.core.fact_event_logs
    group by 1,2,3
    )

    SELECT
    *
    Run a query to Download Data