c2ctraderNumber of ALGOs transactions to Receive ASA
    Updated 2022-04-15
    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