flipside

    Active addresses
    permaryActive addresses
    Updated 2025-03-25
    SELECT
    'Avalanche' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(DISTINCT origin_from_address) AS active_users
    FROM avalanche.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-09'
    GROUP BY 1, 2

    UNION ALL

    SELECT
    'Polygon' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(DISTINCT origin_from_address) AS active_users
    FROM polygon.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-09'
    GROUP BY 1, 2

    UNION ALL

    SELECT
    'Ethereum' AS chain,
    DATE_TRUNC('day', block_timestamp) AS date,
    COUNT(DISTINCT origin_from_address) AS active_users
    FROM ethereum.defi.ez_dex_swaps
    WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
    AND block_timestamp >= '2024-09-09'
    GROUP BY 1, 2
    ORDER BY date ASC;

    Last run: about 1 month ago
    CHAIN
    DATE
    ACTIVE_USERS
    1
    		Avalanche2024-09-09 00:00:00.0002
    2
    		Ethereum2024-09-09 00:00:00.00010
    3
    		Polygon2024-09-09 00:00:00.000211
    4
    		Polygon2024-09-10 00:00:00.000204
    5
    		Ethereum2024-09-10 00:00:00.0007
    6
    		Polygon2024-09-11 00:00:00.000194
    7
    		Ethereum2024-09-11 00:00:00.0008
    8
    		Ethereum2024-09-12 00:00:00.00010
    9
    		Polygon2024-09-12 00:00:00.000202
    10
    		Avalanche2024-09-12 00:00:00.0004
    11
    		Ethereum2024-09-13 00:00:00.0007
    12
    		Polygon2024-09-13 00:00:00.000208
    13
    		Avalanche2024-09-13 00:00:00.0002
    14
    		Avalanche2024-09-14 00:00:00.0003
    15
    		Ethereum2024-09-14 00:00:00.00010
    16
    		Polygon2024-09-14 00:00:00.000112
    17
    		Polygon2024-09-15 00:00:00.000159
    18
    		Avalanche2024-09-15 00:00:00.0002
    19
    		Ethereum2024-09-15 00:00:00.00012
    20
    		Avalanche2024-09-16 00:00:00.0001
    ...
    592
    24KB
    30s