datavortexactual-tan
    Updated 9 days ago
    WITH user_first_swaps AS (
    SELECT
    platform,
    origin_from_address,
    MIN(block_timestamp) AS first_swap_time
    FROM
    kaia.defi.ez_dex_swaps
    GROUP BY
    platform,
    origin_from_address
    ),
    new_users_last_30 AS (
    SELECT
    platform,
    COUNT(DISTINCT origin_from_address) AS new_users_count_30d
    FROM
    user_first_swaps
    WHERE
    first_swap_time > CURRENT_TIMESTAMP - INTERVAL '30 days'
    GROUP BY
    platform
    ),
    new_users_previous_30 AS (
    SELECT
    platform,
    COUNT(DISTINCT origin_from_address) AS new_users_count_previous_30d
    FROM
    user_first_swaps
    WHERE
    first_swap_time > CURRENT_TIMESTAMP - INTERVAL '60 days'
    AND first_swap_time <= CURRENT_TIMESTAMP - INTERVAL '30 days'
    GROUP BY
    platform
    )
    SELECT
    n1.platform,
    Last run: 9 days ago
    PLATFORM
    new users last 30D
    new users previous 30D
    user change last 30D
    1
    capybara12202818749.0% 🟢
    2
    dragonswap-v23287203761.4% 🟢
    3
    dragonswap-v3356392617036.2% 🟢
    4
    kaiaswap30828010.0% 🟢
    5
    klayswap-v2883946- 6.7% 🔴
    6
    klayswap-v320357186349.2% 🟢
    7
    neopin12723896941.9% 🟢
    7
    269B
    12s