select

date_trunc('day', block_timestamp)::date as day,

project_name,

count(distinct(tx_hash)) as tx_num,

count(distinct(tx_signer)) as signers_num,

count(distinct(tx_receiver)) as receivers_num,

row_number() over (partition by day order by tx_num desc) as n

from near.core.fact_transactions a

join near.core.dim_address_labels b

on a.tx_receiver = b.address

where l2_label in ('distributor_cex_satellite', 'distributor_cex')

and tx_status = 'Success'

group by 1, 2

qualify n = 1

)

order by 1