kiichiUntitled Query
    Updated 2022-07-07
    with tab1 as (
    SELECT
    a.swapper as users,
    b.created_at as created_at
    from flipside_prod_db.algorand.swaps a left join flipside_prod_db.algorand.account b
    on a.swapper=b.address
    where a.block_timestamp BETWEEN '2022-05-1' and '2022-06-30'),
    tab2 as (
    SELECT
    block_id,
    block_timestamp
    from flipside_prod_db.algorand.block )
    SELECT
    count(DISTINCT f.users) as wallets,
    date_trunc(month,g.block_timestamp) as date
    from tab1 f left join tab2 g
    on f.created_at=g.block_id
    group by date


    Run a query to Download Data