Afonso_Diaz2023-09-09 11:04 PM
    Updated 2023-09-27
    with t as (
    select
    tx_hash,
    block_timestamp,
    liquidity_provider as user
    from ethereum.uniswapv3.ez_lp_actions
    ),

    t2 as (
    select
    user,
    count(distinct tx_hash) as transactions
    from t
    group by 1
    )

    select
    case
    when transactions = 1 then '1 Transaction'
    when transactions <= 5 then '2 - 5 Transactions'
    when transactions <= 10 then '6 - 15 Transactions'
    when transactions <= 15 then '16 - 25 Transactions'
    when transactions <= 20 then '26 - 50 Transactions'
    else 'More than 50 Transactions'
    end as type,
    count(distinct user) as users
    from t2
    group by 1
    order by users desc
    Run a query to Download Data