with daily as (
select
date_trunc(day, block_timestamp) as day,
platform,
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
group by
1,
2
)
select
platform,
"# of Users",
"Median Swap Volume"
from
daily