Query editor
with claim_txs as (select tx_idfrom solana.instruction_callswhereDATE(block_time) >= DATE('2024-12-10')and executing_account = 'disGCfSiJKFigEphfou4PGHn1rukMfbs9cg9GpTM6oe'and tx_success = Trueand any_match(log_messages, i -> i like '%Instruction: NewClaim%') = Truegroup by 1union allselect tx_idfrom solana.instruction_callswhereDATE(block_time) >= DATE('2024-12-10')and executing_account = 'veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf'and tx_success = Trueand any_match(log_messages, i -> i like '%Instruction: ClaimFromDistribution%') = Truegroup by 1),transfers as (selectblock_date,tx_id,to_owner,amountfrom tokens_solana.transferswhereblock_date >= DATE('2024-12-10')and token_mint_address = 'MEFNBXixkEbait3xn9bkm8WsJzXtVsaJEn4c8Sam21u' -- token addressand amount > 0and outer_executing_account in ('disGCfSiJKFigEphfou4PGHn1rukMfbs9cg9GpTM6oe','veTbq5fF2HWYpgmkwjGKTYLVpY6miWYYmakML7R7LRf'))selectblock_date as time,b.tx_id,to_owner,sum(amount)/1e6 as claim_amtfrom claim_txs a join transfers b on a.tx_id = b.tx_idgroup by 1,2,3