WITH DAU_u AS (

SELECT

date_trunc('d', block_timestamp) AS day,

COUNT(DISTINCT sender) AS DAU

FROM axelar.defi.ez_bridge_squid

GROUP BY 1

),

MAU_u AS (

SELECT

date_trunc('month', block_timestamp) AS month,

COUNT(DISTINCT sender) AS MAU

FROM axelar.defi.ez_bridge_squid

GROUP BY 1

),

mDAU AS (

SELECT

date_trunc('month',day) as month, AVG(DAU) AS mdau_u

FROM

DAU_u

GROUP BY 1

SELECT

a.month,

MAU,

mdau_u,

100 * mdau_u/ MAU AS stickiness_ratio

FROM mDAU a

LEFT JOIN MAU_u b using(month)

ORDER BY 1 DESC