Yousefi_1994Top 10 pair was the most swaps in 11 , 12 May
Updated 2022-06-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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