Crazzy_SidTotal OP Balances on Exchanges in USD (Stacked)
    Updated 2025-02-28
    WITH exchange_transfers AS (
    SELECT
    ett.BLOCK_TIMESTAMP::DATE AS transfer_date,
    ett.TO_ADDRESS AS exchange_address,
    ett.AMOUNT_USD AS amount,
    dl.ADDRESS_NAME AS exchange_name
    FROM optimism.core.ez_token_transfers ett
    JOIN optimism.core.dim_labels dl
    ON ett.TO_ADDRESS = dl.ADDRESS
    WHERE ett.SYMBOL = 'OP'
    AND dl.LABEL_TYPE = 'cex'
    AND ett.HAS_PRICE = TRUE
    AND ett.BLOCK_TIMESTAMP >= current_date - INTERVAL '30 DAYS'
    )

    SELECT
    SUM(amount) AS total_op_balance
    FROM exchange_transfers;

    Last run: 16 days ago
    TOTAL_OP_BALANCE
    1
    720937555.733496
    1
    20B
    5s