headitmanagerNumber of Swaps for each Asset
    Updated 2022-05-23
    with calculate_vol as (
    select
    (case
    when swap_to_asset_id=226701642 then swap_to_amount
    when swap_from_asset_id=226701642 then swap_from_amount
    end
    ) as volume
    ,date_trunc('day', block_timestamp) as swapdate
    , swap_program
    ,(case
    when swap_from_asset_id=226701642 then swap_to_asset_id end
    ) as asset_id
    from algorand.swaps
    where swap_to_asset_id=226701642 or swap_from_asset_id=226701642
    )
    select count(calculate_vol.asset_id) as number_used , asset_name from calculate_vol inner join algorand.asset on calculate_vol.asset_id=algorand.asset.asset_id
    group by asset_name
    Run a query to Download Data