with
users as (
select distinct
from_address as user
from
optimism.core.fact_transactions
limit
500
)
select
count(a.tx_hash) as transactions,
sum(a.amount_in_usd) as amount_in_usd,
sum(a.amount_out_usd) as amount_out_usd,
user
from
optimism.core.ez_dex_swaps a
join users on users.user = a.sender
group by
user
order by
transactions desc