boomer77First Swap Pair
Updated 2021-11-07
9
1
2
3
4
5
6
7
8
9
›
⌄
with raw as (select from_address, block_timestamp, from_asset, to_asset, ROW_NUMBER() OVER(partition by from_address ORDER BY block_timestamp asc) AS tx_no
from thorchain.swaps)
select concat(from_asset,'-',to_asset) as swap_pair, count(distinct from_address) as address_count
from raw
where tx_no = 1
group by 1
order by 2 desc
limit 10
Run a query to Download Data