kiacryptoTop 10 contracts with the most interaction by new users
    Updated 2022-10-16
    with first_tx as (
    select
    from_address,
    min(block_timestamp) as min_date
    from gnosis.core.fact_transactions
    where status = 'SUCCESS'
    group by 1 having min_date >= '2022-09-01'
    )
    select
    to_address,
    project_name,
    count(distinct tx_hash) as count
    from gnosis.core.fact_transactions left join gnosis.core.dim_labels on to_address = address
    where from_address in (select from_address from first_tx)
    group by 1, 2
    order by 3 desc
    limit 10
    Run a query to Download Data