vaults as (

select distinct

tx_json:to as vault_address

from polygon.core.fact_transactions

where

from_address = lower('0xfa9da51631268a30ec3ddd1ccbf46c65fad99251')

and left(tx_json:input, 10) = '0x2ebe3fbb' -- init vault

),

weth_prices as (

select

date(block_timestamp) as date,

replace(feed_name, ' / USD') as symbol,

median(coalesce(latest_answer_adj, latest_answer_unadj / pow(10,8))) as price --using median cause there will be some nulls / zeroes

from ethereum.chainlink.ez_oracle_feeds

where feed_category = 'Cryptocurrency (USD pairs)'

and feed_name in ('ETH / USD')

group by 1,2

order by 1

),

prices as (

select

date(block_timestamp) as date,

token_in as token_address,

symbol_in as symbol,

avg(amount_in_usd / amount_in) as price

from polygon.sushi.ez_swaps

group by 1, 2, 3

),

net_ins as (

select

date(block_timestamp) as date,

b.contract_address,