-- program_id = ' PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'

SELECT

count(DISTINCT a.tx_id ) as n_txns,

count(DISTINCT a.signers[0]) as n_users,

sum(fee/1e9) as fee_sol

FROM solana.core.fact_transactions a

INNER JOIN solana.core.fact_events b using(tx_id)

WHERE program_id = 'PhoeNiXZ8ByJGLkxNfZRnkUfjvmuYqLR89jjFHGqdXY'

AND block_timestamp::date >= current_date - interval '6 months'

AND SUCCEEDED='true'