prices as (

select

token_contract,

case

when token_contract = 'aurora' then 'WETH'

else symbol

end as symbol,

avg(price_usd) AS price

from

near.core.fact_prices

where

token_contract in (

'usn',

'aurora',

'wrap.near',

'meta-pool.near',

'token.burrow.near',

'linear-protocol.near',

'6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.near',

'a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near',

'dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near',

'2260fac5e5542a773aa44fbcfedf7c193bc2c599.factory.bridge.near',

'aaaaaa20d9e0e2461697782ef11675f668207961.factory.bridge.near'

)

group by

token_contract,

symbol

),

deposits as (

select

date_trunc(week, transactions.block_timestamp) as date,

transactions.tx_hash,

transactions.tx_signer AS wallet,

prices.symbol as token,

case