princefarzamHow many of these wallets have performed a swap?
    Updated 2022-06-16
    WITH Time as(
    SELECT
    block_timestamp,
    block_id
    FROM algorand.block
    WHERE block_timestamp >= '2022-05-01' --since May
    AND block_timestamp < '2022-06-01' --since May
    ),
    Addresses as(
    SELECT
    ADDRESS,
    CREATED_AT,
    BALANCE
    FROM algorand.account
    ),
    NEW_Address AS (
    SELECT
    A.ADDRESS AS ADDRESS
    FROM Addresses A INNER JOIN Time T ON A.CREATED_AT=T.block_id
    WHERE T.block_timestamp::DATE >= '2022-05-01' -- may
    AND T.block_timestamp::DATE < '2022-06-01')

    SELECT
    'NUMBER OF WALLETS THAT have PERFORMED A SWAP' AS Wallets,
    COUNT(DISTINCT SWAPPER) AS NUMBER_OF_WALLETS_THAT_PERFORMED_A_SWAP
    FROM NEW_Address A INNER JOIN flipside_prod_db.algorand.swaps B ON A.ADDRESS=B.SWAPPER
    WHERE B.block_timestamp::DATE >= '2022-05-01' -- may
    AND B.block_timestamp::DATE < '2022-06-01'

    UNION
    SELECT
    'ALL NEW WALLETS' AS Wallets,
    COUNT (DISTINCT ADDRESS) AS ALL_NEW_WALLETS
    FROM NEW_Address
    Run a query to Download Data