BLOCK_TIMESTAMP::date as day,

count(distinct tx_id) as no_TX,

count(distinct SIGNERS[0]) as no_users

from solana.core.fact_transactions

where day>=CURRENT_DATE-90

and SUCCEEDED='TRUE'

group by 1