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;