nickpayiatis_ASA High level Swaps by dex (SWAP TO)
    Updated 2022-10-19
    select swap_program as dex,
    asset.asset_name as SWAP_FROM_ASSET_NAME, asset2.asset_name as SWAP_TO_ASSET_NAME,
    count(case when swap_from_amount > 0 then 1 else 0 end) as swaps,
    sum(swap_from_amount) as total_swap_from_amount , sum(swap_to_amount) as total_swap_to_amount, total_swap_to_amount/swaps as average_swap_amount
    from algorand.swaps swaps
    left join algorand.asset asset on swaps.swap_from_asset_id = asset.asset_id
    left join algorand.asset asset2 on swaps.swap_to_asset_id = asset2.asset_id
    where
    swaps.block_timestamp::Date > dateadd(day, -30, current_date())
    and swaps.swap_to_asset_id = {{ASA_ID}}
    group by dex,
    SWAP_FROM_ASSET_NAME, SWAP_TO_ASSET_NAME
    order by total_swap_to_amount desc
    limit 20
    Run a query to Download Data