glass_blossomsALGO Unique Wallets, in 3 Months
    Updated 2022-03-03
    SELECT MONTHNAME(block_timestamp) MONTH,
    COUNT(DISTINCT address) number_of_wallets
    FROM algorand.transaction_participation
    WHERE MONTH(block_timestamp) = 1
    AND YEAR(block_timestamp) = 2021
    GROUP BY MONTHNAME(block_timestamp)
    UNION
    SELECT MONTHNAME(block_timestamp) MONTH,
    COUNT(DISTINCT address) number_of_wallets
    FROM algorand.transaction_participation
    WHERE MONTH(block_timestamp) = 12
    AND YEAR(block_timestamp) = 2021
    GROUP BY MONTHNAME(block_timestamp)
    UNION
    SELECT MONTHNAME(block_timestamp) MONTH,
    COUNT(DISTINCT address) number_of_wallets
    FROM algorand.transaction_participation
    WHERE MONTH(block_timestamp) = 1
    AND YEAR(block_timestamp) = 2022
    GROUP BY MONTHNAME(block_timestamp)
    Run a query to Download Data