WITH bond_durations AS (

SELECT

FACT_BOND_EVENTS_ID,

FROM_ADDRESS,

BLOCK_TIMESTAMP,

LAG(BLOCK_TIMESTAMP, 1) OVER (PARTITION BY FROM_ADDRESS ORDER BY BLOCK_TIMESTAMP) AS prev_bond_timestamp

from thorchain.defi.fact_bond_events

AVG(DATEDIFF(day, prev_bond_timestamp, BLOCK_TIMESTAMP)) AS avg_bond_duration_days

FROM bond_durations

WHERE prev_bond_timestamp IS NOT NULL;