SocioCryptoNumber of users who have interacted with Squid (source_chain)
    Updated 2023-08-17
    with tb0 as (
    SELECT
    sender,
    count(DISTINCT source_chain) as n_source_chain,
    count(DISTINCT destination_chain) as n_destination_chain
    FROM axelar.core.ez_squid
    GROUP BY 1
    ORDER BY 3 DESC
    )

    SELECT
    n_source_chain || ' chain' as n_chains,
    count(sender) as users
    FROM tb0
    GROUP BY 1


    Run a query to Download Data