nickpayiatis_ASA High level Swaps by dex (SWAP TO)
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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