boomer77thorchain top fees
Updated 2021-12-24
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with raw as (select distinct tx_id, liq_fee_rune_usd, liq_fee_asset_usd, from_address, from_amount_usd
from thorchain.swaps
where block_timestamp >= CURRENT_DATE - 30)
select sum(liq_fee_rune_usd) as total_fees, from_address, count (distinct tx_id) as tx_count, sum(from_amount_usd) as total_swaps, avg(from_amount_usd) as average_swaps
from raw
where from_address != '0x3a196410a0f5facd08fd7880a4b8551cd085c031'
group by 2
order by 1 desc
limit 25
Run a query to Download Data