token_out,

sum(amount_out) * avg(price_usd) as outflow_volume,

platform,

trader

from near.core.ez_dex_swaps ds

inner join near.core.fact_prices p on p.timestamp::date = ds.block_timestamp::date and token_out_contract = p.token_contract

where token_in_contract = 'wrap.near'

group by 1, 3, 4