gigiokobatory-green
    Updated 2025-02-08
    WITH borrow_repay_events AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    event_name,
    origin_from_address,
    CASE
    WHEN event_name LIKE '%WETH%' THEN 'WETH'
    WHEN event_name LIKE '%ENA%' THEN 'ENA'
    WHEN event_name LIKE '%USDE%' THEN 'USDE'
    ELSE 'Other'
    END AS token_type,
    CASE
    WHEN LOWER(event_name) LIKE '%borrow%' THEN 'Borrow'
    WHEN LOWER(event_name) LIKE '%repay%' THEN 'Repay'
    ELSE 'Other'
    END AS action_type,
    decoded_log:amount::float / POWER(10,
    CASE
    WHEN event_name LIKE '%WETH%' THEN 18
    WHEN event_name LIKE '%ENA%' THEN 18
    WHEN event_name LIKE '%USDE%' THEN 6
    ELSE 18
    END) AS normalized_amount
    FROM swell.core.ez_decoded_event_logs
    WHERE block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())
    AND (LOWER(event_name) LIKE '%borrow%' OR LOWER(event_name) LIKE '%repay%')
    )

    SELECT
    date,
    token_type,
    action_type,
    COUNT(DISTINCT origin_from_address) as unique_users,
    COUNT(*) as number_of_events,
    SUM(normalized_amount) as total_amount,
    AVG(normalized_amount) as avg_amount_per_event,
    Last run: about 1 month ago
    No Data to Display
    0
    2B
    1s