flipside

    Solana Check
    flipperjo0Solana Check
    Updated 2025-04-12
    WITH latest_transactions AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_FROM AS sender_address,
    TX_TO AS receiver_address,
    AMOUNT AS amount_sol,
    TX_ID AS transaction_id
    FROM
    solana.core.fact_transfers
    WHERE
    TX_FROM = '43cL5tJyigbGxJDvmdG9qo8cG3pj54gTuTN1cp3Tcg3B'
    ORDER BY
    BLOCK_TIMESTAMP DESC
    LIMIT 2000
    ),
    unique_receivers AS (
    SELECT DISTINCT
    receiver_address
    FROM
    latest_transactions
    ),
    incoming_transfers AS (
    SELECT
    TX_TO AS receiver_address,
    MAX(BLOCK_TIMESTAMP) AS last_incoming_time,
    SUM(AMOUNT) AS total_incoming_amount
    FROM
    solana.core.fact_transfers
    WHERE
    TX_TO IN (SELECT receiver_address FROM unique_receivers)
    AND AMOUNT > 0.005
    GROUP BY
    receiver_address
    )
    SELECT
    receiver_address,
    Last run: 12 days ago
    No Data to Display
    0
    2B
    178s