date_trunc(day, block_timestamp) AS date,

COUNT (DISTINCT tx_hash) AS transactions,

COUNT (DISTINCT tx_signer) AS active_users,

sum(transaction_fee/pow(10,24)) AS fees,

CASE WHEN date >= '2023-01-10' THEN ' early 7 day'

WHEN date < '2023-01-10' THEN 'last 7 days ' END AS range

FROM near.core.fact_transactions

WHERE block_timestamp::date >= CURRENT_DATE - 13AND tx_status = 'Success'

GROUP BY 1