date_trunc('day', block_timestamp) AS day,

count(DISTINCT ORIGIN_FROM_ADDRESS) as "unique LP providers",

avg ( "unique LP providers" ) over (order by day),

from

ethereum.core.dim_dex_liquidity_pools y

join ethereum.core.fact_event_logs x on y.CREATION_TX = x.TX_HASH

WHERE

PLATFORM = 'sushiswap'

and CREATION_TX is not null

group by 1