date,

COUNT(DISTINCT from_address) AS daily_users,

'Pegaxy' as game

FROM (

SELECT

block_timestamp::date AS date,

from_address,

COUNT(DISTINCT tx_id) AS n_transaction

FROM polygon.transactions

WHERE block_timestamp > getdate() - interval '60 days'

and to_address = lower('0xc1c93D475dc82Fe72DBC7074d55f5a734F8cEEAE') --Pegaxy contract address

GROUP BY 1,2

WHERE n_transaction <> 0

GROUP BY 1