aPrioriaPriori User Trend
    Updated 8 hours ago

    WITH aprior_product_tag_dim AS (
    select
    FROM_ADDRESS as wallet
    ,'Exclusive LST User' as user_tag
    ,date(BLOCK_TIMESTAMP) as stat_date
    from monad.testnet.fact_transactions
    where TO_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
    group by 1,3
    union all
    select
    TO_ADDRESS as wallet
    ,'Exclusive Faucet User' as user_tag
    ,date(BLOCK_TIMESTAMP) as stat_date
    from monad.testnet.fact_transactions
    where FROM_ADDRESS=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')
    group by 1,3
    ),



    base_user_dim as
    (
    SELECT
    wallet,
    CASE
    WHEN COUNT(DISTINCT user_tag) > 1 THEN 'Both User Groups'
    ELSE MAX(user_tag)
    END as base_user_tag
    ,min(stat_date) as create_date
    FROM aprior_product_tag_dim
    GROUP BY wallet
    ),