SELECT
signers[0] as wallet,
coalesce(sum(fee) / pow(10,9),0) as fees_paid,
count(*) as no_of_txs
from solana.core.fact_transactions
-- where tx_id = '5FTBYnYBtcptkMaWyKzkStTdWyjDMbTz58up7ShfwrQo8r7JR7CdHzcuDPj5LMLxTs8QQxhvnvC2vz5PbTsLJ92F'
where succeeded = 'FALSE'
-- and block_timestamp::date >= '2022-01-01'
group by 1
order by 2 desc
limit 10