DATE_TRUNC('day', BLOCK_TIMESTAMP) AS bonding_day,

TOKEN_ADDRESS,

SUM(OLAS_AMOUNT_USD) AS daily_bonding_volume_usd

FROM

crosschain.olas.ez_olas_bonding

WHERE block_timestamp >= '2024-01-01'

GROUP BY

bonding_day, TOKEN_ADDRESS

ORDER BY

bonding_day, daily_bonding_volume_usd DESC;