33crescoJup Airdrop 2 copy copy
    Updated 2024-02-02
    -- forked from jackguy / Jup Airdrop 2 copy @ https://flipsidecrypto.xyz/jackguy/q/QECNszgj2bVF/jup-airdrop-2-copy

    -- forked from Jup Airdrop 2 @ https://flipsidecrypto.xyz/edit/queries/0d64d718-13ee-405c-9867-d34c74e16d23

    WITH claim_txs AS (
    SELECT DISTINCT
    block_timestamp,
    tx_id
    FROM solana.core.fact_events
    WHERE succeeded
    AND program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
    AND block_timestamp > '2024-01-29'
    ),

    transfers AS (
    SELECT
    block_timestamp,
    tx_id,
    tx_to,
    amount
    FROM solana.core.fact_transfers
    WHERE mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    AND tx_id IN (SELECT tx_id FROM claim_txs)
    AND block_timestamp > '2024-01-29'
    ),

    tab1 AS (
    SELECT
    user,
    SUM(
    CASE WHEN flow = 'in' THEN amt
    ELSE -amt END
    ) AS bal
    FROM (
    SELECT
    tx_to AS user,
    Last run: over 1 year ago
    USER
    BAL
    1
    HXGCUzrTXYq2otRnZ49dFDBeLoMygsfL2LFA4mrgZfoz0.00001700000212
    2
    BPiunxZKqnVjfyGwxEGDJ8fo2Anc9KZW2w81gpbPRJV30.100024
    3
    FWUdYakbRb4prFnLUJSrkNojoFucL3KKwBy5F5MfKsAr4.547473509e-13
    4
    ADr56VbaDAVEwCUUCWs2PTsaVNGo2YEA19ybJnAtzPK0.034506
    5
    GdpYY4sTeg9pBQmAer7kQ24diVcm3T1HxDa5P4XJdZhv9.999985195e-7
    6
    DstmYRmgTRKr5UzgepqXoHzoRo5T4CPS5Ky1cHiCPP1g3.637978807e-12
    7
    7TXMSKhZRbu1AQyNJyDauwqE3bzzwJpZwcFAyYEnHcUn5.820766091e-11
    8
    22K33dFGRvQmavyrk1PqUeSC7t9GHUy7Cf52oGsTr5YM0.0000189999846
    9
    ANvPZkc49VdRf6TaDU1CixfZd8NHpeqhfQwLZazRSZiq0.373012
    10
    D6wh3WS66LqAa5ya4fTCvYRKaZDScC5d54H3ijbSAg3Z0.041589
    11
    RWn4DQQ8M7eCm5mUZLZ6SGGMpHc5fSE3ihxCMbPXq4h0.757589
    12
    2Ffk7bo7fG2vopaKq8xwpTEj4iN9uT22TqZDFvsXQo3s3.637978807e-12
    13
    bck8n1tcBdvgwkWVcBmsX29hEjvgkHZU5BfaScbQUKi2.273736754e-13
    14
    CGr71RLiKRJ9xNeZ49Zv6RUTYSvbqWEq1c1DxgdAVLoy9.094947018e-13
    15
    6vCNEeCUHVyCfQ9wgQeVnpnF97gtJcFqNdoWGxFUhGcF0.929963
    16
    FmPkASPzybdLZBsdrqTmT8k7v5BpXWERE9Hhazv1hktX1.455191523e-11
    17
    9jGWT4YJCxbkTEGRc1jmGBXnEDCXKBhJfx4GGy8ZeFN40.00006800000028
    18
    H6HnRJ5X2mmtVgUAuGzgmyXXGwAQUwZZy3SYcCMmtWui5.684341886e-14
    19
    BoC8ZvF8JMc2JzVddjZdrnbLT2RLZA1gjYYLPwrByQ3R9.999999975e-7
    20
    HRbvwPmivADgLAT6gC3bxbpKgCy7KGZuT5bMSsZsSgYj1.136868377e-13
    ...
    7131
    432KB
    19s