nitsActive Whales on Alert
    Updated 2022-11-27
    with whales as
    (SELECT
    DISTINCT user_address as ua
    from ethereum.erc20_balances
    where contract_address = 'ETH' and balance >= 100
    and balance_date = CURRENT_DATE - 1)

    SELECT DISTINCT origin_from_address as active_whales
    from ethereum.core.ez_eth_transfers
    WHERE
    origin_from_address in (SELECT * from whales) and
    block_timestamp >= CURRENT_DATE -90
    -- GROUP by 1
    -- limit 100
    Run a query to Download Data