• Popular Contracts

Popular Contracts

This query returns the top 10 popular contracts

select
    initcap(
        replace(
            split_part(contract_call_contract_id, '.', 2),
            '-',
            ' '
        )
    ) as contract,
    count(*)
from
    transactions
where
    status = 1
    and contract_call_contract_id is not null
group by
    1
order by
    2 desc
limit
    10