-- (Note that this includes Network Module addresses, and doesn't count non-THORChain address activity.)
WITH
intermediate AS (
SELECT DISTINCT date, address
FROM (
(SELECT DATE(block_timestamp) AS date, from_address AS address FROM thorchain.core.fact_transfer_events)
UNION ALL
(SELECT DATE(block_timestamp) AS date, to_address AS address FROM thorchain.core.fact_transfer_events)
)
)
SELECT DISTINCT date, COUNT(address) AS active_THORChain_addresses
FROM intermediate
GROUP BY date
ORDER BY date DESC