flipside

    JUP Total
    freemartianJUP Total
    Updated 2024-05-21
    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
    count(DISTINCT tx_to) AS wallet,
    SUM(amount) AS jup_amount
    FROM claim



    QueryRunArchived: QueryRun has been archived