with prices as

SELECT CASE when symbol='BNB' then 'WBNB'

else symbol end as token_symbol, *

FROM osmosis.core.ez_prices

SELECT 'satellite' as platform,

source_chain,

count(DISTINCT sender) as n_senders,

count(DISTINCT tx_hash) as n_bridges,

sum(CASE when a.token_symbol in ('USDC','axlUSDC', 'FRAX') then amount else amount*price end) as vol,

avg(CASE when a.token_symbol in ('USDC','axlUSDC', 'FRAX') then amount else amount*price end) as avg_size

FROM axelar.core.ez_satellite a

LEFT JOIN prices b

on a.token_symbol = b.token_symbol AND date_trunc('hour',a.block_timestamp) = b.recorded_hour

WHERE destination_chain = 'neutron'

GROUP by 1,2