DATE_TRUNC('day' ,BLOCK_TIMESTAMP) as main_time,

COUNT(DISTINCT TX_HASH) as transactions_number,

COUNT(DISTINCT TX_SIGNER) as users_number

FROM near.core.fact_transactions

WHERE TX_STATUS='Success'

GROUP BY main_time

ORDER BY main_time