group by 2

order by 1 DESC

limit 10)

select count(*), tx_sender , block_timestamp::date from terra.core.fact_transactions where block_timestamp::date >='2023-01-09'

and tx_sender in (select tx_sender from top10)

group by 2,3