-- forked from Number of Users Vs Median Swap Volume @ https://flipsidecrypto.xyz/edit/queries/969ed722-4884-42cf-af8e-688ee06e97c3
with daily as (
select
platform,
ORIGIN_FROM_ADDRESS,
sum(AMOUNT_IN_USD) as Volume
from base.defi.ez_dex_swaps
where AMOUNT_IN_USD is not null
group by 1,2
)
select
platform,
Volume,
count(distinct ORIGIN_FROM_ADDRESS) as N_users
from
daily
group by 1,2