marginfi as (

date_trunc('day',block_timestamp) as day,

signers[0] as user

FROM solana.core.fact_events

WHERE program_id = 'MFv2hWf31Z9kbCa1snEPYctwafyhdvnV7FZnsebVacA'

AND block_timestamp::date >='2023-02-07'

,

dau as (

SELECT

day,

count(DISTINCT user) as total_active_address

FROM marginfi

GROUP BY 1

,

mau as (

SELECT month,

count(DISTINCT user) as mau_address

FROM (

SELECT date_trunc('month',day) as month,day,user FROM marginfi

GROUP BY month

),

mdau as(

SELECT

date_trunc('month',day) as month, avg(total_active_address) as mdau_address

FROM

dau

GROUP BY month

SELECT