vahid-2jsEENAssets swaped by new wallets
    Updated 2022-06-15
    with new_wallets as ( select *, date_trunc('day', b.block_timestamp) as date from flipside_prod_db.algorand.account a
    left join algorand.block b on a.created_at = b.block_id where closed_at is null and date >= '2022-05-01' and date < '2022-05-31'),
    assets as (
    select asset.asset_name, count(swap.tx_group_id) as swaps
    from algorand.swaps swap inner join algorand.asset asset on swap.swap_to_asset_id = asset.asset_id
    where block_timestamp between '2022-05-04' and '2022-05-10' and swap_from_amount > 0
    group by 1 order by 2 desc) select * from assets order by 2 desc limit 10
    Run a query to Download Data