rain_syndicaMPLX Airdrop Claimers
    Updated 2023-06-12
    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