select

distinct contract_address as v_a,

REGEXP_REPLACE(

contract_name,

'^EVK Vault e(.*)-\\d+$',

'\\1'

) as extracted_token

from

swell.core.ez_decoded_event_logs

where

ORIGIN_TO_ADDRESS = '0x08739cbede6e28e387685ba20e6409bd16969cde'

AND Event_name = 'Deposit'

),

assets_price as (

select

date_trunc('day', HOUR) as date,

symbol,

median(price) as price

from

crosschain.price.ez_prices_hourly

where

symbol in (

select

distinct upper(extracted_token)

from

vaults

)

and date_trunc('day', HOUR) = current_Date

group by

1,

2

),

Base_tx as (

select

block_timestamp :: date as date,