with total_users as (
select block_timestamp::date as date,
count(*) as total_no_of_txns,
count(distinct trader) as number_of_users,
round(sum(amount_in),2) as total_near_amount_swapped
from near.core.ez_dex_swaps
where token_in = 'wNEAR' and
block_timestamp::date >= '2022-01-01'
group by date
order by date
)
select * from total_users;