date_trunc('day', block_timestamp) as date,

count(distinct tx_id) as Successful_Tx

from solana.core.fact_events

where block_timestamp >= CURRENT_DATE-10

and succeeded = 'TRUE'

group by date