BLOCK_TIMESTAMP::date as day,

count(distinct SIGNERS[0]) as users_solana,

count(distinct tx_id) as txn_solana

from flipside_prod_db.solana.fact_transactions

where SUCCEEDED='TRUE'

and BLOCK_TIMESTAMP>=CURRENT_DATE-60

group by 1