count(*) count,

sum(inner_instructions[0].instructions[1].parsed.info.lamports / 1e9) claims,

date_trunc('day', block_timestamp) date

solana.core.fact_transactions

(

ARRAY_CONTAINS('GxiAUu2g1EnD4LUS8R5Pjo52R9SZjQE8PruXznBL8twB'::variant, signers)

)

and array_contains('Program log: Instruction: ClaimSettlement'::variant, log_messages)

and succeeded = TRUE

and date_trunc('day', block_timestamp) between '2024-05-01' and '2025-12-01'

group by

date_trunc('day', block_timestamp)

order by

date_trunc('day', block_timestamp) desc

limit 20