-- forked from Number of Users Vs Median Swap Volume copy @ https://flipsidecrypto.xyz/edit/queries/d5af538a-0175-4152-8419-68588433b266
-- forked from Number of Users Vs Median Swap Volume @ https://flipsidecrypto.xyz/edit/queries/969ed722-4884-42cf-af8e-688ee06e97c3
select
date_trunc(day, block_timestamp) as day,
median(AMOUNT_IN_USD) as "Median Swap Volume",
count(distinct ORIGIN_FROM_ADDRESS) as "# of Users"
from
base.defi.ez_dex_swaps
where
AMOUNT_IN_USD is not null
and platform = '{{DEX}}'
group by
1