Updated 2023-10-20
    with t1 as (
    SELECT
    date_trunc('day',BLOCK_TIMESTAMP) as day,
    from_address as user
    from avalanche.core.fact_transactions
    where to_address='0x5898c3e218a8501533d771c86e2fa37743ea2add'
    and STATUS = 'SUCCESS'
    and block_timestamp>='2022-09-01'
    ),


    t2 as (
    select
    day,
    count(distinct user) as daily_users
    from (
    select * from t1
    )
    group by 1
    ),


    t3 as (
    select
    week,
    count(distinct user) as weekly_user
    from (
    select date_trunc('week',day) as week,* from t1
    )
    group by week
    ),

    t4 as(
    select
    date_trunc('week',day) as week,
    avg(daily_users) as avg_DAU_users
    Run a query to Download Data