-- forked from defi_funds1 / Dex with most daily swap on polygon in the past 180 days @ https://flipsidecrypto.xyz/defi_funds1/q/oAqM1m1R_dkF/dex-with-most-daily-swap-on-polygon-in-the-past-180-days
SELECT
block_timestamp::date AS date,
platform,
event_name,
count(DISTINCT tx_hash) AS NO_OF_TRANSACTIONS_DAILY,
count(DISTINCT ORIGIN_FROM_ADDRESS) AS DAILY_USERS,
abs(sum(amount_in_usd)) AS DAILY_VOLUME,
abs(avg(amount_in_usd)) AS AVG_DAILY_VOLUME
FROM polygon.defi.ez_dex_swaps
WHERE
DATE(block_timestamp) BETWEEN '2023-09-01' AND '2024-03-09'
AND amount_in_usd IS NOT NULL
GROUP BY 1,2,3
ORDER BY 6 DESC