Yousefi_1994Top 10 pair was the most swaps in 11 , 12 May
    Updated 2022-06-09
    with aseets_name as (
    select
    asset_id,
    asset_name
    from
    algorand.asset
    union
    select 0 , 'ALGO'
    )
    select
    block_timestamp::date as days,
    concat(from_info.asset_name , ' / ', to_info.asset_name) as pair_asset,
    count(distinct tx_group_id) as number_of_swaps,
    sum(swap_from_amount) as swap_from_volume
    from algorand.swaps swap
    join aseets_name from_info on swap.swap_from_asset_id = from_info.asset_id
    join aseets_name to_info on swap.swap_to_asset_id = to_info.asset_id
    where swap.block_timestamp::date >= '2022-05-11'
    and swap.block_timestamp::date <= '2022-05-12'
    and swap.swap_from_amount > 0
    group by days, pair_asset
    order by number_of_swaps desc
    limit 10
    Run a query to Download Data