SELECT

block_timestamp,

tx_hash,

tx_receiver,

tx_signer,

row_number() over (partition by tx_signer order by block_timestamp) as rank

FROM near.core.fact_transactions

WHERE TX_SUCCEEDED

SELECT

project_name,

label_type as sector,

count(DISTINCT tx_signer) as active_user

FROM all_user a

LEFT JOIN near.core.dim_address_labels b

on a.tx_receiver = b.address

WHERE block_timestamp :: date >= '2024-01-01'

AND project_name is not null

AND label_type not in ('token', 'operator')

GROUP by 1 , 2

ORDER BY active_user DESC

LIMIT 30