select block_timestamp::date as date,

sender,

count (distinct tx_id) as TX_Count

from osmosis.core.fact_transfers

where tx_status = 'SUCCEEDED'

and transfer_type = 'IBC_TRANSFER_IN'

and block_timestamp >= '2022-11-01'

group by 1,2),

maintable as (

select *,

row_number() over (partition by date order by TX_Count desc) as RN

from table2)

select * from maintable

where RN <= 10

order by date