aPrioriuser_activity
    Updated 2025-05-30

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

    user_lst_tx_stat_dim as
    (
    select
    FROM_ADDRESS as wallet
    ,count(distinct TX_HASH) as lst_tx_count
    ,count(distinct date(BLOCK_TIMESTAMP)) as lst_tx_date_count
    from monad.testnet.fact_transactions
    where TO_ADDRESS=lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A')
    group by 1
    ),


    user_faucet_tx_stat_dim as
    (
    select
    TO_ADDRESS as wallet
    ,count(distinct TX_HASH) as faucet_tx_count
    QueryRunArchived: QueryRun has been archived