flipside

    Active days in Total[2025]
    0xHaM-dActive days in Total[2025]
    Updated 2025-03-20
    WITH eventTb AS (
    SELECT
    BLOCK_TIMESTAMP,
    TX_HASH,
    FROM_ADDRESS,
    FROM ronin.core.fact_transactions
    WHERE TO_ADDRESS in (
    '0x9d3936dbd9a794ee31ef9f13814233d435bd806c'
    ,'0x32950db2a7164ae833121501c797d79e7b79d74c'
    ,'0x05b0bb3c1c320b280501b86706c3551995bc8571'
    ,'0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3'
    )
    )
    ,
    n_day_active as (
    SELECT
    FROM_ADDRESS,
    count(DISTINCT TX_HASH) as n_txs,
    count(DISTINCT BLOCK_TIMESTAMP::date) as n_days,
    FROM eventTb
    where BLOCK_TIMESTAMP::date >= '2025-01-01'
    group by 1
    )
    select
    case
    when n_days = 1 then 'only 1 day'
    when n_days > 1 and n_days <= 7 then '1 Week'
    when n_days > 7 and n_days <= 14 then '2 Weeks'
    when n_days > 14 and n_days <= 21 then '3 Weeks'
    when n_days > 21 and n_days <= 30 then '1 Month'
    when n_days > 30 and n_days <= 60 then '2 Months'
    when n_days > 60 and n_days <= 90 then '3 Months'
    when n_days > 90 then ' > 3 Months'
    end as active_days_breakdown,
    case
    when n_txs <= 1 then 'only 1 Txs'
    Last run: 15 days ago
    ACTIVE_DAYS_BREAKDOWN
    TX_BREAKDOWN
    N_WALLET
    1
    		3 Months50 ~ 100 Txs76161
    2
    		1 Week1 ~ 10 Txs45644
    3
    		only 1 dayonly 1 Txs40151
    4
    		2 Weeks10 ~ 50 Txs24149
    5
    		2 Months50 ~ 100 Txs19158
    6
    		only 1 day1 ~ 10 Txs18787
    7
    		2 Months10 ~ 50 Txs14033
    8
    		3 Weeks10 ~ 50 Txs12662
    9
    		1 Month10 ~ 50 Txs12018
    10
    		3 Months> 100 Txs8816
    11
    		2 Weeks1 ~ 10 Txs7781
    12
    		2 Months> 100 Txs2989
    13
    		1 Week10 ~ 50 Txs2979
    14
    		1 Month> 100 Txs1990
    15
    		3 Weeks50 ~ 100 Txs1482
    16
    		1 Month50 ~ 100 Txs844
    17
    		only 1 day10 ~ 50 Txs741
    18
    		2 Weeks50 ~ 100 Txs487
    19
    		1 Week50 ~ 100 Txs59
    20
    		1 Week> 100 Txs42
    24
    744B
    8s