flipside

    Airdrop Claim Distribution
    freemartianAirdrop Claim Distribution
    Updated 2024-03-03
    with txs AS (
    SELECT
    *
    FROM solana.core.fact_events
    WHERE block_timestamp::date >= '2024-01-31'
    -- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
    -- AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
    ),


    claim AS(
    SELECT
    block_timestamp,
    tx_id,
    tx_to,
    amount
    FROM solana.core.fact_transfers
    WHERE tx_id IN (SELECT tx_id FROM txs)
    AND block_timestamp::date >= '2024-01-31'
    -- AND tx_id = '3wWcrgvBLsuZBwVCeM2m78EJM7tv1VvsbqeHJmo52sPvKdLEKe4VNr75TAcbSSABzqTRTFaRs7vdEoXagYAJA1ta'
    AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    )


    SELECT
    amount,
    count(DISTINCT tx_to) AS wallet
    FROM claim
    GROUP BY 1




    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived