SELECT DISTINCT signers[0] AS claimer_wallet

-- SUM(inner_instructions[1]:instructions[1]:parsed:info:amount / POWER(10,6)) AS amount_claimed

-- inner_instructions[1]:instructions[1]:parsed:info:destination AS destination,

-- inner_instructions[1]:instructions[1]:parsed:info:authority AS authority,

-- instructions[0]:parsed:info:mint AS mint

FROM solana.core.fact_transactions

WHERE instructions[1]:programId = 'gdrpGjVffourzkdDRrQmySw4aTHr8a3xmQzzxSwFD1a'

AND log_messages[22] = 'Program log: Instruction: Claim'

AND instructions[0]:parsed:info:mint = 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m'

AND succeeded = 'True'

AND date(block_timestamp) >= '2022-10-11'

),

all_senders as (

select

tx_from,

tx_to,

from

solana.core.fact_transfers t

where

date(block_timestamp) between '2022-10-08' and '2022-10-15'

and t.mint = 'METAewgxyPbgwsseH8T16a39CQ5VyVxZi9zXiDPY18m'

select

concat('https://solscan.io/account/',tx_to) as reciever,

l.label,

count(distinct tx_from) as sender_wallets,

sum(amount) as mplx_sent

from

all_senders s

left join solana.core.dim_labels l