flipside

    Weekly Whales optimism
    Deebs-DeFi-j9fRbzWeekly Whales optimism
    Updated 2023-04-19
    WITH Deposits AS(
    SELECT
    TO_ADDRESS AS whale,
    sum(ETH_VALUE) AS bought_amount
    FROM optimism.core.fact_transactions
    WHERE BLOCK_TIMESTAMP>CURRENT_DATE-7
    AND STATUS='SUCCESS'
    AND whale NOT IN('0x47029bc8f5cbe3b464004e87ef9c9419a48018cd',
    '0x19793c7824be70ec58bb673ca42d2779d12581be',
    '0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a',
    '0x68f5c0a2de713a54991e01858fd27a3832401849',
    '0x540243fb1aadc71ee6d713409f35e3ea7865718d',
    '0xacd03d601e5bb1b275bb94076ff46ed9d753435a'
    )
    GROUP BY 1
    ),

    Withdrawals AS(
    SELECT
    FROM_ADDRESS AS whale,
    sum(ETH_VALUE) AS sold_amount
    FROM optimism.core.fact_transactions
    WHERE BLOCK_TIMESTAMP>CURRENT_DATE-7
    AND STATUS='SUCCESS'
    AND whale NOT IN('0x47029bc8f5cbe3b464004e87ef9c9419a48018cd',
    '0x19793c7824be70ec58bb673ca42d2779d12581be',
    '0x0296b27c2041d55c7220b05aa2079ef1e8e3b60a',
    '0x68f5c0a2de713a54991e01858fd27a3832401849',
    '0x540243fb1aadc71ee6d713409f35e3ea7865718d',
    '0xacd03d601e5bb1b275bb94076ff46ed9d753435a'
    )
    GROUP BY 1
    )

    SELECT
    d.whale,
    Run a query to Download Data