boomer77thorchain by blockchain
    Updated 2021-12-24
    select blockchain, (sum(liq_fee_rune_usd)/sum(to_amount_usd))*100 as fees_percentage
    from thorchain.swaps
    where block_timestamp >= CURRENT_DATE - 30
    group by 1
    order by 2 desc