SELECT
date_trunc('DAY', block_timestamp),
count(tx_id) AS NUMBER_TRANSACTIONS,
count(distinct tx_from_address) AS UNIQUE_USERS--,
--sum(b.amount) as VOLUME
FROM
solana.transactions --a
--INNER JOIN solana.transfers b
--ON a.tx_id = b.tx_id
WHERE
block_timestamp >= '2022-01-01'
AND succeeded = 'TRUE'
GROUP BY 1