with base as (

SELECT

COUNT(tx_hash) as t_txns

, COUNT(DISTINCT TX_SIGNER) as t_users

, SUM(TRANSACTION_FEE/1e24) as t_fee

, date_trunc(day, BLOCK_TIMESTAMP) as ddate

FROM near.core.fact_transactions

WHERE tx_status='Success'

AND block_timestamp >= '2023-01-01'

GROUP BY ddate

SELECT * from base