rain_syndicaWallets that Got All Airdrops Except RLB
    Updated 2023-06-22
    -- forked from Wallets that Got All Airdrops @ https://flipsidecrypto.xyz/edit/queries/a4c7f558-cecb-4b7a-a427-e53a7a342026

    WITH

    rlb_airdrop AS (
    SELECT
    tx_to AS recipient,
    tx_id AS rlb_tx
    FROM solana.core.fact_transfers
    WHERE 1=1
    AND block_timestamp < '2022-02-01'
    AND block_timestamp >= '2021-12-20'
    AND tx_from = 'AAbcWqh1WGQkVaK6GrMae1dVGcriwCxPh8PrW69vAEp4'
    AND mint = 'RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a'
    GROUP BY 1,2
    ),

    mplx_airdrop AS (
    SELECT
    signers[0] AS recipient,
    tx_id AS mplx_tx
    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 1,2
    ),

    bonk_airdrop AS (
    select
    tx_to AS recipient,
    tx_id AS bonk_tx
    from solana.core.fact_transfers
    Run a query to Download Data