signers[0] as address,

sum(fee / pow (10, 9)) as total_amount

from solana.core.fact_transactions

where

block_timestamp::date > '2022-10-01'

group by address

order by total_amount desc

limit 20