Popex404Top 10 Gas Guzzlers of Cosmos
    Updated 2023-02-19
    select
    distinct tx_from as "User",
    sum(cast(fee as INTEGER)/pow(10,6)) as "Total Fees $ATOM"
    from cosmos.core.fact_transactions
    where fee_denom = 'uatom'
    group by 1 order by 2 desc
    limit 10
    Run a query to Download Data