flipside

    swappers
    datavortexswappers
    Updated 6 days ago
    WITH swapper_activity AS (
    SELECT
    COUNT(DISTINCT swapper) AS total_swappers
    FROM
    sei.defi.ez_dex_swaps
    ),
    swapper_change_last_7d AS (
    SELECT
    COUNT(DISTINCT swapper) AS swapper_change_last_7d
    FROM
    sei.defi.ez_dex_swaps
    WHERE
    block_timestamp >= CURRENT_DATE - INTERVAL '7 DAY'
    ),
    swapper_change_percentage AS (
    SELECT
    (
    sc7d.swapper_change_last_7d * 1.0 / sa.total_swappers
    ) * 100 AS swapper_change_percentage
    FROM
    swapper_activity sa
    LEFT JOIN swapper_change_last_7d sc7d ON TRUE
    ),
    weekly_swappers AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week_start_date,
    COUNT(DISTINCT swapper) AS weekly_swappers
    FROM
    sei.defi.ez_dex_swaps
    GROUP BY
    week_start_date
    ),
    swappers_per_platform AS (
    SELECT
    platform,
    COUNT(DISTINCT swapper) AS swappers_count_per_platform
    Last run: 6 days ago
    TOTAL_SWAPPERS
    SWAPPER_CHANGE_PERCENTAGE
    WEEK_START_DATE
    WEEKLY_SWAPPERS
    PLATFORM
    SWAPPERS_COUNT_PER_PLATFORM
    SWAPPER_GROWTH_PERCENTAGE
    1
    		3523897.23382025-05-12 00:00:00.00024000dragonswap240536-42.3631
    2
    		3523897.23382025-05-12 00:00:00.00024000astroport74104-42.3631
    3
    		3523897.23382025-05-12 00:00:00.00024000sailorswap36249-42.3631
    4
    		3523897.23382025-05-12 00:00:00.00024000jellyswap25184-42.3631
    5
    		3523897.23382025-05-12 00:00:00.00024000seaswap736-42.3631
    6
    		3523897.23382025-05-12 00:00:00.00024000fuzio8-42.3631
    7
    		3523897.23382025-05-05 00:00:00.00041640dragonswap240536720.9779
    8
    		3523897.23382025-05-05 00:00:00.00041640astroport74104720.9779
    9
    		3523897.23382025-05-05 00:00:00.00041640sailorswap36249720.9779
    10
    		3523897.23382025-05-05 00:00:00.00041640jellyswap25184720.9779
    11
    		3523897.23382025-05-05 00:00:00.00041640seaswap736720.9779
    12
    		3523897.23382025-05-05 00:00:00.00041640fuzio8720.9779
    13
    		3523897.23382025-04-28 00:00:00.0005072dragonswap24053644.7076
    14
    		3523897.23382025-04-28 00:00:00.0005072astroport7410444.7076
    15
    		3523897.23382025-04-28 00:00:00.0005072sailorswap3624944.7076
    16
    		3523897.23382025-04-28 00:00:00.0005072jellyswap2518444.7076
    17
    		3523897.23382025-04-28 00:00:00.0005072seaswap73644.7076
    18
    		3523897.23382025-04-28 00:00:00.0005072fuzio844.7076
    19
    		3523897.23382025-04-21 00:00:00.0003505dragonswap24053653.3246
    20
    		3523897.23382025-04-21 00:00:00.0003505astroport7410453.3246
    ...
    552
    39KB
    5s