eob.LP_TOKEN_ADDRESS,

COUNT(DISTINCT eob.tx_hash) AS bonding_events,

CASE

WHEN fpt.lp_token_name IS NULL THEN 'others'

ELSE fpt.lp_token_name

END AS lp_token_name,

AVG(

DATEDIFF(

DAY,

DATE_TRUNC('DAY', eob.BLOCK_TIMESTAMP),

DATE_TRUNC('DAY', eob.MATURITY_TIMESTAMP)

)

) AS avg_maturity_time_days,

SUM(eob.olas_amount_usd) AS total_volume_usd

crosschain.olas.ez_olas_bonding eob

LEFT JOIN crosschain.olas.fact_pol_transfers fpt ON eob.LP_TOKEN_ADDRESS = fpt.LP_TOKEN_ADDRESS

GROUP BY

eob.LP_TOKEN_ADDRESS,

fpt.lp_token_name

ORDER BY

bonding_events DESC;