c2ctraderNumber of ALGOs transactions to Receive ASA
Updated 2022-04-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with asa as(
select round(sum(SWAP_FROM_AMOUNT),0) total_ALGO_Swap_volume,round(avg(SWAP_FROM_AMOUNT),0) average_ALGO_Swap_volume, SWAP_TO_ASSET_ID asset_id
from algorand.swaps
where SWAP_FROM_ASSET_ID=0
group by SWAP_TO_ASSET_ID
),
top10 as (
select top 10 asa.asset_id,a.asset_name, asa.total_ALGO_Swap_volume,asa.average_ALGO_Swap_volume from asa
join algorand.asset a on asa.asset_id=a.asset_id
order by total_ALGO_Swap_volume DESC
),
top10_Number_Swap as(
select date_trunc('day',block_timestamp) day, count(swap_from_amount) number_of_swap, SWAP_TO_ASSET_ID asset_id
from algorand.swaps where asset_id in (select asset_id from top10) and swap_from_amount>0
group by day,asset_id
order by number_of_swap DESC
)
select tns.day,tns.asset_id,t.asset_name,tns.number_of_swap
from top10_Number_Swap tns join top10 t on tns.asset_id=t.asset_id
where day>'2021-12-31'
order by day,number_of_swap
Run a query to Download Data