flipside

    damaged-brown
    Jor-eldamaged-brown
    Updated 2025-02-23
    WITH base AS (
    SELECT
    TO_DATE(block_timestamp) AS stake_date,
    full_decoded_log:data[1]:value / 1e18 AS amount_staked,
    origin_from_address AS staker
    FROM kaia.core.ez_decoded_event_logs
    WHERE origin_to_address = '0x42952b873ed6f7f0a7e4992e2a9818e3a9001995'
    AND event_name = 'Staked'
    ),
    categorized_staking AS (
    SELECT
    CASE
    WHEN amount_staked > 1 AND amount_staked <= 100 THEN 'A: > 1 $KAIA to 100 $KAIA'
    WHEN amount_staked > 100 AND amount_staked <= 500 THEN 'B: > 100 $KAIA to 500 $KAIA'
    WHEN amount_staked > 500 AND amount_staked <= 1000 THEN 'C: > 500 $KAIA to 1000 $KAIA'
    WHEN amount_staked > 1000 AND amount_staked <= 5000 THEN 'D: > 1000 $KAIA to 5000 $KAIA'
    WHEN amount_staked > 5000 AND amount_staked <= 10000 THEN 'E: > 5000 $KAIA to 10000 $KAIA'
    ELSE 'F: > 10000 $KAIA'
    END AS staking_category,
    COUNT(DISTINCT staker) AS total_stakers
    FROM base
    GROUP BY staking_category
    )
    SELECT
    staking_category,
    total_stakers
    FROM categorized_staking
    ORDER BY staking_category;