mamad-5XN3k3Total staked OLAS copy
    Updated 2025-02-16
    -- forked from MLDZMN / Total staked OLAS @ https://flipsidecrypto.xyz/MLDZMN/q/lDI3EuQYet6U/total-staked-olas

    WITH gnosis_balance AS (
    SELECT
    *
    /*COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS total_received_in_olas,
    COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS total_sent_in_olas,
    COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0)
    - COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xa45E64d13A30a51b91ae0eb182e88a40e9b18eD8') THEN AMOUNT ELSE 0 END), 0) AS balance_in_olas*/
    FROM gnosis.core.ez_token_transfers
    WHERE contract_address = lower('0xcE11e14225575945b8E6Dc0D4F2dD4C570f79d9f')
    ),

    optimism_balance AS (
    SELECT
    COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS total_received_in_olas,
    COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS total_sent_in_olas,
    COALESCE(SUM(CASE WHEN TO_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0)
    - COALESCE(SUM(CASE WHEN FROM_ADDRESS = lower('0xBb7e1D6Cb6F243D6bdE81CE92a9f2aFF7Fbe7eac') THEN AMOUNT ELSE 0 END), 0) AS balance_in_olas
    FROM optimism.core.ez_token_transfers
    WHERE
    contract_address = lower('0xFC2E6e6BCbd49ccf3A5f029c79984372DcBFE527')
    )

    SELECT
    gnosis_balance.balance_in_olas as ge,
    optimism_balance.balance_in_olas as opt,
    gnosis_balance.balance_in_olas + optimism_balance.balance_in_olas AS total_balance_in_olas
    FROM
    gnosis_balance,
    optimism_balance



    Last run: 28 days ago
    GE
    OPT
    TOTAL_BALANCE_IN_OLAS
    1
    29922041602992364
    1
    23B
    5s