date(block_timestamp) as date,

sum(fee) as fees,

count(fee) as transactions

--count(distinct signers[0]) as unique_fee_payers

from solana.core.fact_transactions

group by date

order by date DESC