vaitar1Solana "Crypto Bot" Withdrawal address
    Updated 2025-01-31
    WITH token_transfers AS (
    SELECT
    ft.BLOCK_TIMESTAMP::DATETIME AS transfer_datetime,
    ft.TX_ID,
    ft.TX_FROM AS from_address,
    ft.TX_TO AS to_address,
    ft.AMOUNT,
    ft.MINT AS token_address
    FROM solana.core.fact_transfers ft
    WHERE (ft.TX_FROM = '4Ri6Rd7zN6M6H8jF3vPc6MqnmFioVcPaizZt3crLVGXd' OR ft.TX_TO = '4Ri6Rd7zN6M6H8jF3vPc6MqnmFioVcPaizZt3crLVGXd')
    AND ft.BLOCK_TIMESTAMP::DATETIME >= '2025-01-01'
    ),

    token_data AS (
    SELECT
    TOKEN_ADDRESS AS token_address,
    SYMBOL AS token_symbol,
    TOKEN_NAME AS token_name
    FROM solana.core.dim_tokens

    UNION ALL

    SELECT
    '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' AS token_address,
    'TRUMP' AS token_symbol,
    'Trump Token' AS token_name

    UNION ALL

    SELECT
    'FUAfBo2jgks6gB4Z4LfZkqSZgzNucisEHqnNebaRxM1P' AS token_address,
    'MELANIA' AS token_symbol,
    'Melania Token' AS token_name

    UNION ALL

    QueryRunArchived: QueryRun has been archived