WITH user_activity AS (
SELECT
from_address AS user_id,
block_timestamp
FROM
thorchain.core.fact_transfers
UNION
SELECT
from_address AS user_id,
block_timestamp
FROM
thorchain.defi.fact_swaps
)
SELECT
DATE(block_timestamp) AS activity_date,
COUNT(DISTINCT user_id) AS daily_active_users,
COUNT(*) AS total_transactions
FROM
user_activity
GROUP BY
activity_date
ORDER BY
activity_date;