flipside

    Grouping txns
    Afonso_DiazGrouping txns
    Updated 2025-02-23
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    decoded_log:_assets / 1e18 as kaia_amount,
    decoded_log:_shares / 1e18 as stkaia_amount,
    origin_from_address as user,
    from
    kaia.core.ez_decoded_event_logs
    where
    event_name = 'Staked'
    and origin_to_address = '0x42952b873ed6f7f0a7e4992e2a9818e3a9001995'
    )

    select
    case
    when kaia_amount < 10 then 'a. Less than 10 $KAIA'
    when kaia_amount <= 50 then 'b. 10 - 50 $KAIA'
    when kaia_amount <= 100 then 'c. 50 - 100 $KAIA'
    when kaia_amount <= 500 then 'd. 100 - 500 $KAIA'
    when kaia_amount <= 1000 then 'e. 500 - 1000 $KAIA'
    when kaia_amount <= 5000 then 'f. 1000 - 5000 $KAIA'
    when kaia_amount <= 10000 then 'g. 5000 - 10,000 $KAIA'
    when kaia_amount <= 100000 then 'h. 10,000 - 100,000 $KAIA'
    else 'i. More than 100,000 $KAIA'
    end as type,
    count(distinct tx_hash) as transactions
    from
    main
    group by 1
    order by 1

    Last run: 3 months ago
    TYPE
    TRANSACTIONS
    1
    		a. Less than 10 $KAIA16965
    2
    		b. 10 - 50 $KAIA644
    3
    		c. 50 - 100 $KAIA423
    4
    		d. 100 - 500 $KAIA1065
    5
    		e. 500 - 1000 $KAIA303
    6
    		f. 1000 - 5000 $KAIA446
    7
    		g. 5000 - 10,000 $KAIA216
    8
    		h. 10,000 - 100,000 $KAIA664
    9
    		i. More than 100,000 $KAIA443
    9
    269B
    3s