tx_hash,

origin_from_address,

pool_name,

symbol_in,

symbol_out,

case when amount_in_usd is null then amount_out_usd

when amount_out_usd is null then amount_in_usd

when amount_in_usd>=amount_out_usd then amount_in_usd

when amount_out_usd>amount_in_usd then amount_out_usd end as amount_usd

from avalanche.defi.ez_dex_swaps

where platform LIKE '%pharaoh%'

and block_timestamp::date >= '2025-01-01'

,

tbl as (select

trunc(block_timestamp::date,'day') as date,

symbol_out as token,

-- 'Buy' as type,

sum(amount_usd) as volume,

from pharaoh

GROUP by 1,2),

temp as (select

date,

token,

-- 'Buy' as type,

volume,

row_number() over (partition by date order by volume desc) as row_num

from tbl)

select date,

token,