rain_syndicaMPLX Airdrop Claimers
Updated 2023-06-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
date_trunc('day', block_timestamp) AS day,
SUM(inner_instructions[1]:instructions[1]:parsed:info:amount / POWER(10,6)) AS total_amount_claimed,
COUNT(DISTINCT signers[0]) AS num_claimers
-- 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 block_timestamp >= '2022-10-11'
AND block_timestamp <= '2022-10-15'
GROUP BY day
ORDER BY day desc
Run a query to Download Data