drone-mostafatop user copy copy
    Updated 2023-05-05
    SELECT
    count (DISTINCT TX_HASH) as TXN_Users,
    sum (AMOUNT_IN_USD) as USD_Users,

    sum (CASE when ORIGIN_FROM_ADDRESS = '{{User_wallet}}' then AMOUNT_IN_USD end) as USD_Target,
    count (DISTINCT (CASE when ORIGIN_FROM_ADDRESS = '{{User_wallet}}' then TX_HASH end)) as TXN_Target

    FROM avalanche.core.ez_dex_swaps



    Run a query to Download Data