MasiDaily New Users
    Updated 2024-07-18
    with tb1 as (select trunc(block_timestamp,'hour') as hourly,
    tx_hash,
    sender,
    amount,
    source_chain,
    destination_chain,
    token_address as token,
    TOKEN_SYMBOL as token_name
    from axelar.defi.ez_bridge_squid
    where token_symbol in ('USDT','axlUSDT','USDC','BUSD','FRAX','sFRAX','axlDAI','axlUSDC','EUROC','axlUSDT')
    )
    ,
    tb2 as ( select min(hourly::date) as day,
    sender
    from tb1
    group by 2 )

    select day,
    count(DISTINCT sender) "New Users",
    sum("New Users") over (order by day asc) as "Cumulative New Users"
    from tb2
    where day >= '2024-01-01'
    group by 1
    QueryRunArchived: QueryRun has been archived