boomer7751 thor
Updated 2022-02-01
9
1
2
3
4
5
6
7
›
⌄
with total as (select pool_name, from_asset, to_asset, date(block_timestamp) as dt, from_amount_usd, from_amount, to_amount, ROW_NUMBER() OVER(PARTITION BY pool_name ORDER BY from_amount_usd desc) as rank
from thorchain.swaps)
select *
from total
where rank = 1
order by from_amount_usd desc
Run a query to Download Data