farid-c9j0VMThe time of creation wallet for swappers
    Updated 2022-07-08
    select count(DISTINCT a.SWAPPER) as swaper,date_trunc('day',c.block_timestamp) as date_created,
    case
    when date_created BETWEEN '2022-05-01' and '2022-06-30' then 'may-june2022'
    when date_created BETWEEN '2022-03-01' and '2022-04-30' then 'mars-april2022'
    when date_created BETWEEN '2022-01-01' and '2022-02-28' then 'january-februry2022'
    when date_created <'2022-01-01' then 'before 2022'
    else 'null'
    end as Wallet_Creation_Type
    from flipside_prod_db.algorand.swaps a
    LEFT JOIN flipside_prod_db.algorand.account b
    ON a.SWAPPER = b.address
    LEFT JOIN flipside_prod_db.algorand.block c
    ON b.created_at = c.block_id
    WHERE a.SWAPPER IN (select DISTINCT SWAPPER
    from flipside_prod_db.algorand.swaps
    where BLOCK_TIMESTAMP >='2022-05-01' and BLOCK_TIMESTAMP <= '2022-06-30')
    group by 2

    Run a query to Download Data