vaults as (

select distinct

event_inputs:swapAddress::string as vault_address

from ethereum.core.fact_event_logs

where event_name = 'NewSwapPool' and origin_from_address = '0x0af91fa049a7e1894f480bfe5bba20142c6c29a9'

select '0x2796317b0ff8538f253012862c06787adfb8ceb6' as vault_address -- dont include zap bridges

),

token_balances as (

select

date(block_timestamp) as date,

user_address,

contract_address,

balance

from ethereum.core.fact_token_balances

where exists (select 1 from vaults where vault_address = user_address)

qualify block_timestamp = last_value(block_timestamp) over (partition by date(block_timestamp), user_address, contract_address order by block_timestamp)

order by block_timestamp desc

),

cumulative_min_date as (

SELECT user_address, contract_address, MIN(date) as min_date

FROM token_balances

GROUP BY contract_address, user_address

),

date_dim as (select TO_DATE('20210512','YYYYMMDD') date_id )

,

dates AS (

SELECT DISTINCT

date,

user_address,

contract_address

FROM (