farid-c9j0VMAssets Swaped From (past 30 days)
    Updated 2022-06-10
    select block_timestamp::date as date,
    case
    when swap_from_asset_id=0 then 'Algo'
    else asset_name
    end as asset_name, count(*) as swap_count, count(distinct swapper) as swapper_count
    from algorand.swaps
    left join algorand.asset
    on swap_from_asset_id=asset_id
    where block_timestamp = CURRENT_DATE-30
    group by date, swap_from_asset_id,asset_name
    order by swap_count desc
    Run a query to Download Data