SELECT
-- date_trunc('day', block_timestamp) as day,
'Post' as event_type,
count(DISTINCT signer_id) as users,
count(DISTINCT tx_hash) as events
from near.social.fact_posts
GROUP BY 1 --,2
UNION
SELECT
-- date_trunc('day', block_timestamp) as day,
'Profile Update' as event_type,
count(DISTINCT signer_id) as users,
count(DISTINCT tx_hash) as events
from near.social.fact_profile_changes
GROUP BY 1 --,2