-- forked from Slowz / Weekly Transactions and New Users @ https://flipsidecrypto.xyz/Slowz/q/Lc7LkfvUUSJU/weekly-transactions-and-new-users
SELECT
DATE_TRUNC('week', block_timestamp) AS date,
COUNT(TX_HASH) AS transactions,
COUNT(DISTINCT TX_HASH) AS transactions1,
COUNT(DISTINCT TX_SIGNER) AS users,
FROM
near.core.fact_transactions
WHERE
block_timestamp >= '2024-01-01' and
block_timestamp is not NULL
GROUP BY
date