flipside

    Classifying Users
    Afonso_DiazClassifying Users
    Updated 2025-04-10
    with

    tokens as (
    select
    symbol,
    decimals,
    address as token_address
    from
    swell.core.dim_contracts

    union all

    select 'enzoBTC', 8, '0x6a9a65b84843f5fd4ac9a0471c4fc11afffbce4a'

    union all

    select 'swBTC', 18, '0xd557a21f78045380142a7bbccbca0fe3746a0787'

    union all

    select 'swBTC', 18, '0xe786314c7ee33bb45aaf72dd374d715da1c414e7'

    union all

    select 'earnETH', 18, '0x9ed15383940cc380faef0a75edace507cc775f22'
    ),

    pricet as (
    select
    hour::date as date,
    case token_address
    when '0x8db2350d78abc13f5673a411d4700bcf87864dde' then 'swBTC'
    when '0xfae103dc9cf190ed75350761e95403b7b8afa6c0' then 'rswETH'
    when '0x0a6e7ba5042b38349e437ec6db6214aec7b35676' then 'SWELL'
    when '0xf951e335afb289353dc249e82926178eac7ded78' then 'swETH'
    when '0xecac9c5f704e954931349da37f60e39f515c11c1' then 'LBTC'
    Last run: 19 days ago
    USER_CATEGORY
    USERS
    1
    		Active Swapper (11 - 25 Transactions)32
    2
    		Casual Swapper (2 - 5 Transactions)1459
    3
    		Frequent Swapper (26 - 50 Transactions)11
    4
    		Moderate Swapper (6 - 10 Transactions)128
    5
    		Occasional Swapper (1 Transaction)2308
    6
    		Power Swapper (More than 50 Transactions)10
    6
    278B
    7s