SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,
SUM(CAST(DECODED_LOG:penalty AS NUMERIC) / 1e18) AS total_penalty_eth,
SUM(CAST(DECODED_LOG:penalty AS NUMERIC) / 1e18) * 3500 AS total_penalty_usd
FROM
blast.core.ez_decoded_event_logs
WHERE
contract_address = '0xb1a49c54192ea59b233200ea38ab56650dfb448c'
AND event_name = 'OfferFail' OR event_name = 'OfferSuccess'
AND BLOCK_TIMESTAMP >= '2024-05-02'
GROUP BY
week
ORDER BY
total_penalty_eth;