gigiokobaBUY AND SELL
    Updated 2025-02-09
    WITH buy_sell_data AS (
    SELECT
    CASE
    WHEN TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' THEN 'buy'
    WHEN TOKEN_IN = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' THEN 'sell'
    ELSE 'other'
    END AS transaction_type
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE
    TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    OR TOKEN_IN = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    ),
    transaction_counts AS (
    SELECT
    COUNT(CASE WHEN transaction_type = 'buy' THEN 1 END) AS buy_count,
    COUNT(CASE WHEN transaction_type = 'sell' THEN 1 END) AS sell_count,
    COUNT(*) AS total_transactions
    FROM
    buy_sell_data
    )
    SELECT
    buy_count,
    sell_count,
    ROUND((buy_count * 100.0 / total_transactions), 2) AS buy_rate_percent,
    ROUND((sell_count * 100.0 / total_transactions), 2) AS sell_rate_percent
    FROM
    transaction_counts;


    Last run: 14 days ago
    BUY_COUNT
    SELL_COUNT
    BUY_RATE_PERCENT
    SELL_RATE_PERCENT
    1
    366065007842.2357.77
    1
    27B
    3s