WITH weekly_bonding_data AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT tx_hash) AS "weekly_bonded_transactions",
COUNT(
DISTINCT CASE
WHEN is_redeemed = True THEN tx_hash
END
) AS "weekly_redeemed_transactions"
FROM
crosschain.olas.ez_olas_bonding
GROUP BY
DATE_TRUNC('week', block_timestamp)
)
SELECT
week,
"weekly_bonded_transactions",
"weekly_redeemed_transactions"
FROM
weekly_bonding_data
ORDER BY
week;