NakedCollectorETHEREUM WHALES
    Updated 2024-08-06
    WITH whales AS (
    SELECT
    USER_ADDRESS,
    SUM(USD_VALUE_NOW) AS "Wallet Wealth (USD)"
    FROM
    ethereum.core.ez_current_balances
    GROUP BY
    USER_ADDRESS
    ORDER BY
    "Wallet Wealth (USD)" DESC
    LIMIT
    10
    )
    SELECT
    *

    FROM
    whales w
    JOIN
    ethereum.core.fact_token_transfers t ON w.USER_ADDRESS = t.ORIGIN_FROM_ADDRESS
    WHERE
    t.BLOCK_TIMESTAMP >= current_timestamp - interval '7 days'
    GROUP BY
    t.CONTRACT_ADDRESS
    ORDER BY
    "Interaction Count" DESC
    LIMIT
    10;

    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived