SocioCryptoNumber of users who have interacted with Squid (source_chain)
    Updated 2023-11-07
    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
    WHERE token_symbol in ('axlUSDC','USDC', 'axlUSDT', 'USDT', 'axlWMAI')
    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