algo_ahab-4V8aSZrndr_whales
    Updated 2024-07-27
    WITH ranked_balances AS (
    SELECT
    *,
    ROW_NUMBER() OVER (PARTITION BY user_address ORDER BY last_activity_block_timestamp DESC) AS rnk
    FROM
    ethereum.core.ez_current_balances
    WHERE
    contract_address = LOWER('0x6De037ef9aD2725EB40118Bb1702EBb27e4Aeb24')
    AND usd_value_now > 10000000
    ),
    unlabeled_addresses AS (
    SELECT
    rb.user_address,
    rb.current_bal,
    rb.usd_value_now,
    rb.last_activity_block_timestamp
    FROM
    ranked_balances rb
    LEFT JOIN
    ethereum.core.dim_labels dl
    ON
    rb.user_address = dl.address
    WHERE
    rb.rnk = 1
    AND dl.address IS NULL
    ),
    transactions AS (
    SELECT
    ett.block_number,
    ett.block_timestamp,
    ett.tx_hash,
    ett.event_index,
    ett.origin_function_signature,
    ett.origin_from_address,
    ett.origin_to_address,
    ett.contract_address,
    QueryRunArchived: QueryRun has been archived