flipside

    User Breakdown
    0xHaM-dUser Breakdown
    Updated 2025-03-27
    WITH eventTb AS (
    select
    block_timestamp,
    tx_hash,
    origin_from_address,
    from avalanche.core.ez_decoded_event_logs
    where origin_to_address in (
    '0x013b34dba0d6c9810f530534507144a8646e3273'
    ,'0x0363a3debe776de575c36f524b7877db7dd461db'
    ,'0x698c34bad17193af7e1b4eb07d1309ff6c5e715e'
    ,'0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
    ,'0x8a63943ac3f394ed73c7b06fecf3a81bc11b840e'
    ,'0x46080cd724102ac0e1d4d1fb45474d14e175a8f9'
    ,'0xb79a06e4cbf379f4676983d1a6d83e996c3a63c4'
    )
    )
    ,
    statsTb as (
    select
    origin_from_address,
    count(distinct block_timestamp::date) as n_days,
    count(distinct tx_hash) as n_txs,
    from eventTb
    group by 1
    order by 3 desc
    )
    select
    case
    when n_days = 1 then 'Only 1 day'
    when n_days > 1 and n_days <= 5 then '2 - 5 days'
    when n_days > 5 and n_days <= 10 then '6 - 10 days'
    when n_days > 10 and n_days <= 20 then '11 - 20 days'
    when n_days > 20 and n_days <= 50 then '21 - 50 days'
    when n_days > 50 then '> 50 days'
    end as day_breakdown,
    case
    Last run: 12 days ago
    DAY_BREAKDOWN
    TX_BREAKDOWN
    N_USERS
    1
    		Only 1 day2 - 10 Txs1990
    2
    		Only 1 dayOnly 1 Tx482
    3
    		2 - 5 days2 - 10 Txs380
    4
    		21 - 50 days11 - 50 Txs312
    5
    		2 - 5 days11 - 50 Txs119
    6
    		6 - 10 days11 - 50 Txs101
    7
    		11 - 20 days11 - 50 Txs63
    8
    		21 - 50 days51 - 100 Txs27
    9
    		6 - 10 days2 - 10 Txs16
    10
    		> 50 days101 - 200 Txs9
    11
    		11 - 20 days51 - 100 Txs8
    12
    		21 - 50 days101 - 200 Txs7
    13
    		21 - 50 days> 200 Txs3
    14
    		> 50 days> 200 Txs3
    15
    		Only 1 day11 - 50 Txs3
    16
    		11 - 20 days101 - 200 Txs1
    17
    		> 50 days51 - 100 Txs1
    18
    		6 - 10 days> 200 Txs1
    18
    587B
    14s