...sive users in 2023
SELECT
--truncate time to day
date_trunc('day', block_time) AS time,
--count distinct addresses that sent a transactions
COUNT(distinct "from") AS users,
--count distinct addresses that received a transaction
COUNT(distinct "to") AS receiving_addresses
FROM ether...