flipside

    Creation Date
    freemartianCreation Date
    Updated 2022-07-07
    with creation as (
    select
    sender,
    min(block_timestamp::date) as Creation_Date
    from flipside_prod_db.algorand.transactions
    where sender in (
    select swapper from flipside_prod_db.algorand.swaps
    where block_timestamp between '2022-05-01' and '2022-07-01')
    group by sender
    )
    select count(sender), date_trunc('month', Creation_Date) as TIME
    from creation
    group by TIME

    Run a query to Download Data