alleria50. Swap n' Slippage Categorized
    Updated 2022-01-30
    WITH
    slippages as (
    SELECT
    from_amount_usd,
    CASE
    WHEN from_amount_usd < 10 THEN 'a. Less than 10 USD'
    WHEN from_amount_usd >= 10 AND from_amount_usd < 100 THEN 'b. 10 to 100 USD'
    WHEN from_amount_usd >= 100 AND from_amount_usd < 1000 THEN 'c. 100 to 1000 USD'
    WHEN from_amount_usd >= 1000 AND from_amount_usd < 10000 THEN 'd. 1000 to 10000 USD'
    WHEN from_amount_usd >= 10000 AND from_amount_usd < 100000 THEN 'e. 10000 to 100000 USD'
    WHEN from_amount_usd >= 100000 THEN 'f. More than 100000 USD'
    END as category,
    swap_slip_bp / 100 as slippage_percentage
    FROM thorchain.swaps
    WHERE block_timestamp > CURRENT_DATE - 7
    )

    SELECT
    category,
    count(from_amount_usd) as total_transactions,
    avg(slippage_percentage) as average_slippage
    FROM slippages
    GROUP BY category
    ORDER BY category ASC
    Run a query to Download Data