DATE_TRUNC('month',BLOCK_TIMESTAMP) AS date,

COUNT(DISTINCT TX_HASH) AS total_bonds,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_bonders,

SUM(OLAS_AMOUNT_USD) AS total_amount_usd,

AVG(OLAS_AMOUNT_USD) AS average_amount_usd,

SUM(OLAS_AMOUNT) AS total_olas_amount,

COUNT(DISTINCT CASE WHEN IS_REDEEMED = 'TRUE' THEN TX_HASH END) AS total_redeemed_bonds,

SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT END) AS total_redeemed_olas,

SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS total_redeemed_usd,

SUM(OLAS_AMOUNT) - SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT END) AS net_bonded_olas,

SUM(OLAS_AMOUNT_USD) - SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS net_bonded_usd

FROM crosschain.olas.ez_olas_bonding

GROUP BY 1