flipside

    swaping asset name
    talebimorteza_72swaping asset name
    Updated 2022-05-24
    with new_wallets as (select min(BLOCK_TIMESTAMP::DATE) as date_of_creation , sendr
    from flipside_prod_db.algorand.transactions
    where sender in (select sender
    from flipside_prod_db.algorand.transactions
    where BLOCK_TIMESTAMP::DATE between '2022-05-04' and '2022-05-10')
    and TX_TYPE_NAME='asset transfer'
    group by sender)

    select count(distinct sender) , date_of_creation
    from new_wallets
    where new_wallets.date_of_creation between '2022-05-04' and '2022-05-10'

    Run a query to Download Data