flipside

    axl new users
    Moeaxl new users
    Updated 2025-02-05
    select
    *,
    case
    when "new_user change %" > 0 then '1'
    else '0'
    end as type
    from
    (
    with base as (
    select
    TX_FROM SENDER,
    min(BLOCK_TIMESTAMP) as fst
    from
    axelar.core.fact_transactions
    group by
    sender
    )
    SELECT
    date_trunc(week, fst) as date,
    count(DISTINCT SENDER) as new_user,
    round (
    100 *(
    new_user - lag(new_user, 1) over(
    order by
    date
    )
    ) / lag(new_user, 1) over(
    order by
    date
    ),
    2
    ) as "new_user change %",
    sum(new_user) over (
    order by
    date
    ) as total_new_user,
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived