'Solana' as chain,

date(

date_trunc('month', block_timestamp)

) as month,

count (distinct signers[0]) as active_users

from

solana.core.fact_transactions

where

block_timestamp >= '2022-01-01'

group by

1,

2