flipside

    AVAXsunny-moccasin
    Kruys-CollinsAVAXsunny-moccasin
    Updated 2025-03-17
    WITH swaps AS (
    SELECT
    *,
    DATE_TRUNC('day', block_timestamp) AS day,
    CASE
    WHEN block_timestamp >= DATEADD(day, -{{lookback_period}}, CURRENT_TIMESTAMP) THEN 'last_{{lookback_period}}_days'
    ELSE 'All time'
    END AS period
    FROM avalanche.defi.ez_dex_swaps
    WHERE
    token_in = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
    OR token_out = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
    ),
    metrics AS (
    -- Calculate metrics for both periods
    SELECT
    'last_{{lookback_period}}_days' AS period,
    COUNT(*) AS total_xsgd_swaps,
    SUM(amount_in_usd) AS total_xsgd_swap_volume_raw,
    AVG(amount_in_usd) AS average_xsgd_swap_size,
    MEDIAN(amount_in_usd) AS median_xsgd_swap_size,
    COUNT(DISTINCT origin_from_address) AS total_unique_xsgd_swappers
    FROM swaps
    WHERE block_timestamp >= DATEADD(day, -{{lookback_period}}, CURRENT_TIMESTAMP)

    UNION ALL

    SELECT
    'All time' AS period,
    COUNT(*) AS total_xsgd_swaps,
    SUM(amount_in_usd) AS total_xsgd_swap_volume_raw,
    AVG(amount_in_usd) AS average_xsgd_swap_size,
    MEDIAN(amount_in_usd) AS median_xsgd_swap_size,
    COUNT(DISTINCT origin_from_address) AS total_unique_xsgd_swappers
    FROM swaps
    )
    Last run: about 1 month ago
    PERIOD
    Total XSGD Swaps
    Total XSGD Swap Volume
    Average XSGD Swap Size
    Median XSGD Swap Size
    Total Swappers/Traders
    1
    		⌚last_30_days💱35751💲$41.08M💲1149.36💲377.34👤1305
    2
    		⌚All time💱225909💲$427.55M💲1892.71💲678.9👤3593
    2
    166B
    4s