proposal_t1 as (

SELECT

proposal as proposal_field1,

voter as voter_field1,

max(

CASE

when time < block_timestamp then time

end

) as max_date

FROM

solana.core.fact_proposal_votes

full JOIN (

SELECT

block_timestamp as time,

CASE

when tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then tx_from

else tx_to

end as wallet,

CASE

when tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then amount

else -1 * amount

end as net_deposit,

sum(net_deposit) over (

partition by

wallet

ORDER by

block_timestamp

) as deposit_balance

FROM

solana.core.fact_transfers

WHERE

(

tx_to LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo'

OR tx_from LIKE 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo'

)