DATE_TRUNC('day', block_timestamp) AS day,

COUNT(DISTINCT(from_address)) AS active_user,

'polygon' AS chain

FROM polygon.core.fact_transactions

WHERE status = 'SUCCESS'

AND block_timestamp >= '2022-12-30'

GROUP BY 1,3

UNION ALL

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

COUNT(DISTINCT signers[0]) AS active_user,

'solana' AS chain

FROM solana.core.fact_transactions

WHERE succeeded = 1

AND block_timestamp >= '2022-12-30'

GROUP BY 1,3