flipside

    user_activity
    aPrioriuser_activity
    Updated 21 hours ago

    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
    Last run: about 21 hours ago
    BASE_USER_TAG
    LST_BALANCE_TAG
    LST_TX_COUNT_TAG
    LST_TX_DATE_COUNT_TAG
    FAUCET_TX_COUNT
    FAUCET_TX_DATE_COUNT_TAG
    WALLET_COUNT
    1
    		Exclusive LST User0~0.1 MON11~50 LST TX2~7 LST Action days00 Faucet Claiming day2507
    2
    		Both User Groups0~0.05 MON6~10 LST TX >7 LST Action days2~5 Faucet TX2~7 Faucet Claiming days5
    3
    		Exclusive LST User0~0.1 MON51~100 LST TX1~2 LST Action days00 Faucet Claiming day73
    4
    		Both User Groups06~10 LST TX 2~7 LST Action days2~5 Faucet TX1~2 Faucet Claiming days91
    5
    		Both User Groups100~1000 MON11~50 LST TX>7 LST Action days11 Faucet Claiming day23
    6
    		Both User Groups1~2 MON11~50 LST TX2~7 LST Action days6~10 Faucet TX2~7 Faucet Claiming days10
    7
    		Both User Groups1~2 MON2~5 LST TX 1 LST Action day2~5 Faucet TX2~7 Faucet Claiming days7
    8
    		Both User Groups0~0.1 MON51~100 LST TX>7 LST Action days11 Faucet Claiming day10
    9
    		Both User Groups10~100 MON51~100 LST TX2~7 LST Action days11 Faucet Claiming day1
    10
    		Both User Groups2~10 MON6~10 LST TX 1 LST Action day2~5 Faucet TX2~7 Faucet Claiming days1
    11
    		Exclusive LST User0~0.05 MON6~10 LST TX >7 LST Action days00 Faucet Claiming day5395
    12
    		Exclusive LST User1~2 MON51~100 LST TX>7 LST Action days00 Faucet Claiming day385
    13
    		Both User Groups1~2 MON1 TX1 LST Action day2~5 Faucet TX2~7 Faucet Claiming days158
    14
    		Exclusive LST User2~10 MON6~10 LST TX 2~7 LST Action days00 Faucet Claiming day4118
    15
    		Both User Groups0.1~1 MON2~5 LST TX 2~7 LST Action days2~5 Faucet TX1~2 Faucet Claiming days95
    16
    		Exclusive LST User10~100 MON6~10 LST TX >7 LST Action days00 Faucet Claiming day62
    17
    		Both User Groups10~100 MON2~5 LST TX 1 LST Action day11 Faucet Claiming day30
    18
    		Exclusive LST User0.1~1 MON>100 TX1~2 LST Action days00 Faucet Claiming day18
    19
    		Both User Groups0.1~1 MON6~10 LST TX >7 LST Action days2~5 Faucet TX2~7 Faucet Claiming days3
    20
    		Both User Groups0~0.1 MON11~50 LST TX>7 LST Action days11 Faucet Claiming day153
    ...
    784
    82KB
    46s