mehdimarjanNumber of Wallets that used AlgoFi After Tinyman
    Updated 2022-04-13
    WITH tinyman_wallets AS (
    SELECT DISTINCT(swapper) AS wallets
    FROM algorand.swaps
    WHERE swap_program = 'tinyman'
    )
    SELECT COUNT(DISTINCT(a.swapper)) AS wallets
    FROM algorand.swaps a
    INNER JOIN tinyman_wallets ON tinyman_wallets.wallets = a.swapper
    WHERE swap_program = 'algofi'
    Run a query to Download Data