rw2023Airdrop/Spent your wallet
    Updated 2024-03-29

    WITH UsedInPlatform AS (
    SELECT
    DATE(block_timestamp) AS day,
    SUM(-(amount * 50)) AS rkt_spent -- Asumiendo que deseas sumar el gasto total por día
    FROM
    solana.core.fact_transfers
    WHERE
    mint = 'RKT69NZHN5uovcan3q5hRbZzfJuXiGEuPmGANoBJLLz'
    AND tx_to = 'rktaXbHouvPnCBbvEHEiaEXLitsPFT133UHhugjrhrL'
    AND tx_from = '8Apw2ohL61SsykbqYqaZmhgwvWPHATBVaKAx1BCgL9oT'
    AND block_timestamp >= '2023-12-05'
    GROUP BY
    DATE(block_timestamp)
    ),

    Airdrop AS (
    SELECT
    DATE(block_timestamp) AS day,
    SUM(amount) AS airdrop_received -- Asumiendo que deseas sumar la cantidad total recibida por día
    FROM
    solana.core.fact_transfers
    WHERE
    MINT = 'RKT69NZHN5uovcan3q5hRbZzfJuXiGEuPmGANoBJLLz'
    AND TX_FROM IN ('BdMANnELKmZLfE94pHrKzGUFn7sGXqfPkq3kHAwZd2S4','AE6G66YP8y3QAWz3QbPSMQYL7USSdiWXXehn58ANJSmG')
    AND tx_to = '8Apw2ohL61SsykbqYqaZmhgwvWPHATBVaKAx1BCgL9oT'
    AND DATE(block_timestamp) >= '2023-12-05'
    GROUP BY
    DATE(block_timestamp)
    ),
    CombinedData AS (
    SELECT
    COALESCE(uip.day, a.day) AS day,
    COALESCE(uip.rkt_spent, 0) AS rkt_spent,
    COALESCE(a.airdrop_received, 0) AS airdrop_received,
    COALESCE(a.airdrop_received, 0) + COALESCE(uip.rkt_spent, 0) AS net_position
    QueryRunArchived: QueryRun has been archived