platform,

sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end) AS Volume_USD,

avg(case when amount_in_usd is null then amount_out_usd else amount_in_usd end) AS Average_Volume_USD,

count(distinct tx_hash) AS Swaps,

count(distinct origin_from_address) AS Unique_Swappers,

sum(case when amount_in_usd is null then amount_out_usd else amount_in_usd end) * .003 AS Fee_Volume_USD

FROM avalanche.core.ez_dex_swaps

where (AMOUNT_IN_USD between AMOUNT_OUT_USD - 5000 and AMOUNT_OUT_USD + 5000) -- I got this from Masi's Dashboard (https://flipsidecrypto.xyz/Masi/uniswap-s-role-in-avalanche-s-defi-growth-m6D9n6) who Credited it to "Abbas from old Dashboards"

and block_timestamp >= '2023-07-13' -- Started on first day over 5k in Swap volume

GROUP BY 1

ORDER BY 2 desc;