DISTINCT tx_signer,

block_timestamp::date as date,

count(DISTINCT tx_hash) as "Number of Txs"

from near.core.fact_transactions

where TX_STATUS = 'Success'

group by 1,2

order by 2 ASC