date_trunc('day',block_timestamp) as day,

count(distinct tx_id) as sol_transactions

from

solana.core.fact_transactions

where

date_trunc('day',block_timestamp) >date_trunc('day',CURRENT_TIMESTAMP) - interval '12 months'

and succeeded =true

group by 1